I do not understand how to make t-Test, can you please help in making the t-Test using the datas included.

Writing & Testing Hypotheses

Is job satisfaction in our industry the same for both genders? We will look at Job Satisfaction and Gender for this analysis. First, we write out the hypotheses:

(Null Hypothesis) H0: 1 - 2 = 0

(Alternate Hypothesis) H1: 1 - 2 0

H0: Males rate job satisfaction the same as females.

H1: Males rate job satisfaction differently than females.

You decide to test this at the = 0.05 level, using a t-Test: Two-Sample Assuming Unequal Variances. Run this test in Excel and interpret the results.

p-VALUE approach (use the wording to reject or fail to reject the Null hypothesis)

Given that the p value (xx) is greater than the alpha (.05), the Null hypothesis cannot be rejected, therefore there is no support for the Alternate Hypothesis that (paste Alternate Hypothesis)

OR

Given that the p value (xx) is less than the alpha (.05), the Null hypothesis is rejected, therefore there is support for the Alternate Hypothesis that (paste Alternate Hypothesis here)

Discuss implications for management. Research and find out if there are studies that make connections between the variables you tested.

Make industry connections with the research from IBISWorld. Include workplace applications that may be implemented based on the findings.

Repeat the same testing for:

Intrinsic Job Satisfaction

Extrinsic Job Satisfaction

Organizational Commitment

Gender

Age

Department

Position

Tenure

Job Satisfaction

Intrinsic

Extrinsic

Commitment

1

1

1

2

1

6

5.3

2.9

3.7

KEY TO SURVEY

1

1

1

2

1

3.6

5.8

3.1

4

1

1

1

3

1

3.6

5.8

3.1

6.6

DEMOGRAPHICS

1

1

1

3

1

3.5

6.4

5.4

2.8

1

1

2

2

1

3.5

5

3.5

4.3

Gender

1

3

2

2

1

3.5

5

3.5

4.3

1

Male

1

1

2

3

2

3.4

6.4

5.9

3.6

2

Female

1

1

2

1

2

3.4

6.2

2.9

3

Age

1

3

2

3

1

3.4

5.4

6.9

7

1

16 - 21

1

1

2

1

1

3.4

5.3

5.4

6.5

2

22 - 49

1

1

1

3

1

3.4

6.4

5.9

3.6

3

50 - 65

1

2

1

1

1

3.4

6.2

2.9

3

Department

1

2

1

1

2

3.4

5.4

6.9

7

1

Front-Line Worker

1

1

2

1

2

3.4

5.3

5.4

6.5

2

Supervisor

1

3

2

3

1

3.4

4.7

5.9

3.6

3

Management

1

1

2

1

1

3.4

4.7

4.1

4.2

Position

1

1

1

3

1

3.6

5.8

3.1

4

1

Hourly Employee Part-time

1

2

1

1

1

3.6

5.8

3.1

6.6

2

Hourly Employee Full-time

1

2

1

1

2

3.5

6.4

5.4

2.8

3

Salaried Employee

1

2

2

2

3

3.5

5

3.5

4.3

Tenure With Company

1

3

3

3

2

3.5

5

3.5

4.3

1

Less than 2 years

1

2

3

3

2

3.4

6.4

5.9

3.6

2

2 to 5 years

1

1

3

2

2

3.4

6.2

2.9

3

3

Over 5 Years

1

2

1

1

3

3.4

5.3

5.4

6.5

1

1

2

1

2

3.4

4.7

5.9

3.6

SURVEY MEASURES

1

2

2

3

1

3.4

4.7

4.1

4.2

1

1

3

1

1

3.6

5.8

3.1

4

SURVEY MEASURE #1

1

2

2

2

1

4.9

5.3

2.9

3.7

OVERALL JOB SATISFACTION (Scale 1-7)

1

3

3

2

1

4.9

5.4

7

5.4

1 = Least Satisfied

1

3

3

3

2

4.9

5.3

5.7

4.7

7 = Most Satisfied

1

3

3

1

1

4.9

5.3

5.7

2.3

SURVEY MEASURE #2

1

1

2

2

1

5.2

4.7

5.6

5.2

INTRINSIC JOB SATISFACTION (Scale 1-7)

1

1

2

2

1

5.2

4.7

5.6

2.3

1= Least Satisfied

1

1

1

1

3

5.2

4.7

5.6

5.2

7= Most Satisfied

1

3

3

1

1

4.9

6.4

5.4

4.7

SURVEY MEASURE #3

1

3

3

3

2

4.9

6.4

4.6

4.5

EXTRINSIC JOB SATISFACTION (Scale 1-7)

1

3

3

1

1

6.2

2.5

4.4

4.5

1 = Least Satisfied

1

1

2

2

1

6

2.4

4.3

4.2

7 = Most Satisfied

1

1

2

2

1

4.9

5.3

2.9

4.8

SURVEY MEASURE #4

1

