Purchase Solution

Measures of central tendency and measures of variability

Not what you're looking for?

Ask Custom Question

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. The data set for the study is a sample of a survey conducted on the population of the American Intellectual Union (AIU) and contains the following nine sections of data that will be used throughout our course: Gender, Age, Department, Position , Tenure, Overall Job Satisfaction , Intrinsic Job Satisfaction - Satisfaction with the actual performance of the job, Extrinsic Job Satisfaction - external to the job, for example, office location, your work colleagues, your own office (cubicle/hard walled office, etc), Benefits - Health insurance, pension plan, vacation, sick days, etc.

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). Each section should include all data points listed in the column for the variable.

The requirements include:

Identify the data you selected.

Explain why the data was selected.

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). 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. 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.

Attachments
Purchase this Solution

Solution Summary

Analysis is done step by step in Excel so you can see how it is done. Discussion is in text boxes in Excel next to data and graphs. Separate discussion gives the student a draft report to use in crafting their own response.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.