4. Production of a regression model; interpretation and comments. Identification of likely external factors affecting the trend.
The following part displays the results of regression analysis:
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.997143883
R Square
0.994295924
Adjusted R Square
0.993979031
Standard Error
22624.54416
Observations
20
The above table depicts the table of output summary which is comprised of the values like R2 and Adjusted R2
ANOVA
df
SS
MS
F
Significance F
Regression
1.00
1606062773441.34
1606062773441.34
3137.64
0.00
Residual
18.00
9213659974.41
511869998.58
Total
19.00
1615276433415.75
The above table indicates the values of regression, residual and total's sum of square, mean square, f value and significance value. According to the P-value of the above table, regression modal is significantly important in this particular scenario as the p value is 0.00, ...