The Hawaii Island Chamber of Commerce collects ocean temperature data to help promote tourism for local businesses.

The Excel file titled Hawaii ocean temps.xlsx lists daily ocean temperatures for the past 125 days.

a. Using Excel, construct a frequency distribution for these data.

b. Using the results from part

a, calculate the relative frequencies for each class.

c. Using the results from part

a, calculate the cumulative relative frequencies for each class.

d. Construct a histogram for these data.

e. For what percentage of days was the ocean temperature less than 77 degrees Fahrenheit?

AppendixLO1