QRB/501 - Week 4 individual assignment

7) Canmark research center use an online survey rate customer satisfaction. The sample rating are shown below. There are 59 responses and the answers are as follow: 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. I need help in using the data to make a pivot chart.

(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 construct a pie chart ( or a pivot pie chart)

.

(4) interpret information from the charts and the frequency distribution.

I don't know if you are helping me with my assignment , you do not have a white board that I can work along with you, What's the point of you been asked to assist, it makes no sense. I purchased this course because I need help . You are not helping me ,and may be I will ask for a refund