Multiple Regression Analysis Report 2022

Running head: MULTIPLE REGRESSION ANALYSIS 1
Does the Amount of Rainfall for Growing Season and Wheat Yield Affect Summer Rainfall
significantly?
Student Name
Institution

MULTIPLE REGRESSION ANALYSIS 2
Background Information
To predict the relationship between wheat yields, summer rainfall, and growing season
rainfall amount, a multiple linear regression model is conducted using Ms-Excel with summer
rainfall as the dependent (response) variable while the amounts of rainfall in growing season
rainfall and wheat yield as the independent (explanatory) variables. Multiple regression analysis
is a statistical analysis tool used to predict the relationship between a response variable and two
or more variables (Davies, 2017). Multiple regression modeling predicts the degree of
association between and dependent and independent variables and the significance of individual
explanatory in predicting the response variable.
Excel Output
SUMMARY
OUTPUTRegression Statistics
Multiple R
0.73560
2
R Square
0.54111
1
Adjusted R
Square
0.47051
2
Standard Error
68.2802
2
Observations 16
ANOVA
df
SS MS F
Significa
nce F
Regression 2 71467.9
35733.
95
7.6646
31
0.00632
6
Residual 13 60608.45
4662.1
88
Total 15 132076.4
Coefficie
nts
Standard
Error t Stat
P-
value
Lower
95%
Upper
95%
Intercept
286.783
9 97.96901
2.9272
92
0.0117
74
75.1347
6
498.43
31