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\mathrm{.}0711,496\mathrm{.}4111,284\mathrm{.}6511,586\mathrm{.}7411,999\mathrm{.}2712,528\mathrm{.}4514,771\mathrm{.}9117,008\mathrm{.}4419,125\mathrm{.}1120,121\mathrm{.}2422,612\mathrm{.}4023,638\mathrm{.}6425,317\mathrm{.}1426,037\mathrm{.}1327,989\mathrm{.}3631,209\mathrm{.}7832,078\mathrm{.}1231,993\mathrm{.}0331,836\mathrm{.}9032,965\mathrm{.}2634,056\mathrm{.}8533,804\mathrm{.}7734,917\mathrm{.}4839,211\mathrm{.}8944,137\mathrm{.}0647,810\mathrm{.}1251,778\mathrm{.}0558,452\mathrm{.}1464,160\mathrm{.}7660,776\mathrm{.}5966,487\mathrm{.}9573,781\mathrm{.}2675,227\mathrm{.}5077,387\mathrm{.}3879,449\mathrm{.}9674,968\mathrm{.}4876,227\mathrm{.}9581,050\mathrm{.}9685,966\mathrm{.}8387,283\mathrm{.}6084,894\mathrm{.}9296,314\mathrm{.}46100,218\mathrm{.}40105,568\mathrm{.}78110,763\mathrm{.}88116,449\mathrm{.}85122,425\mathrm{.}78128,505\mathrm{.}33134,950\mathrm{.}48$

LINE $84$: PSUNO World Sunflower Oil, US export price from Gulf of Mexico, US$ per metric tonne U$.$S$.$ dollars Units $556\mathrm{.}013561\mathrm{.}653464\mathrm{.}602490\mathrm{.}531673\mathrm{.}72584\mathrm{.}951463\mathrm{.}629450\mathrm{.}078595\mathrm{.}18606\mathrm{.}198603\mathrm{.}572587\mathrm{.}115562\mathrm{.}181682\mathrm{.}172723\mathrm{.}53631\mathrm{.}71560\mathrm{.}392556\mathrm{.}892665\mathrm{.}228466\mathrm{.}463379\mathrm{.}327436\mathrm{.}109605\mathrm{.}827649\mathrm{.}997734\mathrm{.}4071,144\mathrm{.}54713\mathrm{.}1116731,693\mathrm{.}651,041\mathrm{.}671,186\mathrm{.}001,621\mathrm{.}841,489\mathrm{.}481,341\mathrm{.}221,080\mathrm{.}311,022\mathrm{.}181,009\mathrm{.}74953\mathrm{.}032900\mathrm{.}806883\mathrm{.}5111,056\mathrm{.}511,718\mathrm{.}911,934\mathrm{.}161,448\mathrm{.}221,448\mathrm{.}221,448\mathrm{.}221,448\mathrm{.}221,448\mathrm{.}221,448\mathrm{.}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\mathrm{.}87940\mathrm{.}45247\mathrm{.}18457\mathrm{.}51750\mathrm{.}93950\mathrm{.}90641\mathrm{.}03541\mathrm{.}3947\mathrm{.}93241\mathrm{.}79441\mathrm{.}3348\mathrm{.}38367\mathrm{.}23182\mathrm{.}841130\mathrm{.}095160\mathrm{.}665144\mathrm{.}284121\mathrm{.}437185\mathrm{.}838209\mathrm{.}357172\mathrm{.}098165\mathrm{.}419145\mathrm{.}273105\mathrm{.}604100122\mathrm{.}189130\mathrm{.}287135\mathrm{.}32140\mathrm{.}01205\mathrm{.}413193\mathrm{.}895200\mathrm{.}702195\mathrm{.}432192\mathrm{.}467191\mathrm{.}564192\mathrm{.}916193\mathrm{.}775$

LINE $101$: PBEVEW World Commodity Beverage Price Index includes Coffee, Tea, and Cocoa Index, $2016=100114\mathrm{.}29587\mathrm{.}7689\mathrm{.}49497\mathrm{.}44111\mathrm{.}17399\mathrm{.}27116\mathrm{.}18182\mathrm{.}74180\mathrm{.}94366\mathrm{.}04455\mathrm{.}48551\mathrm{.}51643\mathrm{.}90549\mathrm{.}07789\mathrm{.}61892\mathrm{.}99772\mathrm{.}42287\mathrm{.}70379\mathrm{.}3862\mathrm{.}5748\mathrm{.}33138\mathrm{.}6145\mathrm{.}19348\mathrm{.}44149\mathrm{.}49261\mathrm{.}84869\mathrm{.}17280\mathrm{.}23897\mathrm{.}72891\mathrm{.}924105\mathrm{.}901130\mathrm{.}896106\mathrm{.}78992\mathrm{.}292111\mathrm{.}308103\mathrm{.}04110096\mathrm{.}20787\mathrm{.}32682\mathrm{.}36284\mathrm{.}376103\mathrm{.}313117\mathrm{.}916111\mathrm{.}442108\mathrm{.}962109\mathrm{.}363109\mathrm{.}363109\mathrm{.}363109\mathrm{.}363$