Input the following information into Excel to solve the problem

Background: 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

ANOVA

Carry out an ANOVA to determine whether there is evidence to support the claim that the mean number of gummies per package is equal for each color. In other words, consider each of the colors as a treatment that has 38 observations each. Test at the 0.05 and the 0.01 levels of significance.

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