Using the following data: A. Develop a multiple regression model to predict y from x1, x2, and x3 . B. Find the values of F (for the whole model), t (for each independent variable), and P-values and comment of how significant they (the model, and independent variables) are. (You can use Regression Module in Excel for this question) (Round your answers to 4 decimal places, e.g. 1.7586.) y X1 X2 X3 5.3 44 11 401 3.6 24 40 219 5.1 46 13 394 4.9 38 18 362

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter4: Polynomial And Rational Functions
Section4.1: Quadratic Functions
Problem 91E
icon
Related questions
Question

Q.21 Urgent question! I will thumbs up!

In the final answer that you circle, please also include the brief approach / formula you used under "Answer". 

Thanks!

Using the following data:
A. Develop a multiple regression model to predict y from x1, X2, and x3 .
B. Find the values of F (for the whole model), t (for each independent variable), and P-values and
comment of how significant they (the model, and independent variables) are.
(You can use Regression Module in Excel for this question) (Round your answers to 4 decimal
places, e.g. 1.7586.)
X1
X2
X3
5.3
44
11
401
3.6 24
40
219
5.1
46
13
394
4.9
38
18
362
7.0
61
3
453
6.4
58
5
468
5.2 47
14
386
4.6
36
24
357
2.9
19
52
206
4.0 31
29
301
3.8
24
37
243
3.8
27
36
228
4.8
36
21
342
5.4
50
11
421
5.8
55
9.
445
Transcribed Image Text:Using the following data: A. Develop a multiple regression model to predict y from x1, X2, and x3 . B. Find the values of F (for the whole model), t (for each independent variable), and P-values and comment of how significant they (the model, and independent variables) are. (You can use Regression Module in Excel for this question) (Round your answers to 4 decimal places, e.g. 1.7586.) X1 X2 X3 5.3 44 11 401 3.6 24 40 219 5.1 46 13 394 4.9 38 18 362 7.0 61 3 453 6.4 58 5 468 5.2 47 14 386 4.6 36 24 357 2.9 19 52 206 4.0 31 29 301 3.8 24 37 243 3.8 27 36 228 4.8 36 21 342 5.4 50 11 421 5.8 55 9. 445
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning