For the following questions, we will look at the relationship between speeding tickets and two city-level variables: the number of people who use Waze (an app that, allegedly, tells you when there is a police officer somewhere ahead of you so you can slow down and not get a ticket) and population. Here is some data to use:
| # of people using Waze (1000s) | Population (1000s) | Tickets |
| 11 | 25 | 1274 |
| 10 | 23 | 1835 |
| 10 | 18 | 457 |
| 10 | 18 | 870 |
| 9 | 15 | 1029 |
| 3 | 25 | 1951 |
| 10 | 15 | 1061 |
| 7 | 14 | 940 |
| 5.5 | 6 | 835 |
| 6.5 | 7 | 274 |
| 4.5 | 5 | 705 |
| 6 | 16 | 1373 |
| 10 | 23 | 1783 |
| 8 | 19 | 1196 |
| 9 | 10 | 1052 |
5. Now develop the estimated regression equation relating the number of speeding tickets to just the number of people using Waze. Write it in the form TICKETS = ____ + ____ WAZE, where you fill in the missing values. Round to two decimals.
6. What is the adjusted R2?
7. Now suppose you did all of the work and found the following for the estimated equation: TICKETS = 1244 + 102WAZE - 76POP. Interpret b1 and b2 in this new estimated regression equation.
8. Based on your interpretation of the previous question, do the results make sense? Why or why not?
Please Use excel, show work, and explain.