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

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 23PPS
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
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage