a.you received a (virtual) bag of M&Ms.You have opened it, weighed the contents (in grams) on a food scale, and recorded the weight for your bag.See the attached Excel Spreadsheet.

b.Additionally, you have counted the number of M&M pieces your bag contains, counted the number of the class' favorite color ... most classes choose Blue M&Ms as their favorite color, so we'll run with that.And you have recorded these two pieces of information as well.Again, see the attached Excel Spreadsheet.

c.Now, you must use the complete class' weight information to determine an appropriate confidence interval for the mean weight()

()of a bag of M&Ms with a 95% confidence level.Be certain to state the meaning of your confidence interval in terms of today's measurements, and compare your interval with the average weight claim on the M&Ms package.

d.Use the piece information to develop a confidence interval for the true proportion()

()of the class' favorite color contained in the bags of M&Ms at an 80% confidence level.Again, state the meaning of your confidence interval in terms of this measurement. And answer the question ... does your interval for the proportion suggest all colors are equally represented?If the M&M colors are Red, Orange, Yellow, Blue, Green, and Brown, what proportion would show all colors with equal representation?

e.Submit your Excel file with data, results, meaning, and conclusions, the functions

f.separately, use your spreadsheet to correctly conduct a hypothesis test that the mean weight () of a bag of M&Ms is greater than the weight stated on the package.Use a Significance level of 90%.You can use built-in Excel functions or build up your test directly from theory.

Whats on exel sheet:

Student Weight (gms) Total Pieces Favorite Color

student 1 49 53 13

S2 50 54 15

s3 48 53 17

s4 49 54 14

s5 47 56 13

s6 49 55 11

s7 48 55 15

s8 48 55 8

s9 48 56 10

s10 47 41 8

s11 47 54 7

s12 43 55 14

s13 50 54 15

s14 48 55 16

s15 49 56 9

s16 50 54 14

s17 50 55.5 15.5

s18 48 55 14

s19 47 54 13

s20 47 54 13

s21 50 56.5 13

s22 49 56 5

s23 49 56 6

s24 50 57 8

s25 48 55 10

s26 49 56 10

s27 48 54 6