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.)
3
![Employme Billboard Social Networks Careerbuil Company I Diversity Ji Employee Glassdoor Informatic Internet Si MBTA ads Monster.c Newspager/Magazine On-campu On-line We Other
Pay Per Cli Pay Per Cli Profession Search Eng Social Networks - Vendor Re Website Banner Ads Word of Mouth
January
520.00
420.00
410.00
0.00
0.00
0.00
0.00
0.00
0.00
640.00
500.00
629.00
0.00
0.00
0.00
110.00
330.00
100.00
330.00
420.00
0.00
400.00
0.00
February
520.00
481.00
410.00
0.00 5129.00
0.00
0.00
0.00
0.00
640.00
500.00
510.00
0.00
0.00
492.00
110.00
330.00
100.00
410.00
481.00
0.00
400.00
0.00
March
520.00
452.00
410.00
0.00
0.00
0.00
0.00
0.00
0.00
640.00
500.00
293.00 2500.00
0.00
0.00
60.00
180.00
100.00
388.00
452.00
0.00
300.00
0.00
April
520.00
479.00
820.00
0.00
0.00
0.00
0.00
0.00
0.00
640.00
440.00
810.00
0.00
0.00
829.00
121.00
362.00
100.00
372.00
479.00
0.00
388.00
0.00
May
0.00
392.00
820.00
0.00
0.00
0.00
0.00
0.00
0.00
640.00
500.00
642.00
0.00
0.00
744.00
110.00
197.00
100.00
472.00
392.00
0.00
592.00
0.00
June
0.00
508.00
410.00
0.00
0.00
0.00
0.00
0.00
0.00
640.00
500.00
675.00 2500.00
0.00
0.00
109.00
152.00
100.00
412.00
508.00
0.00
610.00
0.00
July
612.00
578.00
410.00
0.00
0.00
0.00
0.00
0.00
0.00
640.00
440.00
707.00
0.00
0.00
610.00
130.00
389.00
100.00
416.00
578.00
0.00
620.00
0.00
466.00
0.00 4892.00
0.00
1300.00
100.00
495.00
466.00
August
Septembe
612.00
820.00
0.00
0.00
0.00
250.00
740.00
0.00
0.00
0.00
146.00
437.00
0.00
669.00
0.00
729.00
389.00
820.00
0.00
0.00
0.00
0.00
0.00
0.00
1300.00
300.00
772.00 2500.00
0.00
0.00
105.00
315.00
100.00
619.00
389.00
0.00
718.00
0.00
October
749.00
439.00
1230.00
0.00
0.00
0.00
0.00
0.00
0.00 1300.00
220.00
805.00
0.00
0.00
510.00
109.00
327.00
100.00
502.00
439.00
0.00
767.00
0.00
Novembe
910.00
491.00
820.00
0.00
0.00
0.00
0.00
0.00
0.00
1300.00
150.00
838.00
0.00
0.00
0.00
105.00
315.00
100.00
389.00
491.00
0.00
816.00
0.00
Decembe
500.00
478.00
410.00
0.00
0.00
0.00
0.00
0.00
0.00
1300.00
300.00
870.00
0.00
0.00
810.00
110.00
176.00
100.00
378.00
478.00
0.00
865.00
0.00
Total
6192.00
5573.00 7790.00
0.00 10021.00
0.00
0.00
0.00
0.00 10980.00 4600.00
8291.00 7500.00
0.00 3995.00 1323.00 3509.00 1200.00 5183.00
5573.00
0.00
7143.00
0.00](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0c52e3cf-1b00-434a-b164-4867378082fa%2F77563b86-48f3-4643-8c9a-9129820ecce8%2Fvpg79zs_processed.jpeg&w=3840&q=75)
![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?
Question 5
Compare the performance of the model above with a model that just controls for the funding of Billboard. In other words, create a multiple regression predicting
Social Network funding from Months 1-12, while controlling for the funding of Billboard. Compare the Regression Statistics. Which model does a better job of
explaining the variance in Social Network funding?
O The model that just controls for Billboard
O The model that controls for Billboard, Careerbuilder, Company Intranet, and Diversity Job Fair](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0c52e3cf-1b00-434a-b164-4867378082fa%2F77563b86-48f3-4643-8c9a-9129820ecce8%2F8286gm6_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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?
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)