Homework1_sol

Homework1_sol - =MI NVERSE(B4:D6) =MMULT(B9:D11,F4:F6)...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 9

Homework1_sol - =MI NVERSE(B4:D6) =MMULT(B9:D11,F4:F6)...

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