What is the best predicted value for diastolic pressure

Question

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

C: Predicted diastolic pressure