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)

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)
14th Edition
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Chapter14A: The Practice Of Revenue Management
Section: Chapter Questions
Problem 1E
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
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Principles of Economics 2e
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax