14 Apr Your Analysis Correlation RegressionAnalysis forAge and Blood Pressure
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
