Please help with TOPIC 5 in HLT362 CorrleationRegression and

Please help with TOPIC 5 in HLT362 Corrleation/Regression and chi square. The tutorial are not helpful and I used two different computers to obtain the tables but not able to do so.

Thank you!

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?

Solution

First enter the all data table in excel of systolic and diastolic blood pressure.

A) to find the linear correlation coefficient for the systolic and diastolic measurements

the excel option is Data -> data analysis -> correlation

in correlation window first put input range as select data (whole table as column wise) then put output range which you want to create answer then press ok button.

then aswer is created in form

there fore the linear correlation coefficient is 0.808177332

B) We have to find the the linear regression equation

Again goto Data -> data analysis -> regression

in regression windows shows input Y-range = select DIAS column and input X-range = select SYS column

then in select output range

the summary output is created with big table it contains Regression statistics and ANOVA Table

in ANOVA table the last two row shows the intercept(a) and SYS(b) and 1st column of that rows shows the coeffcients i.e

linear regression equation is y = a + bx

here a =9.4889 and b=0.512 the

y = 9.4889 + 0.512x

C) predicted diastolic pressure when x=100

y = 9.489 + 0.512 * 100

   =60.689