This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: =MI NVERSE(B4:D6) =MMULT(B9:D11,F4:F6) Spring 2010 CEE 291 – PROBLEM SOLVING USING COMPUTER TOOLS Homework 1 Solve these problems using Excel. Copy and Paste solutions and work into a Word document with problems and solutions clearly identified. Assignment is due on Wednesday (1/27) in class. Problem 1  Excel Plotting and Curve Fitting Part (e) x linear powe r cubic 4 th Order 25 33.279 36.21 1 34.355 36.485 70 74.916 56.66 2 81.673 159.971 100 102.67 5 66.16 8 155.87 8 1002.82 1 150 148.93 9 78.92 7 450.44 1 7788.94 4 Questions: Copy all of your plots into a single word file. In that same word file answer the following questions. 1) What is R 2 a measure of? Does a higher R 2 mean that a given regression is the “right” one? Ans – R 2 is a measure of how well the fitted equation matches the observed data. Typically a higher R 2 value means a better fit; however, it does not guarantee that the trend is maintained between data points or when extrapolated. For example, a plot of a 6...
View
Full
Document
This note was uploaded on 05/04/2010 for the course CEE 291 taught by Professor Hoopes during the Spring '10 term at University of Wisconsin.
 Spring '10
 Hoopes

Click to edit the document details