The data set for our course is a sample of a survey conducted on the population of the American Intellectual Union (AIU). It is available via the following link: DataSet with DataSet Key which contains the following nine sections of data that will be used throughout our course:
(1) Gender (2) Age (3) Department (4) Position (5) Tenure (6) Overall Job Satisfaction (7) Intrinsic Job Satisfaction – Satisfaction with the actual performance of the job (8) Extrinsic Job Satisfaction- Things external to the job, e.g., office location, your work colleagues, your own office (cubicle/hard walled office, etc), and (9) Benefits – Health insurance, pension plan, vacation, sick days, etc.
In each of the assignments in this course you will be dealing with the following scenario:
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.
The study will require that you examine data, analyze the results, and share the results with groups of other researchers. Job Satisfaction is important to companies large and small and understanding it provides managers with insights into human behavior that can be used to strengthen the company's bottom line.
In the first assignment you are to complete the following:
You will need to examine two of the nine sections of data, one section of qualitative data (choose either Gender or Position) and one section of quantitative data (choose either Intrinsic or Extrinsic), from the provided data set through the link above. Each section should include all data points listed in the column for the variable. The requirements include identifying the data you selected, discussing why the data was selected and 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) and the use of two measures of variability (standard deviation and variance). Some measures are appropriate for qualitative data and some are appropriate for quantitative data. If a measure is not applicable, then explain why. You will have to also provide one chart/graph for each of the results of the two processed sections of data (2 total), such as a pie or bar chart or a histogram. (A table is NOT a chart/graph.) Ensure that you label the chart/graph clearly. You will then need to discuss what you additionally learned from the results of this process. Explain why charts/graphs are important in conveying information in a visual format and why standard deviation and variation are important. You will need to combine all of the items above into one comprehensive report.
This report must be completed in Microsoft Word and should contain:
* An Introduction.
* The data selected.
* Discussion of why you chose the data and what you learned from your process results.
* The measures of central tendency and variability. Copy and paste your output from Excel.
* The charts/graphs.
* Summary of what you learned and why the processes are important.
Why did you post this assignment on the Jiskha Homework HELP Forum?
How would you like us to help you?
I do not understand what I need to do her I need some help.
To complete the assignment, follow these steps:
1. Introduction:
Provide a brief introduction to the topic of job satisfaction and its importance to companies. Explain that your report will analyze two sections of data from the provided dataset and discuss the insights gained.
2. Data Selection:
Choose one section of qualitative data (either Gender or Position) and one section of quantitative data (either Intrinsic or Extrinsic) from the dataset. Explain why you selected these specific sections and how they relate to the study of job satisfaction.
3. Discussion of Data and Insights:
Describe the selected data sections and present all the data points listed in the columns for those variables. Discuss what you learned by examining these sets of data, such as any patterns, trends, or differences observed.
4. Measures of Central Tendency and Variability:
Use Microsoft Excel to calculate three measures of central tendency (mean, median, mode) and two measures of variability (standard deviation and variance) for the chosen quantitative data section. If a measure is not applicable, explain why. Copy and paste the output from Excel into your report.
5. Charts/Graphs:
Create two charts/graphs, one for each processed section of data. Choose appropriate types of charts/graphs, such as a pie chart, bar chart, or histogram. Label the charts/graphs clearly to represent the data accurately.
6. Importance of Visual Formats and Measures:
Explain why charts/graphs are important in conveying information in a visual format. Discuss how they enhance understanding and interpretation of the data. Also, explain the importance of standard deviation and variation in analyzing quantitative data, as they provide insights into the spread or dispersion of the data.
7. Summary of Learnings:
Summarize the key insights gained from the data analysis process. Explain why these processes are important for studying job satisfaction and how they can provide managers with valuable information to improve their company's performance.
8. Conclusion:
Conclude your report by summarizing the main points discussed and reiterating the importance of understanding job satisfaction for organizational success.
Remember to compile all sections into a comprehensive report using Microsoft Word.