Data Set

The data set for our course is available via the following link
HYPERLINK
"https://mycampus.aiu-online.com/courses/QMB350/Assignment_Assets/QMB350
DataSet.xls" \t "_blank" DataSet and HYPERLINK
"https://mycampus.aiu-online.com/courses/QMB350/Assignment_Assets/QMB350
DataSet_Key.xls" \t "_blank" DataSet Key contains the following eight
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), 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 to 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 one of eight sections of data from the provided
Unit 1 data set (you are welcome to select a section of data that you
are most interested in). Use thirty data points / scores is a good
average to use when selecting your data. You will then need to list the
raw data you are examining in a MS Word document or MS Excel spreadsheet
(if a MS Excel spreadsheet is ever used, you are welcome to copy and
paste your work into a MS Word document, which could make explanations
of your steps easier to discuss). After organizing your data, it will be
necessary to write up a professional report. The report should discuss
why the data was selected and what was eventually learned by examining
this set of data. When examining your data, you will want to use basic
statistical tools to summarize the data. You may have to provide the
mean, median, mode, variance and standard deviations for the data you
selected. If a measure is not applicable, then explain why. You will
have to also provide 1 chart/graph. For example, you may want to graph
gender information if you selected this as your section. Ensure that you
label the chart/graph clearly. Then combine all of the items above into
one comprehensive report which summarizes your findings. This report
must be done in Microsoft Word and should contain,

An Introduction

The data selected

Discussion (of what was learned by examining your selected data set).

Summary (what can be learned / taken away from this information).

DATA SET

GENDER AGE DEPT POSITION TENURE OVERALL INTRINSIC EXTRINSIC

2 2 3 2 3 6.2 6.33 7

1 1 1 1 2 4.6 3.83 6.5

1 2 3 1 1 2.4 5.33 6

2 2 3 2 1 5.8 6.17 3

1 2 3 2 1 2.8 5.33 3

1 1 2 1 2 2.6 5.33 4

2 1 3 1 2 3.8 4 5

1 2 3 1 1 6.6 6.17 2.5

1 3 3 2 2 7 5 6

1 3 3 2 3 5.4 6.33 5.5

2 2 3 2 1 5.6 5.2 6

1 1 1 1 2 5 6.17 5.5

2 2 2 2 2 4 5.17 4

2 2 3 1 1 3.6 6.67 6

2 2 3 1 2 4.8 4.17 6

1 1 2 2 2 4 5.17 5

2 2 2 1 1 4 4.67 4

1 2 3 2 1 1.6 2.67 4

2 3 2 1 2 6.6 5 6.5

2 1 1 2 2 4.6 4.25 5

2 2 3 2 1 1.6 5.17 4

2 2 3 1 1 2.8 6.17 6

2 2 2 1 2 3.6 6.5 4

2 2 3 2 2 2 3.67 1.5

1 2 3 1 1 6.8 6.83 6

1 2 2 1 2 5 4.83 5

2 2 3 2 2 2.6 6 2

1 2 3 1 1 6.4 4.5 6

2 1 2 1 1 4.2 6 6

2 2 2 2 1 5.4 3.17 5

1 2 3 2 1 4.4 5 7

1 2 3 1 1 5 4.17 6

2 2 2 1 1 3.8 4.33 4

2 2 2 1 3 3.2 5.17 1

2 2 3 1 1 5 5 4

1 2 3 1 1 7 7 7

2 3 2 2 1 4 5.5 6

1 2 3 1 2 6.8 7 5.5

2 2 2 2 3 3.8 5.33 6

2 2 2 1 1 4.6 4.33 6

2 2 3 1 3 3.2 4.67 4

2 2 2 1 2 2 3.67 6

1 2 3 1 1 6.2 5.67 7

1 2 3 1 2 4.6 5.17 6

2 2 3 1 1 4.8 5.5 6

2 2 3 2 3 5.4 6.17 5.5

1 2 3 1 2 5 5 5

1 2 3 1 1 4.2 5.83 6

1 3 3 1 3 4.6 4.67 4

1 3 2 2 1 3.2 3.83 4

2 2 3 2 3 4 6.17 5

