i need the calculations for the asnwer on execel. how to do calculations on excel for this question.
3. Crundy Chewy Flakes Case (Modified from Exaroples in Levine, et. al. Statistics for Managers: Using Aficrosoft Excel 2017.) Health Good Food, Inc. (henceforth HGF) is a company that produces various food products including carcal. Each best of Crunchy Clewy Flakes is said to be 398 grams (bor not included). The company has been producing Crunchy Chewy Flakes for approximately 20 years without any major incidents or complaints. The firun bus two plants producing Crunchy Chrwy Flalow the Thunder Bay Plant (or Planit 1) and the Sherbrooke Plant (or Plant 2). The ww CEO, Grace Lee, has speurhuuded a move to more automated production of various products to improve the firm's profit margins. This change in direction has resulted in the firm switching to a more automated ceteal packing process Within a month of the switch, Dana Si, published an op-ed in a local Quebec City newspaper claiming that the company was cheating its consumers. In response, the HGF contacted Mrs. Si and requested the provide support for her claim. Mrs. Si directed the firm to a series of YouTube videos where she was weighing bags of Crunchy Chewy Flakes. The data luas been recorded/documented in the Box-Concerns.xlsx file. Soon after, the Consumers Association of Atlantic Canada (CAAC) sent a complaint to the Competition Bureau of Canada claiming that HGF was defrauding consumers. CAAC is a consumer's advocacy group for Atlantic Canada. Their complaint included data ot becomes of cereal purchused in Sydney, Novn Sootin. The complaint and data was also slured with HGF (note: data is included in Box-Concerns.xlsx file). In response, Grace Lee ordered a random sample of the cereal weights be collected from each of the plants. The data from Plant 1 and Plant 2 are included in the Bcc-Concem.xlsx file. (a) What does the data suggest? Hitt: Does the data suggest that there is a difference at a 0.05 level of significance between production of the two plants? Further Hint: If you want to test wwerall cereal production, should test data from both plants together. Final Hint: Maloe sure you document wit you are testing with the data. (1) Write tp a short (approximately 1 pago) response analyzing the case tsing the steps described on Slide 16 of Lecture 1. 3. Crundy Chewy Flakes Case (Modified from Exaroples in Levine, et. al. Statistics for Managers: Using Aficrosoft Excel 2017.) Health Good Food, Inc. (henceforth HGF) is a company that produces various food products including carcal. Each best of Crunchy Clewy Flakes is said to be 398 grams (bor not included). The company has been producing Crunchy Chewy Flakes for approximately 20 years without any major incidents or complaints. The firun bus two plants producing Crunchy Chrwy Flalow the Thunder Bay Plant (or Planit 1) and the Sherbrooke Plant (or Plant 2). The ww CEO, Grace Lee, has speurhuuded a move to more automated production of various products to improve the firm's profit margins. This change in direction has resulted in the firm switching to a more automated ceteal packing process Within a month of the switch, Dana Si, published an op-ed in a local Quebec City newspaper claiming that the company was cheating its consumers. In response, the HGF contacted Mrs. Si and requested the provide support for her claim. Mrs. Si directed the firm to a series of YouTube videos where she was weighing bags of Crunchy Chewy Flakes. The data luas been recorded/documented in the Box-Concerns.xlsx file. Soon after, the Consumers Association of Atlantic Canada (CAAC) sent a complaint to the Competition Bureau of Canada claiming that HGF was defrauding consumers. CAAC is a consumer's advocacy group for Atlantic Canada. Their complaint included data ot becomes of cereal purchused in Sydney, Novn Sootin. The complaint and data was also slured with HGF (note: data is included in Box-Concerns.xlsx file). In response, Grace Lee ordered a random sample of the cereal weights be collected from each of the plants. The data from Plant 1 and Plant 2 are included in the Bcc-Concem.xlsx file. (a) What does the data suggest? Hitt: Does the data suggest that there is a difference at a 0.05 level of significance between production of the two plants? Further Hint: If you want to test wwerall cereal production, should test data from both plants together. Final Hint: Maloe sure you document wit you are testing with the data. (1) Write tp a short (approximately 1 pago) response analyzing the case tsing the steps described on Slide 16 of Lecture 1
