Reference no: EM131116066

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 Littletown 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 busser. 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 APA guidelines.

Excel Data Sheet 

Littletown 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