I have been given a set of data in my biostats class. I am working on excel. I h

Question

I have been given a set of data in my biostats class. I am working on excel. I have to answer the following questions but have no idea which commands to use. The information posted below doesn't include all of the data that I was given but if you could tell me what Iam being asked for I can find the answers mysel. Is this asking for R? Slope?

Hurricanes have low pressure at their center. This pulls in moist air and generates high wind speeds. The fileHurricanesWindPressure.xlxs 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.

Use central pressure to predict maximum wind speed:

Which variable is the response variable?

Which variable is the explanatory variable?

Make a scatterplot of wind speed against central pressure. (Instructions at end of assignment.)

Insert the trend line, its equation, and the R2value. (Instructions at end of assignment.)

What is the correlation between wind speed and central pressure?

Using the regression equation, use Hurricane Katrina’s central pressure to predict its wind speed.

Was the actual wind speed for Katrina higher or lower than that predicted by the central pressure?

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

Explanation / Answer

Solution:

a) Which variable is a response variable : Hurricanes is the response variable

b) which variable is the explanatory variable : Sea level pressure and wind speed

c)Make a scatter plot ( you have to attach the dataset for scatter plot) But will give you instruction on how to build one and also its use

A scatter plot is used to see the relationship between explanatory variable.

how to build in excel

Making a Scatter Plot 1. Under Insert (on PC) or under Charts (on Mac), select Scatter Plot. Chose the option without connecting lines. A blank graph will come up. 2. Right click on the blank graph and choose Select Data. Choose the appropriate data for x and y

d) Insert a trend line, equation and R2(R square) : A trend line will help us examining the linearity between our response and predicter variable and a equation of the line can be build. R2(R square ) : Rsquare is calculated into percentage which help us understanding the variation explained by our independent variable . If >0.70 or 70% then termed as good fit to the model

e) Answer to the other question i need dataset (Excel sheet of the data). Please provide the dataset and I will be able to answer the remaining questions.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.