2 2 3 2 1 3.8 6.17 5

2 3 3 2 1 4.2 4.5 6

2 2 2 2 3 5.6 6 5

2 2 3 1 3 5.6 5.83 6

1 2 3 1 1 7 6.83 7

2 2 3 1 1 4.6 5 6

2 3 2 2 1 2 5.83 2

1 3 3 1 1 2.8 5.67 1.5

1 2 3 1 1 3 4.33 5.5

2 2 2 2 1 3 5.24 6

1 1 2 1 2 4.6 5.67 2

2 2 2 1 2 4.6 5 4

2 2 3 1 1 5.4 5.67 7

2 2 2 1 1 5.2 6.17 2

1 2 3 1 1 4 4.67 6

1 2 3 1 1 5.2 5.17 2

2 2 3 2 1 4.8 5 2

1 2 3 2 1 3.4 7 6

1 3 3 2 1 3.4 4.5 6

1 3 3 1 1 3.6 5.17 6

1 3 3 2 1 4 5.5 6

1 2 2 1 1 1.8 3 3

2 3 2 2 2 4.8 5 6

1 2 2 1 3 3.6 4.83 2.5

2 2 2 1 1 4.2 5 6

2 1 2 1 1 4.8 4.5 5.5

1 2 2 1 1 5.4 4.67 6

2 2 3 1 3 4 4.17 6.5

1 2 3 1 1 4.8 5.5 4.5

1 2 3 2 3 4.4 3.33 6

2 1 3 1 2 4.8 5.17 4

1 3 3 2 1 2 5 6

1 2 3 1 1 4.8 5 6

2 2 2 1 1 4.6 6.33 6.5

2 3 3 2 1 3.8 6.33 5.5

1 2 3 2 1 6.6 7 5.5

2 2 3 1 2 3.6 6.67 6

1 2 2 2 3 2.6 3.83 3

2 2 2 1 1 5.4 5.67 4

1 3 3 1 1 3.2 5 6

2 2 3 2 3 2.4 5.33 3.5

2 2 3 1 2 4.6 4.75 5.5

2 3 2 1 1 4.6 4.5 3

2 2 3 2 3 4.2 4.83 4

1 3 3 2 1 4.6 4.33 5.5

2 2 2 1 1 3.2 6.5 5.5

2 2 2 2 2 4.2 6 7

2 2 3 2 3 4.4 5.5 7

2 2 2 2 3 3.4 6.17 6

1 2 2 1 2 3.2 4.83 6

2 2 2 2 1 4.6 6.33 7

1 2 3 1 1 5 4.83 6

2 2 2 2 1 2.8 4.33 5.5

2 2 3 1 1 3.8 5 1

2 3 2 1 3 3.8 2 1.5

2 2 2 1 1 1 2 1

2 1 1 2 2 3.8 5 6

2 1 2 2 1 5.6 6.83 7

1 3 2 2 2 6 6.33 6.5

1 2 3 1 2 2.2 4 2.5

1 2 3 1 1 3.4 4.5 4

2 2 2 1 1 4.2 7 5.5

1 2 2 2 2 4 4.67 6

2 2 3 2 1 4.2 3.5 1.5

2 2 3 1 1 6 6.67 3

1 2 3 1 1 3.4 5.33 2

2 1 3 1 2 3.6 4.83 4

2 2 3 2 1 3.8 4.83 4

1 2 3 2 1 6.6 6.83 6

2 3 3 2 1 3.8 4.83 7

2 1 2 2 2 4 4.5 1.5

1 2 3 1 1 5.2 5 6

2 2 3 2 1 1 5.17 1

2 2 3 2 2 6.2 7 7

1 2 3 2 1 7 6.83 6

2 2 2 1 3 5 3.5 5

1 2 2 1 1 7 6.5 6

2 2 2 2 3 5.2 5 6

2 1 2 2 2 2 5.17 1.5

2 1 2 2 2 2.8 4.5 6

2 2 2 1 1 5.6 5.33 5

1 2 3 1 1 2.6 4.5 4

1 2 3 2 1 3.2 4.33 2.5

2 1 1 1 1 6 6.67 6

2 2 3 2 1 3.4 5.5 6

