Question: 1. Data 3-10 has cross sectional data on total 1995 sales and profits for 27 German companies. Use Excel to estimate the model (in other

1. Data 3-10 has cross sectional data on total 1995 sales and profits for 27 German companies. Use Excel to estimate the model (in other words, run the regression): Profits_i = _i + SALES_i + _i

a. Draw a scatter plot with profits on the Y axis. Compute the R2 from the Excel regression printout. Is the regression line a good fit for the data? Explain what variable you are looking at to arrive at your conclusion.

b. In one or two sentences, state what the regression results imply about the relationship between profits and sales. Do the results coincide with what you expected? Explain.

c. Based on the Significance F, is the overall regression statistically significant from zero? Explain how you arrived at that conclusion.

d. Is the coefficient of Sales statistically significant (from zero)? Explain how you arrived at that conclusion.

DATA 3-10:

profits:

629

1214

1254

1567

1119

711

1618

180

183

349

232

453

757

168

238

118

191

490

211

163

243

145

168

160

sales:

36.617

58.112

43.421

29.186

34.16

41.628

30.265

16.892

1.199

21.011

57.69

30.21

27.69

3.706

9.295

5.861

12.332

25.613

5.423

3.042

9.952

17.253

3.499

12.178

2.292

13.901

17.747

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 Economics Questions!

2.10 LAB: Set basics Given the user inputs, complete a program that does the following tasks: Define a set, fruits, containing the user inputs myFruit1, myFruit 2, and my Fruit3. Add the user input...

1. Data 3-10 has cross sectional data on total 1995 sales and profits for 27 German companies. Use Excel to estimate the model (in other words, run the regression): Profits i = i + SALES i + i here...

Here is question 1 and the answers: 1. Data 3-10 has cross sectional data on total 1995 sales and profits for 27 German companies. Use Excel to estimate the model (in other words, run the...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

** You can use EXCEL or any other software. ** You need to include your printout in your submissions. The layout and format of the paper should include the following sections: Title page, Abstract,...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

LIQUIDITY - PROFITABILITY TRADEOFF: AN EMPIRICAL INVESTIGATION IN AN EMERGING MARKET Abuzar M. A. Eljelly This study empirically examines the relation between profitability and liquidity, as measured...

Please Provide a 2 to 3 page article review for each, there attached on this question. Your discussion should include a brief summary (including the big ideas or major points of the article) along...

Consider a cubic Hermite curve lying in the plane x = 10 whose geometric characteristics at u = 0 are (10,2,2) and dz/dy = 2; at u= = { are (10,6,6); and at u=1 are (10, 10, 2) and dz/dy = -2. Find...

Western Railroad has a dividend reinvestment program for shareholders. Over the past five years, the company has had the following share prices and the following dividends. If you started with 100...

What are the major differences between sales - based and communications - based advertising objectives?

Norr and Caylor established a partnership on January 1, 2019. Norr invested cash of $100,000 and Caylor invested $30,000 in cash and equipment with a book value of $40,000 and fair value of $50,000....

Pharr Foods Company produces a variety of food products including a line of candies. One of its most popular candy items is Far Stars, a bag of a dozen, individually wrapped, star-shaped candies made...

Your company is considering acquiring a private company (New Co., Inc.). The CFO has asked you to review the financial statements, look for key trends, and develop financial/operational questions to...

A company has developed a new product. It needs to decide whether or not to product test and market test before launch, and has been advised that, even though these processes do cost money, they...

3 Consider the following possible alternatives to the vector norms we encountered in the notes. For each, state whether the proposed definition satisfies the conditions of a norm or not. If it does,...

Identifying How Machine Learning Can Solve Problems What problem would you like your machine learning model to solve? What output would you like your machine learning model to produce? How will you...

6. It is what the person has previously done for the group that is the deciding factor.

3. It is the commitment you show that is the deciding factor.

4. It is the principle of equality (according to very specific criteria of equality) that is crucial.