Prov Pop2013 Physic2013 popu2017 phys2017 0 NB 755700 1729 QB 8151300 19501 ON 13555800 28965 MB 1265600 2546 14193400 29898 1338100 2861 4286100 9910 4817200 11612 In this question, you will use information from Canada Medical Association (CMA) to analyze Physician Population ratio across all Canadian provinces from year 2013 to 2017, In year 2013 CMA planned to im- prove this ratio by 5% in every province during next five years. You can find a tabular file a602 trt in Starter folder on Moodle, with all the information that you require for this question. Ithas 5 columns the provincos abbreviated name, its population in year 2013, the number of physicians each province has in 2013, its pop BC 4590100 10528 ulation in year 201 and the nurmber of physicians each province has in 2017 (a) Begin by opening and reading the file a6q2.txt into Python. (b) To assist with analysis, you will need lhe dala slored inarrays Creale five arrays thalt hold the following information: the prowincestrings, the populations in 2013, number of physicians in 2013, the population in 2017 and the number of physicias in 2017 The arrays should mainlain the ordering of the file, so that tho data for NL is first, followed by "PE and so forth Tost this bofono you movo on (c) CalculateIhe population per physician for 2013 and 2017 bolh. This is easily done wilh a umpy array calculation. All thosc valucs will be floot valucs at this point, but we nood intoger valucs to represent this physician-population ratio. Convert thesevaluos to intcgers by using the mcthod uup.around) It will rotum tho float roundlocl to tho noarest intogor. l) Calculato tho rate of improvoment in physician population ratio in oach provinco from 2013 to 2017 lint Formula to find rato of improvemont is: old valuo now valuovold vluc) . 100] (c) Wewillnow usc logical inclexing to analysc ourfindings. Uscalational cxprossion to croateabooloan array. Whcro Truc indicatos that to physician population ration has boon increased by at lcast 5% and ) Also croato a booloan array that chocks if the rate of improv*mont in physician population ration is qual to or lenss than /ero for ..ch province. Your results should indicate, that all of the, provinces g) Finally we need to report our findings by printing the inforrnation to the console. I es lay the ratios for both year as well as the rate of improvement as shown below Hore is an oxample cxocution of the roquirod program. The formatting of your programs output should bo 404 in 2013 and 353 in 2017 In NL population per physician was Based on these ratio, the rate of improvement is 12.74% In PE population por physician was 559 in 2013 and 524 in 2017 Based on these ratio, the rate of improvement is 6.24% In NS population per physician was 384 in 2013 and 379 in 2017 Based on those ratio, the rate of improvement is 1.27% In NB population per physician was 437 in 2013 and 430 in 2017 Based on these ratio, the rate of improvement is 1.50% in GE population por physician was 418 in 2013 and 414 in 2017 Based on these ratio, the rate of improvement is 0.85% In ON population per physician was 488 in 2013 and 475 in 2017 Based on these ratio, the rate of improvement is -1.44% In MB population per physician was 497 in 2013 and 468 in 2017 Based on these ratio, the rate of improvement is 5.89% In sk population per physician was 528 in 2013 and 488 in 2017 Based on these ratio, the rate of improvement is 765% In AB population per physician was 437 in 2013 and 433 in 2017 Based on these ratio, the rate of improvement is 1.03%