American Intellectual Union (AIU) has assembled a team of researchers in the United States and around the world to study job satisfaction. Congratulations, you have been selected to participate in this massive global undertaking.
You will need to examine two of the nine sections of data:
one section of qualitative data(choose either Gender or Position)
one section of quantitative data (choose either Intrinsic or Extrinsic)
What data did you select and why? What have you learned from the sets of data?
Use Microsoft Excel to obtain information about the data through the use of three mean, median, and mode.
Use standard deviationand variance.
Explain if a measure is appropriate for qualitative data or for quantitative data and why.
Include a chart/graph for each of the results of the two processed sections of data (2 total), such as a pie or bar chartor a histogram.
Identify anything else learned from the process.
Why are charts/graphs important to convey information? Why are standard deviation and variation are important?
Identify the data you selected. Explain why the data was selected.
I selected position and intrinsic satisfaction. I wanted to know if the type of position, salaried and hourly, would influence the satisfaction workers felt from completing the job (without outside reward).
Explain what was learned by examining these sets of data. Your analysis should include using Microsoft Excel to obtain information about the data through the use of three measures of central tendency (mean, median, mode).
See Excel, attached, for computation of mean, mode, median, standard deviation and variance.
(see excel for better formatting)
mean 1.14 5.105
mode 1 4.7
median 1 5.2
standard deviation 0.34874 0.38961
variance 0.12162 0.15179
The mean, or average, is not very telling for position since it is a category variable. For the intrinsic satisfaction measure, it does give you an idea of the average score. The mode for position just tells you that there are more hourly workers (more in that category). The mode of 4.7 for intrinsic satisfaction tells you that this is the most frequent score. The median score for position again tells you little except that there are more in the …
Your tutorial is 735 words and selected position and intrinsic variables for study. Two graphs are given, a chart of mean by category and a histogram of intrinsic scores by category. A discussion about how one chart is better than the other is included. Charts are created in SPSS. Counts by category are given in Excel for those that might like to create histograms or charts in Excel.