In the past, the average age of employees of a large corporation has been 40 years. Recently, the company has been hiring older individuals. In order to determine whether there has been an increase in the average age of all the employees, a sample of 64 employees was selected. The average age in the sample was 45 years with a standard deviation of 16 years. Let α = .05.
Using the p-value approach, test to determine whether or not the mean age of all employees is significantly more than 40 years.
Show answers using excel functions to solve.