uPiline profits are strongly correlated with the price of oil. The Following are annual et incomes of American Airlines together with the approximate price of oil in the period 2005-2010: Populate the table Barrel Oil ($) (x) American Net Income (S Year ху million) (y) 1 2005 56 -850 2006 63 250 2007 67 450 4 2008 92 -2100 5 2009 2010 54 -1450 6 71 -700 b. What is Ex? c. What is Ey d. What is n'? e. What is Exy £. What is (Ex) g. What is (Ex)

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
A
B
C
E
K
L
M
N
A common perception is that airline profits are strongly correlated with the price of oil. The Following are annual
net incomes of American Airlines together with the approximate price of oil in the period 2005-2010:
3
a. Populate the table
American Net
Income (S
million) (y)
Barrel Oil ($)
Year
ху
(x)
4.
5.
1
2005
56
-850
6
2006
63
250
7.
3
2007
67
450
8.
4
2008
92
-2100
2009
54
-1450
10
6.
2010
71
-700
11
12
13
14
b. What is Ex?
15
16
c. What is Ey
17
18
d. What is n?
19
20
e. What is Exy
21
22
£. What is (Ex²)
23
24
g. What is (Ex)
25
26
h. Obtain a regression line (obtain the coefficients) showing American's net income as a function of the price of oil
27
28
29
30
31
32 i. Obtain the coefficient of correlation r
33
34
35
Use the data analysis tool in Excel to obtain the coefficients in part 1(h). Copy and Paste your regression output
37 below.
36
38
39
Transcribed Image Text:A B C E K L M N A common perception is that airline profits are strongly correlated with the price of oil. The Following are annual net incomes of American Airlines together with the approximate price of oil in the period 2005-2010: 3 a. Populate the table American Net Income (S million) (y) Barrel Oil ($) Year ху (x) 4. 5. 1 2005 56 -850 6 2006 63 250 7. 3 2007 67 450 8. 4 2008 92 -2100 2009 54 -1450 10 6. 2010 71 -700 11 12 13 14 b. What is Ex? 15 16 c. What is Ey 17 18 d. What is n? 19 20 e. What is Exy 21 22 £. What is (Ex²) 23 24 g. What is (Ex) 25 26 h. Obtain a regression line (obtain the coefficients) showing American's net income as a function of the price of oil 27 28 29 30 31 32 i. Obtain the coefficient of correlation r 33 34 35 Use the data analysis tool in Excel to obtain the coefficients in part 1(h). Copy and Paste your regression output 37 below. 36 38 39
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Multiplicative Exponential demand Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education