https://docs.google.com/spreadsheets/d/16PecTxMOcR69mf7en8iXXqT8vLsWjv-c/edit#gid=1777994166
answers only, please
Pension Plan 1: A firm is interested in studying the factors that influence employee participation in a 401(k) pension plan. Build a regression model to forecast participation rate (as a percent) (prate) from total 401k participants (totpart), total eligible for 401k plan (totelg), and total number of firm employees (totemp). (Hint: There are more variables in the worksheet than you are instructed to use here). The data are contained in the worksheet named "401K". (a) State the model equation. O MRATE = EIPRATE + 2TOTPART + 3TOTELG + 34AGE + ESTOTEMP O TOTEMP = m, + ,b'iPRATE + 2TOTPART + 33TOTELG + [34AGE + [35PRATE O PRATE = (31TOTPART + EZTOTELG + [3TOTEMP O MRATE = 30 + EIPRATE + ZTOTPART + [3TOTELG + [more + STOTEMP PRATE = [20 + lTOTPART + ZTOTELG + 3TOTEMP J (b) Find a point estimate of the average participation rate for any number of plans with 262 total 401k participants, 262 total eligible for 401k plan, and 315 total number of firm employees. (Round your answer to two decimal places.) 90.70 x % Correctly interpret your answer immediately above by mentally inserting that value into the blanks below. Our best interval estimate for the participation rate for one particular pension plan that t this prole is \"/0. Our best interval estimate for the average participation rate of all pension plans that t this profile is %. Our best single number estimate for the participation rate for one particular pension plan that t this prole is \"/0. Our best single number estimate for the average participation rate of all pension plans that t this prole is %. I (c) Find a 95% interval estimate of the average participation rate for any number of plans with 262 total 401k participants, 262 total eligible for 401k plan, and 315 total number ofrm employees. (Round your answers to two decimal places.) (c) Find a 95% interval estimate of the average participation rate for any number of plans with 262 total 401k participants, 262 total eligible for 401k plan, and 315 total number ofrm employees. (Round your answers to two decimal places.) (:.:)% Correctly interpret your answer immediately above by mentally inserting that values into the blanks below. 0 Based on a sample of 50 pension plans, we are 95% condent that the true average participation rate for pension plans in the sample that t this prole is between % and %. 0 Based on a sample of 50 pension plans, we are 0.05 condent that the true average participation rate for pension plans in the sample that t this profile is between % and %. Based on a sample of 50 pension plans, we are 95% condent that the true average participation rate for all pension plans that t this profile is between 0ft) and \"/0. 0 Based on a sample of 50 pension plans, we are 0.05 condent that the true average participation rate for all pension plans that t this prole is between \"lo and \"/0. J (d) Find a point estimate of the participation rate for a single plan with 262 total 401k participants, 262 total eligible for 401k plan, and 315 total number of rm employees. (Round your answer to two decimal places.) Correctly interpret your answer immediately above by mentally inserting that value into the blanks below. 0 Our best interval number estimate for the average participation rate of all pension plans that t this prole is %. Our best single number estimate for the participation rate for one particular pension plan that ts this prole is "/0. 0 Our best single number estimate for the average participation rate of all pension plans that t this prole is %. 0 Our best interval number estimate for the participation rate for one particular pension plan that ts this prole is %. O Based on a sample of 50 pension plans, we are 95% confident that the true average participation rate for pension plans in the sample that fit this profile is between % and %. O Based on a sample of 50 pension plans, we are 0.05 confident that the true average participation rate for pension plans in the sample that fit this profile is between % and %. O Based on a sample of 50 pension plans, we are 95% confident that the true average participation rate for all pension plans that fit this profile is between % and %. O Based on a sample of 50 pension plans, we are 0.05 confident that the true average participation rate for all pension plans that fit this profile is between % and %. (d) Find a point estimate of the participation rate for a single plan with 262 total 401k participants, 262 total eligible for 401k plan, and 315 total number of firm employees. (Round your answer to two decimal places.) % Correctly interpret your answer immediately above by mentally inserting that value into the blanks below. Our best interval number estimate for the average participation rate of all pension plans that fit this profile is O Our best single number estimate for the participation rate for one particular pension plan that fits this profile is Our best single number estimate for the average participation rate of all pension plans that fit this profile is %. Our best interval number estimate for the participation rate for one particular pension plan that fits this profile is %. (e) Find a 95% interval estimate for the participation rate for a single plan with 262 total 401k participants, 262 total eligible for 401k plan, and 315 total number of firm employees. (Round your answers to two decimal places.) %