Regression and Forecasting

Regression and
Forecasting

Table of Contents
Table of Contents.............................................................................................................................2
INTRODUCTION...........................................................................................................................1
MAIN BODY..................................................................................................................................1
a. Using the excel tool regression to get the relationship between the two variables..................1
b. Creating a scatter diagram for the two variables and display the regression equation and R
square on the chart.......................................................................................................................3
c. Analysis of that the estimated equation is providing a good fit or not....................................4
d. Use of regression results for forecasting purpose....................................................................5
CONCLUSION................................................................................................................................6
REFERENCES................................................................................................................................7

INTRODUCTION
Regression could be defined as a statistical method which is used in studies to determine
the relationship between two different variables. Apart from this, it is also used to analyse the
character and strength of the relation of dependent and independent variables. On the other hand,
forecasting is the process of estimating the future values on the basis of the results that are
generated through regression analysis (Angarita-Zapata, Masegosa and Triguero, 2020). These
two procedures are interlinked with each other because in order to perform activities related to
forecasting it will eb very important to use the outcomes that are generated with the help of
regression. Present report is based upon the online education data base. The two variables that
are taken in it for the analysis purpose are retention and graduation rate for different colleges.
This report will cover different topics such as analysis of relationship with the help of regression,
creation of scatter diagram and assessment of the accuracy of regression equation. Additionally,
the capability of using the regression result for forecasting is also analysed under this project.
MAIN BODY
a. Using the excel tool regression to get the relationship between the two variables
Output from excel calculations:
Regression Statistics
Multiple R 0.621628
R Square 0.386421
Adjusted R
Square 0.362822
Standard Error 7.579612
Observations 28
ANOVA
df SS MS F
Significance
F
Regression 1 940.7152 940.7152 16.37436 0.000414
Residual 26 1493.713 57.45051
Total 27 2434.429
Coefficients
Standard
Error t Stat P-value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept 26.10682 4.263687 6.123062 1.79E-06 17.34269 34.87096 17.34269 34.87096
1