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: