Consider the following data for a dependent variable y and two independent variables, ¤1 and x2. 12 29 12 94 47 10 109 24 17 113 51 17 178 41 95 52 19 176 75 8 171 36 12 118 59 13 143 77 16 211 The estimated regression equation for these data is ŷ = –16.20 + 1.90x1 + 4.93x2 Here SST = 15,059.6, SSR = 14,242.3, s = 0.2030, and Sin = 0.812? a. Test for a significant relationship among 21, 82, and y. Use a = 0.05. F = | (to 2 decimals) The p-value is - Select your answer - At a = 0.05, the overall model is - Select your answer b. Is B1 significant? Use a = 0.05 (to 2 decimals). Use t table.
Consider the following data for a dependent variable y and two independent variables, ¤1 and x2. 12 29 12 94 47 10 109 24 17 113 51 17 178 41 95 52 19 176 75 8 171 36 12 118 59 13 143 77 16 211 The estimated regression equation for these data is ŷ = –16.20 + 1.90x1 + 4.93x2 Here SST = 15,059.6, SSR = 14,242.3, s = 0.2030, and Sin = 0.812? a. Test for a significant relationship among 21, 82, and y. Use a = 0.05. F = | (to 2 decimals) The p-value is - Select your answer - At a = 0.05, the overall model is - Select your answer b. Is B1 significant? Use a = 0.05 (to 2 decimals). Use t table.
Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter1: Functions
Section1.2: The Least Square Line
Problem 8E
Related questions
Question
I need help solving this and how to input in excel! Thank you!
Transcribed Image Text:Consider the following data for a dependent variable y and two
independent variables, a1 and æ2.
29
12
94
47
10
109
24
17
113
51
17
178
41
95
52
19
176
75
8
171
36
12
118
59
13
143
77
16
211
The estimated regression equation for these data is
ŷ = -16.20 + 1.90¤1 + 4.93x2
Here SST = 15,059.6, SSR = 14,242.3, si, = 0.2030, and si, = 0.8127
a. Test for a significant relationship among a1, x2, and y. Use a = 0.05.
F
(to 2 decimals)
The p-value is - Select your answer -
At a =
0.05, the overall model is - Select your answer
b. Is B1 significant? Use a = 0.05 (to 2 decimals). Use t table.
te,
5.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning