Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!