Scribd Logo
Upload

Welcome to Scribd!

  • 31 views

    Linear Regression Excel Example

    Uploaded by

    lomeroaia
    1. The document appears to contain data on cholesterol levels and ages for 10 individuals. 2. A linear regression was performed and found a moderate positive correlation between age and cholesterol level, with an R^2 value of 0.1668. 3. The regression output provides details on the regression statistics, ANOVA table, coefficients, and significance tests.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Linear Regression Excel Example

    Uploaded by

    lomeroaia
    31 views3 pages
    1. The document appears to contain data on cholesterol levels and ages for 10 individuals. 2. A linear regression was performed and found a moderate positive correlation between age and cholesterol level, with an R^2 value of 0.1668. 3. The regression output provides details on the regression statistics, ANOVA table, coefficients, and significance tests.

    Original Title

    Linear regression excel example

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document appears to contain data on cholesterol levels and ages for 10 individuals. 2. A linear regression was performed and found a moderate positive correlation between age and cholesterol level, with an R^2 value of 0.1668. 3. The regression output provides details on the regression statistics, ANOVA table, coefficients, and significance tests.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    31 views3 pages

    Linear Regression Excel Example

    Uploaded by

    lomeroaia
    1. The document appears to contain data on cholesterol levels and ages for 10 individuals. 2. A linear regression was performed and found a moderate positive correlation between age and cholesterol level, with an R^2 value of 0.1668. 3. The regression output provides details on the regression statistics, ANOVA table, coefficients, and significance tests.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    index age cholestrol_level

    250
    1 58 189
    2 69 235 240

    3 43 193 230
    4 39 177 220
    5 63 154
    210
    6 52 191
    7 47 213 200 f(x) = 0.649820637265246 x + 156.329183372019
    R² = 0.166815826313632
    8 31 165 190
    9 74 198 180
    10 36 181
    170

    160

    150
    30 35 40 45 50 55 60 65 70 75 80

    2.685 3.246
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.41562229046
    R Square 0.17274188833
    Adjusted R Square 0.05456215809
    Standard Error 23.8123150006
    Observations 9

    ANOVA
    df SS MS F
    Regression 1 828.8155801904 828.815580190384 1.4616879559
    Residual 7 3969.18441981 567.026345687088
    Total 8 4798

    Coefficients Standard Error t Stat P-value


    Intercept 155.849620436 29.0754364846 5.36018162680795 0.0010525827
    58 0.67038197373 0.554491628296 1.20900287672861 0.265908619

    RESIDUAL OUTPUT

    Observation Predicted 189 Residuals Standard Residuals


    1 202.105976624 32.89402337631 1.47676486537878
    2 184.676045307 8.323954693337 0.373700829828467
    3 181.994517412 -4.99451741174 -0.224226989468448
    4 198.083684781 -44.0836847813 -1.97912052523013
    5 190.70948307 0.290516929751 0.013042648804169
    6 187.357573202 25.64242679841 1.15120715169826
    7 176.631461622 -11.6314616219 -0.52219011519788
    8 205.457886492 -7.45788649235 -0.334819022163612
    9 179.983371491 1.016628509459 0.045641156350385
    Significance F
    0.265908619021088

    Lower 95% Upper 95% Lower 95.0% Upper 95.0%


    87.0971381990563 224.60210267 87.097138199 224.60210267
    -0.640782377842079 1.9815463253 -0.6407823778 1.9815463253

    PROBABILITY OUTPUT

    Percentile 189
    5.55555555555556 154
    16.6666666666667 165
    27.7777777777778 177
    38.8888888888889 181
    50 191
    61.1111111111111 193
    72.2222222222222 198
    83.3333333333333 213
    94.4444444444444 235

    You might also like