Question: (Use data at the bottom) Make a chart in excel with X coordinates being number of(filers)that the restaurant manager distributed weekly and Y coordinates being
(Use data at the bottom) Make a chart in excel with X coordinates being number of(filers)that the restaurant manager distributed weekly and Y coordinates being number of weekly restaurant(customers). In addition please 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 this data*********):
Fliers Customers
450 388
650 610
650 399
250 416
450 450
450 401
50 345
250 335
450 439
450 450
50 370
450 374
450 332
250 325
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
