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.(Each part is worth 2 marks)

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 (1).xIsx - Excel Page Layout Formulas Data Review Add-ins ? Tell me what you want to do.. Sign in Share File Home Insert View Team X Cut Calculation Calibri AA Be Wrap Text General Normal Bad Good Neutral AutoSum . A O Fill Paste BE Copy BIU - B - LA Merge & Center $ - % % 08 58 Conditional Format as Check Cell Explanatory ... Input Linked Cell Note Insert Delete Format Formatting * Table _ Clear Sort & Find & Format Painter Filter . Select Font Alignment Number Styles Cells Editing Clipboard H15 X V D E F G K L M N P Q R S T U V W X Y Z AA AB AC AD B Store Item Price Item Super$ Ralph's Lowblaws Super$ 1.12 $1.12 $1.02 $1.07 3 Super$ 2 1.14 W N 1.14 1.1 1.21 Super$ 3 1.72 1.72 1.97 2.08 Super$ 4 2.22 2.22 2.09 2.32 Super$ 5 2.4 2.4 2.3 Super$ 4.04 U A 2.1 6 4.04 4.32 4.15 Super$ 5.05 5.05 4.95 5.05 Super$ 8 4.68 4.68 4.13 4.67 Super$ 5.52 9 5.52 5.46 5.86 11 Ralph's 1 1.02 12 Ralph's N 1.1 13 Ralph's 3 1.97 14 Ralph's 4 2.09 15 Ralph's 2.1 16 Ralph's 6/ 4.32 17 Ralph's 4.95 18 Ralph's B/ 4.13 Ralph's 2/ 5.46 20 owblaws 1.07 21 lowblaws 2 1.21 22 owblaws 2.08 23 Lowblaws 2.32 24 Lowblaws 2.3 25 lowblaws 6/ 4.15 26 owblaws 5.05 27 lowblaws B 4.67 28 owblaws LD 5.86 29 30 31 32 33 34 35 36 37 Q1 + # 0 J -- Ready