Topic: 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