{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lab 5 solutions

# Lab 5 solutions - CEIE 340 Lab 5 Solutions YHK Problem 1...

This preview shows pages 1–3. Sign up to view the full content.

CEIE 340 Lab 5 Solutions YHK Page 1 of 5 Problem 1, Problem 7.2 on pages 411-412 Given observations, A P Qp 133.0 13.0 16800 103.0 10.5 9000 91.4 12.5 8200 76.1 13.5 7400 60.7 15.0 6300 54.7 7.0 1600 44.8 8.5 1970 24.7 9.5 740 23.9 11.0 1820 In order to do a linear regression in excel, a transformation of the equation into a linear basis is needed. On way is to take the logs of both sides of the equation, ) ( ) ( ) ( 4 2 1 1 0 ^ 4 1 0 ^ 2 1 X Log b X Log b b Log Y Log X X b Y b b + + = = By doing this, we will have to recalculate the values of the observed values, log(A) Log(P) Log(Qp) 2.1239 1.1139 4.2253 2.0128 1.0212 3.9542 1.9609 1.0969 3.9138 1.8814 1.1303 3.8692 1.7832 1.1761 3.7993 1.7380 0.8451 3.2041 1.6513 0.9294 3.2945 1.3927 0.9777 2.8692 1.3784 1.0414 3.2601

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document