2 2 2 2 2 2 4.5 7

1 2 3 1 1 6.6 5.17 5.5

2 2 3 2 1 6.2 4.83 4.5

1 3 3 2 1 5 5 2

1 1 2 2 1 2.6 4 5

2 2 2 2 2 5 5.17 6

1 1 3 1 2 5.6 5.67 6

1 2 3 2 1 4.4 5.67 6

2 1 1 1 2 3.6 5 4.5

1 1 1 1 2 2.2 4.17 4.5

1 2 3 1 2 7 7 7

1 2 3 2 1 1.8 4.33 3

1 3 3 2 1 3.6 4.17 6

1 2 3 1 1 4 5.17 2

2 1 1 1 2 6.2 6.33 5.5

1 2 2 1 3 5.8 5.83 5

1 2 3 1 1 4.6 6.17 3

2 2 3 1 1 4 4.67 4

1 2 3 1 1 5.8 6.17 7

2 2 2 1 1 5.4 4.83 6.5

2 1 2 2 3 3 3.67 4

2 2 3 2 1 5.8 5.67 7

2 2 3 2 1 3.2 5.33 1.5

1 1 2 1 1 2 4.67 2.5

1 3 3 1 1 4.6 5 6

1 1 3 2 1 4 5.33 6.5

1 2 3 1 1 3.4 4.67 6

2 3 3 2 1 3.4 6.33 4

2 3 3 2 3 4.4 5.3 5

2 2 3 1 3 6 7 3

1 3 3 1 3 5.2 5.67 5.5

2 2 3 2 3 6 6.83 6

1 3 3 2 3 5.6 5.83 6

2 3 2 2 3 7 7 1.5

1 3 3 1 3 1.8 5.33 5.5

2 1 1 2 2 4 3.5 3

2 2 3 1 1 3.8 5.5 4

2 2 3 2 2 5 3.17 4.5

2 2 3 2 1 3.2 5.33 4.5

1 2 3 1 1 2.6 5.67 6

2 3 3 2 1 2 5.67 6

2 2 2 2 2 3.6 5.33 3

1 2 2 2 1 5.6 5.67 4.5

1 2 3 1 1 4.8 4.33 6

2 2 3 2 3 5.4 5 6.5

2 2 3 1 1 6 5 7

2 2 3 1 1 4.4 5.33 4.5

1 1 3 1 1 4.2 4.17 5

2 2 3 1 1 4.6 5.33 6.5

2 1 3 1 1 4.2 5.67 4

2 2 3 1 1 5.8 6.33 6

1 1 2 1 2 3 4.67 6

2 2 2 1 1 2.2 1 1

1 3 3 1 3 5.2 4.33 4

2 2 3 1 2 1 4.67 5

1 2 3 2 1 4 4.5 6

1 2 3 2 3 2.2 6.17 1.5

2 2 3 1 1 6 6.67 5

2 2 2 1 1 5.6 6.33 6

2 2 3 2 1 5 7 2.5

2 2 2 2 3 4.8 4.67 4

1 3 2 1 1 6.2 4.83 4

2 3 2 1 3 1 5 1

2 2 3 1 1 5 5 7

2 2 3 1 1 4.4 6.5 5.2

2 2 3 2 2 5.6 5.83 5

2 1 2 2 1 5 5.17 4

1 3 3 1 1 4 5.5 6

2 2 2 1 1 4.6 5.33 3

1 1 3 1 2 5.8 7 5.5

2 3 3 1 3 2.4 4.33 6

1 1 2 2 3 3.8 3.83 3

2 2 2 2 3 4.2 4.67 3

2 1 3 1 1 3.8 6 6

1 2 3 2 1 4.8 4.33 6.5

1 2 3 2 1 3 5 6

1 2 3 1 1 4.8 6.33 6.5

1 1 3 1 2 2.8 5.5 5.5

2 1 3 1 1 5.4 5.33 6

2 2 3 2 3 3.2 3 6

2 1 3 1 1 6.2 6.33 6

2 2 3 1 2 6.2 5.67 2

1 2 3 1 2 7 6.5 6

2 2 3 1 1 5.6 6.17 6

