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.


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?
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...
Murphy’s Law: The Air Force has ordered a new fighter jet from Lockheed Martin with contains...
Murphy’s Law: The Air Force has ordered a new fighter jet from Lockheed Martin with contains 1000 critical engineering components. Tests have shown that each of these parts will fail independently with a probability of p = 0.001. In the design team they have to decide how much redundancy to build into the system. (a) Define a random variable X which counts the number of components which fail on the jet. What distribution does X have, and what are the...
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...
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
ADVERTISEMENT
ADVERTISEMENT