Lab2ExcelFile.csv

,,,2010,2019,Percent Change Formula,Percent ChangeSimple 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. “,,,,,,