Question: Read data files, the data.csv data containing the annual potato production in cities in Turkey between 2004 and 2019. The TUIK_nufus_2019.csv data containing the population

Read data files, the data.csv data containing the annual potato production in cities in Turkey between 2004 and 2019. The TUIK_nufus_2019.csv data containing the population of Turkey between 2007 and 2019 Write R program that will read data produce a plot to show the changes on total annual potato production in Turkey between 2004 and 2019. perform a linear regression with total annual potato production. report the information about the fit such as residuals, coefficients etc. predict the total annual potato production for years 2021, 2022 and 2023. use regression analysis to identify the relationship between annual potato production in Turkey and the population between 2007 and 2019.

data.csv =

year,Adana-1,Adiyaman-2,Afyonkarahisar-3,Aksaray-68,Amasya-5,Ankara-6,Antalya-7,Ardahan-75,Artvin-8,Aydin-9,Agri-4,Balikesir-10,Bartin-74,Bayburt-69,Bilecik-11,Bingol-12,Bitlis-13,Bolu-14,Burdur-15,Bursa-16,Denizli-20,Diyarbakir-21,Duzce-81,Edirne-22,Elazig-23,Erzincan-24,Erzurum-25,Eskisehir-26,Gaziantep-27,Giresun-28,Gumushane-29,Hakkari-30,Hatay-31,isparta-32,igdir-76,Kahramanmaras-46,Karabuk-78,Karaman-70,Kars-36,Kastamonu-37,Kayseri-38,Kocaeli-41,Konya-42,Kutahya-43,Kirklareli-39,Kirikkale-71,Kirsehir-40,Malatya-44,Manisa-45,Mardin-47,Mersin-33,Mugla-48,Mus-49,Nevsehir-50,Nigde-51,Ordu-52,Osmaniye-80,Rize-53,Sakarya-54,Samsun-55,Sinop-57,Sivas-58,Tekirdag-59,Tokat-60,Trabzon-61,Tunceli-62,Usak-64,Van-65,Yozgat-66,Zonguldak-67,Canakkale-17,Cankiri-18,Corum-19,istanbul-34,?zmir-35,Sanl?urfa-63
2004,77753,195,332439,130087,46231,21069,49223,5287,20003,9460,10410,30803,7950,11676,1706,3836,39090,283283,10263,67284,750,200,9217,3653,1955,10830,102425,17980,,17827,55837,3182,14657,13163,3804,15284,5970,43086,38295,38597,84096,2448,134416,38787,14375,415,21976,4068,19731,901,5111,53718,220,977999,929256,99318,1121,1925,22957,55572,17051,51769,4548,49931,142335,44,717,45498,34387,4630,875,39139,29524,551,325831,
2005,80015,,364140,117388,41915,4080,45240,5640,32172,9496,11105,27490,8630,13524,1895,4150,41358,279350,6520,62330,351,350,2800,3150,1969,5062,94175,16872,,15246,53430,2870,11625,17438,1600,14090,4163,78237,38250,38243,154916,2325,145575,36024,10440,120,111250,2202,18285,855,7050,56549,195,385410,712865,56638,1500,2569,21209,55423,14960,42529,5070,50460,140525,228,790,43999,33550,3755,1820,38830,29040,350,316335,
2006,83385,150,400298,120288,18835,3730,39825,5280,29170,7163,5580,21480,7945,15255,1405,2256,45418,284837,8985,65890,980,150,3540,2025,1710,3130,99553,38535,3195,15521,55615,24288,22230,15080,1800,11720,3863,86358,38250,38196,161822,1233,151263,34192,10475,110,118250,1973,25720,,7863,56917,188,563800,751360,41933,1500,1361,17680,50406,5435,66661,6980,57075,142411,139,1029,44155,30322,1037,1020,34502,29325,275,312929,1925
2007,140410,335,369268,145660,18482,850,48510,676,22467,3752,983,25567,6780,16020,1091,11664,63095,285976,10550,43510,756,,3723,1638,1606,2030,76687,45439,600,17315,46935,2075,19780,21227,1000,15890,2855,81661,44999,44276,208689,1323,153516,21490,10131,85,42890,1611,17075,100,7775,28862,601,466750,793401,51516,2020,237,22412,51405,4325,118466,4983,49956,125154,58,1380,37511,15730,362,922,27421,23996,150,287360,1925
2008,146610,727,359223,152040,20085,785,55190,906,22280,4784,1059,12425,4825,16158,1085,11621,63428,278776,11635,43337,827,,3716,1638,2096,2675,61205,48385,1950,17494,45048,1683,28338,16705,1125,18630,2450,81192,47453,58762,186000,1264,222075,22373,8122,76,46850,1581,11391,95,8310,19925,644,444850,722482,43750,2000,223,27500,52288,4413,113270,4163,51490,124065,59,4784,36463,46435,325,816,25758,26066,240,288025,
2009,136295,35,342459,194208,9351,1263,34115,1103,10487,6139,2230,11797,5895,12255,947,6119,65778,310542,8752,39876,965,,3329,1396,1550,2425,55596,40584,1275,17719,43077,1557,24220,14611,1500,17990,2838,80089,83800,49916,181298,1386,315825,22871,8635,48,65470,1586,9882,120,8327,16162,1350,430650,716849,30081,1800,114,6305,49937,3709,180152,4100,67471,129286,55,5884,8301,39550,369,290,11880,25863,150,407247,625
2010,154330,1073,409098,246184,11783,3063,33388,328,12662,7324,2991,9257,5205,21825,841,6095,76329,353319,10188,38464,965,,1284,1308,1411,2556,65527,57033,2191,14376,41205,901,40540,13596,2100,12420,2679,11388,18686,22641,172783,1216,321482,28448,9653,,68264,1643,12752,,9097,17178,1380,404119,728564,28191,150,69,4914,46980,536,149548,8170,73075,129290,50,6563,4381,39138,340,66,11850,24703,150,489406,2750
2011,220256,1264,422771,206134,16214,3636,35355,571,10977,4490,2250,10234,5286,22038,819,5715,134435,334723,9580,38459,575,,932,1085,1009,7222,85640,76488,2275,13187,41893,940,40405,12639,1800,13470,2655,12453,5275,16696,222038,931,370388,31652,6891,,90990,1051,12197,,8497,13310,2588,321302,731270,21451,165,52,5982,44447,541,160128,10250,79916,108009,,8786,4293,20888,248,52,6659,28225,150,476603,1275
2012,200417,1944,433460,209306,12235,2971,37010,561,10907,6087,1680,10984,5211,17983,845,3946,79964,273604,8202,42329,799,,853,958,1058,6179,65942,91136,2374,14786,40458,887,32180,12661,2202,13867,2430,24822,6405,18024,281896,592,460154,30120,5446,,72448,1024,12433,,6864,16085,2260,323200,801468,26787,826,62,6086,44085,,162922,6521,77264,109630,,7328,5373,28176,262,39,6440,29373,120,570671,1500
2013,179775,2626,306377,173756,11018,2340,44509,324,13736,4805,1836,7946,4268,20467,696,982,165407,247093,8137,38530,601,,951,717,1433,3814,84792,81238,4313,14560,42066,633,44362,10504,1474,15050,1282,33400,6430,18493,299346,452,420755,22091,3745,80,12123,924,12783,,7466,18270,1922,177620,512644,28263,904,35,7797,39701,,133598,423,68387,51870,,9685,8155,28120,270,6,6259,30668,120,441279,1498
2014,206120,3050,301579,239728,9097,3537,43767,477,18099,4635,1934,7367,4126,11553,491,1132,132504,280735,8410,36467,557,,976,757,1307,3744,83490,49065,3150,14163,28337,441,51802,10620,1895,14489,1099,28182,1918,19660,285770,409,509188,21713,2732,,6688,928,11873,,7402,25213,1854,218952,618853,26929,,97,7588,29391,,171663,460,69815,47012,,8462,4006,27752,282,,6354,31189,120,391347,1498
2015,219221,2854,434929,242302,18405,5803,26181,618,15098,6238,1416,6475,3170,23457,427,1192,212490,249603,6605,35005,1322,,975,1076,1326,3450,78516,45228,4485,13801,46387,491,70231,10258,1386,14356,1048,28857,152010,19558,287835,255,493748,11889,2317,,4503,2879,11881,,7123,27074,1892,301039,674773,25753,,94,5487,24918,,263167,801,70764,38689,,11501,6602,25476,195,,5782,37734,116,407745,1718
2016,221397,1953,476900,210959,18105,8012,14887,2747,16941,6715,765,5431,2986,28564,373,756,163992,226919,6453,30936,657,,844,751,1180,4135,72173,49492,3350,11820,43862,430,109961,8861,1350,18595,265,28027,1629,21569,305470,226,549802,28664,2021,3,3136,9838,10964,,6572,29961,1485,255773,892297,23180,,52,4729,17488,,202524,899,67902,46487,,12165,6652,29613,263,,4806,41821,115,367706,2644
2017,241196,1845,473016,207810,25640,18595,11964,5127,16656,13446,1099,5579,2833,5772,281,635,154696,164778,5460,32034,643,,880,670,1366,3053,75708,86542,3293,11468,43583,488,148858,7684,812,24874,241,31067,941,20660,351270,214,567076,29810,1729,4,5312,7652,11819,,10580,36598,1282,249626,835200,25700,,53,3599,18043,,182149,683,72542,44395,,13291,7317,27600,281,,4075,41675,123,396130,2879
2018,219076,1804,455352,202371,26892,11755,14201,278,16811,10008,813,3112,2847,12268,268,652,150043,150327,5322,33165,116,,421,656,1088,3941,85729,59845,3877,10318,41686,410,71145,7575,635,38193,156,32187,1282,17354,385913,191,611957,25871,1360,4,3071,4359,7280,19990,10882,33277,1236,269620,732188,24110,,49,3340,15734,,169737,676,61385,50893,,11728,5929,26904,288,,4092,40784,122,330143,2908

