can you plz do this on excel and show me the excel work
. . . . . . . . Human resource managers face the business problem of assessing the impact of factors on full-time job growth. A human resource manager is interested in the impact of full-time voluntary turnover and total worldwide revenues on the number of full- time job openings at the beginning of a new year. Data are collected from a sample of 63 "best companies to work for." The total number of full-time job openings as of February 2017, the full-time voluntary turnover in the past year (in %), and the total worldwide revenue (in $billions) are recorded and stored in "Best_Companies.xlsx" file. (a) State the multiple regression equation. (b) Interpret the meaning of Bi and B2, in this problem. (c) What is the significance of Bo? (d) Predict the total number of full-time job openings for the company that has total worldwide revenues of $13.26 billion and full-time voluntary turnover of 29%. (e) How much percent of variation in the number of full-time job openings is explained by the regression model? (f) Does the regression model overestimate or underestimate the number of full-time job openings for the company "KPMG?"Human resource managers face the business problem of assessing the impact of factors on full-time job growth. A human resource manager is interested in the impact of full-time voluntary turnover and total worldwide revenues on the number of full- time job openings at the beginning of a new year. Data are collected from a sample of 63 "best companies to work for." The total number of full-time job openings as of February 2017, the full-time voluntary turnover in the past year (in %), and the total worldwide revenue (in $billions) are recorded and stored in "Best_Companies.xlsx" file. (a) State the multiple regression equation. (b) Interpret the meaning of Bi and B2, in this problem. (c) What is the significance of Bo? (d) Predict the total number of full-time job openings for the company that has total worldwide revenues of $13.26 billion and full-time voluntary turnover of 29%. (e) How much percent of variation in the number of full-time job openings is explained by the regression model? (f) Does the regression model overestimate or underestimate the number of full-time job openings for the company "KPMG?"Year GDP Education Spend Unemployment Rate Employee Compensation 2000 256,376 14,185 7.00 128,564 2001 264,335 15,004 6.60 135,710 2002 273,256 15,821 7.50 141,985 3 281,200 16,566 8.20 144,669 2004 296,820 16,709 8.40 148,851 2005 310,038 17,646 8.50 153,985 2006 325,152 18,295 8.30 161,393 2007 343,619 18,962 7.50 170, 106 2008 351,743 20,133 7.00 179,628 2009 346,473 21,071 7.90 180,906 2010 363,140 21,936 8.30 184,711 2011 375,968 23,356 7.20 193, 171 2012 386,175 24,158 7.60 199,806 2013 392,880 25,045 8.40 203,606 2014 403,003 25,436 8.50 206,201 2015 416,701 26,282 8.50 208, 128 2016 430,085 26,675 7.80 211,813 2017 444,991 27,853 7.10 219,187 2018 460,419 28,618 6.00 226,300
