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