BPScatterPlotandCorrelationSolution.xlsx

    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

    AGE434356666770BLOOD PRESSURE434356666770128120135143141152

    Sheet2

    Sheet3

                                                                                                                                      Order Now