HLT 362 M5 Topic Five: Correlation/Regression and Chi Square
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
104
99
102
114
94
101
108
104
123
93
89
112
107
116
181
98
100
127
107
116
97
155
106
110
105
118
133
113
113
107
95
108
114
104
125
124
92
119
93
106
DIAS
61
64
65
76
58
66
61
41
72
61
56
62
48
62
102
61
53
74
67
71
64
85
59
70
69
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.