Explore BrainMass

Obtaining regression equation & correlation using excel toolpak

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Name: Date:

Topic Five: Correlation/Regression and Chi Square Excel Worksheet

Directions: Answer all problems and submit to instructor at the end of Module 5

SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES
The following table represents systolic and diastolic blood pressure measurements of 40 females.

A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.

B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.

C) What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100?

SYS DIAS A: place correlation table here
104 61 SYS DIAS
99 64 SYS
102 65 DIAS
114 76
94 58
101 66 B: place regression equation table here
108 61 SUMMARY OUTPUT
104 41
123 72 Regression Statistics
93 61 Multiple R
89 56 R Square
112 62 Adjusted R Square
107 48 Standard Error
116 62 Observations
181 102
98 61 ANOVA
100 53 df SS MS F Significance F
127 74 Regression
107 67 Residual
116 71 Total
97 64
155 85 Coefficients Standard Error t Stat P-value Lower 95%
106 59 Intercept
110 70 SYS
105 69
118 82
133 83
113 75
113 66 C: Predicted diastolic pressure
107 67
95 59
108 72
114 79
104 73
125 73
124 85
92 46
119 81
93 64
106 64

© BrainMass Inc. brainmass.com October 2, 2020, 5:51 am ad1c9bdddf
https://brainmass.com/statistics/correlation-and-regression-analysis/obtaining-regression-equation-correlation-using-excel-toolpak-608544

Solution Summary

The solution gives detailed steps on obtaining regression equation and correlation using excel toolpak.

\$2.19