Hello excellent work for the survey you did. Can you do this weeks work for me as well. This includes the data set for this course which is attatched along with the instructions for this week assignment.

Using survey responses from the AIU data set, complete the following requirements in the form of a 2-page report:
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
•	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.
•	Identify the significance level, 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.
TEST #2
Perform the following two-tailed hypothesis test, using a .05 significance level:
•	Extrinsic variable by Position Type
•	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.
•	Identify the significance level, 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.
GENERAL ANALYSIS (Research Required)
Using your textbook or other appropriate college-level resources:
•	Explain when to use a t-test and when to use a z-test. Explore the differences.
•	Discuss why samples are used instead of populations.
The report should be well written and should flow well with no grammatical errors. It should include proper citation in APA formatting in both the in-text and reference pages and include a title page, be double-spaced, and in Times New Roman, 12-point font. APA formatting is necessary to ensure academic honesty.

Gender	Age	Department	Position	Tenure	Job Satisfaction	Intrinsic	Extrinsic	Benefits			
1	1	1	1	3	4.9	6.4	5.5	5.4			
1	3	3	1	1	4.9	5.2	4.6	4.2		KEY TO SURVEY	
1	1	2	2	1	4.9	5.3	5.7	2.3			
1	1	3	1	1	5.2	4.7	5.6	4.5		Demographics	
1	3	3	1	1	4.9	5.2	4.6	4.2			
1	1	2	1	2	6.9	5.4	4.1	4.8		Gender	
1	1	1	1	3	6.8	6.4	4.8	4.7		1	Male
1	1	2	1	2	2.2	4.7	4.7	4.7		2	Female
1	1	1	1	3	3.4	5.2	5.4	5.4		Age	
1	2	2	1	2	6.5	5.3	2.9	3.7		1	16 - 21
1	2	1	1	3	4.8	5.3	5.5	5.2		2	22 - 49
1	2	2	1	3	3.8	6.4	3.9	6.4		3	50 - 65
1	2	1	1	2	5.2	5.2	5.8	5.2		Department 	
1	2	2	1	2	3.4	5.2	5.2	5.3		1	Human Resources
1	3	1	1	1	5.5	6.4	5.8	4.7		2	Information Technology
1	3	2	1	1	2.4	5.2	5.9	6.4		3	Administration
1	3	3	1	1	3.5	5.3	6.4	5.2		Position	
1	3	3	1	2	6.9	4.7	5.7	4.7		1	Hourly Employee (Overtime Eligible)
1	3	3	1	2	5.5	6.4	5.8	5.4		2	Salaried Employee (No Overtime)
1	3	3	1	2	5.2	5.2	5.6	6.4		Tenure With Company	
1	3	3	1	2	5.7	1.2	5.4	4.7		1	Less than 2 years
1	1	3	1	2	5.5	2.4	2.3	5.2		2	2 to 5 years
1	1	1	1	2	4.9	5.3	5.6	5.4		3	Over 5 Years
1	1	1	1	3	4.9	6.4	5.5	5.4			
1	3	3	1	1	4.9	5.2	4.6	4.2		Four Survey Measures	
1	1	2	2	1	4.9	5.2	4.6	4.2			
1	1	3	1	1	5.2	6.4	5.5	3.5		SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7)	
1	3	3	1	1	4.9	5.2	4.6	4.2		1 = Least Satisfied	
1	2	2	1	1	5.2	5.3	5.7	2.3		7 = Most Satisfied	
1	2	1	1	2	5.2	4.7	5.6	4.5		SURVEY MEASURE #2 INTRINSIC JOB SATISFACTION (Scale 1-7)	
1	3	3	1	2	4.9	6.4	5.5	5.4		1= Least Satisfied	
1	2	2	1	3	5.9	5.2	4.6	4.2		7= Most Satisfied	
1	1	3	2	1	4.9	4.7	5.6	4.5		SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7)	
1	1	1	1	3	3.2	5.4	5.6	5.4		1 = Least Satisfied	
1	3	3	1	1	4.9	6.4	4.6	4.2		7 = Most Satisfied	
1	1	3	2	1	4.9	4.7	5.6	4.5		SURVEY MEASURE #4 BENEFITS (Scale 1-7)	
1	1	2	2	1	4.9	5.2	5.7	4.2		1= Least Satisfied	
1	1	3	1	1	5.2	5.2	4.6	4.2		7= Most Satisfied	
1	3	3	1	1	4.9	6.4	5.5	3.5			
1	1	2	1	2	6.9	4.7	5.6	4.5			
1	1	1	1	3	6.8	5.4	5.6	5.4			
1	1	2	1	2	2.2	5.2	4.6	4.2			
1	1	1	1	3	3.4	6.4	5.5	3.5			
1	2	2	1	2	6.5	5.2	4.6	4.2			
1	2	1	1	3	4.8	4.7	5.6	4.5			
1	2	2	1	3	3.8	6.4	5.5	5.4			
1	2	1	1	2	5.2	5.2	4.6	4.2			
1	2	2	1	2	3.4	4.7	5.6	4.5			
1	2	1	1	1	4.9	5.4	5.6	5.4			
1	1	1	2	3	4.9	6.4	4.6	4.2			
1	3	3	1	1	4.9	4.7	5.6	4.5			
1	1	2	2	1	4.9	5.2	5.7	4.2			
1	3	3	1	1	4.9	6.4	4.6	4.2			
1	2	2	1	1	5.2	4.7	5.6	4.5			
1	2	2	1	3	4.9	5.2	4.6	4.2			
1	1	1	1	3	3.2	4.7	5.6	4.5			
1	2	1	2	2	5.2	4.7	5.5	5.4			
1	2	2	1	3	4.9	5.4	4.6	4.2			
1	3	3	1	1	4.9	6.4	5.4	4.5			
1	2	2	1	1	5.2	5.3	5.7	2.3			
1	2	2	1	3	4.9	4.7	5.6	4.5			
1	1	1	1	3	3.2	5.2	4.6	4.2			
1	1	3	1	1	5.2	4.7	5.6	4.5			
1	3	3	2	1	4.9	4.7	5.6	4.5			
1	2	2	1	1	5.2	4.7	5.6	4.5			
1	2	3	2	3	4.9	4.7	5.5	5.4			
1	2	2	2	1	3.2	5.4	4.6	4.2			
1	2	2	1	1	4.9	6.4	5.4	4.5			
1	1	2	2	1	4.9	5.3	5.7	2.3			
1	1	3	1	1	5.2	4.7	5.6	4.5			
1	3	3	1	1	4.9	5.2	4.6	4.2			
1	2	2	1	1	5.2	4.7	5.6	4.5			
1	2	1	1	2	5.2	4.7	5.6	4.5			
1	3	3	1	2	4.9	5.4	5.6	5.4			
1	2	2	1	3	5.9	3.7	5.5	4.2			
1	1	3	2	1	4.9	5.2	4.6	4.2			
1	1	1	1	3	3.2	6.4	5.5	3.5			
1	3	3	1	1	4.9	5.2	4.6	4.2			
1	1	2	2	1	4.9	5.3	5.7	2.3			
1	1	3	1	3	5.2	4.7	5.6	4.5			
1	2	2	1	3	4.9	6.4	5.5	5.4			
1	3	3	1	1	4.9	5.2	4.6	4.2			
1	2	2	1	1	5.2	4.7	5.6	4.5			
1	2	2	1	3	4.9	5.4	5.6	5.4			
1	1	1	1	3	3.2	6.4	4.6	4.2			
1	2	1	1	2	5.2	4.7	5.6	4.5			
1	3	3	1	1	4.9	5.2	5.7	4.2			
1	1	3	2	1	4.9	5.2	4.6	4.2			
1	1	2	2	1	4.9	5.3	5.7	2.3			
1	3	3	1	1	4.9	6.4	5.5	5.4			
1	1	2	2	1	4.9	5.2	4.6	4.2			
1	1	3	1	3	5.2	5.3	5.7	2.3			
2	2	2	1	3	4.9	4.7	5.6	4.5			
2	3	3	1	1	4.9	5.2	4.6	4.2			
2	2	2	1	1	5.2	5.4	4.1	4.8			
2	2	2	1	3	4.9	6.4	4.8	4.7			
2	1	1	1	3	3.2	4.7	4.7	4.7			
2	2	1	1	2	5.2	5.2	5.4	5.4			
2	3	3	1	1	4.9	5.3	2.9	3.7			
2	1	3	2	1	4.9	5.3	5.5	5.2			
2	1	1	1	3	3.2	6.4	3.9	6.4			
2	2	2	1	1	5.2	5.2	5.8	5.2			
2	2	2	1	3	4.9	5.2	5.2	5.3			
2	2	1	1	2	5.2	6.4	5.8	4.7			
2	3	3	1	2	4.9	6.4	5.5	5.4			
2	2	2	1	3	5.9	5.2	4.6	4.2			
2	1	3	2	1	4.9	4.7	5.6	4.5			
2	1	1	1	3	3.2	5.4	5.6	5.4			
2	3	3	1	1	4.9	6.4	4.6	4.2			
2	1	3	2	1	4.9	4.7	5.6	4.5			
2	1	3	1	3	5.2	5.2	5.7	4.2			
2	2	3	1	3	4.9	5.2	4.6	4.2			
2	3	2	1	1	4.9	6.4	5.5	3.5			
2	2	2	1	1	5.2	4.7	5.6	4.5			
2	2	2	2	3	4.9	5.4	5.6	5.4			
2	1	3	2	3	4.9	5.2	4.6	4.2			
2	2	2	1	2	5.2	6.4	5.5	3.5			
2	3	3	1	1	4.9	5.2	4.6	4.2			
2	3	3	1	1	5.2	5.3	5.7	2.3			
2	2	2	1	1	5.2	4.7	5.6	4.5			
2	2	2	1	3	4.9	6.4	5.5	5.4			
2	1	1	1	3	5.9	5.2	4.6	4.2			
2	2	1	1	2	5.7	4.7	6.9	6.7			
2	3	3	1	1	5.1	5.4	6.8	2.1			
2	1	3	2	1	3.1	6.4	2.2	2.5			
2	1	2	2	1	2.3	4.7	3.4	3.1			
2	3	3	1	1	2.8	6.4	6.5	5.5			
2	1	2	2	1	6.9	5.2	6.9	5.7			
2	1	3	1	3	6.8	4.7	6.8	4.8			
2	2	2	1	3	2.2	5.4	2.2	4.6			
2	3	3	1	1	3.4	6.4	3.4	2.2			
2	2	2	1	1	6.5	4.7	6.5	2.5			
2	2	2	1	3	4.8	5.2	5.5	2.6			
2	1	1	1	3	3.8	4.7	2.4	2.8			
2	2	1	1	2	5.2	4.7	3.5	2.9			
2	3	3	1	1	3.4	5.4	6.9	5.4			
2	1	3	2	1	5.7	6.4	5.5	3.1			
2	1	1	1	3	5.1	5.3	5.2	2.5			
2	2	2	1	1	3.1	2.3	5.7	3.8			
2	2	2	1	3	2.3	4.5	5.5	3.4			
2	2	1	1	2	2.8	5.4	2.8	3.6			
2	3	3	1	2	6.9	4.2	3.4	2.5			
2	2	2	1	3	6.8	4.5	3.9	6.6			
2	3	2	2	3	2.2	3.1	2.2	6.8			
2	1	2	1	3	3.4	3.5	5.4	6.5			
2	1	3	1	2	6.5	3.7	2.3	6.5			
2	1	3	1	1	4.8	4.2	2.5	6.6			
2	2	3	1	1	3.8	5.8	2.1	6.8			
2	3	3	1	3	5.2	6.7	4.5	4.5			
2	3	3	1	3	3.4	2.1	4.1	4.2			
2	1	1	1	3	2.4	3.1	4.7	4.8			
2	1	1	1	2	3.5	5.5	5.4	2.8			
2	2	1	1	2	6.9	5.7	2.9	2.9			
2	3	1	2	1	5.5	4.8	5.5	5.4			
2	3	2	2	1	5.2	4.6	3.9	3.1			
2	3	2	2	3	5.7	4.7	5.8	2.5			
2	2	2	2	2	3.4	4.7	5.9	3.6			
2	3	2	2	2	3.9	5.4	6.4	2.5			
2	3	1	2	1	4.8	3.7	5.7	6.6			
2	1	1	2	1	3.8	5.2	5.8	6.8			
2	2	1	2	3	5.2	6.4	5.6	6.5			
2	3	1	2	3	3.4	5.2	5.4	6.5			
2	3	2	1	1	5.7	5.3	5.4	6.6			
2	2	2	1	3	5.1	4.7	2.3	6.8			
2	2	2	1	2	3.1	6.4	2.5	4.5			
2	1	2	1	1	2.3	5.2	2.1	4.2			
2	1	2	1	3	2.8	4.7	4.5	4.3			
2	1	2	1	2	6.9	5.4	4.1	4.8			
2	1	1	1	3	6.8	6.4	4.8	4.7			
2	1	2	1	2	2.2	4.7	4.7	4.7			
2	1	1	1	3	3.4	5.2	5.4	5.4			
2	2	2	1	2	6.5	5.3	2.9	3.7			
2	2	1	1	3	4.8	5.3	5.5	5.2			
2	2	2	1	3	3.8	6.4	3.9	6.4			
2	2	1	1	2	5.2	5.2	5.8	5.2			
2	2	2	1	2	3.4	5.2	5.2	5.3			
2	3	1	1	1	5.5	6.4	5.8	4.7			
2	3	2	1	1	2.4	5.2	5.9	6.4			
2	3	3	1	1	3.5	5.3	6.4	5.2			
2	3	3	1	2	6.9	4.7	5.7	4.7			
2	3	3	1	2	5.5	6.4	5.8	5.4			
2	3	3	1	2	5.2	5.2	5.6	6.4			
2	3	3	1	2	5.7	1.2	5.4	4.7			
2	1	3	1	2	5.5	2.4	2.3	5.2			

