Question: I have ran a regression model analysis. I am unsure what i comment on to report it. I also need to report what coefficients are
I have ran a regression model analysis. I am unsure what i comment on to report it. I also need to report what coefficients are linked to the bid ask price/spread. Can you please clarify. The question is as follows:
Using the data from Problem Set 1 Data.xls, calculate the bid-ask spread for all stocks in the sample. Use a multiple regression model to identify the variables that can explain the bid-ask spread. When running this regression model, your dependent variable should be the bid-ask spread and your independent variables should be: share price, market capitalisation, return volatility and turnover. In your word document report the regression output and identify which of these variables are shown to be related to the bid-ask spread at the 95% confidence level.
The results are attached as

SUMMARY OUTPUT Snipping Regression Statistics Multiple R 0.669402789 In a future up R Square 0.448100093 new home. To Adjusted R Square 0.436102269 with Snip & S Standard Error 0.160080902 Windows log Observations 189 Try Snip & SK ANOVA df SS MS F Significance F Regression 4 3.82834955 0.957087387 37.3484468 7.52872E-23 Residual 184 4.715164736 0.025625895 Total 188 8.543514286 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.165439471 0.03 3470393 4.942860187 1.72539E-06 0.099404376 0.231474565 0.0994043 76 0.231474565 Closing Share Price 0.005508962 0.00055841 9.865445219 1.07377E-18 0.004407253 0.006610672 0.004407253 0.006610672 Market Capitalization -1.61537E-06 6.541168-07 -2.469540187 0.014440301 -2.9059E-06 -3.24834E-07 -2.9059E-06 -3.24834E-07 Return Volatility -0.003952491 0.003319882 -1.190551546 0.235363375 -0.01050242 0.002597439 -0.01050242 0.002597439 Turnover -0.008927507 0.002849391 -3.133127607 0.002012886 -0.014549186 -0.003 305827 -0.014549186 -0.003305827
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
