Purchase Solution

Linear Regression (example problem)

Not what you're looking for?

Ask Custom Question

Linear Regression (example problem)

Boeing and McDonnell Douglas from the United States, and Airbus Industrie, the European consortium, dominate the global aerospace industry. During the early 1990's, the end of the cold war with the Soviet Union led to a dramatic downshifting in orders for military related purchases at the same time a global recession cut sharply into the commercial demand for aircraft. Against this backdrop, a number of financial analysts began to question the wisdom and profitability of the industry's massive long-term investments in research and development (R&D).

The following table shows sales revenues, profit, and R&D data for a sample of firms taken from the U.S. aerospace industry. Data are for the most recent fiscal year reported as of May 18, 1993, and are limited to those companies reporting sales of $58 million or more and R&D expenditures of at least $1 million. R&D expenditures are the dollar amount of company sponsored R&D during the most recent fiscal year, as reported to the Securities and Exchange Commission on Form 10-K. Excluded from such numbers is R&D under contract to others, such as U.S. government agencies. All figures are in millions of dollars.

Company Name Sales Profits R&D Expense
Abex 728.4 194.0 1.6
Boeing 30,184.0 2,256.0 1,846.0
Curtiss-Wright 179.7 32.7 1.6
GenCorp 1,937.0 37.0 36.0
General Dynamics 3,472.0 227.0 66.0
K&F Industries 782.9 29.0 14.1
Kaman 295.5 (14.7) 14.1
Lockheed 10.100.0 549.0 420.0
Martin Marietta 5.954.3 512.4 200.0
McDonnell Douglas 17,373.0 1,086.0 509.0
Northrop 5,550.0 180.0 93.0
OEA 88.1 23.1 2.6
Orbital Sciences 174.6 5.4 6.0
Pacific Scientific 172.6 8.1 8.2
Sequa 1,868.3 43.8 17.6
Sunstrand 1,672.7 130.1 115.4
Thiokol 1,311.7 101.8 14.2
United Technologies 21,641.0 200.0 1,219.0
Woodward Governor 374.2 33.0 16.0

Required:

1. Using Excel generate a simple regression model with sales revenue as the dependent
Y-variable and R&D expenditures as the independent X- variable

2. Based on the model generated, forecast revenues for a firm with R&D expenditures of $300.0

3. Evaluate the predictability of the model.

Attachments
Purchase this Solution
Solution Summary

Linear Regression example problem is examined thoroughly.

Solution Preview

refer to the attachment.
<br>
<br>1. Using Excel generate a simple regression model with sales revenue as the dependent
<br> Y-variable and R&D expenditures as the independent X- ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Simple Linear Regression and Multiple Regression.

    There is a problem with multiple regression, and that is you need more data than your variables. For example, if you need 5 variables, then you must sample at least 5 data to ensure that your regression will work.

  • Regression Analysis

    454366 Simple Linear Regression: Example Problem The value of a sports franchise is directly related to the amount of revenue that a franchise can generate.

  • Least squares linear trend line

    58034 A least squares linear trend line is just a simple regression line with the independent variable being time (months or years for example).

  • solve linear regression problem

    Tony The solution provides detailed explanation how to solve linear regression problem.

  • Linear regression model - auditors

    For example, 2500 is 2.5.) Y hat = 12.8 +.0973X X = miles driven Y = Gallons used SSE = 652 Please see the attached file. A linear regression model is used to estimate gas usage.

  • simple linear regression models

    Do the assumptions of linear regression hold for your models? How do these models compare to the multiple regression models? Hi Here is solution to problem on regression.

  • quantitative methods

    The above is a typical example which a lot of businesses face, and this problem can be easily solved using linear programming.

  • Linear Regression height vs. weight

    570667 Linear Regression: Height vs. Weight Using an example from a hospital, create a mock data set for two specific variables of importance within hospital (minimum of 20).

  • Linear Regression Paper

    The expert examines a linear regression paper.

  • Quantitative Reasoning Example Problem

    369151 Quantitative Reasoning Example Problem 1. When using linear regression analysis what are we attempting to measure? Explain how this measurement can help in a business decision. 2.

View More Related Solutions