1)Department of Labor reported the average hourly earnings for production workers to be $15.23 per hour in 2001. A sample of 75 production workers during 2003 showed a sample mean of $15.86 per hour. Assuming the population standard deviation is $1.50, can we conclude that an increase occurred in the mean hourly earnings since 2001? Use = .05.

Do it in Excel PLEASE