Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
i need the calculations for the asnwer on execel. how to do calculations on excel for this question.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started