Complete the following frequency table by hand and calculate the percentage of the total in each category:
Colour of Skirt
Frequency
Percentage
Orange
14
Pink
24
White
Total
80
100
Colour of Skirt
Frequency
Percentage
Orange
14
17.50
Pink
24
30.00
White
42
52.50
Total
80
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.