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 and one section of quantitative data, from the provided Unit 1 data set. Each section should include all data points. After analyzing your data, it will be necessary to write up a single concise professional report in Word that includes numerical data and graphs. The requirements include providing 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 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 1 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. Finally, 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 (Why you selected your data and what you learned by examining your selected data set.)
• The measures of central tendency and variability. (Copy and paste from your Excel process.)
• The charts/graphs
• Summary (what you learned and why the processes are important.)
The report should be well written and should flow well. It should not have any grammatical errors. It should include proper citation in APA formatting in both the in-text and bibliography. It should include a title page, be double-spaced and in 12-point font. APA formatting is necessary to ensure academic honesty.
For more information on using Excel, please visit the Excel Lab.
Please submit your assignment.
100
Sunday, Jun 15, 2008
• Construct charts and diagrams to interpret data.
• Compute mean, median, mode for a set of data.
• Explain variance and standard deviation.
• Use effective communication techniques.
Submit Assignment
N/A
About the dataset: there are 29 individuals in the dataset who provided answers to 9 variables (gender, age, department, how satisfied with their job and their benefits). So each column represents the answers to a variable (say gender in the first column) by all the 29 individuals and each row represents the answers of one individual to all variables.
On IP1:
There are two kinds of data, qualitative and quantitative. The dataset we use for the IP has both types. You are asked to choose one qualitative and one quantitative variable and describe it using the tools we learned (charts/graphs, tables, numerical measures).
I need help I don't know how to do this
How would you like us to help you with this?
What is meant by each section should include all data pints.
How to explain why I selected the data I chose (gender and age)? I just picked them.
ARE THESE ANSWERS CORRECT?
Directions: The playing times for 20 songs on a top-hits radio station are recorded in the chart below.
Using the times listed in the chart, circle the correct answer for questions 1-3 below.
Playing Time (minutes:seconds)
3:32 3:24 2:54 3:07 4:52 3:45 2:39 3:09 3:34 3:26
3:35 4:17 4:03 3:52 5:10 4:59 3:07 4:00 3:07 2:56
1. In a stem-and- leaf plot of this data where 33|2 represents 3:32, which of the following stems has the
fewest number of leaves?
A. 25
B. 30
C. 45
D. 51
2. In a frequency distribution of this data, how many data values are in the class 3:00 – 3:30?
A. 11
B. 5
C. 6 MY ANSWER because between 3:00- 3:30 has frequency of 6 data
D. 7
3. In a histogram of this data, which bar would have the greatest height?
A. 3:00-3:15 MY ANSWER
B. 3:15-3:30
C. 3:30-3:45
D. 3:45-4:00
ARE THESE ANSWERS CORRECT?
Directions: The playing times for 20 songs on a top-hits radio station are recorded in the chart below.
Using the times listed in the chart, circle the correct answer for questions 1-3 below.
Playing Time (minutes:seconds)
3:32 3:24 2:54 3:07 4:52 3:45 2:39 3:09 3:34 3:26
3:35 4:17 4:03 3:52 5:10 4:59 3:07 4:00 3:07 2:56
1. In a stem-and- leaf plot of this data where 33|2 represents 3:32, which of the following stems has the
fewest number of leaves?
A. 25
B. 30 MY ANSWER
C. 45
D. 51
2. In a frequency distribution of this data, how many data values are in the class 3:00 – 3:30?
A. 11
B. 5
C. 6 MY ANSWER because between 3:00- 3:30 has frequency of 6 data
D. 7
3. In a histogram of this data, which bar would have the greatest height?
A. 3:00-3:15 MY ANSWER
B. 3:15-3:30
C. 3:30-3:45
D. 3:45-4:00
To complete the assignment, you will need to follow these steps:
1. Choose one section of qualitative data and one section of quantitative data from the provided Unit 1 dataset. From the given options, you can choose any two variables that you find interesting or relevant to the study of job satisfaction. For example, you can choose "Gender" as your qualitative variable and "Overall Job Satisfaction" as your quantitative variable.
2. Once you have selected your qualitative and quantitative variables, you need to describe them using appropriate tools. For qualitative data, you can use charts/graphs such as a pie chart or bar chart to represent the distribution of responses. For the "Gender" variable, a pie chart would be a suitable choice. For quantitative data, you can use measures of central tendency (mean, median, mode) and measures of variability (standard deviation and variance) to describe the data.
3. To calculate the measures of central tendency (mean, median, mode), you can use Excel. Enter the data for the selected quantitative variable in an Excel worksheet and use the appropriate formulas to calculate these measures. You will have to copy and paste the calculated values into your report.
4. Additionally, create a chart/graph for each of the two processed sections of data. For example, you can create a pie chart to represent the distribution of genders among the participants, and a bar chart to represent the distribution of different levels of overall job satisfaction.
5. After analyzing the data using the tools mentioned above, you need to discuss why you selected these specific variables and what you learned from examining them. For example, you can discuss any patterns or trends you noticed in the data, any differences between genders in terms of job satisfaction, etc.
6. Explain why charts/graphs are important in conveying information in a visual format. Discuss how they help in analyzing and understanding the data more easily. Also, explain the importance of measures of variability like standard deviation and variance. Discuss how they provide information about the spread or dispersion of the data points.
7. Finally, combine all the above elements into one comprehensive report in Microsoft Word. The report should include an introduction, the data selected, a discussion of why you selected the data and what you learned, measures of central tendency and variability (copied and pasted from Excel), the charts/graphs, and a summary of what you learned and why the processes are important. Remember to format your report following APA guidelines for citations, font, spacing, and citation format.
By following these steps, you will be able to complete the assignment successfully, providing a concise and professional report that incorporates both numerical data and visual representations of the selected data.