stats

Sheet 1

		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

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?

Name: Janie Southerland Date: 3/20/2016 Topic Five: Correlation/Regression and Chi Square Excel Worksheet Directions: Answer all problems and submit to instructor at the end of Module 5

Type the regression equation:

Show calculations of predicted diastolic pressure.