Uas Numerik.xlsx

  • Uploaded by: Sinung Dwi Martanto
  • 0
  • 0
  • May 2020
  • PDF

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

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 28

More Documents from "mda Nurul Iman"