Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help! In the data set shown below, CONTRIBis the variable indicating contribution to the plan in dollars at the end of its first year.

Please help!

image text in transcribed
In the data set shown below, CONTRIBis the variable indicating contribution to the plan in dollars at the end of its first year. SUSAN is a categorical variable taking on the value of 1 if Susan Shepard sold the policy and 0 if she did not. GROUP takes on the value of I if the client also has a group life or group health insurance policy with Best Retirement; if not, GROUP is 0. TURNOVER is the employee turnover rate. It mea- sures the percentage of employees terminating employment each year. ESTIMATE is the estimated end-of-year contributions in dollars and SALARY is the average annual employee salary in dollars. ELIGIBLE is the number of employees eligible to partici- pate in the 401(k) plan. VEST and FAILSAFE are both binary variables: does the plan have immediate vesting of employer contributions (0 = no, 1 = yes) and does the plan have a fail-safe provision (0 = no, 1 = yes)? MATCH is the percentage of the contri- butions matched by the employer. Can you do better than the underwriter at estimating year-end contributions? GROUP ELIGIBLE FAILSAFE SALARY SUSAN CONTRIB TURNOVER VEST MATCH ESTIMATE 36675 1 14.00 69 1 0 25 26296.3 75432 63733 10.00 33 1 0 50 14133.7 50000 PO 25560 8.00 21 1 0 50 24000.0 45000 177970 0 10.00 67 1 25 36833.3 235000 86873 1 10.00 47 1 50 41140.1 146965 39051 0 10.00 12 1 66463 . 8 95000 131449 1 12.00 85 1 0 25 25929.3 155045 30711 0 10.00 40 1 0 50 17198 . 7 54392 13691 0 10.00 30 1 1 0 28788. 6 50000 49587 1 10.00 63 0 25 32124.4 100000 37898 0 10.00 25 1 100 35288.1 86000 41686 0.10 30 WHOHP 0 100 23266.7 56000 107657 0 14.00 21 0 50 54798 .0 115650 39811 0 14.00 29 0 50 18617.9 50000 148274 0 14.00 99 0 25516.6 252316 (continues on the following page)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Algebra Graphs & Authentic Applications (Subscription)

Authors: Jay Lehmann

3rd Edition

0134781252, 9780134781259

More Books

Students also viewed these Mathematics questions