Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    Regresi Optika Geometri Pada Lensa

    Uploaded by

    jiahah
    The document contains data from 5 experiments measuring the length (L), magnified size (S diperbesar), minimized size (S diperkecil), and the difference between magnified and minimized sizes (d). It performs regression analysis on the data finding the regression equation and R-squared value indicating a very high correlation between L and d.

    Copyright:

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

    Regresi Optika Geometri Pada Lensa

    Uploaded by

    jiahah
    19 views13 pages
    The document contains data from 5 experiments measuring the length (L), magnified size (S diperbesar), minimized size (S diperkecil), and the difference between magnified and minimized sizes (d). It performs regression analysis on the data finding the regression equation and R-squared value indicating a very high correlation between L and d.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains data from 5 experiments measuring the length (L), magnified size (S diperbesar), minimized size (S diperkecil), and the difference between magnified and minimized sizes (d). It performs regression analysis on the data finding the regression equation and R-squared value indicating a very high correlation between L and d.

    Copyright:

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

    Regresi Optika Geometri Pada Lensa

    Uploaded by

    jiahah
    The document contains data from 5 experiments measuring the length (L), magnified size (S diperbesar), minimized size (S diperkecil), and the difference between magnified and minimized sizes (d). It performs regression analysis on the data finding the regression equation and R-squared value indicating a very high correlation between L and d.

    Copyright:

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

    L S S' f=S f rerata (f-frerata)^2

    50 7 43 7 7.366667 0.13444444444
    45 7.4 37.6 7.4 7.366667 0.00111108889
    40 7.7 32.3 7.7 7.366667 0.11111088889
    jumlah 135 22.1 112.9 22.1 22.1 0.24666642222
    L (cm) S diperbesar S diperkecil d (s diperbesar - s diperkecil)
    38.84 18.2 26.2 8
    53.62 13 41.5 28.5
    63.28 12 50.5 38.5
    69.52 11.7 57.7 46
    71.92 11.7 59.9 48.2
    Jumlah 297.18 66.6 235.8 169.2
    L^2 d^2 4L F (L^2-d^2/4L) F rerata (f-f rerata)^2
    1508.5456 64 155.36 1508.13365355304 3673.5570339 4689058.41599448
    2875.1044 812.25 214.48 2871.31733360686 3673.557034 643588.53688687
    4004.3584 1482.25 253.12 3998.50248185841 3673.557034 105589.544083901
    4833.0304 2116 278.08 4825.42107894131 3673.557034 1326790.77802856
    5172.4864 2323.24 287.68 5164.41062135706 3673.557034 2222644.41893543
    18393.5252 6797.74 1188.72 18367.7851693167 18367.78517 8987671.69392924
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.995535676076716
    R Square 0.991091282341524
    Adjusted R Square 0.988121709788699
    Standard Error 17.3914258568218
    Observations 5

    ANOVA
    df SS
    Regression 1 100946.22784
    Residual 3 907.385079999994
    Total 4 101853.61292

    Coefficients Standard Error


    Intercept -26.6920000000002 44.6793820010974
    X Variable 1 10.0472 0.549965174655024
    MS F Significance F
    100946.22784 333.748802129303 0.000358
    302.461693333331

    t Stat P-value Lower 95%Upper 95%Lower 95,0%


    Upper 95,0%
    -0.597412023276075 0.592319218738441 -168.8817 115.4977 -168.8817 115.4977
    18.2687931218596 0.000357829685922885 8.296965 11.79743 8.296965 11.79743
    Upper 95,0%
    x s s' y (s.s') x^2 y^2 xy
    100 89.2 10.8 963.36 10000 928062.5 96336
    90 78.5 11.5 902.75 8100 814957.6 81247.5
    80 68.8 11.2 770.56 6400 593762.7 61644.8
    70 58.5 11.5 672.75 4900 452592.6 47092.5
    60 48 12 576 3600 331776 34560
    400 343 57 3885.42 33000 3121151 320880.8
    percobaan A, diperkecil
    1200

    1000
    f(x) = 9.72366060606061 x
    R² = 0.999674692479787
    800

    600

    400

    200

    0
    55 60 65 70 75 80 85 90 95 100 105
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.999992443468732
    R Square 0.999984886994566
    Adjusted R Square 0.999979849326088
    Standard Error 0.677610999517215
    Observations 5

    ANOVA
    df SS
    Regression 1 91143.29961
    Residual 3 1.37747000000016
    Total 4 91144.67708

    Coefficients Standard Error


    Intercept 23.8360000000002 1.74081417733207
    X Variable 1 9.5469 0.0214279412605765
    MS F Significance F
    91143.29961 198501.527314547 2.49354431428246E-08
    0.459156666666719

    t Stat P-value Lower 95% Upper 95%


    13.6924436337775 0.000842851208231178 18.2959523531643 29.37605
    445.535102224894 2.49354431428246E-08 9.47870672750544 9.615093
    Lower 95,0%
    Upper 95,0%
    18.29595 29.37605
    9.478707 9.615093
    x s s' y (s.s') x^2 y^2 xy
    100 11 89 979 10000 958441 97900
    90 11.2 78.8 882.56 8100 778912.2 79430.4 optik
    80 11.5 68.5 787.75 6400 620550.1 63020 1200
    70 11.9 58.1 691.39 4900 478020.1 48397.3
    60 12.6 47.4 597.24 3600 356695.6 35834.4 1000
    f(x) = 9.8358212
    jumlah 400 58.2 341.8 3937.94 33000 3192619 324582.1 R² = 0.99997260
    800

    600

    400

    200

    0
    55 60 65 70
    optika geometri pada lensa
    1200

    1000
    f(x) = 9.83582121212121 x
    R² = 0.999972605078749
    800

    600

    400

    200

    0
    55 60 65 70 75 80 85 90 95 100 105

    You might also like