When finding the mean and standard deviations, please use the average and var.s functions. Please use excel and show all steps. Thank you. Attached is the data.

If you choose a brown M&M at random, what is the probability that it weighs less than 0.8g.

If you picked 10 brown M&Ms at random and averaged their masses, what is the probability that the average mass is less than 0.8 g?

Transcribed Image Text:

RED (13%) Mass of M&M candies (in grams) by color ORANGE (25%) YELLOW (12%) BROWN (12%) BLUE (25%) GREEN (13%) 0.751 0.735 0.883 0.696 0.881 0.925 0.841 0.895 0.769 0.876 0.863 0.914 0.856 0.865 0.859 0.855 0.775 0.881 0.799 0.864 0.784 0.806 0.854 0.865 0.966 0.852 0.824 0.84 0.81 0.865 0.859 0.866 0.858 0.868 0.858 1.015 0.857 0.859 0.848 0.859 0.818 0.876 0.942 0.838 0.851 0.982 0.868 0.809 0.873 0.863 0.803 0.865 0.809 0.888 0.932 0.848 0.89 0.925 0.842 0.94 0.878 0.793 0.832 0.833 0.905 0.977 0.807 0.845 0.85 0.841 0.852 0.83 0.932 0.778 0.856 0.833 0.814 0.842 0.881 0.791 0.778 0.818 0.81 0.786 0.864 0.881 0.853 0.825 0.864 0.855 0.873 0.942 0.88 0.825 0.882 0.869 0.931 0.912 0.887 0.886 RED (13%) Mass of M&M candies (in grams) by color ORANGE (25%) YELLOW (12%) BROWN (12%) BLUE (25%) GREEN (13%) 0.751 0.735 0.883 0.696 0.881 0.925 0.841 0.895 0.769 0.876 0.863 0.914 0.856 0.865 0.859 0.855 0.775 0.881 0.799 0.864 0.784 0.806 0.854 0.865 0.966 0.852 0.824 0.84 0.81 0.865 0.859 0.866 0.858 0.868 0.858 1.015 0.857 0.859 0.848 0.859 0.818 0.876 0.942 0.838 0.851 0.982 0.868 0.809 0.873 0.863 0.803 0.865 0.809 0.888 0.932 0.848 0.89 0.925 0.842 0.94 0.878 0.793 0.832 0.833 0.905 0.977 0.807 0.845 0.85 0.841 0.852 0.83 0.932 0.778 0.856 0.833 0.814 0.842 0.881 0.791 0.778 0.818 0.81 0.786 0.864 0.881 0.853 0.825 0.864 0.855 0.873 0.942 0.88 0.825 0.882 0.869 0.931 0.912 0.887 0.886