Your friends are in a local band, and you help them promote upcoming concerts by passing out postcard-sized print ads. In the attached Excel spreadsheet are the approximate numbers of ads passed out each week last summer, along with the number of people that attended each concert.
a. Use regression analysis and show your printouts. What is the regression equation you obtained? Interpret each regression coefficient.
b. Is the regression coefficient significant at the 0.05 level? Explain.
c. How much of the variability in number of people attending the concerts can be explained by the number of ads passed out? How do you know this?
d. What are some other factors that might be included in a multiple regression model to explain the number of people that attend the concerts?
| NO. OF ADS |
ATTENDANCE |
| 900 |
625 |
| 550 |
400 |
| 750 |
450 |
| 300 |
200 |
| 600 |
500 |
| 1000 |
650 |
| 400 |
375 |
| 325 |
350 |
| 675 |
400 |
| 200 |
200 |
| 500 |
500 |
| 150 |
125 |
| 500 |
300 |
| 700 |
550 |
| 600 |
400 |