Question

In: Statistics and Probability

An Air Force base mess hall has received a shipment of 10,000-gallon size cans of cherries....

An Air Force base mess hall has received a shipment of 10,000-gallon size cans of cherries. The supplier claims that the average amount of liquid is 0.25-gallon size can. A government inspector took a random sample of 100 cans and found that the average liquid content to be 0.28 gallons per can with a standard deviation of 0.10. Does this indicate that the supplier’s claim is different from 0.25? (use a 5% significance level). Note: N > 30

*Please show the process of solving the answer, specifically in Excel*

Solutions

Expert Solution

We can use Excel function to find the p value as :

P-value = TDIST(T-statistic,n-1,2) = TDIST(3,100-1,2) = 0.0034

Hence, there is enough evidence to conclude that the average amount of liquid is different than 0.25 at 5% level of significance.

orchestra answered 2 years ago
Next > < Previous

Related Solutions

An electronics store has received a shipment of 30 table radios that have connections for an...
An electronics store has received a shipment of 30 table radios that have connections for an iPod or iPhone. Twelve of these have two slots (so they can accommodate both devices), and the other eighteen have a single slot. Suppose that eight of the 30 radios are randomly selected to be stored under a shelf where the radios are displayed, and the remaining ones are placed in a storeroom. Let X = the number among the radios stored under the...
A lumber company has just taken delivery on a shipment of 10,000 2 ✕ 4 boards....
A lumber company has just taken delivery on a shipment of 10,000 2 ✕ 4 boards. Suppose that 10% of these boards (1000) are actually too green to be used in first-quality construction. Two boards are selected at random, one after the other. Let A = {the first board is green} and B = {the second board is green}. (a) Compute P(A), P(B), and P(A ∩ B) (a tree diagram might help). (Round your answer for P(A ∩ B) to...
1. A salsa producer has just received a shipment of tomatoes from their main supplier. If...
1. A salsa producer has just received a shipment of tomatoes from their main supplier. If the salsa company finds convincing evidence that more than 7% of the tomatoes are damaged and unusable for the salsa making process, the truck will have to be sent away and a new shipment will have to be sent out by the supplier. An inspection reveals that 49 tomatoes are unusable when the supervisor selects a random sample of 500 tomatoes from the truck....
A 1830-kg car experiences a combined force of air resistance and friction that has the same...
A 1830-kg car experiences a combined force of air resistance and friction that has the same magnitude whether the car goes up or down a hill at 34.5 m/s. Going up a hill, the car's engine needs to produce 74.7 hp more power to sustain the constant velocity than it does going down the same hill. At what angle is the hill inclined above the horizontal?
$10,000 is used to purchase an appropriate size annuity that has level annual payments for 15...
$10,000 is used to purchase an appropriate size annuity that has level annual payments for 15 years. The price of the annuity is based on an effective annual rate of 12%. As each payment is received, it is put into a fund that earns an effective annual rate of 6.4%. (a) Determine the accumulated value of the investment at the end of 15 years. (b) If the $10,000 were put into a fund that was to produce the same final...
Teloxy Engineering has received a one-time contract to design and build 10,000 units of a new...
Teloxy Engineering has received a one-time contract to design and build 10,000 units of a new product. During the proposal process, management felt that the new product could be designed and manufactured at a low cost. One of the ingredients necessary to build the product was a small component that could be purchased for $60 in the marketplace, including quantity dis- counts. Accordingly, management budgeted $650,000 for the purchasing and handling of 10,000 components plus scrap. During the design stage,...
A city has 10,000 households, and you have collected a simple random sample size of 25...
A city has 10,000 households, and you have collected a simple random sample size of 25 from the households in this city and measured how much each household paid in school taxes in 2012. For this sample, X = $2500, and s = $ 1000. You wish to construct a 95% confidence interval for μ.
A consumer advocacy group received a tip that an air conditioning company has been charging female...
A consumer advocacy group received a tip that an air conditioning company has been charging female customers more than male customers. The group's statistical expert decides examine this question at the α=0.10α=0.10 level of significance, by looking at the difference in mean charges between a random sample of female customers and a random sample of male customers. Let μFμF represent the average charges for female customers and μMμM represent the average charges for male customers.(Round your results to three decimal...
A consumer advocacy group received a tip that an air conditioning company has been charging female...
A consumer advocacy group received a tip that an air conditioning company has been charging female customers more than male customers. The group's statistical expert decides examine this question at the α=0.10α=0.10 level of significance, by looking at the difference in mean charges between a random sample of female customers and a random sample of male customers. Let μFμF represent the average charges for female customers and μMμM represent the average charges for male customers.(Round your results to three decimal...
Joe Masters has received a job offer from a large wine retailer. His base salary will...
Joe Masters has received a job offer from a large wine retailer. His base salary will be $136,500. He will receive his first annual salary payment one year from the day he begins work. He will also get an immediate $50,000 bonus for joining the company. His salary will grow at 5 percent each year, starting after the first year. Mr. Masters is expected to work for 15 years. What is the present value of the offer if the discount...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT