Complete the following frequency table by hand and calculate the percentage of the total in each category:
Colour of Cardigan
Frequency
Percentage
Purple
18
Pink
8
Green
Total
67
100
Colour of Cardigan
Frequency
Percentage
Purple
18
26.87
Pink
8
11.94
Green
41
61.19
Total
67
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.