2. Descriptive statistics for qualitative data Guests staying at Marada Inn were asked to rate the quality of their accommodations as being excellent, above average, average, below average, or poor. The ratings provided by a sample of 20 quests are shown below. Below Average Average Above Average Above Average Above Average Above Average Above Average Below Average Below Average Average Poor Poor Above Average Average Above Average Average Excellent Above Average Average Above Average Use excel to a. Provide a frequency distribution showing the number of occurrences of each rating level in the sample. b. Construct relative frequency and percent frequency distributions for the data. c. Display the frequencies graphically with a bar