Home /
Expert Answers /
Computer Science /
a-mul-ple-regression-equa-on-was-developed-rela-ng-the-number-of-embarking-bus-passengers-y-to-bus-pa956
(Solved): A mul!ple regression equa!on was developed rela!ng the number of embarking bus passengers, y, to bus ...
A mul!ple regression equa!on was developed rela!ng the number of embarking bus passengers, y, to bus headway (x1) and dummy variable segment location (x2) where x2 is 1 if the bus segment is located along EDSA and 0 otherwise.
The resul!ng multiple regression equation and other statistical results using the EXCEL software is shown below:
What is now the multiple regression equation?
Compute manually the value of R2.
Compute manually the confidence intervals of x1 and x2.
ANOVA SS F Significance Regression 2 64047.5632023 .786 .6674830 .023933 Residual 7 33620.854802 .979 Total 9 97668.41
Regression Statistics Multiple R R Square Adjusted R 0.557413 Square Standard Error 69.30353 Observations 10
\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & Coefficients & & t Stat & P-value & Lower 95\% & & & \\ \hline Intercept & 19.4339 & 48.67227 & 0.399281 & 0.701588 & & 134.5254 & & 134.5254 \\ \hline & -0.10148 & 0.629721 & -0.16115 & 0.876527 & -1.59053 & 1.387573 & & 1.387573 \\ \hline & 158.4882 & 53.44564 & 2.965409 & 0.020944 & 32.10943 & 284.867 & 32.10943 & 3284.867 \\ \hline \end{tabular}