perhitungan pengukuran daya listrik metode regresi.xlsx

77
tegangan arus (mA) daya y= 10.2 47.3 0.47 0.47 20 58.9 1.16 1.16 30.6 67.8 2.06 2.06 40.2 75 3 3.00 50.6 82.4 4.15 4.15 60.2 89 5.34 5.34 70.3 95.6 6.7 6.70 80.1 101.8 8.13 8.13 Ey 31.01 (Ey)^2 961.62 A 70611.60 Sy^2 0.0000

Upload: juhri-light

Post on 16-Nov-2015

91 views

Category:

Documents


1 download

TRANSCRIPT

resistorteganganarus (mA)dayay=x=VI/1000y^2x^2x*y10.247.30.470.470.480.220.230.22058.91.161.161.181.351.391.430.667.82.062.062.074.244.304.340.27533.003.029.009.099.050.682.44.154.154.1717.2217.3817.360.2895.345.345.3628.5228.7128.670.395.66.76.706.7244.8945.1745.080.1101.88.138.138.1566.1066.4966.3data deng

EyExE(y^2)E(x^2)E(x*y)31.0131.15171.54172.76172.15

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma961.62970.4629634.91D=deltaA=bagian atas regresiAD70611.60411.65

Sy^2SymDmcDc0.00000.00200.998800.00028-0.00.0

1.54167520671.0011982785

induktor(m)teganganarus (mA)dayay=x=VI/1000y^2x^2x*y10.417.500.000.180.000.030.0020.131.40.080.080.630.010.400.0530.245.30.190.191.370.041.870.264058.70.340.342.350.125.510.8050.272.70.520.523.650.2713.321.9060.286.60.730.735.210.5327.183.8170.51010.980.987.120.9650.706.9880.1114.41.241.249.161.5483.9711.36data deng

EyExE(y^2)E(x^2)E(x*y)4.0829.683.4594182.9825.15

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma16.65880.66632.67D=deltaA=bagian atas regresiAD2016.46583.213.45753.4575195899Sy^2SymDmcDc0.00030.01770.137420.002070.000.0

\thetaD theta82.12682.2400.11

induktor(Xl)teganganarus (mA)dayay=x=V^2y^2x^2x*y10.417.500.110.000.010.000.0020.131.40.080.400.080.160.010.0330.245.30.190.910.190.830.040.174058.70.341.600.342.560.120.5450.272.70.522.520.526.350.271.3160.286.60.733.620.7313.130.532.6570.51010.984.970.9824.700.964.8780.1114.41.246.421.2441.171.547.96data deng

EyExE(y^2)E(x^2)E(x*y)20.554.0888.923.4617.53

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma422.4916.65307.38D=deltaA=bagian atas regresiAD980.0011.03

Sy^2SymDmcDc0.01020.10095.113488540.08592981-0.040.151134.8854859.2981Xl001202.30036100460.1955612088

Kapasitor(m)teganganarus (mA)dayay=x=VI/1000y^2x^2x*y10.59.900.000.100.00000.010.000020.219.300.000.390.00000.150.000030.228.70.010.010.870.00010.750.008740.438.50.030.031.560.00092.420.046750.3480.060.062.410.00365.830.144960.557.90.10.103.500.010012.270.350370.567.60.140.144.770.019622.710.667280.176.80.190.196.150.036137.841.1688data deng

EyExE(y^2)E(x^2)E(x*y)0.5319.750.070381.992.3865

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma0.28390.095.6955D=deltaA=bagian atas regresiAD18.63265.82

Sy^2SymDmcDc0.00000.00590.032440.00103-0.01380.0

theta230.8225461341

kapasitor(XC)

teganganarus (mA)dayay=x=py^2x^2x*y10.59.900.110.000.010.000.000020.219.300.410.000.170.000.000030.228.70.010.910.010.830.000.009140.438.50.031.630.032.660.000.049050.3480.062.530.066.400.000.151860.2557.90.13.630.1013.180.010.363070.567.60.144.970.1424.700.020.695880.176.80.196.420.1941.170.041.2190data deng

EyExE(y^2)E(x^2)E(x*y)20.610.5389.120.072.4878

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma424.730.286.1890D=deltaA=bagian atas regresiAD25.020.28

Sy^2SymDmcDc0.03780.194431.898656041.036231500.50.1318986.560410362.3150XcDXc000.0313492831

RL(m)

