i figured it out

A B D E F G I | J K Warning: Please do not change the layout on the left side till column D. You can use the right side (from column E) to type in data needed for the table or graphs. Please only put your work in the yellow areas. Your instructor will only grade your work in the yellow areas. Rating Name Excellent Excellent Many airlines use surveys to collect data on customer satisfaction related Very Good to flight experiences. Assume that passengers on a Delta Airlines flight Good from Myrtle Beach, South Carolina to Atlanta, Georgia provided their rating for the question "Please rate the airline based on your overall Excellent experience with this flight." a five-point scale, with Excellent (E), Very Excellent good (V), Good (G), Fair (F), and Poor (P) issued to record customer Good ratings. Very Good The sample ratings are shown in cells A2:A 51 Excellent Directions: Use the data to complete the 9 tasks. Excellent Good 1) What type is the variable "Rating"? Very Good 2) How many elements are the data collected for? Very Good 3) How many observatios in the data? Very Good 4) is the data a sample or a population? Very Good 5) How many categories are for "Rating" Very Good 6) Summarize the data into a frequency distribution. Excellent Enter a title for the table here Fair Excellent Rating Frequency Relative Frequency Very Good Very Good Excellent Very Good Very Good Excellent Total Excellent Very Good 39 40 41 42 43 44 45 46 4 Excellent 7) Insert a bar chart to visualize this data set Excellent Please add appropriate titles for the chart, the x axis and the y axis. Poor The total row should not be in the chart. Very Good Points will be deducted if the above mentioned were not done. Excellent Insert your chart here you can size your chart to fit in this area) Very Good Very Good Excellent Very Good Excellent Excellent Very Good Very Good Very Good Excellent Good Very Good Poor Excellent Very Good Excellent 8) Construct a pie chart Very Good Add an appropriate tile for the chart. Very Good 4 50 51 53 54 9) What do the table and the charts show about the customer satisfaction? Use a couple of sentence to brief answer the question. RE End of assignment A B D E F G I | J K Warning: Please do not change the layout on the left side till column D. You can use the right side (from column E) to type in data needed for the table or graphs. Please only put your work in the yellow areas. Your instructor will only grade your work in the yellow areas. Rating Name Excellent Excellent Many airlines use surveys to collect data on customer satisfaction related Very Good to flight experiences. Assume that passengers on a Delta Airlines flight Good from Myrtle Beach, South Carolina to Atlanta, Georgia provided their rating for the question "Please rate the airline based on your overall Excellent experience with this flight." a five-point scale, with Excellent (E), Very Excellent good (V), Good (G), Fair (F), and Poor (P) issued to record customer Good ratings. Very Good The sample ratings are shown in cells A2:A 51 Excellent Directions: Use the data to complete the 9 tasks. Excellent Good 1) What type is the variable "Rating"? Very Good 2) How many elements are the data collected for? Very Good 3) How many observatios in the data? Very Good 4) is the data a sample or a population? Very Good 5) How many categories are for "Rating" Very Good 6) Summarize the data into a frequency distribution. Excellent Enter a title for the table here Fair Excellent Rating Frequency Relative Frequency Very Good Very Good Excellent Very Good Very Good Excellent Total Excellent Very Good 39 40 41 42 43 44 45 46 4 Excellent 7) Insert a bar chart to visualize this data set Excellent Please add appropriate titles for the chart, the x axis and the y axis. Poor The total row should not be in the chart. Very Good Points will be deducted if the above mentioned were not done. Excellent Insert your chart here you can size your chart to fit in this area) Very Good Very Good Excellent Very Good Excellent Excellent Very Good Very Good Very Good Excellent Good Very Good Poor Excellent Very Good Excellent 8) Construct a pie chart Very Good Add an appropriate tile for the chart. Very Good 4 50 51 53 54 9) What do the table and the charts show about the customer satisfaction? Use a couple of sentence to brief answer the question. RE End of assignment