What is the best predicted value for diastolic pressure

Question

Correlation/Regression and Chi Square Excel Worksheet

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
104	61
99	64
102	65
114	76
94	58
101	66
108	61
104	41
123	72
93	61
89	56
112	62
107	48
116	62
181	102
98	61
100	53
127	74
107	67
116	71
97	64
155	85
106	59
110	70
105	69
118	82
133	83
113	75
113	66
107	67
95	59
108	72
114	79
104	73
125	73
124	85
92	46
119	81
93	64
106	64

A:  place correlation table here
		SYS	DIAS
	SYS
	DIAS

B:  place regression equation table here
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R
	R Square
	Adjusted R Square
	Standard Error
	Observations

ANOVA
	df	SS	MS	F	Significance F
Regression
Residual
Total
	Coefficients	Standard Error	t Stat	P-value	Lower 95%
Intercept
SYS

Type the regression equation:

C: Predicted diastolic pressure

Show calculations of predicted diastolic pressure.