Question: How well does the regression model work for market capitalization? I've got this set of data which i've computed from excel's regression analysis. I find

How well does the regression model work for market capitalization?

I've got this set of data which i've computed from excel's regression analysis. I find it weird that my standard error is so large! can i get some help on why is it so large and how do i get about doing this question? I've attached a pic of my data. I need help. Thanks!

Regression Statistics Mean of Market Cap 16778.43 Multiple R 0.930007185 R Square 0.864913365 Adjusted R Square 0.864647838 Standard Error 17200.3995 Observations 2040 ANOVA df 55 MS F Significance F Regression 4 3.8548E+12 9.637E+11 3257351649 0 Residual 2035 6.02062E+11 2958537429 Total 2039 4.45686E+12 Coefficients Standard Error t Stat Pvalue Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 2992.99612 4003518144 7475914963 1.13271E13 2207.854005 3778.138235 2207.854005 3778.138235 Net Income (Loss) 3.687366077 0.477629076 7.720145734 1.8085E-14 2.750673175- 4.62405898 2.750673175 4.62405898 Sales/Turnover (Net) 1.669551466 0030527911 5468934548 0 1.609682252 1.72942068 1.609682252 1.72942068 Long-Term Debt Tota| -0.242157992 0.027626067 8.765561S32 3.84082E18 0.296336313 -0.187979672 -0.296336313 0.187979672 Net Assets 0762156677 0041431981 1839537143 4.96122E70 0.68090316 0.843410194 0.68090316 0.843410194

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

pleas do this steps on excel from 2-8 from the first link and from 9-14 from the second link...

CableTech Bell Corporation (CTB) operates in the telecommunications industry. CTB has two divisions: the Phone Division and the Cable Service Division. The Phone Division manufactures telephones in...

Could I please get a step by step explanation on how to do this? Would you please include all explanations and reasons on how to get the answer. Graphs and histograms and formulas included. Thank you...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Location Income ($1,000) Urban 27 Rural 25 Suburban 25 Suburban 26 Rural 30 Urban 29 Rural 33 Urban 30 Suburban 32 Urban 34 Urban 35 Urban 40 Rural 30 Rural 33 Urban 42 Suburban 32 Urban 43 Urban 43...

1. What is the issue being addressed in the paper? 2. What are the findings of the paper? 3. Why is this paper important to auditors, and what are the implications of this paper for the auditing...

Return Predictability along the Supply Chain F.AJ inancial Analysts Journal Volume 66 . Number 3 @2010 CFA Institute these two studies were based on the idea that the 2007, the last month for which...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

A cable passes around three 30-mm-radius pulleys and supports two blocks as shown. Pulleys C and E are locked to prevent rotation, and the coefficients of friction between the cable and the pulleys...

Let f X* be a continuous linear functional on a Hilbert space X. There exists a unique element y X such that f(x) = xT y for every x X

Look again at your answers to questions 1 and 2. a Think about a method you can use to check you have shared each amount correctly. b Discuss your method with a partner. Do they have the same method?...

Sales (42,000 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 336,000 210,000 126,000 47,000 $ 79,000 Per Unit $ 8.00 5.00 $ 3.00 Required: (Consider each...