Perform a two-tailed hypothesis test

Question

Discussion:

Using AIU's survey responses from the AIU data set, complete the following requirements in the form of a report:

Perform a two-tailed hypothesis test on both the legal services satisfaction and the sentence satisfaction variable's data using a .05 significance level.

Begin by creating a null and an alternate statement.

Use Microsoft Excel to process your data.

Identify the significance level, the test statistic, and the critical value.

State whether you are rejecting or failing to reject the null hypothesis statement.

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

Key to Criminal Justice Satisfaction Survey
Gender
1 Female
2 Male
Age
1 16 - 21
2 22 - 49
3 50 - 65
Type of Crime
1 Homicide
2 Robbery
3 Burglary
Facility
1 Federal Prison
2 State Prison
Length of Sentence
1 Less than 2 years
2 2 to 5 years
3 Over 5 Years
CJ System Scale from 1-7
1 = Least Satisfied
7 = Most Satisfied
Legal Services Scale from 1-7
1= Least Satisfied
7= Most Satisfied
Sentence Scale from 1-7
1 = Least Satisfied

Gender	Age	Type of Offense	Facility	Length of Sentence	CJ System	Legal Services	Sentence Satisfaction	Incarceration Services
1	3	3	1	1	4.2	6.2	5.5	4.7
1	1	1	1	3	4.5	4.2	3.6	3.2
1	1	1	2	1	6.5	6.2	3.8	5.1
1	2	2	1	2	5	4.3	5.6	5.3
1	1	3	2	3	6.4	3.2	5.5	5.7
2	1	3	1	1	5.1	4.5	4.4	5.5
2	2	2	2	3	5.3	4.7	3.1	5.2
2	1	1	1	1	3.7	5.3	6.9	5.1
2	3	3	1	3	5.5	4.9	4.6	5.6
2	2	1	2	3	5.3	3.4	6.8	5.5
2	3	3	1	1	5.2	5.5	5.5	5.9
2	3	2	1	1	5.1	5.8	3.8	5.2
2	2	1	1	3	6.5	6.2	3.2	5.3
2	2	2	2	2	5.3	4.2	4.6	4.7
2	1	3	2	1	5.9	5.7	6.5	5.4
2	1	1	1	3	6.8	6.4	6.1	4.2
2	3	3	1	1	5.1	3.7	3.9	3.2
2	2	1	2	2	5.7	6.2	4.6	6
2	1	2	2	2	6.2	6.5	5.5	5.7
2	3	2	1	2	4.3	5.1	4.4	5.6
2	2	3	2	2	4.5	6.2	4.7	5.4
2	2	1	1	3	5.9	6.3	6.2	4.3
2	3	1	2	1	5.4	6.3	4.7	6.2
2	1	3	2	2	6.9	5.2	5.5	6.3
2	2	2	2	1	5.6	4.6	4.8	5.6