1

1

1

3

4.9

5.4

7

4.9

ORGANIZATIONAL COMMITMENT (Scale 1-7)

1

3

3

1

1

4.9

5.3

5.7

4.2

1= Least Satisfied

1

2

2

2

3

4.9

5.3

5.7

5

7= Most Satisfied

1

1

2

1

1

5.2

4.7

5.6

4.2

1

1

1

1

3

5.2

4.7

5.6

5.4

1

3

3

1

1

5.2

4.7

5.6

4.7

1

3

3

3

1

4.9

6.4

5.4

2.3

1

3

3

2

1

4.9

6.4

4.6

2.3

1

1

3

2

1

6.2

2.5

4.4

5.3

1

3

3

2

1

6

2.4

4.3

3.7

1

2

1

1

2

5.2

4.7

5.6

5.4

1

2

2

2

3

5.2

4.7

5.6

4.7

1

1

1

2

1

5.7

3.2

5.1

4.1

1

1

1

2

1

5.7

3.2

5.1

4.1

1

1

1

3

1

5.7

3.1

5

4.2

1

1

1

3

1

5.7

3.1

5

4.2

1

1

2

2

1

5.7

3

4.9

4.3

1

3

2

2

1

5.7

2.9

4.8

4.4

1

1

2

3

2

5.5

5.4

4.1

5.3

1

1

2

1

2

5.4

5.4

4.1

4.8

1

3

2

3

1

5.2

2.8

4.7

4.5

1

1

2

1

1

6.6

2.7

4.6

4.6

1

1

1

3

1

6.4

2.6

4.5

4.7

1

2

1

1

1

6.2

2.5

4.4

4.8

1

2

1

1

2

6

2.4

4.3

4.9

1

2

2

2

3

5.9

3.7

5.5

4.2

1

3

3

3

2

5.8

2.3

4.2

5

1

2

3

3

2

5.6

2.2

4.1

5.1

1

1

3

2

2

5.4

2.1

4

5.2

1

2

2

2

1

5.2

6

3.9

5.3

1

1

3

2

1

5.2

5.3

5.7

6.4

1

2

2

1

2

5.2

5.3

5.7

4.7

1

2

2

3

1

5.2

5.3

5.7

2.3

1

1

3

2

1

5.2

5.3

5.7

2.3

1

1

3

3

1

5.2

5.2

4.6

5.3

1

2

1

1

3

5.2

4.7

5.6

6.4

1

1

2

1

2

5.2

4.7

5.6

5.2

1

2

2

3

1

5.2

4.7

5.6

4.7

1

1

3

1

1

5.2

4.7

5.6

4.5

1

2

1

1

2

5.2

4.7

5.6

4.5

1

2

3

1

3

5.2

4.7

5.6

4.5

1

3

3

2

1

4.9

6.4

4.6

4.2

1

3

3

3

2

4.9

5.4

5.6

5.4

1

3

3

1

1

4.9

5.3

5.7

4.7

1

1

2

2

1

4.9

5.3

5.7

2.3

1

1

2

2

1

4.9

5.3

5.7

2.3

1

1

1

1

3

4.9

5.3

2.9

5.3

1

3

3

1

1

4.9

5.3

2.9

3.7

1

2

2

2

3

4.9

5.3

2.9

3.7

1

1

2

1

1

4.9

5.2

5.7

4.2

1

1

1

1

3

6

5.2

4.6

5.4

1

3

3

1

1

4.9

5.2

4.6

4.2

1

3

3

3

1

4.9

5.2

4.6

4.2

1

3

3

2

1

4.9

5.2

4.6

4.2

1

1

3

2

1

4.9

5.2

4.6

4.2

1

3

3

2

1

4.9

4.7

5.6

4.7

2

1

3

2

1

4.9

4.7

5.6

4.5

2

1

3

1

1

4.9

4.7

5.6

4.5

2

2

2

3

1

4.9

4.7

5.6

4.5

2

2

2

2

1

4.9

4.7

5.6

4.5

2

3

3

2

1

4.9

4.7

5.6

4.5

2

2

2

2

1

4.9

4.7

5.6

4.5

2

2

2

2

3

4.9

4.7

5.6

4.5

2

3

3

2

1

4.9

4.7

5.6

4.5

2

2

3

1

3

4.9

4.7

5.5

5.4

2

2

2

2

1

4.8

5.8

3.7

5.5

2

2

1

1

3

4.6

5.7

3.6

5.6

2

3

1

1

3

4.4

5.6

3.5

5.7

2

2

1

2

2

4.2

5.5

3.4

5.8

2

1

2

3

2

4

5.4

3.3

5.9

2

2

2

2

3

3.8

5.3

3.2

6

2

1

2

1

1

3.6

5.2

3.1

6.1

2

1

1

1

3

3.4

5.1

3

6.2

2

3

3

1

1

6

6.4

5.5

3.5

2

3

3

3

