Wind Chill Factor.We all have experienced "wind chill". In the cold weather especially, when the wind blows on your exposed skin with increased speed, the perceived temperature seems to decrease. Might there be a linear relation between wind speed and the wind chill factor?

The wind chill "factor" depends on wind speed and air temperature. The data in the accompanying data file represent the wind speed (in mph) and wind chill factor at an air temperature of 15° Fahrenheit.

Access the data file below, which is an Excel spreadsheet with the wind chill data already populated. It is recommended you use Excel to answer the questions below:

(a) Draw a scatter diagram of the data treating wind speed as the explanatory variable. What kind of trend do you see in the data?

(b) Determine the linear correlation coefficient between wind speed and wind chill factor. Does this value alone imply a good linear relation between wind speed and wind chill factor?

(c) What is the equation of the least-squares regression line?

(d) What do the residuals look like? Are they random or do they exhibit a trend?

(e) So after all this: Do you think the least-squares regression line is a good model? Why or why not? If not, what other kind of model might better explain the relationship between wind speed and wind chill factor?

Attachment:- data file.xlsx