Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. you are interested in testing whether stock volati

You are interested in testing whether stock volatility, controlling for size and overall market returns, has...

70.2K

Verified Solution

Question

Statistics

You are interested in testing whether stock volatility,controlling for size and overall market returns, has an impact onreturns. You conduct a regression on 89 observations, using monthlyreturns, specified as follows: Ri = b0 + b1 Volatilityi + b2 Sizei+ b3 Rmarket + error Where Volatility is measured as standarddeviation of returns in the previous month, Size is the natural logof total assets, in millions, and Rmarket is the contemporaneousmarket index return.

Your regression results are as follows:

CoefficientStandard error
Incercept0.230.13
Volatility0.770.19
Size0.570.28
R market0.190.19

The regression sum of squares is 0.12 and the residual sum ofsquares is 1.92.

What is the F statistic for testing whether the threeindependent variables are jointly statistically related toreturns?

(Bonus question: is the regression statistically significant atthe 5% level? Use the FDIST function to find the p-value.)

The answer should be 1.77 and the hint professor gave was\"Review how to calculate the F statistic for a multipleregression.\" Please do the problem on excel and show all the steps.Thank you.

Answer & Explanation Solved by verified expert
3.6 Ratings (601 Votes)
The problem is solved in excel and the formula along withexplanation of the formula is givenFormulas to be    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Plot the complex number on the complex plane and write it in polar exponential form...

Basic Math
Q

Keno: Keno game is a game with 80 numbers 1, 2, … , 80 where 20...

Basic Math
Q

What are the problems that occur with concrete that can be solved by nanotechnology?

Civil Engineering
Q

1 The Ideal Gas Law is representative of ideal conditions not realistic ones What makes...

Biology
Q

A Leeches are in the Phylum Annelida and have medicinal uses for humans Leeches are...

Biology
Q

3 Solve the linear systems of equations using the elimina addition multiplication method 10x 10y...

Algebra
Q

Find a calculator approximation of the following Be sure your calculator is in radian mode...

Algebra
Q

Zhong Corp. uses the conventional retail method to estimate ending inventory. Cost data for...

Accounting
Q

Calculate the dollar value of ending inventory and cost of goods sold using: a.)...

Accounting
Q

Bruer Jeep Tours operates jeep tours in the heart of the Colorado Rockies. The company...

Accounting
Q

Variance Analysis Project Use the following data to calculate the variances in problems 1-5. Standard...

Accounting
Q

Exercise 20-17(Algo) Preparation of cash budgets (for three periods) LO P2 Kayak Company...

Accounting