BPScatterPlotandCorrelationSolution.xlsx

Sheet1

AN EXAMINATION OF AGE AND BLOOD PRESSURE USING EXCEL STATISTICS
SUBJECTAGE xBLOOD PRESSURE y
A43128
B43120
C56135
D66143
E67141
F70152
MODE43ERROR:#N/A
MEDIAN61138
MEAN57.5136.5
GEO MEAN56.36136.10
SCATTER PLOT
CORRELATION0.945996599

AGE434356666770BLOOD PRESSURE434356666770128120135143141152

Sheet2

Sheet3