Use theFliers Customersdata and create a chart with X coordinates being number ofFliersthat the restaurant manager distributed weekly and Y coordinates being number of weekly restaurantCustomers. In addition add thetrendlineand itsequationon the chart.

Answer questions 9 to 12.(pick the answer that fits best)

9. Which kind of trend do you observe?

• a. No trend
• b. Positive
• c. Negative

10. Is this trend (or lack of trend) potentially good news regarding increasing the restaurant profits?

• a. No
• b. Yes

11. What is the slope of the line?

• a. 0.338
• b. 0.338x
• c. 0.2297
• d. 0.2297x

12. Given the data what is the interpretation of the number 315.48? (pick ONE answer that fits the best):

• a. The number is meaningless in this setting.
• b. It tells us the restaurant would expect on average about 315 customers weekly even if no fliers were distributed weekly.
• c. It tells us the more fliers being distributed the weekly number of restaurant customers will increase by about 315.
• d. It tells us the restaurant profit will increase by about $315 even if no fliers were distributed weekly.

Use theTornadoesdata and the procedure described in the tutorial on Tornadoes to create a chart whereX-axisare theMonths (Jan, Feb,...)and theY-axiscontains themedian number of tornadoes deathper month. Hint: to compute average type =Median(P5:P49).

Answer questions 13 and 14.

13. Which two months have the highest median number of tornado deaths?

• a. April and May
• b. May and June
• c. July and August

14. Which month has the third highest median tornado death and what is the median (round to one decimal place)?

• a. March and 2
• b. June and 3
• c. August and 5

Use theTornadoesdata and the procedure described in the tutorial on tornadoes to create an additional row data containing the standard deviation of tornado death per each month. Hint: to compute standard deviation type =StDev(P5:P49).

Answer questions 15 and 16.

15. Which month has the second highest standard deviation of tornado death?

• a. June
• b. July
• c. August

16. Which month has the second lowest standard deviation of tornado death?

• a. August
• b. October
• c. September

Create the third row data, containing the range of number of tornado deaths for each month. Hint: Type =Max(P5:P49) - Min(P5:P49)and then (as before) drag the cursor.

Answer questions 17 to 20.

17. Which month has the highest range?

• a. March
• b. April
• c. May

18. Which months have range below 20?

• a. July and September
• b. November and December
• c. March and April

19. Which month has the highest sum of tornadoes deaths(need to create another row!!)?

• a. February
• b. March
• c. April

20. Which two months have the lowest sum of tornado deaths?

• a. January and March
• b. July and September
• c. April and May