Explore BrainMass
Share

Explore BrainMass

    Obtaining regression equation & correlation using excel toolpak

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Name: Date:

    Topic Five: Correlation/Regression and Chi Square Excel Worksheet

    Directions: Answer all problems and submit to instructor at the end of Module 5

    SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES
    The following table represents systolic and diastolic blood pressure measurements of 40 females.

    A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.

    B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.

    C) What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100?

    SYS DIAS A: place correlation table here
    104 61 SYS DIAS
    99 64 SYS
    102 65 DIAS
    114 76
    94 58
    101 66 B: place regression equation table here
    108 61 SUMMARY OUTPUT
    104 41
    123 72 Regression Statistics
    93 61 Multiple R
    89 56 R Square
    112 62 Adjusted R Square
    107 48 Standard Error
    116 62 Observations
    181 102
    98 61 ANOVA
    100 53 df SS MS F Significance F
    127 74 Regression
    107 67 Residual
    116 71 Total
    97 64
    155 85 Coefficients Standard Error t Stat P-value Lower 95%
    106 59 Intercept
    110 70 SYS
    105 69
    118 82
    133 83
    113 75
    113 66 C: Predicted diastolic pressure
    107 67
    95 59
    108 72
    114 79
    104 73
    125 73
    124 85
    92 46
    119 81
    93 64
    106 64

    © BrainMass Inc. brainmass.com October 10, 2019, 8:06 am ad1c9bdddf
    https://brainmass.com/statistics/correlation-and-regression-analysis/obtaining-regression-equation-correlation-using-excel-toolpak-608544

    Attachments

    Solution Summary

    The solution gives detailed steps on obtaining regression equation and correlation using excel toolpak.

    $2.19