This preview has intentionally blurred sections. Sign up to view the full version.
View Full 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 leastsquares regression to fit a secondorder 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
 Spring '09
 HINDS
 Least Squares, Harshad number, Prime number, Lecture HW

Click to edit the document details