Uas Numerik.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Uas Numerik.xlsx as PDF for free.
More details
- Words: 355
- Pages: 3
Hitungan regresi linier dgn transformasi Log Yi Pi=log Yi Qi= logxi Pi * Qi (Qi)^2 0.18 0.674 -0.17134 -0.744727 0.1276017 0.554619 0.4 1.7 0.2304489 -0.39794 -0.091705 0.1583563 0.6 3.4 0.5314789 -0.221849 -0.117908 0.0492169 0.8 5.7 0.7558749 -0.09691 -0.073252 0.0093916 1 8.4 0.9242793 0 0 0 1.2 12 1.0791812 0.0791812 0.0854509 0.0062697 1.4 14 1.146128 0.146128 0.1674814 0.0213534 1.6 16 1.20412 0.20412 0.2457849 0.041665 1.8 18 1.2552725 0.2552725 0.3204366 0.0651641 10 20 1.30103 1 1.30103 1 18.98 99.874 8.2564736 0.2232755 1.9649209 1.9060358
Xi
q=
Jml qi/n
0.0223276
q=
Jml qi/n
0.9427814
p=
jml pi/n
0.8256474
p=
jml pi/n
0.5866616
B=
A=
p-bq
17.805741 19.010506
=
0.9366263
0.8256474
-
0.9366263 0.0223276 0.8047348
NO 1 2 3 4 5 6 7 8 9 10
Hitungan regresi linier dgn transfo Xi= q1 Yi 1 0.5 2 1.7 3 3.4 4 5.7 5 8.4 6 12 7 14 8 16 9 18 10 20 55 99.7
NO 1 2 3 4 5 6 7 8 9 10
B=
A=
-261.4081 -2930.722 p-bq
0.5866616
Hitungan koefisien kolerasi
n regresi linier dgn transformasi ln q1^2 = xi^2 pi=ln*yi qi*pi 1 -0.693147 -0.693147 0.23044892 0.30103 0.069372 0.53147892 0.4771213 0.2535799 0.75587486 0.60206 0.455082 0.92427929 0.69897 0.6460435 1.07918125 0.7781513 0.8397662 1.14612804 0.845098 0.9685906 1.20411998 0.90309 1.0874287 1.25527251 0.9542425 1.1978344 1.30103 1 1.30103 9.42781375 5.8666159 6.1255801
NO
Yi
Yi
y rata"
yi-yrata"
(yi-yrata")^2
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10 55
0.5 1.7 3.4 5.7 8.4 12 14 16 18 20 99.7
9.97 9.97 9.97 9.97 9.97 9.97 9.97 9.97 9.97 9.97 99.7
-9.47 -8.27 -6.57 -4.27 -1.57 2.03 4.03 6.03 8.03 10.03 0
89.681 68.393 43.165 18.233 2.465 4.121 16.241 36.361 64.481 100.601 443.741
r dengan =
0.0891958
-
0.0891958 0.9427814 0.5
=
akar 99.4009
11.456871
99.4009 99.4009 = =
jlm n *jlm (yi - y)^2 10 443.741
= 0.0552812
4437.41
4009
Transformasi log g(xi) D^2 Dt^2 0.4984 0.000003 89.6809 1.6848 0.000231 99.4009 6.7848 11.456871 99.4009 17.0848 129.613671 99.4009 33.5848 634.274151 99.4009 59.9848 2302.541031 99.4009 83.9848 4897.872231 99.4009 111.9848 9213.081831 99.4009 143.9848 15872.169831 99.4009 179.9848 25595.136231 99.4009 639.5616 58656.146082 984.289 -
11.45687104
Xi
q=
Jml qi/n
0.0223276
q=
Jml qi/n
0.9427814
p=
jml pi/n
0.8256474
p=
jml pi/n
0.5866616
B=
A=
p-bq
17.805741 19.010506
=
0.9366263
0.8256474
-
0.9366263 0.0223276 0.8047348
NO 1 2 3 4 5 6 7 8 9 10
Hitungan regresi linier dgn transfo Xi= q1 Yi 1 0.5 2 1.7 3 3.4 4 5.7 5 8.4 6 12 7 14 8 16 9 18 10 20 55 99.7
NO 1 2 3 4 5 6 7 8 9 10
B=
A=
-261.4081 -2930.722 p-bq
0.5866616
Hitungan koefisien kolerasi
n regresi linier dgn transformasi ln q1^2 = xi^2 pi=ln*yi qi*pi 1 -0.693147 -0.693147 0.23044892 0.30103 0.069372 0.53147892 0.4771213 0.2535799 0.75587486 0.60206 0.455082 0.92427929 0.69897 0.6460435 1.07918125 0.7781513 0.8397662 1.14612804 0.845098 0.9685906 1.20411998 0.90309 1.0874287 1.25527251 0.9542425 1.1978344 1.30103 1 1.30103 9.42781375 5.8666159 6.1255801
NO
Yi
Yi
y rata"
yi-yrata"
(yi-yrata")^2
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10 55
0.5 1.7 3.4 5.7 8.4 12 14 16 18 20 99.7
9.97 9.97 9.97 9.97 9.97 9.97 9.97 9.97 9.97 9.97 99.7
-9.47 -8.27 -6.57 -4.27 -1.57 2.03 4.03 6.03 8.03 10.03 0
89.681 68.393 43.165 18.233 2.465 4.121 16.241 36.361 64.481 100.601 443.741
r dengan =
0.0891958
-
0.0891958 0.9427814 0.5
=
akar 99.4009
11.456871
99.4009 99.4009 = =
jlm n *jlm (yi - y)^2 10 443.741
= 0.0552812
4437.41
4009
Transformasi log g(xi) D^2 Dt^2 0.4984 0.000003 89.6809 1.6848 0.000231 99.4009 6.7848 11.456871 99.4009 17.0848 129.613671 99.4009 33.5848 634.274151 99.4009 59.9848 2302.541031 99.4009 83.9848 4897.872231 99.4009 111.9848 9213.081831 99.4009 143.9848 15872.169831 99.4009 179.9848 25595.136231 99.4009 639.5616 58656.146082 984.289 -
11.45687104
Related Documents
Uas
April 2020 50
Program Uas-bn & Uas
May 2020 48
Solution Uas
May 2020 29
Uas Penggas.xlsx
July 2020 15
Uas Pipemas.docx
November 2019 38
Kartu Uas
June 2020 28More Documents from "mda Nurul Iman"
Uas Numerik.xlsx
April 2020 18
Jembatan Ruwetttttt.docx
April 2020 23
Cv. Sinong.docx
May 2020 10
Uas Numerik.xlsx
May 2020 9
