Lab 5 solutions

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
CEIE 340 Lab 5 Solutions YHK Page 2 of 5 With this new table, it is possible to use the linear regression tool in excel. After running the regression, a regression summary sheet will be created and it will have the following results: SUMMARY OUTPUT Regression Statistics Multiple R 0.98192772 R Square 0.964182048 Adjusted R Square 0.952242731 Standard Error 0.098547705 Observations 9 ANOVA df SS MS F Significance F Regression 2 1.568565178 0.784282589 80.75688273 4.59518E-05 Residual 6 0.058269901 0.00971165 Total 8 1.626835078 Coefficients Standard Error Intercept -0.465518028
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

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

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online