Max Wind Speed (mph)	Central Pressure (mb)
110	920
145	922
135	925
110	931
130	934
120	934
125	936
100	937
115	938
130	941
90	942
100	942
110	945
105	945
100	945
65	946
105	946
105	946
115	948
100	949
100	949
100	950
110	950
110	950
110	950
105	950
105	950
100	951
105	952
100	953
105	953
100	954
100	954
100	955
105	955
105	955
105	955
95	955
65	955
95	955
90	956
100	957
90	957
95	958
100	959
100	959
100	959
100	960
100	960
100	960
110	960
100	960
90	960
100	961
80	961
100	962
90	962
100	963
90	963
80	963
90	964
95	964
90	964
70	965
90	965
90	965
90	965
95	965
85	967
90	969
90	969
90	969
90	969
90	969
90	969
90	969
90	969
90	969
90	969
90	969
70	970
70	970
90	970
90	970
95	970
100	971
75	971
90	972
85	972
85	972
70	972
90	973
85	973
85	973
85	973
80	973
85	973
85	973
65	973
85	973
80	973
85	973
85	973
90	974
90	975
90	975
80	976
80	976
75	976
80	977
80	977
80	977
80	977
80	977
85	979
75	979
80	979
80	980
75	980
75	981
75	981
75	981
65	982
70	983
75	983
70	984
70	984
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
55	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
70	985
65	985
75	986
70	986
70	987
80	987
70	987
70	987
65	988
65	988
55	989
65	989
70	990
75	990
65	990
65	991
65	993
65	1002

Hurricanes have low pressure at their center. This pulls in moist air and generates high wind speeds. The file HurricaneWindPressure.xlsx contains data from National Hurricane Center (NHC), National Oceanic and Atmospheric Administration (NOAA) on the wind speed and central pressure for 163 hurricanes that have hit the US since 1851. For comparison, standard sea level pressure is 1013 millibars (mb) or 29.9 inches of mercury. Hurricane Katrina had a central pressure of 902 mb and wind speed of 175 mph.

1. Use central pressure to predict maximum wind speed:

(a) Which variable is the response variable?

(b) Make a scatterplot of wind speed against central pressure. Label the graph and each axis.

(c) Insert the trend line and r squared value on your scatterplot.

(d) What is the correlation between wind speed and central pressure? What 2 specific things does this value of correlation, r, tell you about the relationship between wind speed and central pressure?

2.

(a) Using the regression equation, use Hurricane Katrinas central pressure to predict its wind speed.

(b) What is the residual for Katrina? (Residual = Actual value Predicted value) .

(c) Have Excel find the residuals for all the central pressure values.

(d) Plot the residuals against central pressure in a scatterplot.