Perform hypothesis testing on variabl''s data

Question

Assignment:

Using AIU's large database of survey responses from the AIU data set, complete the following:

Perform hypothesis testing on one variable's data. (Choose either the intrinsic or extrinsic column.) Perform a t-test by formulating a null and an alternative statement, choosing an acceptable significance value, selecting the test statistic and determining its value from the sample data, comparing the observed value to the critical value obtained and determining whether to reject or fail to reject the null hypothesis. Make sure to view the attachment file.

In a separate paragraph, provide some information on when to use a t-test and when to use a z-test and why. Also, provide some information about why samples are used instead of populations.

1) Using the entire data set of 288 responses as if it were a the general population of workers choose a sample of 30, work through a t-test using data from either the extrinsic or intrinsic variables-(e.g. testing the claim that the mean extrinsic satisfaction of of the population is 5.0) following the steps noted below:
1. Name the variable picked for the test and briefly describe the sampling procedure used to select the sample of 30 data points for the variable the sampling. Paste the 30 data points used in the analysis, below this table.

a. State clearly the claim being tested

b.The Null Hypothesis (in equation format)

c.The Alternate Hypothesis (in equation format) (indicate whether the set-up is a one-tailed or two-tailed test)

d.The significance level selected and explanation for choice

e.The t-test statistic formula used and calculations and result

f.The critical t value(s) with explanation

2.Conclusion from the test and explanation: (We reject OR we fail to reject the Null and why)

a. Explain when a t-test is used, and when a z-test is used, and why.

b. Explain clearly and completely why samples are used in hypothesis testing instead of populations.

KEY TO JOB SATISFACTION SURVEY
Gender
1 Male
2 Female
Age
1 21 and under
2 22-49
3 50 and over
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
OVERALL Scale from 1-7
1 = Least Satisfied
7 = Most Satisfied
INTRINSIC Scale from 1-7
1= Least Satisfied
7= Most Satisfied
EXTRINSIC Scale from 1-7
1 = Least Satisfied
7 = Most Satisfied
BENEFITS Scale from 1-7
1= Least Satisfied
7= Most Satisfied

