Marketing Research Assignment - Descriptive statistics for Current Salary Education Level

Marketing research Assignment

To get descriptive statistics for “Current Salary” “Education Level” and “Employment Category” click on Data Analysis. Descriptive Statistics. OK. Your input range is the column of data you want to look at. Column F has “Current Salary” Select column F. Then check the boxes: Labels in First Row, Summary Statistics and Confidence Level for Mean. You will repeat this for Education Level and Employment Category.     

 

To complete this assignment, you will need to download either Employee.sav or Employee.xsl from the D2L location for this assignment.  The first is a .sav file used for the software program IBM SPSS and the second is for use with Microsoft Excel.  Depending on what software you have available, you will open the correct file to complete this assignment. 

 

You are able to use your text to complete this assignment.  It has instructions for both SPSS and Excel analysis.  You will want to make sure you are using the correct instructions based on the software you will be using so you are able to complete the assignment. 

 

If you are using Excel, the job categories are 1= Clerical, 2 = Custodial, and 3 = Manager.  Education levels are 8 = eighth grade, 12 = H.S. Senior, 13 = 1 year college, etc. Missing values are entered as 0, except for the variable Minority which is 0 = No, 1 = Yes, and 9 = Missing.  F = Female and M = Male. Job time is “months since hire”.

 

This assignment asks you to take already collecteddata and then use analysis to answer questions and make inferences about what you find. 

 

 

SPSS: Descriptive Statistics

Frequencies

[select “Current Salary” “Education Level” and “Employment Category”] move to variable list

Charts [select “bar charts”]

Statistics [select mean, median, mode, std. deviation, range]

[CONTINUE], [OK]

 

Excel:These instructions are for the Office 365 version of Excel from MSUB.

If you have a different version of Excel, the steps may be different.You will need to allow the Data Analysis add-in to function in Excel.

                Go to: File. Options. Add-ins. Click Analysis Tool Pack. Click Go.

To check if it allowed access, go back to your Excel sheet, click the Data ribbon. In the Analysis group it should say Data Analysis.

To get descriptive statistics for “Current Salary” “Education Level” and “Employment Category” click on Data Analysis. Descriptive Statistics. OK. Your input range is the column of data you want to look at. Column F has “Current Salary” Select column F. Then check the boxes: Labels in First Row, Summary Statistics and Confidence Level for Mean. You will repeat this for Education Level and Employment Category.

 

1.  How many cases are there?____________________________________

 

2.  How many cases are missing?__________________________________

 

 

Excel: Go back to your original sheet. “Sheet 1” Choose the Insert Ribbon. Click on Pivot Table in the Tables group. Create PivotTable should pop up. Make sure all of your data is selected. You can choose to work on your PivotTable in a new sheet or the existing one you are working in. Your choice. Click OK. In PivotTable Fields drag the category ‘Salary’ to both the Rows and Values boxes. Click on ‘Salary’ in the values box, then Values Field Setting, change it to count.

 

3. How many employees make $28,800_____________________________

 

Excel: Click on ‘Salary’ in the values box, then Values Field Setting, click the show values as tab, choose % of grand total.  You will need to change between count and % depending on the information you are trying to obtain.

 

4. What percentage of employees make more than 100K or more?_______

 

5.  What is the most common salary in the bank?_________

 

6. How many people make this salary?______________________________

 

Excel: Click on your PivotTable. Click on the Analyze Ribbon. Choose PivotChart. Choose a column chart. Click OK.

 

7.  Look at the bar chart for current salary.  Is there anything unusual here?  If so, what?

________________________________________________________________

 

8.  Speculate why it is that the average salary is higher than the most common salary.

 

________________________________________________________________

 

Excel: Create PivotTables using the ‘Job Category’ and ‘Education’ information.

 

9.  How many managers does the bank have?________________________

 

10.  What is the cumulative percent of clerical workers and custodians?_______

 

11. What is the average education level in the bank?___

*Note: Think about how you would report education.  If it comes back as a number you wouldn’t report a number with decimal points in your analysis, but would instead talk about what grade level that might equate to.  (Here you can report both to show you can convert the numerical value).

 

 

 

 

SPSS: Create a histogram of beginning salary.[Analyze > Descriptive > Frequency > Chart > Histogram; check box for normal curve]

 

Excel: create a column chart of beginning salary.

 

12. What is the standard deviation ________________________

 

13.  How would you describe the distribution (look at it and tell me what you see).

 

 

SPSS: Data View, Look at bottom left of screen

Data > select cases > random sample of cases > sample > approximately 10%      of all cases > okay.

You now have a small random sample you can compare to the “population”.

SPSS: Analyze > Descriptive statistics > Explore > current salary

 

Excel: You will need to create a random sample of 10%. On your original data page, add a column to the right of ‘Salary.’ Label this column Random. Below random, type =rand(), click enter. This has just created a random number that you will use to create random sample of your data. (You may need to change it from currency to general. This is on the Home ribbon in the Number group.) Double click the box at the bottom right of your cell or drag the box to the end of your data.

Highlight your random column by clicking the letter above it. Probably ‘G’. Copy this column. Then paste ‘values only’ in the column. (This will stop the numbers from re-randomizing.)

Now you will need to sort your data. Highlight your entire sheet of data. Then click AZ sort & filter on the Home Ribbon under the editing group. Choose custom sort. Sort by Random, smallest to largest.

Your sample size of 10% will be approximately 47 cases. Highlight and copy the first 47 salary cases. Paste these on a new sheet and use the Data Analysis function to answer the following questions. (Make sure to unselect ‘labels in first row’ if you do not have a label.)

 

14. What is the mean? ____________________

 

15. What is the number of cases ______________

 

16. What is the standard error________________

 

17.  What is the “lower bound” of the confidence interval? ______________

 

18.  What is the “upper bound” of the confidence interval?_______________

 

19. Based on the information you have, what can be said about the value of the population mean?

 

SPSS: Data > Select cases > all cases

 

Excel: Refer to your previous Data Analysis on Current Salary. 

 

20. Determine the population mean.  Does this confirm of disconfirm what you found in the sample? ___________________

 

21. Why?

___________________