Question 1

*please help to use excel to show the working.

The table below shows the total number of car and motorbike accidents occurred for year 2017 to 2021 by gender. Is there statistical evidence at 95 confidence level that there are different in type of accident by gender in the last four years? (Hint: Use Chi Square test)

	Car	Motorbike	Grand Total
Female	5,301,000	4,726,200	10,027,200
Male	4,601,500	4,486,100	9,087,600
Grand Total	9,902,500	9,212,300	19,114,800