Q. British Columbia Tourist Association distributes s pamphlets, maps, and other tourist-related information to people who call a toll-free number and request information. The marketing manager decided to develop a multiple regression model to predict the number of calls that will be received in the coming week. A random sample of 20 weeks is selected. The collected data are summarized in the attached Excel spreadsheet bcta1.xls (see the side menu bar of this PDF).
a. Specify a suitable multiple regression equation to estimate with the data.
b. What percentage of the total variation in the number of calls is explained by the regression model?
c. Is the overall multiple regression equation statistically significant? Explain.
d. Which, if any, of the independent variables is statistically significant? Test using a significance level of 0.05.