2019,251408,2185,532410,239650,36679,19155,19743,312,17056,11186,572,2300,3017,17583,178,556,190511,133681,4491,34989,116,,374,617,1196,4479,88725,79119,6000,11781,38302,147,69230,7851,827,43235,207,54082,1833,20057,451798,187,599699,25676,1532,4,8627,4440,8893,16425,12212,27889,4349,321301,716180,22099,,56,3097,14280,,180756,720,53855,50317,,11372,5706,28717,308,,5012,55555,141,390481,12300

TUIK_nufus_2019.csv =

year,Man in Village,Man in City,Woman in Village,Woman in City,Total
2007,10447548,24928985,10390849,24818874,70586256
2008,8954348,26946806,8951029,26664917,71517100
2009,8872983,27589487,8881110,27217732,72561312
2010,8734326,28308856,8766306,27913500,73722988
2011,8679379,28853575,8659184,28532131,74724269
2012,8607938,29348230,8571015,29100201,75627384
2013,3337565,35135795,3295886,34898618,76667864
2014,3228312,35755990,3181410,35530192,77695904
2015,3134796,36376395,3083123,36146739,78741053
2016,3107640,36936010,3035483,36735738,79814871
2017,3064942,37470193,2984451,37290939,80810525
2018,3227657,37912323,3109728,37754174,82003882
2019,3060531,38660605,2943186,38490675,83154997

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 Databases Questions!