Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Statistics Template

    Uploaded by

    Jackie

    Copyright:

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

    Statistics Template

    Uploaded by

    Jackie
    4 views9 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Statistics Template

    Uploaded by

    Jackie

    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 9

    A X Freq X*Freq Dif Dif^2*Freq

    94 20 1880 -4.84 468.512


    96 20 1920 -2.84 161.312 A
    98 17 1666 -0.84 11.9952
    100 10 1000 1.16 13.456 n 100
    102 14 1428 3.16 139.7984 Mean 98.84
    104 12 1248 5.16 319.5072 Variance 14.7344
    106 7 742 7.16 358.8592 Sigma 3.838541
    S^2 14.88323
    s 3.857879

    Sum dif^2 1473.44


    B X Freq X*Freq Dif Dif^2*Freq
    94 12 1128 -5.62 379.0128
    96 20 1920 -3.62 262.088 B
    98 20 1960 -1.62 52.488
    100 10 1000 0.38 1.444 n 100
    102 11 1122 2.38 62.3084 Mean 99.62
    104 15 1560 4.38 287.766 Variance 15.3356
    106 12 1272 6.38 488.4528 Sigma 3.916069
    S^2 15.49051
    s 3.935798

    Sum dif^2 1533.56


    X Y Freq ReCalculate each single time
    7 27 1
    8 30 1 y = ax + b
    11 32 1 r Multiple R
    11 38 1 a X variable 1
    14 40 1 b Intercept Coefficient
    14 42 1
    15 45 1 SUMMARY OUTPUT
    15 48
    17 55 Regression Statistics
    Multiple R 0.9541736182489
    R Square 0.9104472937622
    Adjusted R Square 0.8976540500139
    Standard Error 2.8925389213215
    Observations 9

    ANOVA
    df SS
    Regression 1 595.432530120482
    Residual 7 58.567469879518
    Total 8 654

    Coefficients Standard Error


    Intercept 8.0457831325301 3.87034402401046
    X Variable 1 2.5409638554217 0.30120447504283

    RESIDUAL OUTPUT

    Observation Predicted Y Residuals


    1 15.85006234414 -1.8500623441397
    2 13.140897755611 -0.140897755611
    3 22.17144638404 -2.1714463840399
    4 29.395885286783 7.60411471321696
    5 19.462281795511 5.53771820448878
    6 31.201995012469 -4.2019950124688
    7 22.17144638404 -8.1714463840399
    8 38.426433915212 -3.426433915212
    9 28.49283042394 5.50716957605985
    10 26.686720698254 1.31327930174564
    0.95417361825
    2.54096385542
    8.04578313253

    MS F Significance F
    595.43253012048 71.16625866573 6.485323928E-05
    8.3667814113597

    t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
    2.0788289316444 0.076216800212 -1.106126208652 17.197692473712 -1.106126208652 17.197692473712
    8.4360096411594 6.48532393E-05 1.8287284490471 3.2531992617962 1.8287284490471 3.2531992617962

    You might also like