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.
Tis is the instructions for it.
• This project may be turned in via Oncourse Assignments or at my office (Hayes 255-R). If I am not there, place it under the door.
• Students can work individually or in groups. The maximum group size allowed is three (3).
• Students are to maintain academic honesty and professionalism while working on this project. If you elect to work on this project by yourself, then the work must be your own. If you elect to work on this project in a group then you can only work with your group members. There is to be no sharing of work among other groups or people outside of your group. Any use of someone else’s work outside of your group or another individual’s work will result in a zero for the project and possible other academic ramifications. If you have any questions regarding this please let me know.
• If working in groups, each group member must contribute to the project.
• If working in groups, please turn in only one (1) completed project file.
• 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.
• Note, you can use Excel, Word, or do the project by paper and pencil / pen. Work done by paper and pencil/pen can then be scanned if you are submitting the project via Oncourse Assignments. I will also take paper copies at my office.
• All the data for the project can be found in the Excel file: Project1_Data. There are three worksheets in this Excel file. See the case below for information regarding the data.
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.
By nature Liz is a numbers person. She enjoys collecting and analyzing data. Out of curiosity, Liz has been keeping track of the time spent (each week) on the major resort activities for the past ten weeks. Table 1 (see Excel file) shows the amount of time (in hours) spent each week by guests on a particular resort activity. For example, in Week 3 the total time spent by guests on tennis and kayaking was 46.2 hours and 61.1 respectively. The time spent per week is higher for golf since one typical round of golf usually takes four to five hours and resort guests usually play a few rounds per week. Liz decides to spend some time analyzing this collected data.
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 ends up surveying 80 departing guests. Table 2 (see Excel file) contains the responses for the 80 guests who took her survey. For example, Guest 6 indicated that fishing and horseback riding were the guest’s first and second favorite resort activities. Guest 6 tried eight activities during his/her stay, gave the resort a 5 for overall activity quality, and does plan on returning to the resort in the future.
Finally, Liz is curious to see if there is a relationship between the number of activities available and the number of guests coming to the resort each year. She does some digging and is able to retrieve the number of major activities available and the number of guests coming to the resort for the years 2004 to 2011. The resort opened to guests in May 2001. Table 3 (see Excel file) shows the number of major resort activities available and the number of guests that stayed at the resort for the years 2004 to 2011. For example, in 2009 there were 1000 resort guests and nine major activities available.
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.
• Total points possible for this section: 10 points
• The frequency and relative frequency distributions for the first favorite activity are worth 5 points.
• The frequency and relative frequency distributions for the second favorite activity are worth 5 points.
• Rubric for the distributions:
o 4 to 5 points: Done correctly or there is a minor error
4
o 2 to 3 points: Has made a decent attempt; however, there are errors.
o 0 to 1 points: Has not attempted or has not made a decent attempt.
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.
• Total points possible for this section: 10 points
• Each bar graph is worth 5 points.
• Rubric for each bar graph:
o 4 to 5 points: Done correctly or there is a minor error. Titles for the vertical axis and horizontal axis and labels showing the data values are present in the bar graphs. The bar graph has gaps between categories.
o 2 to 3 points: Has made a decent attempt; however, there are errors. Missing titles and/or labels. No gaps between categories.
o 0 to 1 points: Has not attempted or has not made a decent attempt.
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.
• Total points possible for this section: 5 points
• Rubric:
o 4 to 5 points: Done correctly or there is a minor error. Pie chart has labels showing the categories and percentages and a legend.
o 2 to 3 points: Has made a decent attempt; however, there are errors. Missing categories, percentages, and/or legend.
o 0 to 1 points: Has not attempted or has not made a decent attempt.
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
• Total points possible for this section: 5 points
• Rubric:
o 4 to 5 points: Done correctly or there is a minor error. The histogram has titles for the vertical axis and horizontal axis and labels showing the data values. Histogram contains no gaps.
o 2 to 3 points: Has made a decent attempt; however, there are errors. Missing titles and/or labels. Histogram has gaps.
o 0 to 1 points: Has not attempted or has not made a decent attempt.
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.
• Total points possible for this section: 7 points
• Rubric: o 6 to 7 points: Done correctly or there is a minor error
o 3 to 5 points: Has made a decent attempt; however, there are errors or missing some information.
o 0 to 2 points: Has not attempted or has not made a decent attempt.
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.
• Total points possible for this section: 12 points
• Rubric: o 9 to 12 points: Done correctly or there are a few minor errors.
o 5 to 8 points: Has made a decent attempt; however, there are errors or missing some information.
o 0 to 4 points: Has not attempted or has not made a decent attempt. Many errors.
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.
• Total points possible for this section: 5 points
6
• Rubric:
o 4 to 5 points: Done correctly or there is a minor error. The scatter diagram includes titles for the vertical axis and horizontal axis.
o 2 to 3 points: Has made a decent attempt; however, there are errors.
o 0 to 1 points: Has not attempted or has not made a decent attempt.
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.
• Total points possible for this section: 6 points
• Rubric: o 5 to 6 points: Done correctly or there is a minor error
o 3 to 4 points: Has made a decent attempt; however, there are some errors.
o0 to 2 points: Has not attempted or has not made a decent attempt. There are errors.
9) Finally, your report needs to include a write-up that notes observations and recommendations. These observations and recommendations should be based on and reference your tables, graphs, and calculations. The write-up should be a minimum of three paragraphs (each paragraph should include at least three complete sentences) and refer to your tables, graphs, and calculations. Use correct grammar and spelling in your write-up.
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
• Total points possible for this section: 15 points
• Rubric: o 12 to 15 points: The write-up is well written (few or no grammar and spelling issues), is at least three paragraphs in length, and addresses most or all the requirements listed above. Your statements are correct and are backed up by references to the tables, graphs, and calculations. Minor mistakes.
o 7 to 11 points: A decent attempt at the write-up. However, there may be some grammar, spelling, and/or length issues. Also, it is possible that not all points are addressed in the report or one’s statements are not backed up by references to the tables, graphs, and calculations.
o 0 to 6 points: Has not attempted or has not made a decent attempt at the write-up. There are serious grammar, spelling, and/or length issues. The write-up does not include all the requirements and / or does not sufficiently reference the tables, graphs, and calculations.
SHOW ALL WORK!!
, -2 – 
, -2 – 
, ± 
, ± 
, ± 1, ± 2, ± 4, ± 8
– x2+ 3