Lab 2

profileFancy
Lab2ExcelFile.csv

,,,2010,2019,Percent Change Formula,Percent Change Simple assault,,,,,(New Value-Original Value/Original Value) X 100 ,(Round 2 Decimal Places) ,Never married,,1688802,1890741,(1890741-1688802/1688802) X 100,11.96 ,,Male,956257,963077,(963077-956257/956257) X 100,0.71 ,,Female,732545,927664,(927664-732545/732545) X 100,26.64 ,Married,,710250,1112084,, ,,Male,438937,624949,, ,,Female,271313,487136,, ,Widowed,,53149,87555,, ,,Male,5235,30535,, ,,Female,47914,57020,, ,Divorced,,572276,483285,, ,,Male,248979,179460,, ,,Female,323297,303825,, ,Separated,,206645,221752,, ,,Male,52873,36868,, ,,Female,153771,184884,, Total Simple Assault,,,3241148,3800193,, ,,,,,, "Please complete the percent change from 2010-2019 for each of the groups (married, widowed, divorced, separated and total simple assaults); Please calculate percent change of simple assaults for both males and females in their respective marital status groups. ",,,,,,