teganganarus (mA)dayay=x=VI/1000y^2x^2x*y1016.20.030.030.160.00090.030.004920.530.50.20.200.630.04000.390.125130.342.50.490.491.290.24011.660.631040.352.91.021.022.131.04044.542.174550.461.31.791.793.093.20419.555.530260.468.62.632.634.146.916917.1710.897270.475.33.623.625.3013.104428.1019.190180.681.94.754.756.6022.562543.5831.3554data deng

EyExE(y^2)E(x^2)E(x*y)14.5323.3447.11105.0169.9084

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma211.12544.854887.1805D=delta3A=bagian atas regresiAD13847.03295.23

0.7455399934Sy^2SymDmcDc0.03450.18570.745540.03057-0.40.1

cos theta51570.0549982525-0.29951539480.1291.34130966660.128

RL(Zl)teganganarus (mA)dayay=x=V^2y^2x^2x*y1016.20.030.100.030.010.00090.00320.530.50.20.420.200.180.040.08430.342.50.490.920.490.840.240.45040.352.91.021.621.022.641.041.65750.461.31.792.541.796.453.204.54760.468.62.633.652.6313.316.929.59570.475.33.624.963.6224.5613.1017.94180.681.94.756.504.7542.2022.5630.858data deng

EyExE(y^2)E(x^2)E(x*y)20.7014.5390.1947.1165.134

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma428.63211.124242.443D=deltaA=bagian atas regresiAD14944.74165.75

Sy^2SymDmcDc0.00540.07351.328803470.016153350.20.013288.0347161.5335ZDZ100.7525567366

RC(m)teganganarus (mA)dayay=x=VI/1000y^2x^2x*y109.300.000.090.000.010.0020.3190.030.030.390.000.150.013028.10.110.110.840.010.710.094037.30.250.251.490.062.230.3750.346.50.510.512.340.265.471.1960.154.60.950.953.280.9010.773.1270.661.81.611.614.362.5919.047.0280.468.92.382.385.545.6630.6913.18data deng

EyExE(y^2)E(x^2)E(x*y)5.8418.349.4969.0625.00

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma34.11336.24624.81D=deltaA=bagian atas regresiAD2000.17216.21

0.4295955592Sy^2SymDmcDc0.04060.20150.429600.03876-0.30.1

cos theta51570.2100178432-0.29951539480.1292.32777080350.128

RC(Zc)teganganarus (mA)dayay=x=V^2y^2x^2x*y109.300.100.000.010.000.020.3190.030.410.030.170.000.013028.10.110.900.110.810.010.104037.30.251.600.252.560.060.4050.346.50.512.530.516.400.261.2960.154.60.953.610.9513.050.903.4370.661.81.614.981.6124.842.598.0280.468.92.386.462.3841.795.6615.38data deng

EyExE(y^2)E(x^2)E(x*y)20.605.8489.639.4928.64

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma424.4734.11820.40D=deltaA=bagian atas regresiAD3700.8441.85

Sy^2SymDmcDc0.19970.44692.600195010.195402180.70.226001.95011954.0218ZDZ000.3845865384

RLC(m)teganganarus (mA)dayay=x=VI/1000y^2x^2x*y10.420.30.080.080.210.010.040.0220.440.40.490.490.820.240.680.4030.6541.211.211.651.462.732.0040.662.92.072.072.554.286.525.2950.770.43.053.053.579.3012.7410.8960.477.24.114.114.6616.8921.7419.1670.283.65.275.275.8727.7734.4430.9380.3906.596.597.2343.4352.2347.63data deng

EyExE(y^2)E(x^2)E(x*y)22.8726.57103.39131.13116.311

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma523.04705.9313528.295D=deltaA=bagian atas regresiAD35461.25343.11

0.9409570356Sy^2SymDmcDc0.00630.07960.940960.01216-0.30.0

cos theta

0.013729376210.1291.06274777930.128

RLC(Z)teganganarus (mA)dayay=x=V^2y^2x^2x*y10.420.30.080.110.080.010.010.0120.440.40.490.420.490.170.240.2030.6541.210.941.210.881.461.1340.662.92.071.652.072.724.283.4150.770.43.052.573.056.619.307.8460.477.24.113.654.1113.3116.8914.9970.283.65.274.935.2724.2927.7725.9780.3906.596.456.5941.5843.4342.49data deng

EyExE(y^2)E(x^2)E(x*y)20.7022.8789.56103.3996.06

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma428.65523.049226.62D=deltaA=bagian atas regresiAD27167.69304.09

