Question 1.1- For ease of performing the next task, move the variable "Social Networks - Facebook, Twitter, etc" to column A on the spreadsheet. (i.e. Make sure it is the first column in the spreadsheet.)

The hiring managers recognize that the funding for one employment source depends on the funding for the other sources. Therefore, they want you to perform a multiple regression predicting Social Network funding from Months 1-12, while controlling for the funding of Billboard, Careerbuilder, Company Intranet - Partner, and Diversity Job Fair.

Assume that we know the funding for the the controlled variables for Month 13. They are:

Billboard: 520

Careerbuilder: 800

Company Intranet: 0

Diversity Job Fair: 1000

For this model and these known values, what is the predicted value for Social Network funding for Month 13? reference data

Question 1.2 - Based on the above simple regression analysis, how much should the hiring managers expect to have for Newspaper/Magazine in the following January (Month 13)? Round to two decimal places, do not include the dollar sign.