The new data spreadsheet should be as below $($whereby you need to provide the data for the four new columns$).$

i$.$ Determine the min, max, mode and mean for Final, Courseworks and Total. What can you conclude?

Based on these statistics, we can conclude that the students generally performed better in the Courseworks and Total compared to the Final.

ii$.$ Create a pivot table and histogram of the students' status and gender. Provide a brief description.

iii. Create a pivot table and histogram of the students' weekly SLT and gender. Provide a brief description.

iv$.$ Create a pivot table of the students' weekly SLT and status. What can you conclude from this pivot table?