EGR_102_Lecture_HW_05

EGR_102_Lecture_HW_05 - Display the trendline equation 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 Name: 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. Also use Excel to plot the data and trendline.
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: 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 12/26/2010 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 - Display the trendline equation 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