Share
Explore BrainMass

Job Satisfaction Survey

Interrupting Data

Using the survey responses from the data set below, answer the following questions and include the Excel charts.

KEY TO SURVEY

Demographics

Gender
1 Male
2 Female
Age
1 16 - 21
2 22 - 49
3 50 - 65
Department
1 Human Resources
2 Information Technology
3 Administration
Position
1 Hourly Employee (Overtime Eligible)
2 Salaried Employee (No Overtime)
Tenure With Company
1 Less than 2 years
2 2 to 5 years
3 Over 5 Years

Four Survey Measures

SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7)
1 = Least Satisfied
7 = Most Satisfied
SURVEY MEASURE #2 INTRINSIC JOB SATISFACTION (Scale 1-7)
1= Least Satisfied
7= Most Satisfied
SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7)
1 = Least Satisfied
7 = Most Satisfied
SURVEY MEASURE #4 BENEFITS (Scale 1-7)
1= Least Satisfied
7= Most Satisfied

Gender Age Department Position Tenure Job Satisfaction Intrinsic Extrinsic Benefits
2 1 3 2 3 5.2 5.5 6.8 1.4
1 1 1 1 3 5.5 5.5 5.5 5.4
2 3 1 1 1 4.9 5.2 4.6 6.2
1 1 2 2 1 5.5 5.3 5.7 2.3
1 1 2 1 1 5.2 4.7 5.6 4.5
1 2 2 1 1 5.5 5.5 5.5 5.4
1 3 1 1 1 4.9 5.2 4.6 6.2
1 2 1 1 1 3.9 2.1 5.7 2.3
2 2 2 1 2 5.2 4.7 5.6 4.5
1 2 2 1 2 5.5 5.4 5.6 5.4
1 2 2 2 2 5.9 6.2 5.5 6.2
1 2 1 1 1 4.9 5.2 4.6 6.2
1 3 1 2 2 5.5 5.3 5.7 2.3
2 2 2 1 1 5.2 4.7 5.6 4.5
1 2 2 1 1 5.5 5.4 5.6 5.4
2 2 2 2 3 5.4 6.2 4.6 6.2
1 1 2 2 1 5.5 5.2 5.7 6.2
2 2 2 1 2 5.5 5.3 5.6 5.4
2 3 2 1 2 5.4 5.3 5.5 6.2
2 1 1 1 3 5 5.3 4.6 2.3
1 1 2 1 1 5.2 4.7 5.7 2.3
1 1 2 2 2 5.5 5.3 5.6 4.5
1 3 2 1 1 5.1 4.7 5.5 2.3
1 2 1 2 3 4.9 5.2 4.6 6.2
1 2 1 1 2 5.5 5.3 5.7 2.3
1 3 2 1 2 5.2 4.7 5.6 4.5
1 2 2 1 3 5.5 5.4 5.5 5.4
1 1 3 2 2 5.4 6.2 4.6 6.2
1 2 1 2 1 5.5 5.2 5.7 2.3
1 2 1 2 1 5.5 5.3 5.6 4.5
2 2 2 1 2 5.5 5.4 5.6 5.4
2 3 2 2 2 5.9 6.2 5.5 6.2
2 3 1 1 1 4.9 5.2 4.6 6.2
2 2 2 1 2 5.5 5.3 5.7 2.3
2 2 2 1 2 5.2 4.7 5.6 4.5
2 2 3 2 2 5.5 5.4 5.6 5.4

TEST #1
Perform the following two-tailed hypothesis test, using a .05 significance level:
Intrinsic by Gender
State the null and an alternate statement for the test. Write out a Null & Alternate Hypothesis ( alpha = .05).
Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test. Copy and paste the results of the output to your report in Microsoft Word.
Specifically identify the significance level (alpha), the test statistic, and the critical value.
State whether you are rejecting or failing to reject the null hypothesis statement.
Explain how the results could be used by the manager of the company specifically and why this information is valuable? Comment on why you are making your decision in terms of how the test statistic compares to the critical value or in terms of how the p value compares to the alpha.

TEST #2
Extrinsic variable by Position Type
Write out a Null & Alternate Hypothesis (alpha = .05). State the null and an alternate statement for the test.
Use Microsoft Excel (Data Analysis Tools) to process your data and run the appropriate test.
Copy and paste the results of the output to your report in Microsoft Word.
Specifically identify the significance level (alpha), the test statistic, and the critical value.
State whether you are rejecting or failing to reject the null hypothesis statement.
Specifically explain how the results could be used by the manager of the company. Comment on why you are making your decision in terms of how the test statistic compares to the critical value or in terms of how the p value compares to the alpha. Why is this information valuable?

Explain the following:
Explain when to use a t-test and when to use a z-test. Tells some of the differences.
Explain the difference between a sample and the population. Why are samples used for hypothesis tests? Be specific.

Solution Summary

This solution is comprised of a detailed explanation of the various aspects of Hypothesis Tests as they pertain to the given problem. Calculations have been shown both in text and EXCEL for better understanding. The solution provides students with a clear perspective of the underlying concepts.

$2.19