California and New York lead the list of average teachers’ salaries. The California yearly average is $64,421 while teachers in New York make an average annual salary of $62,332. Random samples of 45 teachers from each state yielded the following.
California New York
Sample Mean 64,510 62,900
Population Standard Deviation 8,200 7,800
At a = 0.10, is there a difference in means of the salaries?
Note: I would like someone to please explain the process to find the answer step by step and also show me how to find this answer on Excel. I know how to find the answer for problems that contain data sets, but do not know how when there are not any datum.