Input the information into excel to complete the problem.

The owner of Haribo hires you to perform some statistical analysis. The owner knows that producing one yellow gummy cost 1 cent. Also, the price for one red gummy is 1 cent. However, making one green gummy costs 5 cents, and producing one orange gummy costs 3 cents. These costs are well known in the company, and everyone refers to the yellow and red gummies as low-cost candy and orange and green as high-cost gummies. The marketing team developed a campaign to find out the gummy colors that clients prefer. Unsurprisingly, people prefer green and orange gummies. Hence, the marketing team wants to have those colors on every package. The team responsible for labeling the nutrition facts computes sugar and sodium content based on packages estimated to have seven gummies. Hence, the production team sets the machines to produce packages that are expected to have seven gummies. The financial team decided that the best way to minimize cost and fulfill the requirements of the marketing and nutrition teams is to produce packages expected to have one green and one orange gummy (high-cost group) and two yellow and three red gummies (low-cost candy). Use the gummy_sample_exam3.xlsx file to answer the following questions

Inference with Two Populations

a) What is the average proportion of low-cost candy per package? What is the standard deviation of the average proportion of low-cost candy per package?

b)What is the average proportion of high-cost gummies per package? What is the standard deviation of the average proportion of high-cost gummies per package?

c)Compute a 95% confidence interval for the difference in the proportions of low-cost candy and high-cost gummies per package.

d) If the production per package goes according to plan, what would be the expected proportion of low-cost candy per package?

e) If the production per package goes according to plan, what would be the expected proportion of high-cost gummies per package?

f) If the production per package goes according to plan, what would be the expected difference in the proportions of low-cost candy per package and high-cost gummies per package? Hint: The expected difference will be equal to the difference between the proportions used in question d) and question e).

A2 X V fx 2 A B C D E F G H I J K L M N P Q R S T U V W 1 Yellow Red X Y Z AA AB AC AD AE Green Orange AF AG AH Al AJ AK AL AM 2 W N ON WN- A - WO- O - W N W - O O W - O - O N O N O N O O N W N O O O O O - - O A O - A N - A W - O O N N A N WANA - A - ANNAN - N NANO WA- W- JAWS - - W A W N A - - J J J - NO - W W N N N N - W N - A - - O W A O - AT - N - - N N - - O - N W - NO Now