Interpret the measures of central tendency and variability. What are three conclusions you can draw based on the data analysis?

Resource: University of Phoenix Material: Data Set

Review the following business scenario:

You are the manager in a small town in the lake district of a Midwestern state that enjoys a robust tourist season during the summer months but has only a small population of residents during the off season. The Little town Café adjusts the levels of staff according to the time of year to coincide with the number of guests, with the tourist season typically starting around Memorial Day each year. One wait staff employee can serve 50 guests. When a bus staff employee is added, the pair can serve 75 guests. At 76 guests, the café adds a second wait staff employee, for a total of 2 waiters and one bustier. Analysis of guest numbers can support future decisions about scheduling wait staff, dishwashers, and bus staff for the café.

Download the data set.

Review the data in the data set.

Create a 875-word report in which you do the following:

  • Explain why this is (or is not) a suitable sample of quantitative data for the business scenario.
  • Evaluate the factors that would affect the validity of the data set.
  • Evaluate the factors that would affect the reliability of the data set.
  • Explain the steps you took to arrive at your conclusion about validity and reliability.
  • Display the data set in a chart
  • Explain briefly why that chart type was selected
  • Calculate the measures of central tendency and variability (mean, median, mode, standard deviation) for the data.
  • Explain the steps you followed to come your answer.
  • Interpret the measures of central tendency and variability. What are three conclusions you can draw based on the data analysis?

Format your assignment consistent with SPA guidelines.

Excel Data Sheet

Little town Café
Lunch + Dinner Guest Counts by Date
Month Date 2012 2013 2014
May 20 48 42 58
21 43 40 45
22 57 51 47
23 56 49 80
24 61 71 105
25 73 97 102
26 110 94 110
27 107 95 91
28 112 76 94
29 90 73 91
30 96 81 107
31 91 94 112
June 1 105 96 89
2 107 87 94
3 105 81 96
4 89 76 99
5 91 83 115
6 96 85 123
7 92 96 96
* Memorial Day
Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: