THERE IS NO FILE EXCEL FILE CREATED Hypothesis Testing with M&Ms The plain M&M's Milk Chocolates are mass-produced with a distribution of 24% blue, 20% orange, 16% green, 14% yellow, 13% red and 13% brown. The peanut M&M's are mass-produced with a distribution of 23% blue, 23% orange, 15% green, 15% yellow, 12% red and 12% brown. Open a packet of your favorite M&Ms, plain or peanut.Count the number of M&M's in the packet.Count number of BLUE, ORANGE, GREEN and RED candies.Using the Excel file for One Sample Hypothesis Testing, conduct a test of proportions for each of the four colors. Use two-tailed tests and a .05 significance level in each case. Be sure to use the proportions shown above as the hypothesized values.After each student has posted their results, the instructor will summarize the findings. What we should see is that about 5% of the samples will likely result in a rejection of the null hypothesis.Need this in an excel file please