1 3 3 1 1 4.6 5 6

1 2 3 1 1 4.6 4.5 4.5

1 2 3 2 1 2.8 5 1

2 2 2 2 2 4.4 3.5 4.5

2 2 2 1 1 5.8 4.17 5

2 2 2 1 1 4.6 5.17 3

1 2 2 2 1 4.8 5 7

2 2 1 1 1 4.2 7 5.5

1 3 2 2 2 5.2 6 5.2

2 1 2 1 1 2.2 5.17 5.5

2 1 2 2 1 6 5.33 7

2 2 3 1 3 3.4 4.5 6

2 2 2 2 1 3.8 5.17 6

2 1 2 2 2 3.6 6 7

2 2 3 2 1 5.4 4.5 7

2 2 3 2 1 4.2 6.33 6

1 2 3 1 1 5.2 5.33 5.5

2 2 2 1 1 4 6.33 2.5

2 2 2 1 1 5.8 7 6

2 1 2 2 1 1.8 3 4

2 2 2 2 1 2 7 6

1 1 2 1 2 3.6 4.17 4.5

2 2 3 1 2 4.6 4.17 6.5

2 2 2 2 1 3.2 5.17 5.5

1 2 2 2 1 5.8 4.67 5

1 3 2 2 1 2.6 5 1

2 1 2 2 2 4.8 6.83 6

2 2 2 2 2 4 4.5 4

2 2 2 2 2 3.6 4.17 2

2 2 3 1 3 5.8 5 6

1 2 3 2 3 1.8 5.33 6

1 3 3 1 1 5 6.17 7

2 2 3 2 2 1.8 4 1

2 2 3 1 1 6.2 7 5.5

2 2 3 2 1 2 5.33 1.5

1 1 3 1 1 4.6 5 3.5

1 3 3 2 1 6 6.17 6.5

2 2 3 1 3 6.2 5.67 4

2 2 3 1 3 5.8 5.83 6

1 3 3 2 1 3.4 6.17 5.5

1 3 3 1 1 6.2 5 6

1 1 2 1 2 1.6 5.67 5

2 1 3 2 1 5.8 5.83 3.5

1 2 3 2 1 4.6 4.5 5.5

2 2 2 1 1 5.8 6 5

2 2 3 1 1 3.6 5 4.5

2 3 2 2 3 4.4 4.17 3.5

2 2 3 2 3 5.8 5.5 6

2 2 1 2 3 4 4.17 4

1 2 3 1 3 5.4 5 6

2 1 2 1 2 5 5.33 5.5

1 2 3 1 1 4 4.33 6

2 2 3 1 1 2.8 4.5 1

1 1 3 1 1 5.5 5 6

1 3 3 2 1 5.2 4.67 6

1 2 2 1 2 3.8 5 5.5

2 1 3 1 1 5 6.17 7

2 2 2 1 2 4.2 4.83 4.5

2 2 2 2 1 4.8 6.33 5

2 2 3 1 1 4 5 7

1 2 2 1 1 4.6 3.67 6

1 2 3 1 3 5.2 6.33 6

2 2 3 1 2 2 4.83 6.5

1 2 2 1 2 6 6.17 1

2 2 3 1 1 4 3.67 7

2 2 3 2 2 4.6 6.5 5.5

2 2 3 1 3 3 3.67 5

1 3 3 1 1 5.4 5.67 6.5



DATA SET KEY

KEY TO JOB SATISFACTION SURVEY

 

Gender   Tenure With Company  

1 Male 1 Less than 2 years

2 Female 2 2 to 5 years

Age   3 Over 5 Years

1 21 and under    

2 22-49 OVERALL Scale from 1-7

3 50 and over JOB SATISFACTION 1= Least Satisfied

Department     7= Most Satisfied

1 Human Resources    

2 Information Technology INTRINSIC Scale from 1-7

3 Administration JOB SATISFACTION 1= Least Satisfied

      2= Most Satisfied

Position      

1 Hourly Employee (Overtime Eligible) EXTRINSIC Scale from 1-7

2 Salaried Employee (No Overtime) JOB SATISFACTION 1= Least Satisfied

      2= Most Satisfied