1. Please solve this problem in Excel and submit your Excel spreadsheet. The problem is as follows:

The owner of Gilleys Ice Cream Parlor has noticed that she sells more ice cream on hotter days during the summer, especially on days when the temperature is 85 degrees Fahrenheit or higher. To plan how much ice cream to stock, she would like to know the average daily high temperature for the summer months of July and August. Assuming that daily temperatures are normally distributed, she has gathered the following data for the high temperature for 20 days from a local almanac.

86 92 85 94 78 83 91 81 90 84 92 76 83 78 80 78 69 85 74 90

1. Compute the mean and standard deviation for these data
2. Determine the probability that a summer days high temperature will be 85 or higher.
3. How many days will have a temperature between 75 and 85?
4. What temperature will put a day in the bottom 10% among all summer days?
5. What temperature will put a day in the top 1% among all summer days?

Please use Excell for solving and how. ! :)