Sy^2SymDmcDc0.03640.19070.969923700.03093663-0.20.19699.2370309.3663ZDZ101.0310089347

resistor(R)teganganarus (mA)dayay=V^2x=dayay^2x^2x*y10.247.30.470.100.470.010.220.052058.91.160.401.160.161.350.4630.667.82.060.942.060.884.241.9340.27531.623.002.619.004.8550.682.44.152.564.156.5617.2210.6360.2895.343.625.3413.1328.5219.3570.395.66.74.946.7024.4244.8933.1180.1101.88.136.428.1341.1766.1052.16data deng

EyExE(y^2)E(x^2)E(x*y)20.6031.0188.94171.54122.54

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma424.32961.6215016.53D=deltaA=bagian atas regresiAD36364.37410.66

Sy^2SymDmcDc0.06450.25390.831738920.03543968-0.650.28317.3892354.3968rDXckilo Ohm1.2020.0510.85499508931.2023003498

kapasitorteganganarus (mA)dayay= arusx=tegangany^2x^2x*y10.417.5017.5010.40306.25108.16182.020.131.40.0831.4020.10985.96404.01631.130.245.30.1945.3030.202052.09912.041368.14058.70.3458.7040.003445.691600.002348.050.272.70.5272.7050.205285.292520.043649.560.286.60.7386.6060.207499.563624.045213.370.51010.98101.0070.5010201.004970.257120.580.1114.41.24114.4080.1013087.366416.019163.4data deng

EyExE(y^2)E(x^2)E(x*y)527.60361.7042863.2020554.5529676.0

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma278361.76130826.89880664976.0D=deltaA=bagian atas regresiAD1440605054.1733609.51

Sy^2SymDmcDc0.03020.17391.385770870.002682193.30.113857.708726.8219XlDXl0.7220.0011.20230034980.7216200165

induktorteganganarus (mA)dayay=arusx=tegangany^2x^2x*y10.417.5017.5010.40306.25108.16182.020.131.40.0831.4020.10985.96404.01631.130.245.30.1945.3030.202052.09912.041368.14058.70.3458.7040.003445.691600.002348.050.272.70.5272.7050.205285.292520.043649.560.286.60.7386.6060.207499.563624.045213.370.51010.98101.0070.5010201.004970.257120.580.1114.41.24114.4080.1013087.366416.019163.4data deng

EyExE(y^2)E(x^2)E(x*y)527.60361.7042863.2020554.5529676.0

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma278361.76130826.89880664976.0D=deltaA=bagian atas regresiAD1440605054.1733609.51

Sy^2SymDmcDc0.03020.17391.385770870.002682193.30.113857.708726.8219Xl0.72160.00140.7216200165

RLCteganganarus (mA)dayay=arusx=tegangany^2x^2x*y10.420.30.0820.3010.40412.09108.16211.120.440.40.4940.4020.401632.16416.16824.230.6541.2154.0030.602916.00936.361652.440.662.92.0762.9040.603956.411648.362553.750.770.43.0570.4050.704956.162570.493569.360.477.24.1177.2060.405959.843648.164662.970.283.65.2783.6070.206988.964928.045868.780.3906.5990.0080.308100.006448.097227.0data deng

EyExE(y^2)E(x^2)E(x*y)478.50353.2034509.5320595.6626358.2

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma228962.25124750.24694753652.9D=deltaA=bagian atas regresiAD669512542.7919419.38

Sy^2SymDmcDc6.60302.56960.798226310.0487868828.12.67982.2631487.8688Xl1.25280.07661.252777552

RLC 2teganganarus (mA)dayay=arusx=tegangany^2x^2x*y10.420.30.0820.3010.40412.09108.16211.120.440.40.4940.4020.401632.16416.16824.230.6541.2154.0030.602916.00936.361652.440.662.92.0762.9040.603956.411648.362553.750.770.43.0570.4050.704956.162570.493569.360.477.24.1177.2060.405959.843648.164662.970.283.65.2783.6070.206988.964928.045868.780.3906.5990.0080.308100.006448.097227.0data deng

EyExE(y^2)E(x^2)E(x*y)438.10332.8032877.3720179.5025534.0

(Ey)^2(Ex)^2(E(x*y))^2E=Sigma191931.61110755.84651986177.4D=deltaA=bagian atas regresiAD339297097.9310321.16

Sy^2SymDmcDc0.85980.92730.717403860.0223573533.21.37174.0386223.5735Xl1.39390.04341.3939150023