Find the linear correlation coefficient

Reference no: EM13693959

SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES

The 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.

A: place correlation table here
		SYS	DIAS
	SYS
	DIAS

B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.

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) 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

Reference no: EM13693959

Questions Cloud

An appropriate choice : Identify a cost driver and explain why it is an appropriate choice.

High-income workers but doesnot change for low-income worker : If the level of incomes rises for high-income workers but doesn’t change for low-income workers,

Price elasticity of demand for cigarettes : According to studies undertaken by the US Department of Agriculture, the price elasticity of demand for cigarettes is between - 0.3 and - 0.4 and the income elasticity is about + 0.5.

Public policies might help raise the us standard of living : Explain briefly (in no more than a sentence or two for each part) how the following public policies might help raise the US standard of living?

Find the linear correlation coefficient : Find the linear correlation coefficient for the systolic and diastolic measurements - determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.

Certificate of need : Certificate of Need

Receipts and subsequent payments to suppliers. : A CPA is reviewing a client's internal controls over merchandise receipts and subsequent payments to suppliers.

The yummy food company purchased equipmen : The Yummy Food Company purchased equipmen

Produce a detailed project plan : Produce a detailed project plan, including some of the key headings given below, and any other information such as recommendations to the Project Board that you consider appropriate.

User Account

All Pages