Item WinCo Foods Bananas (lb) $0.42 Red Onions (lb) $0.58 Mini Peeled Carrots (1 lb bag) $0.98 Roma Tomatoes (lb) $0.98 Deli Tater Wedges (lb) $1.18 Beef Cube Steak (lb) $3.83 Beef Top Round London Broil (lb) $3.48 Pillsbury Devils Food Cake Mix (18.25 oz) $0.88 Lipton Rice and Sauce Mix (5.6 oz) $0.88 Sierra Nevada Pale Ale (12 - 12 oz bottles) $12.68 GM Cheerios Oat Clusters (11.3 oz) $1.98 Charmin Bathroom Tissue (12 roll) $5.98 Bumble Bee Pink Salmon (14.75 oz) $1.58 Pace Thick & Chunky Salsa, Mild (24 oz) $2.28 Nalley Chili, Regular w/Beans (15 oz) $0.78 Challenge Butter (lb quarters) $2.18 Kraft American Singles (12 oz) $2.27 Yuban Coffee FAC (36 oz) $5.98 Totino's Pizza Rolls, Pepperoni (19.8 oz) $2.38 Rosarita Refried Beans, Original (16 oz) $0.68 Barilla Spaghetti (16 oz) $0.78 Sun-Maid Mini Raisins (14 - 0.5 oz) $1.18 Jif Peanut Butter, Creamy (28 oz) $2.54 Dole Fruit Bowl, Mixed Fruit (4 - 4 oz) $1.68 Progresso Chicken Noodle Soup (19 oz) $1.28 Precious Mozerralla Ball, Part Skim (16 oz) $3.28 Mrs. Cubbison Seasoned Croutons (6 oz) $0.88 Kellog's Raisin Bran (20 oz) $1.98 Campbell's Soup at Hand, Cream of Tomato (10.75 oz) $1.18 Walmart $0.48 $0.98 $1.48 $2.67 $1.78 WinCo Foods, a large discount grocery retailer in the Western United States, prom lowest priced grocery retailer. In newspaper ads WinCo Foods published a price co products between WinCo and several competing grocery retailers. One of the retai WinCo was Walmart, also known as a low price competitor. WinCo selected a varie the price of the product charges at each retailer, and showed the sales receipt to p WinCo were the lowest in the area. A sample of the products and their price compa and Walmart are shown on the left. Do the prices listed indicate that, on average, p lower than prices at Walmart? Use 5% significance level. Solve this question using Excel. State the null & alternative hypotheses clearly. Inte and state your conclusion clearly. Provide all your results and comments on this sh in your answers in the spaces provided below: $4.11 $4.12 $0.88 Are the samples related (i.e. dependent) or independent? Null Hypothesis: $1.06 $11.84 Alternative Hypothesis: $2.74 $5.48 Interpretation of Excel output: $1.98 $2.78 $0.78 $2.58 $2.27 $7.56 $2.42 $0.73 $1.23 $1.36 $1.92 $1.98 Full conclusion: $1.38 $4.23 $1.12 $1.68 $1.26 stern United States, promotes itself as the oods published a price comparison for retailers. One of the retailers compared against or. WinCo selected a variety of products, listed wed the sales receipt to prove the prices at cts and their price comparison at both WinCo dicate that, on average, prices at WinCo are e hypotheses clearly. Interpret the Excel output and comments on this sheet. Specifically, type Branch 1 4.21 5.55 3.02 5.13 4.77 2.34 3.54 3.20 4.50 6.10 0.38 5.12 6.46 6.19 3.79 Branch 2 9.66 5.90 8.02 5.79 8.73 3.82 8.01 8.35 10.49 6.68 5.64 4.08 6.17 9.91 5.47 A bank with a branch (Branch 1) loca for serving customers during the noon time elapsed from when the custome shortened to increase customer satis minutes) are shown in the table on th residential area, is also concerned wi selected and the results are shown in branches are equal, is there evidence branches? Use alpha = 0.01. Solve this question using Excel. State state your conclusion clearly. Provide answers in the spaces provided below Are the samples related (i.e. depende Null Hypothesis: Alternative Hypothesis: Interpretation of Excel output: Full conclusion: th a branch (Branch 1) located in a commercial district of a city has developed an improved process g customers during the noon-to-1 p.m. lunch period. The waiting time (operationally defined as the sed from when the customer enters the line until he or she reaches the teller window) needs to be d to increase customer satisfaction. A random sample of 15 customers is selected and the results (in are shown in the table on the left. In addition, suppose that another branch (Branch 2), located in a l area, is also concerned with the noon-to-1 p.m. lunch period. A random sample of 15 customers is and the results are shown in the table on the left. Assuming that the population variances from both are equal, is there evidence of a significant difference in the mean waiting time between the two ? Use alpha = 0.01. question using Excel. State the null & alternative hypotheses clearly. Interpret the Excel output and conclusion clearly. Provide all your results and comments on this sheet. Specifically, type in your n the spaces provided below: amples related (i.e. dependent) or independent? thesis: e Hypothesis: tion of Excel output: usion: oved process fined as the needs to be the results (in located in a customers is es from both en the two el output and ype in your