EGR_102_Lecture_HW_05

EGR_102_Lecture_HW_05 - Also use Excel to plot the data and...

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

View Full Document Right Arrow Icon
EGR 102 of 3 pages Lecture HW 05 1 EGR 102 Lecture HW 05 This lecture homework will not be collected nor graded This material will be on Lecture Exam 1 Name: Solution PID: Lab Section #: Problem 1 Use least-squares regression to fit a second-order polynomial to the data given below. Along with the equation of the curve, also compute the correlation coefficient. Also use Excel to plot the data and trendline. Display the trendline equation and correlation coefficient. Show all work to receive full credit. Express your answers to 4 decimal places. Place your answers in the spaces provided. x 1 2 3 4 5 6 7 8 9 y 1 1.5 2 3 4 5 8 10 13 a 0 = a 1 = a 2 = r 2 =
Background image of page 1

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

View Full DocumentRight Arrow Icon
EGR 102 of 3 pages Lecture HW 05 2 Problem 2: Use least-squares regression to fit a second-order polynomial to the data given below. Along with the equation of the curve, also compute the correlation coefficient.
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Also use Excel to plot the data and trendline. Display the trendline equation and correlation coefficient. Show all work to receive full credit. Express your answers to 4 decimal places. Place your answers in the spaces provided. x 0.75 2 3 4 6 8 8.5 y 1.2 1.95 2 2.4 2.4 2.7 2.6 a = a 1 = a 2 = r 2 = EGR 102 of 3 pages Lecture HW 05 3 Problem 3: Use least-squares regression to fit a second-order polynomial to the data given below. Along with the equation of the curve, also compute the correlation coefficient. Also use Excel to plot the data and trendline. Display the trendline equation and correlation coefficient. Show all work to receive full credit. Express your answers to 4 decimal places. Place your answers in the spaces provided. x 5 10 15 20 25 30 35 40 45 50 y 17 24 31 33 37 37 40 40 42 41 a = a 1 = a 2 = r 2 =...
View Full Document

This note was uploaded on 02/03/2012 for the course EGR 102 taught by Professor Hinds during the Spring '09 term at Michigan State University.

Page1 / 3

EGR_102_Lecture_HW_05 - Also use Excel to plot the data and...

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