Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach

Authors: Jeffrey Slater, Debra Good

13th Canadian edition

134616316, 134166698, 9780134632407 , 978-0134166698

More Books

Students also viewed these Accounting questions

Question

=+b) Is this model appropriate for this series? Explain.

Answered: 1 week ago

Question

What are the purposes of promotion ?

Answered: 1 week ago

Question

Define promotion.

Answered: 1 week ago