2. The following table shows U.S. exports to a certain country as a function of U.S. imports from that same country, based on trade figures in the period 1990-2003. a. Populate the table Imports (S billions) (x) Еxports (S billions) (y) ху 22 24 10 27 15 35 20 25 12 b. What is Ex? c. What is Ey d. What is n? e. What is Exy £. What is (Ex²) g. What is (Ex)² h. Obtain a regression line (obtain the coefficients) showing American's imports as a function of exports i. Obtain the coefficient of correlation r numerator denominator j. Use the data analysis tool in Excel to obtain the coefficient of correlation in part 2(i). Copy and Paste your regression output below.
2. The following table shows U.S. exports to a certain country as a function of U.S. imports from that same country, based on trade figures in the period 1990-2003. a. Populate the table Imports (S billions) (x) Еxports (S billions) (y) ху 22 24 10 27 15 35 20 25 12 b. What is Ex? c. What is Ey d. What is n? e. What is Exy £. What is (Ex²) g. What is (Ex)² h. Obtain a regression line (obtain the coefficients) showing American's imports as a function of exports i. Obtain the coefficient of correlation r numerator denominator j. Use the data analysis tool in Excel to obtain the coefficient of correlation in part 2(i). Copy and Paste your regression output below.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
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
Transcribed Image Text:fx
A
B.
D
G
39
K
2. The following table shows U.S. exports to a certain country as a function of U.S. imports from that
same country, based on trade figures in the period 1990-2003.
40
41 a. Populate the table
Imports (S
billions) (x)
Exports ($
billions) (y)
42
ху
y
43
22
7
44
24
10
45
27
15
46
35
25
20
47
12
48
49
50
51
b. What is Ex?
52
53
c. What is Ey
54
55
d. What is n?
56
57
e. What is Exy
58
59
£. What is (Ex²)
60
61
g. What is (Ex)²
62
63
h. Obtain a regression line (obtain the coefficients) showing American's imports as a function of exports
64
65
66
m
67
b =
68
69 i. Obtain the coefficient of correlation r
70
71
numerator =
72
denominator -
73
74
75
j. Use the data analysis tool in Excel to obtain the coefficient of correlation in part 2(i).
Copy and Paste your regression output below.
76
77
78
79
L
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
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
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman