QUESTION $2$Suppose you are given the following sample of STA$1506$ students.Spreadsheet $2$: Sample of STA$1506$ student performance.File Home Insert Draw Page Layout Formulas Data Review ViewAptos Narrow $11$Past$1$ NameClipboard$2$ TshepoA$3$ Gerald$4$ Nancy$111213$BI U A A$5$ Pertunia van der MeFCSurname GenderMualusi MSmith$8$ Grace Baloyi FNyikolawance Nkomo$10$ Michelle LizardXV NameLombard F$($e$)()$NgobeniMADMarksERace$91\%$ B$789\%$ W$108\%==$W$59\%$ E$88\%$ Erace.Alignment$44\%$ WGeneralMmheumbeon the graph.G$\%9$HAutomate Help Acrobat SAS Analytic SolverConditional FormattingFormat as TableCel StylesStylesKInsertDeleteFormatCellsEditingensitvy Add$-$insSensitivitydd$-$in:P$($a$)$ Which graphical display would you use to display the variables Gender and Race of theentire sample? Explain why you would use this graphical display.PCommentsAdobe Acrobat$($b$)$ Display variable Gender using the answer in question $2($a$).$ Use the appropriate labelsShare$(4)($c$)$ Suppose you are told that there was an omission of three students in the sample. Thedata editor asks you to add Percy Chukwu, an African female who obtained $50\%.$ Theentry is to be added between Pertunia and Allowance in the database. Add theinformation as instructed by the editor to the sample and explain how you added PercyChukwu who currently resides in Madagascar but Percy is Nigerian by nationality. $(3)($d$)$ Now add Excellent Naidoo. Excellent isa Male, who obtained $81\%$ and he is Indian by$(6)$race$.$ Add Candice Mooiloop, a Female, who obtained $66\%$ from a coloured race, asstudent number $8.$ Display the updated STA$1506$ sample following the instructionsgiven in questions $2($c$)$ to $($d$)$ by highlighting the new information.$(6)$Sort the sample byy surname in ascending order and explain or write down each step onhow you sorted the sample in ascending order. Clearly show the display of the currentsample spreadsheet after sampling.$(6)$After communicating with the assignment department, the editor was updated about thecorrupt files of Petunia van der Merve $($whom the name was spelled incorrectly asPertunia$)$ and Feng Hu $($whom her identity was incorrectly placed as Hu instead of FengHu$)$ with race Other. The assignment department also updated that these students eachobtained $38\%$ and $71\%$ in general. Another update says that Grace Baloyi is black inFurthermore, display the final sample of the STA$1506$ students after updatingthe given information arranged in ascending order by variable Surname. Moreover, usea pie chart to display the information related to variable Race. Lastly, between a barchart and a pie chart, which one looks more appropriate to display variable Raceinformation? Motivate your answer.$(14)($g$)$ Name the procedure used to solve problems posted in questions $($c$)$ to $($f$)$ under theinstruction of the editor.$(2)$