Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the WEO data We will use the following variables ( see lines on excel ) : Line 4 - GPD current prices Line 8

Use the WEO data We will use the following variables (see lines on excel): Line 4- GPD current prices Line 84- Sunflower Oil, US export price from Gulf of Mexico, US$ per metric ton. Line 121-Commodity Metals Price Index includes Copper, Aluminum, Iron Ore, Tin, Nickel, Zinc, Lead, and Uranium Price Indices Line 101- Commodity Beverage Price Index includes Coffee, Tea, and Cocoa Exercise 1. Linear Regression Do a linear regression and present the graphics and correlation between -1) please copy and paste the graphics 2) add explanation of this relationship - is it negative? Positive? No relationship? GDP vs Sunflower Oil, US export price from Gulf of Mexico, US$ per metric ton. GDP vs Commodity Metals Price Index includes Copper, Aluminum, Iron Ore, Tin, Nickel, Zinc, Lead, and Uranium Price Indices GDP vs Commodity Beverage Price Index includes Coffee, Tea, and Cocoa Exercise 2. Multiple regression Use GDP as a dependent variable. And Sunflower, Commodity Metals, and Commodity Beverage as independent variables. Present the multiple regression. (yes, copy and paste the results here). What do you conclude? LINE 4 NGDPD World Gross domestic product, current prices U.S. dollars Billions 11,236.0711,496.4111,284.6511,586.7411,999.2712,528.4514,771.9117,008.44
19,125.1120,121.2422,612.4023,638.6425,317.1426,037.1327,989.3631,209.78
32,078.1231,993.0331,836.9032,965.2634,056.8533,804.7734,917.4839,211.89
44,137.0647,810.1251,778.0558,452.1464,160.7660,776.5966,487.9573,781.26
75,227.5077,387.3879,449.9674,968.4876,227.9581,050.9685,966.8387,283.60
84,894.9296,314.46100,218.40105,568.78110,763.88116,449.85122,425.78
128,505.33134,950.48
LINE 84 PSUNO World Sunflower Oil, US export price from Gulf of Mexico, US$ per metric tonne U.S. dollars Units 556.013561.653464.602490.531673.72584.951463.629450.078595.18606.198
603.572587.115562.181682.172723.53631.71560.392556.892665.228466.463
379.327436.109605.827649.997734.4071,144.54713.1116731,693.651,041.67
1,186.001,621.841,489.481,341.221,080.311,022.181,009.74953.032900.806
883.5111,056.511,718.911,934.161,448.221,448.221,448.221,448.221,448.22
1,448.22
LINE 121 PMETAW World Commodity Metals Price Index includes Copper, Aluminum, Iron Ore, Tin, Nickel, Zinc, Lead, and Uranium Price Indices Index, 2016=100 n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a 47.87940.45247.18457.51750.93950.90641.03541.3947.93241.79441.3348.383
67.23182.841130.095160.665144.284121.437185.838209.357172.098165.419
145.273105.604100122.189130.287135.32140.01205.413193.895200.702
195.432192.467191.564192.916193.775
LINE 101 PBEVEW World Commodity Beverage Price Index includes Coffee, Tea, and Cocoa Index, 2016=100114.29587.7689.49497.44111.17399.27116.18182.74180.94366.044
55.48551.51643.90549.07789.61892.99772.42287.70379.3862.5748.33138.61
45.19348.44149.49261.84869.17280.23897.72891.924105.901130.896106.789
92.292111.308103.04110096.20787.32682.36284.376103.313117.916111.442
108.962109.363109.363109.363109.363

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen

15th edition

77861612, 1259194078, 978-0077861612, 978-1259194078

More Books

Students also viewed these Finance questions

Question

What is an access control list?

Answered: 1 week ago

Question

Describe the six elements of communication.

Answered: 1 week ago