Populate the table American Net Barrel Oil ($) Year Income ($ ху y (x) million) (y) 2005 56 -850 47600 3136 722 2006 63 250 15750 3969 625 2007 67 450 30150 4489 202 2008 92 -2100 -193200 8464 4410 5 2009 54 -1450 -78300 2916 2102 6. 2010 71 -700 49700 5041 490 234 S6

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
Topic Video
Question
PLEASE DO PARTS H,I,J
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
Barrel Oil (S)
Year
Income
xy
(x)
million) (y)
4.
5.
2005
56
-850
47600
3136
722500
6.
2006
63
250
15750
3969
62500
7.
3
2007
67
450
30150
4489
202500
8.
4
2008
92
-2100
-193200
8464
4410000
9.
2009
54
-1450
-78300
2916
2102500
10
6
2010
71
-700
49700
5041
49000
11
403
4400
-322900
28015 79990000
12
13
14
b. What is Ex?
403
15
16
c. What is Ey
4400
17
18
d. What is n?
6.
19
20
e. What is Exy
-322,900
21
22
f. What is (Ex)
28018
23
24
g. What is (Ex)
7,990,000
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
36
37 j. Use the data analysis tool in Excel to obtain the coefficients in part 1(h). Copy and Paste your regression output below.
38
Transcribed Image Text: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 Barrel Oil (S) Year Income xy (x) million) (y) 4. 5. 2005 56 -850 47600 3136 722500 6. 2006 63 250 15750 3969 62500 7. 3 2007 67 450 30150 4489 202500 8. 4 2008 92 -2100 -193200 8464 4410000 9. 2009 54 -1450 -78300 2916 2102500 10 6 2010 71 -700 49700 5041 49000 11 403 4400 -322900 28015 79990000 12 13 14 b. What is Ex? 403 15 16 c. What is Ey 4400 17 18 d. What is n? 6. 19 20 e. What is Exy -322,900 21 22 f. What is (Ex) 28018 23 24 g. What is (Ex) 7,990,000 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 36 37 j. Use the data analysis tool in Excel to obtain the coefficients in part 1(h). Copy and Paste your regression output below. 38
Expert Solution
Step 1

(

Please note that    x2=28015

)

 

 

The data for American's net income and price of oil is listed below

x y
56 -850
63 250
67 450
92 -2100
54 -1450
71 -700

As given,

 

y = -4400,x=405,xy=-322900,x2=28015,y2=7990000

Here American's net income is the response variable (x) and the price of oil is an explanatory variable (y).

 

Step 2

h)  It is required to obtain the regression line.

y = -4400,x=405,xy=-322900,x2=28013,y2=7990000

First calculating the coefficeint of regression (b)

b=nxy-xynx2-(x)2

b=6* -322900 -405* (-4400)6*28018-(405)2

b =-1642005681 =-28.9034


The formula for the intercept (a) is

a=y- bxn

a=-4400--28.9034* 4056 

a =72486 = 1208.009


The regression line is

y = 1208.009 -28.9034 x

 

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Permutation and Combination
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
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