Complete the following frequency table by hand and calculate the percentage of the total in each category:
Colour of Shirt
Frequency
Percentage
Blue
35
Orange
43
Turquoise
Total
83
100
Colour of Shirt
Frequency
Percentage
Blue
35
42.17
Orange
43
51.81
Turquoise
5
6.02
Total
83
100
Excel Task
Enter the frequency table above into Excel and produce a pie chart [with title] of the data using the inbuilt functions. Your tutor will check that you have done this.