14.1)use the following data to develop a quadratic model to predict y from x. develop a...

14.1)use the following data to develop a quadratic model to predict y from x. develop a simple regression model from the data and compare the results of the two models. Does the quadratic model seem to provide any better predictability? Why or why not ?

x	y	x	y
14	200	15	247
9	74	8	82
6	29	5	21
21	456	10	94
17	320

Answer:simple model: y^= -14.27+27.128x, F=229.67 with p=.000, s_e=27.27, R²=.97, adjusted R²=.966 Quadratic Model: y^= -22.01 +3.385x₁ +0.9373x_2, F=578.76 with p=.000 ,s_e=12.3, R² =.995, adjusted R²=.993, for x₁ : t=0.75, for x₂ :t=5.33

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Use the following data to develop a quadratic model to predict y from x. Develop a...

Use the following data to develop a quadratic model to predict y from x. Develop a simple regression model from the data and compare the results of the two models. Does the quadratic model seem to provide any better predictability? Why or why not? x y x y 15 229 15 247 9 74 8 82 6 29 5 21 21 456 10 94 17 320

Use the following data to develop a multiple regression model to predict from and . Discuss...

Use the following data to develop a multiple regression model to predict from and . Discuss the output, including comments about the overall strength of the model, the significance of the regression coefficients, and other indicators of model fit. y x1 x2 198 29 1.64 214 71 2.81 211 54 2.22 219 73 2.70 184 67 1.57 167 32 1.63 201 47 1.99 204 43 2.14 190 60 2.04 222 32 2.93 197 34 2.15 Appendix A Statistical Tables *(Round...

Data was collected from 40 employees to develop a regression model to predict the employee’s annual...

Data was collected from 40 employees to develop a regression model to predict the employee’s annual salary using their years with the company (Years), their starting salary in thousands (Starting), and their Gender (Male = 0, Female = 1). The level of significance is .01. The results from Excel regression analysis are shown below: SUMMARY OUTPUT Regression Statistics Multiple R 0.718714957 R Square 0.516551189 Adjusted R Square 0.476263788 Standard Error 10615.63461 Observations 40 ANOVA Df SS MS F Significance F...

Use Excel to develop a regression model for the Hospital Database to predict the number of...

Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel Births 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...

Use Excel to develop a regression model for the Hospital Database to predict the number of...

Use Excel to develop a regression model for the Hospital Database to predict the number of Personnel by the number of Births. How many residuals are within 1 standard error? Write your answer as a whole number. Personnel(y) Births(x) 792 312 1762 1077 2310 1027 328 355 181 168 1077 3810 742 735 131 1 1594 1733 233 257 241 169 203 430 325 0 676 2049 347 211 79 16 505 2648 1543 2450 755 1465 959 0 325...

PLEASE USE PYTHON CODE Compute the zero of the function y(x) from the following data: x...

PLEASE USE PYTHON CODE Compute the zero of the function y(x) from the following data: x = 0.2, 0.4, 0.6, 0.8, 1.0 y = 1.150, 0.855, 0.377, -0.266, -1.049 Use inverse interpolation with the natural cubic spline

For the following data, find the regression equation for predicting Y from X X Y 1...

For the following data, find the regression equation for predicting Y from X X Y 1 2 4 7 3 5 2 1 5 8 3 7 1a. Group of answer choices a. Ŷ = -2X + 8 b. Ŷ =2X + 8 c. Ŷ =1.8X - 0.4 d. Ŷ =1.8X + 0.4 1b. For the following scores, find the regression equation for predicting Y from X X Y 3 8 6 4 3 5 3 5 5 3

Develop a conceptual data model for the following scenario: The data model should consist of the...

Develop a conceptual data model for the following scenario: The data model should consist of the usual 5 components: E-R diagram, Entity Types (including entity type identifiers), assumptions, additional constraints, and limitations: It is desired to develop a shop database for a shop of different classes of products. A shop sells different classes of products to customers. For each class, it is required to keep the following information: class identification number (class-id) and class name. Each class has one or...

Use Excel to estimate a simple linear regression model for the following data (Y is a...

Use Excel to estimate a simple linear regression model for the following data (Y is a dependent variable and X is an independent variable): Y X 0 -2 0 -1 1 0 1 1 3 2 Fill in Multiple Blanks: What is the slope of the estimated line? In your answer, show one (1) digit to the right of the decimal point, for example, 1.0, 1.2. Apply the appropriate rounding rule if necessary. What is the Y-intercept?

Use the model of the market for loanable funds to predict the effects of the following...

Use the model of the market for loanable funds to predict the effects of the following events: a) A tax credit is given to firms starting a new business or expanding a current business. b) An unhealthy economy has depressed firms future profit expectations. c) The federal government goes from a balanced budget to a budget surplus.

Subjects