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.

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..

Using AIU’s 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.
  • I am willing to pay $10 for this if it is done correctly and to me on time.

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. You will need to sign up for the tutoring. Your instructor has the session-specific information. Don’t 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.

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.

Posted in Uncategorized