MBA 598-Statistics Homework Assignment # 2

MBA 598-Statistics

Homework Assignment # 2

Submit Homework Assignment # 2 to the Dropbox no later than 11:59 pm (EST) on Sunday, March 21, 2021.  The required submission format is Microsoft EXCEL as one file with four tabs.

1.  (5) Using the Data Set:  Diastolic Blood Pressure and Weight, Input the Diastolic Blood Pressure and Weight Data into EXCEL.
2. (10) Construct the Five Number Summary for the Diastolic Blood Pressure and the Weight.
3. (10) Construct a Scatter Plot for Weight (explanatory variable) vs Diastolic Blood Pressure (response).  Please label axes and title.
4. Using the Regression Module and the ANOVA (Analysis of Variance)

1. (10) Develop a linear regression model (using EXCEL) for these data. 
2. (10) Forecast the weight if the diastolic blood pressure is 90 mmHg. 
3. (10) Using EXCEL, forecast the diastolic blood pressure if the weight is 168.
4. (10) Determine the strength of the linear relationship between diastolic blood pressure and weight and explain its meaning.
5. (10) What is the coefficient of determination? Explain its meaning.
6. (10) Construct a Residual Plot and explain its meaning.
7. (10) List and define the Significance of F value, p-value for the intercept and the slope.
8. (5) List and define the meaning slope.