# 1. See the spreadsheet, and find the requested values (mean,…

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: