 Hi, this is Dr. Don, I want to show you briefly how to do some of the basic things you need to do in the fourth assignment. The first question says that BAST is advertising the mean salary of Programmer 1s at 65,000. Connie has gotten some feedback that some employees think the ad is misleading because they think the salary mean is not 65,000. So you have to check to see if you can verify the employee's claim and we're given a standard deviation of $7,000 which is a big clue that we should use the Z test and because we just have one sample of salaries it's a one sample Z test. So let's grab the data. There are a number of ways to grab the data using pivot tables but I'm just going to show you using basic Excel data sort. So I'm going to go over here and click on first the job title column and select that whole column and then I'm going to go to data sort and it'll say do you want to expand the selection and yes because I want to get all of the information and so it's now sorted and it's alphabetical. One way you can just scroll down until you see the programmers and there's Programmer 2. I'm going to go up, up, up, up, up, up, up, there's Programmer 1. Okay there we go and if I go over here I'm going to find that row and see that starts the Programmer 1's and then I'm just going to drag down until I have highlighted all the Programmer 1's and then I'm going to right click copy and you can see the marching ants we've selected those rows which includes the names and salaries. I'm going to go over here to question one calculations and I'm just going to click a cell, right click, paste the numbers and now I've got the basic data I need. Now all I need to do is to go get my one sample Z test. I'm going to go over here and find it and I'm just going to slide it across, relocate it next to my number one data. Now I can just get the salaries here, control C to copy that, go into my test, control V to paste in the data so we've got the basics there. We need to put the null hypothesis in which is 65,000 I think and our significance level is .05 typically and I think the standard deviation we're giving it was 7,000 but you guys check that and enter and then that does it. You just need to interpret the output. I hope this helps.