Dunkin' selects random consumers to analyze smoothie consumption. Use the smoothie consumption data below (also in attached file) to answer the following questions:

a.Develop a histogram of the data. Explain what the histogram depicts.

b.Construct a relative and a cumulative relative frequency distribution of the data.

c.What percentage of the smoothie drinkers sampled drink 8.0 kg or more annually?

Smoothie Consumption (kgs.) 7.7 7.9 5.6 7.5 7.9 6.5 6.7 5.8 7.6 10.1 6.8 6.6 7.9 6 6.4 6.3 6.1 5.3 6 7.5 6.3 7.6 6.8 4.5 6 3.8 5.3 7 6.4 6.9 6.5 6.2 7 6.2 6.3 5.3 5.9 5.3 7.5 6.9 6.1 7.4 8.4 8.3 6.1 8 7.8 7.8 6.3 5.3 6.5 4.7 5.5 8.9 6.5 8.6 7 4.6 7.1 5.9 5 5 5 7.6 7.6 7.2 6.7 7.8 8 5.4 6 5.7 6.3 6.6 4.6 5.7 6.8 6.4 5.7 7.7 6.4 4.7 6.8 7.5 8 6 6.1 6.8 6.3 6.7 7.4 7.5 4.8 5.3 6.1 6.2 5.4 6.4 7.2 6.6 5.4 8.4 6.8 7.6 6.4 7.6 5.6 7.2 6.5 6.6 6 7.1 5.8 7.3 6.7 6.6 7.1 6.5 5 6.8 7.9 6 5.4 8.4 8 6.5 7.2 6.4 6.5 5.2 6.8 8 6.5 3.5 7.4 4.4 6 7 7.2 7.6 5.7 4.8 5.5 6.7

Note: please attach excel file or screenshot with explanations

thank you

Smoothie Consumption (kgs.) 7.7 7.9 5.6 7.5 7.9 6.5 6.7 5.8 7.6 10.1 6.8 6.6 7.9 6 6.4 6.3 6.1 5.3 6 7.5 6.3 7.6 6.8 4.5 6 3.8 5.3 7 6.4 6.9 6.5 6.2 7 6.2 6.3 5.3 5.9 5.3 7.5 6.9 6.1 7.4 8.4 8.3 6.1 8 7.8 7.8 6.3 5.3 6.5 4.7 5.5 8.9 6.5 8.6 7 4.6 7.1 5.9 5 5 5 7.6 7.6 7.2 6.7 7.8 8 5.4 6 5.7 6.3 6.6 4.6 5.7 6.8 6.4 5.7 7.7 6.4 4.7 6.8 7.5 8 6 6.1 6.8 6.3 6.7 7.4 7.5 4.8 5.3 6.1 6.2 5.4 6.4 7.2 6.6 5.4 8.4 6.8 7.6 6.4 7.6 5.6 7.2 6.5 6.6 6 7.1 5.8 7.3 6.7 6.6 7.1 6.5 5 6.8 7.9 6 5.4 8.4 8 6.5 7.2 6.4 6.5 5.2 6.8 8 6.5 3.5 7.4 4.4 6 7 7.2 7.6 5.7 4.8 5.5 6.7