EGR_102_Lecture_HW_05

# EGR_102_Lecture_HW_05 - Display the trendline equation and...

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

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 =

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

View Full Document
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.
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
Ask a homework question - tutors are online