GENDER	AGE	DEPT	POSITION	TENURE	OVERALL	INTRINSIC	EXTRINSIC	BENEFITS
1	2	2	1	1	2.2	1	1	6
1	2	2	1	1	1	2	1	4.5
1	3	2	1	3	3.8	2	1.5	4.7
1	2	2	1	1	1.8	3	3	5.2
1	2	2	1	3	5	3.5	5	4.3
1	2	2	1	2	2	3.7	6	5.2
1	2	3	1	3	3	3.7	5	6.1
1	2	3	1	1	4	3.7	7	5.7
1	2	2	1	1	4.6	3.8	6	5.7
1	1	1	1	2	4.6	3.8	6.5	6.1
1	2	3	1	2	2.2	4	2.5	6
1	1	3	1	2	3.8	4	5	4.2
1	1	1	1	2	2.2	4.1	4.5	4
1	1	2	1	2	3.6	4.1	4.5	5
1	2	3	1	3	4	4.1	6.5	5.8
1	2	3	1	2	4.6	4.1	6.5	6
1	2	3	1	1	5	4.1	6	4.7
1	2	3	1	1	3	4.2	5.5	7
1	2	3	1	2	4.8	4.2	6	5.2
1	3	3	1	3	5.2	4.2	4	6.5
1	3	2	1	1	6.2	4.2	4	5.8
1	2	2	1	1	3.8	4.3	4	5.7
1	2	3	1	1	4	4.3	6	6.5
1	1	3	1	1	4.2	4.3	5	4.6
1	2	2	1	1	4.6	4.3	6	5
1	2	3	1	1	4.6	4.3	6.5	1
1	2	2	1	1	5.8	4.3	5	6.5
1	3	3	1	3	2.4	4.4	6	4.4
1	2	3	1	2	1	4.5	5	6.3
1	2	3	1	1	2.6	4.5	4	5.6
1	2	3	1	1	2.8	4.5	1	3.5
1	2	3	1	1	3.4	4.5	4	5.5
1	2	3	1	3	3.4	4.5	6	5.3
1	2	3	1	1	4.6	4.5	4.5	3
1	3	2	1	1	4.6	4.5	3	5.2
1	2	3	1	1	4.8	4.5	6	6.8
1	1	2	1	1	4.8	4.5	5.5	4.5
1	2	3	1	1	6.4	4.5	6	4.3
1	1	2	1	1	2	4.6	2.5	5.1
1	2	3	1	3	3.2	4.6	4	4.2
1	2	2	1	1	4	4.6	4	3.3
1	2	3	1	1	4	4.6	4	4.2
1	2	2	1	1	5.4	4.6	6	6
1	2	3	1	1	3.4	4.7	6	4.3
1	2	3	1	2	4.6	4.7	5.5	4.5
1	3	3	1	3	4.6	4.7	4	5.2
1	2	3	1	2	2	4.8	6.5	5
1	2	2	1	2	3.2	4.8	6	6.7
1	2	3	1	1	3.4	4.8	6	3.7
1	1	3	1	2	3.6	4.8	4	7
1	2	2	1	3	3.6	4.8	2.5	6.1
1	2	2	1	2	4.2	4.8	4.5	5.8
1	2	3	1	1	5	4.8	6	5.6
1	2	2	1	2	5	4.8	5	5.2
1	2	2	1	1	5.4	4.8	6.5	4.6
1	3	2	1	3	1	5	1	5.1
1	3	3	1	1	3.2	5	6	5
1	2	3	1	1	3.6	5	4.5	5
1	1	1	1	2	3.6	5	4.5	5.3
1	2	3	1	1	3.8	5	1	5.3
1	2	2	1	2	3.8	5	5.5	6.4
1	2	3	1	1	4	5	7	5
1	2	2	1	1	4.2	5	6	6.2
1	1	3	1	1	4.6	5	3.5	5
1	3	3	1	1	4.6	5	6	7
1	3	3	1	1	4.6	5	6	5
1	2	3	1	1	4.6	5	6	3.9
1	2	2	1	2	4.6	5	4	5.5
1	2	3	1	1	4.8	5	6	4.3
1	2	3	1	1	5	5	4	6.2
1	2	3	1	1	5	5	7	5.5
1	2	3	1	2	5	5	5	5.2
1	2	3	1	1	5.2	5	6	5.1
1	2	3	1	3	5.4	5	6	6.2
1	1	3	1	1	5.5	5	6	5.7
1	2	3	1	3	5.8	5	6	4.5
1	2	3	1	1	6	5	7	5.9
1	3	3	1	1	6.2	5	6	4
1	3	2	1	2	6.6	5	6.5	4.3
1	2	2	1	3	3.2	5.1	1	3.9
1	3	3	1	3	1.8	5.2	5.5	5
1	1	2	1	1	2.2	5.2	5.5	3.5
1	2	3	1	1	4	5.2	2	5.2
1	2	3	1	1	4.2	5.2	2	5
1	2	2	1	1	4.6	5.2	3	6.1
1	2	3	1	2	4.6	5.2	6	2.6
1	1	3	1	2	4.8	5.2	4	5.9
1	2	3	1	1	5.2	5.2	5.5	5.3
1	2	3	1	1	6.6	5.2	5.5	4.5
1	2	3	1	1	2.4	5.3	6	5.2
1	1	2	1	2	2.6	5.3	4	5.4
1	1	2	1	2	3	5.3	6	4.5
1	2	3	1	1	3.4	5.3	2	4.8
1	3	3	1	1	3.6	5.3	6	5.5
1	2	2	1	1	4.6	5.3	3	4.7
1	1	2	1	2	5	5.3	5.5	3.5
1	1	3	1	1	5.4	5.3	6	3
1	2	2	1	1	5.6	5.3	5	5.1
1	2	3	1	1	2.6	5.5	6	6.2
1	1	3	1	2	2.8	5.5	5.5	7
1	2	3	1	1	3.8	5.5	4	4.7
1	3	3	1	1	4	5.5	6	3.8
1	2	3	1	1	4.8	5.5	4.5	6.8
1	2	3	1	1	4.8	5.5	6	4.2
1	1	2	1	2	1.6	5.6	5	5
1	2	3	1	1	4.4	5.6	4.5	6.3
1	1	2	1	2	4.6	5.6	2	5.2
1	2	2	1	1	5.4	5.6	4	5.2
1	3	3	1	1	2.8	5.7	1.5	5
1	3	3	1	3	5.2	5.7	5.5	5.7
1	3	3	1	1	5.4	5.7	6.5	5
1	2	3	1	1	5.4	5.7	7	3
1	1	3	1	2	5.6	5.7	6	6.2
1	2	3	1	1	6.2	5.7	7	4.3
1	2	3	1	1	4.2	5.8	6	6.3
1	1	3	1	1	4.2	5.8	4	4.3
1	2	3	1	3	5.6	5.8	6	5
1	2	2	1	3	5.8	5.8	5	5.1
1	2	3	1	3	6.2	5.8	4	4.7
1	2	3	1	3	5.8	5.9	6	4.5
2	2	3	2	1	1.6	2.6	4	6.5
2	1	2	2	1	1.8	3	4	7
2	2	3	2	3	3.2	3	6	7
2	2	3	2	2	5	3.1	4.5	3.8
2	2	2	2	1	5.4	3.1	5	4.8
2	1	2	2	3	3.8	3.2	3	5
2	2	3	2	3	4.4	3.4	6	5
2	1	1	2	2	4	3.5	3	5.8
2	2	3	2	1	4.2	3.5	1.5	6.4
2	2	2	2	2	4.4	3.5	4.5	5.6
2	1	2	2	3	3	3.6	4	2.6
2	2	3	2	2	2	3.7	1.5	5.3
2	2	2	2	3	2.6	3.7	3	4.7
2	3	2	2	1	3.2	3.8	4	6.1
2	2	3	2	2	1.8	4	1	4.2
2	1	2	2	1	2.6	4	5	3.5
2	2	1	2	3	4	4.1	4	4.7
2	3	3	2	1	3.6	4.2	6	6.3
2	2	2	2	2	3.6	4.2	2	5.7
2	2	2	2	3	4.2	4.2	3	6
2	3	2	2	3	4.4	4.2	3.5	3.8
2	2	3	2	1	1.8	4.3	3	5
2	2	2	2	1	2.8	4.3	5.5	5
2	2	3	2	1	3.2	4.3	2.5	5.6
2	3	3	2	1	4.6	4.3	5.5	3
2	1	1	2	2	4.6	4.3	5	5.3
2	2	2	2	2	2	4.5	7	4
2	1	2	2	2	2.8	4.5	6	4
2	3	3	2	1	3.4	4.5	6	4.2
2	2	3	2	1	4	4.5	6	7
2	1	2	2	2	4	4.5	1.5	5
2	2	2	2	2	4	4.5	4	5.8
2	3	3	2	1	4.2	4.5	6	3.6
2	2	3	2	1	4.6	4.5	5.5	4.5
2	2	3	2	1	4.8	4.5	6.5	6.2
2	2	2	2	3	4.8	4.5	4	6.5
2	2	3	2	1	5.4	4.5	7	4
2	2	2	2	1	5.8	4.5	5	5.9
2	2	2	2	2	4	4.6	6	4.7
2	3	3	2	1	5.2	4.7	6	5
2	2	3	2	1	3.8	4.8	4	6.7
2	3	3	2	1	3.8	4.8	7	6.5
2	2	3	2	3	4.2	4.8	4	5.5
2	2	3	2	1	6.2	4.8	4.5	7
2	3	3	2	1	2	5	6	5.7
2	3	2	2	1	2.6	5	1	4.3
2	2	3	2	1	2.8	5	1	6.4
2	2	3	2	1	3	5	6	5.3
2	2	2	2	1	3.2	5	5.5	2
2	1	1	2	2	3.8	5	6	4
2	2	3	2	1	4.4	5	7	6.2
2	2	2	2	1	4.8	5	7	5
2	2	3	2	1	4.8	5	2	4.5
2	3	2	2	2	4.8	5	6	5
2	3	3	2	1	5	5	2	4.6
2	2	2	2	3	5.2	5	6	4.7
2	2	3	2	3	5.4	5	6.5	5
2	3	3	2	2	7	5	6	7
2	2	3	2	1	1	5.1	1	4.5
2	2	3	2	1	1.6	5.1	4	6.2
2	1	2	2	2	2	5.1	1.5	5
2	2	2	2	2	4	5.1	4	5.2
2	1	2	2	1	5	5.1	4	4.3
2	1	2	2	2	4	5.2	5	3.2
2	2	2	2	2	5	5.2	6	6.6
2	2	3	2	1	5.6	5.2	6	5.6
2	2	3	2	2	5.6	5.2	5	7
2	2	3	2	3	1.8	5.3	6	6
2	2	3	2	1	2	5.3	1.5	4.2
2	2	3	2	3	2.4	5.3	3.5	7
2	2	3	2	1	2.8	5.3	3	4.2
2	2	2	2	1	3	5.3	6	4.5
2	2	3	2	1	3.2	5.3	1.5	4.3
2	2	2	2	3	3.8	5.3	6	5.1
2	1	3	2	1	4	5.3	6.5	6.1
2	3	3	2	3	4.4	5.3	5	4.6
2	1	2	2	1	6	5.3	7	4.2
2	2	3	2	1	3.4	5.5	6	6.3
2	2	2	2	2	3.6	5.5	3	6
2	3	3	2	1	4	5.5	6	3.7
2	3	2	2	1	4	5.5	6	5.7
2	2	3	2	3	4.4	5.5	7	5
2	2	3	2	3	5.8	5.5	6	3.5
2	2	3	2	1	4.4	5.6	6	5.3
2	2	3	2	1	5.8	5.6	7	5
2	3	3	2	1	2	5.7	6	4.5
2	2	3	2	1	3.2	5.7	4.5	6.1
2	2	2	2	1	3.8	5.7	6	5
2	2	3	2	3	2.2	5.8	1.5	4.6
2	3	3	2	3	5.6	5.8	6	5.5
2	1	3	2	1	5.8	5.8	3.5	6.4
2	2	3	1	2	6.2	5.9	2	4.2
2	3	2	2	1	2	5.9	2	5.1
2	1	3	1	1	3.8	6	6	4.5
2	1	2	1	1	4.2	6	6	5
2	2	2	1	1	5.8	6	5	6.4
2	2	3	2	2	2.6	6	2	5.7
2	1	2	2	2	3.6	6	7	4.5
2	2	2	2	2	4.2	6	7	4.8
2	3	2	2	2	5.2	6	5.2	5
2	2	2	2	3	5.6	6	5	6.4
2	2	2	1	1	3.6	6.1	2	5
2	2	2	1	2	3.6	6.1	4	6.5
2	2	3	1	1	4.6	6.1	3	6.7
2	1	3	1	1	5	6.1	7	5.6
2	1	1	1	2	5	6.1	5.5	5.1
2	2	2	1	2	6	6.1	1	6.4
2	1	3	1	1	6.2	6.1	6	4.2
2	2	3	1	1	6.6	6.1	2.5	4.8
2	2	2	2	3	3.4	6.1	6	4.5
2	2	3	2	3	4	6.1	5	5.5
2	2	3	1	1	4.8	6.2	6.5	6.5
2	3	3	1	1	5	6.2	7	5
2	2	2	1	1	5.6	6.2	6	5
2	2	3	1	1	5.8	6.2	7	5.2
2	2	3	2	1	3.8	6.2	5	6.2
2	2	3	2	1	4.2	6.2	6	5
2	2	2	2	1	5.6	6.2	4.5	5.8
2	2	3	2	1	5.8	6.2	3	4.1
2	2	2	1	1	4.6	6.3	6.5	5.2
2	2	3	1	3	5.2	6.3	6	5.7
2	2	3	1	1	5.6	6.3	6	4.7
2	3	3	2	1	3.4	6.3	5.5	5
2	3	3	2	1	3.8	6.3	5.5	5
2	2	2	2	1	4.6	6.3	7	3.9
2	2	2	2	1	4.8	6.3	5	6.2
2	3	3	2	3	5.4	6.3	5.5	3.6
2	2	3	2	3	5.4	6.3	5.5	5.5
2	3	2	2	2	6	6.3	6.5	6.5
2	2	3	2	3	6.2	6.3	7	5.3
2	2	2	1	1	4	6.4	2.5	6.2
2	2	3	1	1	5.8	6.4	6	4.6
2	2	3	1	1	6	6.4	5	4.8
2	1	1	1	2	6.2	6.4	5.5	6.1
2	3	3	2	1	3.4	6.4	4	6.9
2	2	2	1	1	3.2	6.5	5.5	5
2	2	3	1	1	4.4	6.5	5.2	5.3
2	2	2	1	1	7	6.5	6	5.3
2	2	3	1	2	7	6.5	6	5.1
2	2	3	2	2	4.6	6.5	5.5	5.8
2	3	3	2	1	6	6.5	6.5	5.5
2	2	3	1	2	3.6	6.6	6	6.2
2	2	3	1	1	6	6.6	3	4
2	2	3	1	1	3.6	6.7	6	3.6
2	1	1	1	1	6	6.7	6	5
2	2	3	1	1	7	6.8	7	6.3
2	1	2	2	1	5.6	6.8	7	4.2
2	2	3	2	3	6	6.8	6	5.2
2	2	3	2	1	6.6	6.8	6	3.5
2	2	3	2	1	7	6.8	6	4.5
2	2	3	1	1	6.8	6.9	6	5.5
2	1	2	2	2	4.8	6.9	6	5
2	2	3	1	1	2.8	7	6	5.4
2	2	1	1	1	4.2	7	5.5	4.5
2	2	2	1	1	4.2	7	5.5	6.2
2	2	2	1	1	5.8	7	6	4
2	1	3	1	2	5.8	7	5.5	6
2	2	3	1	3	6	7	3	3.7
2	2	3	1	1	6.2	7	5.5	5.5
2	2	3	1	2	6.8	7	5.5	5.1
2	2	3	1	1	7	7	7	4.7
2	2	3	1	2	7	7	7	6.1
2	2	2	2	1	2	7	6	5.5
2	2	3	2	1	3.4	7	6	4.3
2	2	3	2	1	5	7	2.5	5
2	2	3	2	2	6.2	7	7	5.3
2	2	3	2	1	6.6	7	5.5	5.6
2	3	2	2	3	7	7	1.5	6.3