Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Regression Analysis Excel Template

    Uploaded by

    carlunatencio123
    This document provides a regression analysis of height and weight data for 10 individuals. It finds a strong positive correlation between height and weight, with a regression equation of f(x) = 0.6746x - 38.46 and an R-squared value of 0.95, indicating the model explains 95% of the variation in weight. The ANOVA table shows the regression is highly significant with an F-value of 168.92 and p-value near 0. Residual analysis shows the predicted and actual weights are very close.

    Copyright:

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

    Regression Analysis Excel Template

    Uploaded by

    carlunatencio123
    33 views5 pages
    This document provides a regression analysis of height and weight data for 10 individuals. It finds a strong positive correlation between height and weight, with a regression equation of f(x) = 0.6746x - 38.46 and an R-squared value of 0.95, indicating the model explains 95% of the variation in weight. The ANOVA table shows the regression is highly significant with an F-value of 168.92 and p-value near 0. Residual analysis shows the predicted and actual weights are very close.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a regression analysis of height and weight data for 10 individuals. It finds a strong positive correlation between height and weight, with a regression equation of f(x) = 0.6746x - 38.46 and an R-squared value of 0.95, indicating the model explains 95% of the variation in weight. The ANOVA table shows the regression is highly significant with an F-value of 168.92 and p-value near 0. Residual analysis shows the predicted and actual weights are very close.

    Copyright:

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

    Regression Analysis Excel Template

    Uploaded by

    carlunatencio123
    This document provides a regression analysis of height and weight data for 10 individuals. It finds a strong positive correlation between height and weight, with a regression equation of f(x) = 0.6746x - 38.46 and an R-squared value of 0.95, indicating the model explains 95% of the variation in weight. The ANOVA table shows the regression is highly significant with an F-value of 168.92 and p-value near 0. Residual analysis shows the predicted and actual weights are very close.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 5

    Regression Analysis Excel Template

    Visit: www.educba.com

    Email: info@educba.com
    Height (in Weight (in
    cm) Kg)
    151 63 SUMMARY OUTPUT
    174 81
    138 56 Regression Statistics
    186 91 Multiple R 0.977129596189794
    128 47 R Square 0.954782247750031
    136 57 Adjusted R Square 0.949130028718785
    179 76 Standard Error 3.25292472221476
    163 72 Observations 10
    152 62
    131 48 ANOVA
    df SS
    Regression 1 1787.447846013
    Residual 8 84.65215398717
    Total 9 1872.1

    Coefficients Standard Error


    Intercept -38.455087076077 8.049013302993
    Height (in cm) 0.674610449129239 0.051905142473

    RESIDUAL OUTPUT

    Observation Predicted Weight (in Kg) Residuals


    1 63.4110907424381 -0.411090742438
    2 78.9271310724106 2.072868927589
    3 54.641154903758 1.358845096242
    4 87.0224564619615 3.977543538039
    5 47.8950504124656 -0.895050412466
    6 53.2919340054995 3.7080659945
    7 82.3001833180568 -6.300183318057
    8 71.506416131989 0.493583868011
    9 64.0857011915674 -2.085701191567
    10 49.9188817598533 -1.918881759853
    MS F Significance F
    1787.44784601 168.921664655 1.16440531E-06
    10.5815192484

    t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
    -4.77761504777 0.00139492796 -57.0161450371 -19.8940291151 -57.0161450371 -19.8940291151
    12.9969867529 1.1644053E-06 0.55491697595 0.79430392231 0.55491697595 0.79430392231
    Height (in Weight
    cm) (in Kg) Regression Analysis
    151 63
    100
    174 81 90
    138 56 80 f(x) = 0.674610449129239 x − 38.455087076077
    186 91 70

    Weight (in Kg)


    128 47 60
    50
    136 57
    40
    179 76
    30
    163 72 20
    152 62 10
    131 48 0
    110 130 150 170 190 210
    Height (in cm)
    0 210

    You might also like