Background Information A local realestate company invests in

Background Information: A local real-estate company invests in retirement accounts for all full-time employees. The company automatically deposits an amount equal to 3% of the employee’s base salary into a 401K account through an investment firm. Employees of the company may choose to have a portion of their pay deposited into these accounts as well, but they are not required to do so. The company has access to the annual return rate data on all 254 of their employee’s accounts for the 2014-2015 fiscal year. They have analyzed the data, and found that it is approximately normally distributed with a mean annual return rate of 6.71% and standard deviation of 2.93%. Finally, they know that 82, or 32%, of all their full-time employees did not choose to deposit a portion of their pay into these accounts. Let X = the annual rate return rate of a company employee (%). Let Y = the choice to deposit a portion of an their pay into the retirement account (Yes=0 or No=1) Use the background information above to answer the following questions. Be very careful to use the correct probability distributions, formulas, and calculations for each problem. Answer the problems according to the instructions given at the beginning of the assignment. What type of variable is X? What is the name of the probability distribution of X? What annual return rate would we expect to see for a single randomly selected employee? (Using the appropriate distribution) what is the probability that a single randomly selected employee will have an annual return rate of 8% or higher? (Using the appropriate distribution) what is the probability that a single randomly selected employee will have an annual return rate of between 4.50% and 9.50%? Suppose we are going to randomly select a group of 40 employees. What is the probability that the sample mean will be less than 7%? What type of variable is Y? What is the name of the probability distribution of Y? What is the probability that a single randomly selected employee will choose not to deposit a portion of their pay into their company retirement account? Suppose we are going to randomly select a group of five employees. What is the probability that exactly two of them choose not to deposit a portion of their pay into their company retirement account? Suppose we are going to randomly select a group of 40 employees. What is the probability that at most 18 employees in the sample choose not to deposit a portion of their pay into their company retirement account? If we randomly select a group of 40 employees, how many employees would we expect to see who do not choose to deposit a portion of their pay into their company retirement account? In the background information above, it was determined that the annual return rate of a company employee (X) has an approximate normal distribution. We want to confirm this. Make a histogram of the annual return rates data, which is located in the file titled “portfolioreturns” on Carmen, using Excel. Use at least 15 bins, but do not use the default bins that Excel creates. Do you agree that the data has an approximate normal distribution based on your graph? Explain briefly. Please copy/paste the graph into the document. REMEMBER: Directions for a histogram are on Carmen under the “How-To” section. Have Excel make a normal probability plot of the annual return rates data. Do you agree that the data has an approximate normal distribution based on this plot? Explain briefly (what should the graph look like?) Please copy/paste the graph into the document.

Solution

What type of variable is X? continous variable

What is the name of the probability distribution of X? exponential distribution or normal distribution

What annual return rate would we expect to see for a single randomly selected employee? 6.71%

what is the probability that a single randomly selected employee will have an annual return rate of 8% or higher?

0.266126