Chat with us, powered by LiveChat BELOW I HAVE UPLOADED 2 EXCEL DOCUMENTS AND I NEED - Credence Writers
+1(978)310-4246 [email protected]

BELOW I HAVE UPLOADED 2 EXCEL DOCUMENTS AND I NEED TO COMPLETE THE CORRELATION REGRESSION ANALYSIS FOR BLOOD PRESSURE EXCEL WORK

I HAVE ALSO ADDED AN EXAMPLE(BP SCATTER PLOT) WITH THAT

THE ONE ON THE (BELOW UPLOADS) IS MY HOMEWORK AND ON THE RIGHT I HAVE AN EXAMPLE.

      CORRELATION,         REGRESSION PREDICTION FOR AGE 72,           Your Analysis.

Sheet1

REGRSSION ANALYSIS FOR AGE AND BLOOD PRESSURE
SUBJECT AGE X BP Y
A 44 124
B 50 128
C 55 135
D 61 143
E 63 141
F 65 146
G 69 152
H 70 150
CORRELATION
REGRESSION PREDICTION
FOR AGE 72
Your Analysis

Sheet1

AN EXAMINATION OF AGE AND BLOOD PRESSURE USING EXCEL STATISTICS
SUBJECT AGE x BLOOD PRESSURE y
A 43 128
B 43 120
C 56 135
D 66 143
E 67 141
F 70 152
MODE 43 ERROR:#N/A
MEDIAN 61 138
MEAN 57.5 136.5
GEO MEAN 56.36 136.10
SCATTER PLOT
CORRELATION 0.945996599

AGE 43 43 56 66 67 70 BLOOD PRESSURE 43 43 56 66 67 70 128 120 135 143 141 152

Sheet2

Sheet3

error: Content is protected !!