Using survey responses from the AIU data set, complete the following requirements in the form of a 2-page report:
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
•	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.
•	Identify the significance level, 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.
TEST #2
Perform the following two-tailed hypothesis test, using a .05 significance level:
•	Extrinsic variable by Position Type
•	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.
•	Identify the significance level, 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.
GENERAL ANALYSIS (Research Required)
Using your textbook or other appropriate college-level resources:
•	Explain when to use a t-test and when to use a z-test. Explore the differences.
•	Discuss why samples are used instead of populations.
The report should be well written and should flow well with no grammatical errors. It should include proper citation in APA formatting in both the in-text and reference pages and include a title page, be double-spaced, and in Times New Roman, 12-point font. APA formatting is necessary to ensure academic honesty.
Be sure to provide references in APA format for any resource you may use to support your answers.
NEED HELP?
•	Check out the Free Tutoring Available for BUSN311 students in the learning center. You will need to sign up for the tutoring.Do not wait, tutoring appointments fill up quickly.
•	Beginning Statistics Lab. Presentations and Resources are Available 24/7. Synchronous Live Sessions and Office Hours are held during the session. Live Sessions are also recorded for viewing at your convenience. Your instructor has the session-specific information.
•	The tutors and the lab instructor are qualified faculty members.
Please submit your assignment as a Word document in APA format using the attached Template.