The data set for the study is a sample of a survey conducted on the population of the American Intellectual Union (AIU). It is available via the following link: Excel 2007 DataSet with DataSet Key which contains the following nine sections of data that will be used throughout our course:

o Gender
o Age
o Department
o Position
o Tenure
o Overall Job Satisfaction
o Intrinsic Job Satisfaction—Satisfaction with the actual performance of the job
o Extrinsic Job Satisfaction—external to the job, for example, office location, your work colleagues, your own office (cubicle/hard walled office, etc),
o Benefits—Health insurance, pension plan, vacation, sick days, etc.
In the first assignment you are to complete the following:
• You will need to examine two of the nine sections of data:
o one section of qualitative data (choose either Gender or Position)
o one section of quantitative data (choose either Intrinsic or Extrinsic)
• Each section should include all data points listed in the column for the variable. The requirements include:
1. Identify the data you selected.
2. Explain why the data was selected.
3. Explain what was learned by examining these sets of data.
4. 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).
5. Your analysis should also include 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.
6. If a measure is not applicable, then explain why.
7. 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.
8. You will then need to discuss what you additionally learned from the results of this process.
9. Explain why charts/graphs are important in conveying information in a visual format and why standard deviation and variation are important.

To complete this assignment, you will need to analyze two sections of data from the provided dataset - one qualitative section (choose either Gender or Position) and one quantitative section (choose either Intrinsic or Extrinsic).

1. Identify the data you selected:
- Qualitative data: Gender
- Quantitative data: Intrinsic Job Satisfaction

2. Explain why the data was selected:
- Gender was selected as it is an important demographic variable that can provide insights into any gender-based differences or patterns in the survey responses.
- Intrinsic Job Satisfaction was chosen as it represents a quantitative measure of how satisfied individuals are with the actual performance of their job, which can give valuable information about their overall job satisfaction.

3. Explain what was learned by examining these sets of data:
- By examining the gender data, you can learn about the distribution and representation of different genders within the American Intellectual Union (AIU) population.
- Analyzing the intrinsic job satisfaction data can provide insights into the level of satisfaction employees have with the actual performance of their job.

4. Use Microsoft Excel to obtain information about the data:
- Calculate the measures of central tendency (mean, median, mode) for both gender and intrinsic job satisfaction sections of data.
- To find the mean, median, and mode for qualitative data like gender, you can count the frequency of each category and determine the most common category (mode).
- For quantitative data like intrinsic job satisfaction, calculate the mean by summing up all values and dividing by the number of data points. Use the median to find the middle value when the data is sorted, and the mode to determine the most frequently occurring value.

5. Use two measures of variability (standard deviation and variance):
- Standard deviation and variance are measures that indicate the spread or variability of data points around the mean.
- Since gender is qualitative data, measures of variability like standard deviation and variance are not applicable.
- For quantitative data like intrinsic job satisfaction, calculate the standard deviation and variance to assess the dispersion or variability of the dataset.

6. Provide one chart/graph for each of the results of the two processed sections of data:
- For gender, you can create a pie chart or a bar chart to visualize the distribution of different genders within the AIU population.
- For intrinsic job satisfaction, a histogram or bar chart can be used to display the distribution of satisfaction levels among the employees.

7. Discuss what you additionally learned from the results:
- Examining the results can reveal insights such as the majority gender representation in the AIU population and the distribution of different levels of intrinsic job satisfaction among employees.
- These findings can help identify any gender-based disparities and provide a better understanding of satisfaction levels within the organization.

8. Explain why charts/graphs are important in conveying information visually:
- Charts/graphs provide a visual representation of the data, making it easier to understand patterns and relationships.
- They help in summarizing large amounts of data and making complex information more accessible and engaging.

9. Explain why standard deviation and variation are important:
- Standard deviation and variation are important measures of dispersion that provide information about the spread or variability of data points around the mean.
- They help in understanding the diversity or consistency of responses within a dataset, highlighting the range and distribution of values.
- Standard deviation and variation allow researchers to assess the reliability and stability of data, helping to draw more accurate conclusions from the analysis.