Company Name  Profits R&D Expense Sales Abex 194 1.6 728.4 Boeing 2256 1846 30184 Curtiss-Wright 32.7 1.6 179.7 GenCorp 37 36 1937 General Dynamics 227 66 3472 K&F Industries 29 14.1 782.9 Kaman -14.7 14.1 295.5 Lockheed 549 420 10100 Martin Marietta 512.4 200 5954.3 McDonnell Douglas 1086 509 17373 Northrop 180 93 5550 OEA 23.1 2.6 88.1 Orbital Sciences 5.4 6 174.6 Pacific Scientific 8.1 8.2 172.6 Sequa 43.8 17.6 1868.3 Sunstrand 130.1 115.4 1672.7 Thiokol 101.8 14.2 1311.7 United Technologies 200 1219 21641 Woodward Governor 33 16 374.2 Using Excel generate a simple regression model with profits as the dependent variable and sales revenue as the independent variable.  Write the coefficients from the output:   Intercept   Independent variable   R-square   Significance F

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Company Name  Profits R&D Expense Sales
Abex 194 1.6 728.4
Boeing 2256 1846 30184
Curtiss-Wright 32.7 1.6 179.7
GenCorp 37 36 1937
General Dynamics 227 66 3472
K&F Industries 29 14.1 782.9
Kaman -14.7 14.1 295.5
Lockheed 549 420 10100
Martin Marietta 512.4 200 5954.3
McDonnell Douglas 1086 509 17373
Northrop 180 93 5550
OEA 23.1 2.6 88.1
Orbital Sciences 5.4 6 174.6
Pacific Scientific 8.1 8.2 172.6
Sequa 43.8 17.6 1868.3
Sunstrand 130.1 115.4 1672.7
Thiokol 101.8 14.2 1311.7
United Technologies 200 1219 21641
Woodward Governor 33 16 374.2
  1. Using Excel generate a simple regression model with profits as the dependent variable and sales revenue as the independent variable.  Write the coefficients from the output:

 

Intercept

 

Independent variable

 

R-square

 

Significance F

Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman