Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 438 Weeks Ago, 1 Day Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Accounting Posted 20 Apr 2017 My Price 15.00

HLT 362 M5 Correlation Regression

Topic Five: Correlation/Regression and Chi Square

Excel Worksheet

Directions: Answer all problems and submit to instructor at the end of Module 5

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

104

99

102

114

94

101

108

104

123

93

89

112

107

116

181

98

100

127

107

116

97

155

106

110

105

118

133

113

113

107

95

108

114

104

125

124

92

119

93

106



DIAS

61

64

65

76

58

66

61

41

72

61

56

62

48

62

102

61

53

74

67

71

64

85

59

70

69

82

83

75

66

67

59

72

79

73

73

85

46

81

64

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



Coefficients



Standard Error



t Stat



P-value



Lower 95%



Regression

Residual

Total

Intercept

SYS

Type the regression equation:

C: Predicted diastolic pressure

Show calculations of predicted diastolic pressure.

Answers

Alpha Geek
(8)
Status NEW Posted 20 Apr 2017 08:04 AM My Price 15.00

-----------

Attachments

file 1492676616-d5_d5_d5_hlt362.m5.correlationregressionchisquare.xlsx preview (28 words )
AN-----------OVA-----------SSd-----------fMS-----------FP------------val-----------ueT-----------ota-----------lSY-----------SDI-----------ASS-----------UMM-----------ARY----------- OU-----------TPU-----------TRe-----------gre-----------ssi-----------on -----------Sta-----------tis-----------tic-----------sMu-----------lti-----------ple----------- RR----------- Sq-----------uar-----------eAd-----------jus-----------ted----------- R -----------Squ-----------are-----------Sta-----------nda-----------rd -----------Err-----------orO-----------bse-----------rva-----------tio-----------nsR-----------egr-----------ess-----------ion-----------Res-----------idu-----------alI-----------nte-----------rce-----------ptS-----------ign-----------ifi-----------can-----------ce -----------FCo-----------eff-----------ici-----------ent-----------st -----------Sta-----------tLo-----------wer----------- 95-----------%A:----------- p-----------lac-----------e c-----------orr-----------ela-----------tio-----------n t-----------abl-----------e h-----------ere-----------B: ----------- pl-----------ace----------- re-----------gre-----------ssi-----------on -----------equ-----------ati-----------on -----------tab-----------le -----------her-----------eC:----------- Pr-----------edi-----------cte-----------d d-----------ias-----------tol-----------ic -----------pre-----------ssu-----------reA-----------Upp-----------er -----------95%-----------Low-----------er -----------95.-----------0%U-----------ppe-----------r 9-----------5.0-----------%HL-----------T36-----------2.M-----------5.C-----------orr-----------ela-----------tio-----------nRe-----------gre-----------ssi-----------onC-----------hiS-----------qua-----------re -----------
Not Rated(0)