Each of the three supermarket chains in Denver are claims to have to lower overall prices.As part of an investigative study, a local media television station conducted a study by randomly selecting nine grocery items.Then, on the same day, an intern was sent to each of the three stores to purchase the nine items.From the receipts, the following data were recorded:click hereto access the table containing the data. Please provide your answers in the space provided below.Also attach the excel worksheet that shows the details of your answer.

a)What are the null and alternate hypotheses?

b)What are the test statistics?

c)What are the p-values?

d)Using a 0.05 significance level, what is your decision regarding the null hypotheses?

e)Interpret the result.

Final Exam Q1.xIsx - Excel File Home Insert Page Layout Formulas Data Review View Add-ins Team Tell me what you want to do.. do Cut Calibri Copy - 12 - A A Eff Wrap Text General Normal Bad Good Neutral Calculation Paste BIU - - LA- Merge & Center Conditional Format as Check Cell Explanatory ... Input Linked Cell Note Format Painter Formatting Table Clipboard Font Alignment Number Styles K18 X V B D E F G H K M N O P Q R S T U V W Store tem Price Item Super$ Ralph's Lowblaws A W N Super$ 1 1.12 1 $1.12 $1.02 $1.07 Super$ UPWN 1.14 W N 1.14 1.1 1.21 Super$ 1.72 1.72 1.97 2.08 Super$ 2.22 2.22 2.09 2.32 Super$ 2.4 2.4 2.1 2.3 Super$ 1.04 4.04 4.32 4.15 LD CO Super$ 5.05 7 5.05 4.95 5.05 Super$ 4.68 4.68 4.13 4.67 10 Super$ 5.52 5.52 5.46 5.86 11 Ralph's 1.02 12 Ralph's 1.1 13 Ralph's 1.97 14 Ralph's 2.09 15 Ralph's 2.1 16 Ralph's 4.32 17 Ralph's 4.95 18 Ralph's 4.13 19 Ralph's 5.46 20 owblaws 1.07 21 Lowblaws 1.21 22 lowblaws 2.08 23 owblaws OUI AWN PU 2.32 24 owblaws 2.3 25 owblaws 4.15 26 Lowblaws 5.05 27 owblaws 4.67 28 Lowblaws LD 00 5.86 29 30 31 32 33 34 35