Obtaining regression equation & correlation using excel toolpak
Not what you're looking for?
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
Purchase this Solution
Solution Summary
The solution gives detailed steps on obtaining regression equation and correlation using excel toolpak.
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.