What is the best predicted value for diastolic pressure

Assignment Help Applied Statistics

Reference no: EM13718416

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.

Reference no: EM13718416

Questions Cloud

Cylindrical coordinates to define the stream line function : The streamlines in a certain incompressible, two-dimensional flow field are all concentric circles so that vr=0. Determine the string function for 1) V(theta)=Ar and for 2) V(theta)= Ar^(-1) where A is a constant in both cases. Use cylindrical coordi..

Calculate what is the thickness of the film : A thin film having an index of refraction of 1.50 is surrounded by air. It is illuminated normally by white light. What is the thickness of the film

Estimate the hourly cost of running the pump : An electrically-driven pump operating at steady state draws water from a pond at a pressure of 1 bar and a rate of 40 kg/s and delivers the water at a pressure of 4 bar. Evaluating electricity at 8 percents per kW/h estimate the hourly cost of runnin..

How much mass would have to be suspended : A particular spring has a force constant of 2.9 x 103 N/m. How much mass would have to be suspended from the vertical spring to stretch it the first 5.0cm

What is the best predicted value for diastolic pressure : What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100 and use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.

What is the diameter of the hair : Light from a He-Ne laser (632.8 nm) is directed upon a human hair, in an attempt to measure its diameter by examining the diffraction pattern. What is the diameter of the hair

Find magnitude of maximum possible torque exerted on coil : A 55.0-turn circular coil of radius 4.80 cm can be oriented in any direction in a uniform magnetic field having a magnitude of 0.495 T. Find the magnitude of the maximum possible torque exerted on the coil

Calculate the electric flux through the hole : An uncharged nonconductive hollow sphere of radius 14.0 cm surrounds a 20.0 µC charge located at the origin of a Cartesian coordinate system. Calculate the electric flux through the hole

Determine the electric flux through this area : A flat surface of area 3.00 m2 is rotated in a uniform electric field of magnitude E = 5.50 x 105 N/C. Determine the electric flux through this area when the electric field is perpendicular to the surface

User Account

All Pages