Here is the tables you will need to work with in excel but I need to jump on another computer to send all the information. Mine is messing up. okay • If working in groups, please clearly list all group members. • The work needs to be clear and well organized. Points will be deducted for work that is not clear or missing. • Clearly label each part of the project. 2 Liz has spent the summer interning as an assistant to the activities director at a beautiful resort. The resort property has two challenging 18 hole golf courses, numerous trails for horseback riding and hiking, and borders a large beautiful lake. The major resort activities include horseback riding, kayaking, canoeing, sailing, tubing, boating, jet skiing, water skiing, fishing, golfing, archery, and tennis. There has been some talk lately about paring down the number of resort activities. Joan, the activities director, is wondering if there are too many activities for the guests. Perhaps, the resort should only concentrate on a few activities such as golf and leave other activities such as kayaking and horseback riding to local companies specializing in outdoor interests. Joan is concerned that guests are inundated with too many choices and feel as if they must try everything in order to get their money’s worth. In addition, the director is concerned about the costs of maintaining and the difficulty of scheduling all the different resort activities for the guests. Liz has enjoyed her summer internship, especially working for Joan. She has gained some valuable work experience and would love to one day work as a manager at the resort once she finishes her undergraduate business degree. As her internship winds down, Liz wonders how she might be able to help Joan in her decision making regarding the resort activities. In addition, Liz decides to conduct a short survey for departing guests concerning their resort activities experience. Liz includes the following questions in her survey: 1) What was your first favorite activity? 3 2) What was your second favorite activity? 3) How many resort activities did you try during your stay? 4) On a scale from 1 to 5 (where 5 is the highest, 1 is the lowest), please rate the overall quality of the resort activities. 5) Do you plan on returning to the resort in the future? Liz decides to spend the final week of her summer internship organizing and analyzing all this collected data. Before departing she will provide Joan with a report of her findings and analysis. Liz is hoping that the report will be helpful to Joan as she makes decisions concerning future activities at the resort. Liz plans on including tables, graphs, numerical measures, observations, and recommendations in the report. Project Requirements The following needs to be included in one’s report: 1) Create frequency and relative frequency distributions for the first and second favorite guest activities. One will find this data in the Table 2 worksheet of the Excel file. • The frequency a
nd relative frequency distributions for the second favorite activity are worth 5 points. • Rubric for the distributions: 4 2) Create bar graphs that show the frequencies for the first and second favorite resort activities. The bar graphs should include titles for the horizontal axis and vertical axis and data labels. One will find this data in the Table 2 worksheet of the Excel file. • Rubric for each bar graph: 3) Create a pie chart that shows the percentages of the survey responses for the question “Do you plan on returning to the resort in the future?” One will find the responses in the Table 2 worksheet of the Excel file. Note, there are three possible answers: Yes, No, and Maybe. Be sure to note the categories and percentages on the pie chart and include a legend. 4) Create a histogram for the number of resort activities tried by the guests. This data can be found in the Table 2 worksheet of the Excel file. Use the following classes for the histogram. 1 to 2 3 to 4 5 to 6 7 to 8 9 to 10 11 to 12 5 5) Create a table that shows the different resort activity ratings and the number of guests that selected each of these ratings. Then calculate the weighted mean (average) of the ratings. The data can be found in the Table 2 worksheet of the Excel file. 6) Calculate the following numerical measures: mean, median, sample variance, sample standard deviation, range, and coefficient of variation for each resort activity. The data (time spent each week on a resort activity) can be found in the Table 1 worksheet of the Excel file. In a table list each activity and the numerical measures (e.g. mean, median) calculated for each activity. 7) Create a scatter diagram to see if there is a relationship between the number of resort activities available and the number of resort guests. The data can be found in the Table 3 worksheet of the Excel file. 6 8) Calculate the sample covariance and sample correlation coefficient to see whether there is a relationship between the number of resort activities available and the number of resort guests. The data can be found in the Table 3 worksheet of the Excel file. At least the following needs to be included in your write-up. Be sure your statements refer to your graphs, tables, and calculations. 1) Discuss what are the most popular and least popular resort activities. 2) Discuss the number of resort activities tried by the guests. 3) Discuss the resort activity ratings. 4) Discuss whether guests will return. 5) Discuss whether there is a relationship between the number of resort activities available and the number of resort guests based on your scatter diagram and covariance and correlation calculation results. 6) What recommendations would you make to Joan, the activities director, regarding future resort activities? You may also include other observations and recommendations based on the results of your tables, graphs, and numerical measures. 7 SHOW ALL WORK!!