Q2.From the following tableX124781) Use excel to find the regression model.2) What is y if x = 6.3?6121218

We have to find the regression equation and find the value for for the given set of points.

Answered: From the following table X Y 1 2 7 8 1)…

Advanced Engineering Mathematics

10th Edition

ISBN:9780470458365

Author:Erwin Kreyszig

Publisher:Erwin Kreyszig

Chapter2: Second-order Linear Odes

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Similar questions

In order for applicants to work for the foreign-service department, they must take a test in the language of the country where they plan to work. The data below shows the relationship between the number of years that applicants have studied a particular language and the grades they received on the proficiency exam. Find the equation of the regression line for the given data. Number of years, x 4 4 3 6 2 7 3 Grades on test, y 61 68 75 82 73 90 58 93 72 滷 O A. =6.910x+46.261 O B. y = 46.261x+6.910 OC. v=6.910x-46.261 OD. O D. y = 46.261x -6.910 Fi St 5e Assig
An instructor asked a random sample of eight students to record their study times at the beginning of a course. She then made a table for total hours studied (x) over 2 weeks and test score (y) at the end of the 2 weeks. The table is given below. Complete parts (a) through (f). x 10 13 10 18 6 15 16 21 y 93 79 81 74 85 81 85 80 a. Find the regression equation for the data points. b. Graph the regresson equation c. Describe the apparent relationship between the two variables. d. Identify the predictor and response variables. e. Identify outliers and potential influential observations. f.Predict the score for a student that studies for 17 hours.
please quickly thanks !!!!
You may need to use the appropriate technology to answer this question. A regression analysis involving 45 observations relating a dependent variable and two independent variables resulted in the following information. ý = 0.406 + 1.3385X, + 2X2 The SSE for the above model is 43. When two other independent variables were added to the model, the following information was provided. ý = 1.9 – 3X + 12X2 + 4Xg + 8x, This model's SSE is 36. At a 0.05 level of significance, test to determine if the two added independent variables contribute significantly to the model. State the relevant null and alternative hypotheses. O Ho: One or more of the parameters is not equal to zero. H₂: B₁ = B₂= B3 =B4 = 0 O Ho: One or more of the parameters is not equal to zero. H₂: B3 =B4 = 0 O Ho: B3 = P4 = 0 H₂: None of the parameters are equal to zero. ⒸH₁: B3 =B₁ = 0 H: One or more of the parameters is not equal to zero. O Ho: B₁ = P₂ = B3 =B4 = 0 H: One or more of the parameters is not equal to zero. ✔ Find…
Which of the following is true of a linear regression line? a. Located as close as possible to all the points of a scatter chart. B. Is defined by an equation having 2 parameters: the slope and the intercept c. Provides an approximate relationship between the values of two parameters d. All of the above
a. Using the pairs of values for all 10 points, find the equation of the regression line. b. After removing the point with coordinates (2,3), use the pairs of values for the remaining 9 points and find the equation of the regression line. c. Compare the results from parts (a) and (b).
4) How to conduct multiple regression in Excel (Provide the steps)? Driving Experience (years) Monthly Auto Insurance Premium 5 $64 2 87 12 50 9 71 15 44 6 56 25 42 16 60 Does the insurance premium depend on the driving experience or does the driving experience depend on the insurance premium? Do you expect a positive or a negative relationship between these two variables?
The table shows the number of goals allowed and the total points earned (2 points for a win, and 1 point for an overtime or shootout loss) by 14 ice hockey teams over the course of a season. The equation of the regression line is y= - 0.558x + 216.186. Use the data to answer the following questions. (a) Find the coefficient of determination, r, and interpret the result. (b) Find the standard error of the estimate, s,, and interpret the result. Goals Allowed, x Points, y 218 212 216 220 257 266 274 200 211 206 216 204 264 244 O 111 106 99 90 86 83 45 105 100 101 94 83 67 68 (a) ? =O (Round to three decimal places as needed.)
Which of the multivariate regression parameters listed below would be best interpreted as: the proportion of variation in the dependent variable explain by all the independent variables in the model. a b1 X1 R2
n order for applicants to work for the foreign-service department, they must take a test in the language of the country where they plan to work. The data below shows the relationship between the number of years that applicants have studied a particular language and the grades they received on the proficiency exam. Find the equation of the regression line for the data. given Number of years, x 4 5 3 6 2 7 3 Grades on test, y 61 68 75 82 73 90 58 93 72 O A. y 6.910x+46.261 O B. -46.261x +6.910 O C. =6.910x-46.261 O D. = 46.261x-6.910 Next Time Remaining: 01:02:25 74°F Mostly 五 TTL
In the graph shown below consider the horizontal line to represent the average y value for the data set and the slant line to represent the linear regression equation. use only the graph of the data to do the following:

Recommended textbooks for you

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Mathematics For Machine Technology

Advanced Math

ISBN:

9781337798310

Author:

Peterson, John.

Publisher:

Cengage Learning,

Basic Technical Mathematics

Advanced Math

ISBN:

9780134437705

Author:

Washington

Publisher:

PEARSON

Topology

Advanced Math

ISBN:

9780134689517

Author:

Munkres, James R.

Publisher:

Pearson,

SEE MORE TEXTBOOKS

From the following table X Y 1 2 7 8 1) Use excel to find the regression model. 2) What is y if x = 6.3? 9 12 12 18