{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

EGR_102_Lecture_HW_05

# EGR_102_Lecture_HW_05 - Also use Excel to plot the data 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 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 =

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.
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online