1. Math
  2. Statistics And Probability
  3. i really need to know how to calculate the pvalues...

Question: i really need to know how to calculate the pvalues...

Question details

I really need to know how to calculate the P-values in Excel, please help me with the p-values

STORE Item Half-gallon milk Dozen eggs Head of lettuce Ground beef 1 lb Apples 1 lb Whole chicken The data to the right compared the price of some kitchen staples at four different supermarkets located in the same city. 2.15 2.38 2.06 4.83 1.74 2.23 1.62 1.59 1.52 3.91 1.92 1.26 1.37 1.72 1.26 3.82 1.44 1.54 1.87 2.27 1.22 3.56 0.93 1.54 a. At he 0.05 level o significance s here evidence of a difference in the mean prices orthese kitchen staples at the four supermarket ? Determine he null and alternative hypotheses where μΑ le-Ac and Hoare the mean prices at Store A, Store B, Store C, and Store D, respectively. Choose the correct answer below. H: At least one mean is different OD. Ho: At least one mean is different Calculate the p-value p-value-0.002 (Round to three decimal places as needed.) Is there evidence of a difference in the mean prices for these kitchen staples at the four supermarkets? O A. Yes. Do not reject Ho and conclude that there is evidence of a difference.Item   A   B   C   D
Half-gallon_Milk   2.15   1.62   1.37   1.87
Dozen_Eggs   2.38   1.59   1.72   2.27
Head_of_Lettuce   2.06   1.52   1.26   1.22
Ground_Beef_1_lb   4.83   3.91   3.82   3.56
Apples_1_lb   1.74   1.92   1.44   0.93
Whole_Chicken   2.23   1.26   1.54   1.54

b. Do you think that there was a significant block effect in this experiment? Use a 0.05 level of significance. Determine the null and alte native hypotheses where μ, μ2t3 Ha 5 and Ho are the mean grocery prices for each item across all stores. Choose the correct answer below. O B. Ho: Not all μί are equal where i-12 ,6 H1 : Not all are equal where i = 12, 6 Find the p-value p-value 0.000 (Round to three decimal places as needed.) Is there evidence of a significant block effect in this experiment?

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution