QRB/501 – Week 4 individual assignment

7) Canmark research center use an online survey rate customer satisfaction.the sample rating are shown below.1. excellent, 2. excellent, 3. very good, 4 good, , 5 excellent, 6, excellent, 7, good, 8, very good, 9. excellent, 10,.excellent ,11. good, 12. very good.13 good, 14.very good, 15. very good, 16, very good,, 17. excellent,18. fair, excellent,20.very good, 21. very good, 22.excellent, 23. very good,24.very good, 25. excellent, 26. excellent, 27.very good,28. excellent. 29.excellent. 30.very good,excellent, 32. very good, 33. very good, 34.excellent, 35. excellent, 36.very good, 37. excellent,38. excellent, 39. poor, 40. very good, 41. excellent, 42. very good,43. very good. 44.excellent,45. very good, 46. excellent, 47. excellent, 48.very good, 49.very good, 50. very good, 51. excellent, 52, good, 53. very good, 54. poor,55/ excellent,56.

very good, 57.excellent,58. very good, 59.very good. (1) using the pivot table feature in Microsoft.excel and create frequency distribution with two columns-rating and frequency.(2)Use excel to prepare bar chart (or a pivot bar chart ).(3)use excel to prepare a pie chart ( or a pivot pie chart).(4) interpret information from the charts and the frequency distribution.