Homework1 - CEE 291 PROBLEM SOLVING USING COMPUTER TOOLS...

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

View Full Document Right Arrow Icon
   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 In a new Excel Workbook, add the data set in Table 1. Table 1: Data for curve fitting problem 1 x y 1 10 12 19 19 33 34 40 42 49 51 57 Part (a)  Create an X-Y scatter plot of the data in the same Worksheet, be sure to  format the  Figure .  Add a  Linear Regression  and show the equation and R 2  on the chart. Part (b)  Create another figure, but on this one add a  Power  regression, again be sure to put the  equation and R 2  on the chart. Part (c)  Create a third figure, but on this one add a  Cubic ( 3 rd -order polynomial) regression,  again be sure to put the equation and R 2  on the chart. Part (d)  Create a fourth figure, but on this one add a  4 th -order polynomial  regression, again be  sure to put the equation and R 2  on the chart. Part (e)  Use the equations for the 4 regressions that you performed to predict the y-value for x =  25, 70, 100, and 150 Questions:  Copy all of your plots into a single word file.  In that same word file answer the  following questions.
Background image of page 1

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

View Full DocumentRight Arrow Icon
1) What is R 2  a measure of? Does a higher R 2  mean that a given regression is the “right” 
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.

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.

Page1 / 7

Homework1 - CEE 291 PROBLEM SOLVING USING COMPUTER TOOLS...

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