Q29 The ages of 28 applicants for a graduate management traineepost are: 21 23 21 21 23 21 24 22 21 24 21 26 23 22 21 22 23 21 2221 22 25 21 22 21 22 21 24 (a) Produce a frequency distribution forthese figures. (b) Plot a bar chart to represent the frequencydistribution. [4 Marks]
PLEASE DO NOT WRITE THE ANSWER. PROVIDE THE ANSWER IN WORDFORMAT WITHOUT PLAGIARISM
Expert Answer
a) Frequency Distribution for the Above Figures using MSExcel with Formula Mentioned
1BCDEFG2ApplicantsAgeAgeFrequencyFrequency_131212112124223227195321234236421243267523251278621261289724Formula written below10822AgeFrequencyFrequency_11192121=G12=FREQUENCY(C12:C39,21)12102422=G13-G12=FREQUENCY(C12:C39,22)13112123=G14-G13=FREQUENCY(C12:C39,23)14122624=G15-G14=FREQUENCY(C12:C39,24)15132325=G16-G15=FREQUENCY(C12:C39,25)16142226=G17-G16=FREQUENCY(C12:C39,26)171521181622191723201821211922222021232122242225252321262422272521282622292721302824
b) Frequency Distribution Chart or Pareto chart for theAbove data of Age with calculated Frequency
Using MiniTab 2017,
PayPal Gateway not configured
PayPal Gateway not configured