1. See the spreadsheet, and find the requested values (mean, median, mode...). Assume each region's numbers is the population. You may use Excel commands or a calculator.

	Yesterday's Dining Expenses Per Region
	South	North
	25	13
	32	18
	15	26
	13	11
	10	20
	10	18
	22	12
	47	15
	24	38
	26	22
	11	21
	29	15
	33	11
	34	10
	17	14
		15
		15
mean
median
mode
maximum
minimum
range
variance
standard deviation
First quartile
Third quartile
Interquartile range
80th percentile
Five Number Summary

2. Find the z score given the following means of a sample: The population mean is 45. The population standard deviation is 6. Show your work.

A. x = 42

B. x = 40

C. x = 51

3. Use the Empirical Rule to solve the following. Assume the mean came from a normal distribution. The mean is 512 and the standard deviation is 34. Show your work.

A. Provide the interval which contains 68% of the values.

B. Provide the interval which contains 95% of the values.

C. Provide the interval which contains 99% of the values.

4. A restaurant manager wondered if there were a correlation between the number of minutes customers stayed and their bill. He had 9 customers at lunch time. He recorded this data.

Customer for lunch	Minutes spent at the table	Bill in dollars and cents
A	27	7.25
B	34	8.45
C	70	10.50
D	36	8.10
E	50	9.25
F	34	8.25
G	61	8.75
H	49	8.50
I	38	7.00

A. Crreate a scatter diagram in Excel with a trendline. Make sure to label your axes.

B. Use Excel to calculate Pearson's correlation coefficient (r). Provide that value.

C. Interpret the results. Is there a relationship between the minutes spent at the table and the amount spent at the restaurant?

Please doo APA style and reference: