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? The hiring managers want to compare three different employment sources: Newspaper/Magazine, CareerBuilder, and Monster.com. Perform simple regressions as you did above predicting allocations for month 13 for those three employment sources. Which of the following statements would be the best conclusion from your analysis? The model R-square for Monster.com is the highest R-square value of the three platforms. Therefore, management will likely provide the most funding for that platform, and we should focus on that above the other two. The models for Monster.com and Newspaper/Magazine are both significant, which means we should focus on these two platforms over CareerBuilder because management will likely provide us the most funding for those two platforms. The predicted monthly amount for CareerBuilder is lower than the predicted amount for Newspaper/Magazine. Therefore, they should expect the lowest amount of funding for CareerBuilder out of all of the three, and should concentrate on their efforts on the other two employment resources. The monthly amounts for Monster.com have a negative slope, compared to the other two, which have a positive slope. Therefore, they should expect lower funding for Monster.com than in the past, and should concentrate their efforts on the other two employment resources. All of the above are correct. None of the above are correct. Employment Source Billboard Careerbuilder Company Intranet - Partner Diversity Job Fair Peale Employee Referral Glassdoor Information Session Internet Search MRTA MBTA ads Monster Monster.com Newspager/Magazine New On-campus Recruiting On-line Web application Othe Other Pay Per Click Pay Per Click - Google Professional Society Coorch Search Engine Google Bing Ya Social Networks - Facebook Twi Vendor Referral Website Banner Ads Word of Mouth January 520.00 410.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 200 0.00 40.00 640.00 500.00 500.00 .. 629.00 0.00 0.00 0.00 ..... 110.00 220.00 330.00 100.00 100.00 220.00 330.00 420.00 0.00 400.00 0.00 February March 520.00 410.00 0.00 120.00 5129.00 0.00 200 0.00 200 0.00 200 0.00 40.00 640.00 500.00 500.00 $10.00 510.00 0.00 0.00 200 0.00 ...... 492.00 110.00 110.00 220.00 330.00 100.00 100.00 410.00 481.00 0.00 400.00 0.00 520.00 410.00 0.00 0.00 0.00 Z 0.00 Z 0.00 0.00 0.00 0.00 $40.00 640.00 500.00 500.00 202.00 293.00 2500.00 2500.00 0.00 0.00 50.00 60.00 180.00 100.00 100.00 388.00 452.00 0.00 300.00 0.00 April 520.00 820.00 0.00 0.00 0.00 2.00 0.00 0.00 0.00 0.00 0.00 540.00 640.00 440.00 010.00 810.00 0.00 0.00 www 0.00 220.00 829.00 121.00 262.00 100.00 272.00 372.00 479,00 0.00 388.00 0.00 May 0.00 820.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 540.00 640.00 500.00 500.00 43.00 642.00 200 0.00 0.00 0.00 744.00 744.00 110.00 110.00 107.00 197.00 100.00 100.00 473.00 472.00 202.00 392.00 0.00 592.00 0.00 June 0.00 410.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7. 640.00 00.00 500.00 00 675.00 00.00 2500.00 0.00 0.00 200 0.00 100.00 109.00 ***.** 152.00 100.00 100.00 412.00 412.00 508.00 0.00 0.00 610.00 0.00 July 612.00 410.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 40.00 640.00 140.00 707.00 707.00 0.00 0.00 0.00 10.00 610.00 120.00 130.00 300.00 389.00 100.00 415.00 416.00 578.00 0.00 620.00 0.00 November December 1.00 1.00 August September October 612.00 729.00 749.00 820.00 820.00 1230.00 0.00 0.00 0.00 0.00 0.00 237.00 350.00 2.00 6.00 3.00 2.00 Total Interest Click Submitted A Passed Quali Recruiter Int Interview Ro Interview Ro Interview Ro Accepted Offer/Hired 910.00 500.00 6192.00 820.00 410.00 7790.00 0.00 0.00 0.00 0.00 21.00 0.00 10021.00 0.00 0.00 0.00 20 0.00 0.00 34.00 85.00 11.00 350.00 17.00 47.00 1.00 0.00 0.00 55.00 98.00 13.00 400.00 400.00 200.00 299.00 160.00 0.00 0.00 4892.00 0.00 0.00 200.00 7.00 16.00 2.00 22.00 10.00 19.00 10.00 10.00 200 3.00 200 2.00 0.00 1.00 200 8.00 6.00 6.00 4.00 0.00 0.00 360.00 226.00 236.00 130.00 1.00 0.00 3.00 249.00 778.00 112.00 1481.00 1442.00 1443.00 703.00 782.00 1303.00 1202.00 1004.00 1094.00 ****** 1467.00 4370.00 1279.00 2.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 160.00 120.00 4.00 1.00 1.00 0.00 0.00 0.00 Z 0.00 0.00 0.00 0.00 Z 0.00 0.00 71.00 ***.** 1.00 1.00 2.00 4.00 0.00 0.00 2 0.00 200 ** 0.00 Z 0.00 200.00 1300.00 0.00 0.00 200.00 0.00 200.00 1300.00 4.00 2.00 1.00 99.00 ***.** 182.00 242.00 243.00 170.00 151.00 ***.** 180.00 4.00 1333.00 006.00 996.00 641.00 641.00 402.00 493.00 ***.** 700.00 ****.** 1159.00 w 614.00 ***** 593.00 F45.00 545.00 G44.00 644.00 ***.** 482.00 ZA 20 4.00 5.00 5.00 11.00 11.00 14.00 14.00 17.00 17.00 MA 21.00 1.00 1300.00 200.00 300.00 1300.00 10980.00 200.00 300.00 1.00 250.00 250.00 6.00 3.00 2.00 0.00 00.00 1300.00 150.00 929.00 838.00 0.00 0.00 0.00 220.00 220.00 005.00 805.00 240.00 740.00 070.00 772.00 772.00 4600.00 wwwww 8291.00 3500.00 7500.00 6.00 8.00 CA 012.00 913.00 1090.00 870.00 0.00 0.00 5.00 5.00 0.00 A 0.00 500.00 2500.00 0.00 **** 5.00 2.00 2.00 0.00 0.00 0.00 0.00 0.00 0.00 10.00 178.00 136.00 136.00 136.00 136.00 167.00 ***.** 140.00 www 188.00 ***** 96.00 130.00 139.00 106.00 106.00 ***.** 120.00 ***.** 134.00 125.00 167.00 04.00 2.00 2.00 6.00 Z 0.00 0.00 0.00 7.00 2.00 146.00 105.00 1089.00 4300.00 0.00 0.00 1288.00 *. 2005.00 3995.00 561.00 ****.** 1222.00 1323.00 1225.00 3500.00 304.00 3509.00 1200.00 1200.00 E192.00 $10.00 510.00 100.00 109.00 337.00 327.00 0.00 105.00 315.00 2 810.00 110.00 110.00 176.00 176.00 10.00 18.00 **** 19.00 31.00 21.00 10.00 10.00 400 4.00 5.00 6.00 22.00 2.00 2.00 1.00 1.00 427.00 437.00 315.00 315.00 315.00 100.00 625.00 ***.** 369.00 FA7.00 527.00 742.00 384.00 84.00 400.00 100.00 100.00 100.00 100.00 400 1.00 126.00 222.00 102.00 163.00 3.00 Z 2.00 Z 2.00 12.00 12.00 5.00 1.00 1.00 200 3.00 100.00 378.00 478.00 478.00 495.00 00.00 2.00 3.00 742.00 420.00 33.00 13.00 2.00 2.00 619.00 389.00 0.00 718.00 0.00 100.00 264.00 100.00 561.00 5183.00 389.00 757.00 01.00 491.00 5573.00 608.00 0.00 0.00 0.00 179.00 816.00 865.00 7143.00 1284.00 0.00 0.00 0.00 96.00 100.00 503.00 502.00 439.00 0.00 767.00 0.00 466.00 0.00 669.00 0.00 223.00 420.00 101.00 166.00 40.00 937.00 262.00 54.00 16.00 163.00 74.00 28.00 186.00 10.00 1.00 0.00 3.00 15.00 1.00 0.00 2.00 6.00 2.00 0.00 0.00 0.00