1

3.2

5.4

5.6

5.4

2

3

3

2

1

3.2

5.4

4.6

4.2

2

1

3

2

1

3.1

5.2

4.6

4.2

2

3

3

2

1

3.2

5.2

4.6

4.2

2

1

3

2

1

3.2

5.2

4.6

4.2

2

1

3

1

1

5.6

6.4

6

2.5

2

2

2

3

1

5.2

5.2

2.9

2.9

2

2

2

2

1

5.2

4.7

3.9

6.6

2

3

3

2

1

6.5

5.3

2.3

6.5

2

2

2

2

1

6.5

4.7

6.5

2.5

2

2

2

2

3

5.9

5.2

4.6

4.2

2

3

3

2

1

5.7

6.4

5.5

3.1

2

2

3

1

3

5.7

6

3

5

2

2

2

2

1

5.7

6

3

6.4

2

2

1

1

3

5.7

5.6

3.2

6.8

2

3

2

3

1

5.7

5.6

3.2

6.8

2

3

2

1

3

5.7

5.4

5.8

2.5

2

3

2

2

2

6

5.4

3.3

4.1

2

3

2

2

2

5.7

5.4

3.3

4.1

2

3

1

2

1

5.5

5.2

5.5

5.4

2

2

1

1

3

5.2

6.4

5.6

7

2

2

1

3

1

5.2

5.4

4.1

4.8

2

2

2

1

1

5.2

5.2

5.8

5.2

2

2

2

1

1

5.2

5.2

5.8

5.2

2

1

3

3

3

5.2

5.2

5.7

4.2

2

2

1

1

2

3.2

5.2

5.4

5.4

2

3

3

3

3

5.2

5.2

4.5

4.5

2

2

2

2

1

5.2

4.7

5.6

4.5

2

2

2

1

1

5.2

4.7

3.9

3.1

2

2

1

2

2

5.2

4.7

3.5

2.9

2

1

1

1

3

5.1

5.3

6

2.5

2

3

2

3

1

4.9

6.4

5.5

3.5

2

2

2

1

3

4.2

6.4

4.8

4.7

2

3

3

2

1

4.9

6.4

4.6

4.2

2

2

2

2

3

4.9

5.4

5.6

5.4

2

1

3

1

1

4.9

5.3

5.5

5.2

2

1

3

1

3

4.9

5.3

2.9

3.7

2

2

1

1

2

6

5.3

2.9

3.7

2

1

3

2

1

4.9

5.2

5.2

5.3

2

1

3

1

1

4.9

5.2

4.6

4.2

2

1

3

2

1

4.9

5.2

4.6

4.2

2

2

2

2

3

6

5.2

4.6

4.2

2

3

1

1

1

4.9

4.7

5.6

4.5

2

3

3

3

2

4.9

4.7

5.6

4.5

2

3

3

2

3

4.9

4.7

5.6

4.5

2

3

2

3

1

4.8

6.4

2.5

6.6

2

3

3

1

1

4.8

5.2

5.5

2.6

2

1

2

2

1

4.8

3.7

5.7

6.6

2

1

2

1

1

4.5

4

4

4.8

2

2

2

2

2

5

1.8

5

5.8

2

3

3

2

2

4.4

1.6

5.2

6

2

3

2

1

2

4.3

4.2

3.9

4.7

2

3

3

1

3

4.3

2

4.8

5.6

2

1

1

3

1

4.1

4.4

3.8

4.6

2

2

2

2

2

4.1

1.9

4.9

5.7

2

3

3

2

2

3.9

5.4

6.4

2.5

2

3

2

1

2

3.9

4.7

6.4

2.5

2

3

3

1

3

3.9

4.6

3.7

4.5

2

1

1

3

1

3.8

5.2

5.8

6.8

2

2

3

2

1

3.8

5.2

2.1

6.8

2

1

1

3

3

3.8

4.7

2.4

2.8

2

1

3

3

2

3.7

4.8

3.6

4.4

2

3

2

2

1

3.6

5.8

3.1

4

2

3

2

2

1

3.6

5.8

3.1

6.6

2

1

1

1

2

3.5

6.4

5.4

2.8

2

3

2

1

1

3.5

5

3.5

4.3

2

3

2

1

1

3.5

5

3.5

4.3

2

2

2

3

2

3.4

6.4

5.9

3.6

2

2

1

3

3

3.4

6.2

2.9

3

2

3

3

2

1

3.4

5.4

6.9

7

2

1

2

1

3

3.4

5.3

5.4

6.5

2

2

1

2

2

3.4

4.7

5.9

3.6

2

3

3

2

3

3.4

4.7

4.1

4.2

2

1

1

1

3

3.2

6.4

3.9

6.4

2

1

1

1

3

3.2

6.4

3.9

6.4

2

1

1

2

3

3.2

5.4

5.6

5.4

2

1

1

1

3

3.2

4.7

4.7

4.7