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
Get step-by-step solutions from verified subject matter experts
