This exercise requires the use of a statistical software package. The cotton aphid poses a threat to cotton crops. The accompanying data on y = Infestation rate (aphids/100 leaves) X₁ = Mean temperature (°C) X₂ = Mean relative humidity appeared in an article on the subject. x2 62 21.0 57.0 78 24.8 y X₁ 88 28.3 41.5 94 26.0 56.0 97 27.5 58.0 101 27.1 31.0 105 26.8 36.5 119 29.0 41.0 28 30.8 37.0 103 28.3 40.0 75 34.0 25.0 13 33.6 20.0 62 30.5 34.0 42 28.3 13.0 31 31.3 21.0 7 34.3 6.0 19 33.0 21.0 X₁ 43 32.0 28.0 x2 61 27.8 39.0 48.0 83 68 33.0 24.5 39 34.5 16.0 25.0 107 41.0 20 31.0 19.0 22 31.8 17.0 24 33.5 18.5 20 34.3 26.0 22 26.5 26.0 57 27.3 24.5 58 25.8 29.0 88 18.5 53.5 78 26.0 51.0 103 19.0 48.0 18.0 70.0 98 16.3 79.5 Find the estimated regression equation of the multiple regression model y = a + B₁x₁ + B₂X2 + e. (Round your numerical values to two decimal places.) ŷ = Assess the utility of the multiple regression model using a significance level of 0.05. Calculate the test statistic. (Round your answer to two decimal places.) F = Use technology to calculate the P-value. (Round your answer to four decimal places.) P-value =

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section: Chapter Questions
Problem 22SGR
icon
Related questions
Question
This exercise requires the use of a statistical software package.
The cotton aphid poses a threat to cotton crops. The accompanying data on
y = Infestation rate (aphids/100 leaves)
X1 = Mean temperature (°C)
x2 = Mean relative humidity
appeared in an article on the subject.
ŷ
y
=
62 21.0
105
X1
88 28.3 41.5 94 26.0 56.0
97 27.5 58.0 101 27.1 31.0
x2
68
103 28.3 40.0 75 34.0 25.0
7
57.0 78 24.8 48.0
62 30.5 34.0 42 28.3 13.0
13 33.6 20.0
28 30.8 37.0 20 31.0 19.0
31 31.3 21.0
26.8 36.5 119 29.0 41.0
61
78
34.3
X1
33.0 24.5
19 33.0 21.0
6.0
43 32.0 28.0
X2
27.8 39.0
22 31.8 17.0
24 33.5
39
34.5
18.5
16.0
20 34.3 26.0
22 26.5 26.0
57 27.3 24.5
58 25.8 29.0
83 25.0 41.0 88 18.5 53.5
26.0 51.0 103 19.0 48.0
Find the estimated regression equation of the multiple regression model y = a + B₁X₁ + ₂×₂ + e. (Round your numerical values
to two decimal places.)
107 18.0 70.0 98 16.3 79.5
Assess the utility of the multiple regression model using a significance level of 0.05.
Calculate the test statistic. (Round your answer to two decimal places.)
F =
Use technology to calculate the P-value. (Round your answer to four decimal places.)
P-value =
Transcribed Image Text:This exercise requires the use of a statistical software package. The cotton aphid poses a threat to cotton crops. The accompanying data on y = Infestation rate (aphids/100 leaves) X1 = Mean temperature (°C) x2 = Mean relative humidity appeared in an article on the subject. ŷ y = 62 21.0 105 X1 88 28.3 41.5 94 26.0 56.0 97 27.5 58.0 101 27.1 31.0 x2 68 103 28.3 40.0 75 34.0 25.0 7 57.0 78 24.8 48.0 62 30.5 34.0 42 28.3 13.0 13 33.6 20.0 28 30.8 37.0 20 31.0 19.0 31 31.3 21.0 26.8 36.5 119 29.0 41.0 61 78 34.3 X1 33.0 24.5 19 33.0 21.0 6.0 43 32.0 28.0 X2 27.8 39.0 22 31.8 17.0 24 33.5 39 34.5 18.5 16.0 20 34.3 26.0 22 26.5 26.0 57 27.3 24.5 58 25.8 29.0 83 25.0 41.0 88 18.5 53.5 26.0 51.0 103 19.0 48.0 Find the estimated regression equation of the multiple regression model y = a + B₁X₁ + ₂×₂ + e. (Round your numerical values to two decimal places.) 107 18.0 70.0 98 16.3 79.5 Assess the utility of the multiple regression model using a significance level of 0.05. Calculate the test statistic. (Round your answer to two decimal places.) F = Use technology to calculate the P-value. (Round your answer to four decimal places.) P-value =
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL