Submit the Excel template containing your work. Before submitting your assessment, verify you have included all of the elements listed above. Note: Be su

Submit the Excel template containing your work. Before submitting your assessment, verify you have included all of the elements listed above.

Note: Be sure to complete Assessment 3 before completing this assessment.

By completing Assessment 3, you are now in the position of having data and summary statistics for your survey. 

Use the Inferential Statistics to Analyze Data Template [XLSX] to complete this assessment. Review the "Example" sheet in the file first. Then use the corresponding information from Assessment 3 in the "Inferential Statistics" sheet of the template.

For this assessment, analyze data using inferential statistics for your previously defined survey questions. Before you begin your analysis, note the following:

• When using the Inferential Statistics to Analyze Data Template, note that there are two pages. Be sure to review each one carefully. The first page is the blank template that you will complete, and the second page is a completed example. Try to model your results on the ones shown.
• Enter the sample statistics (proportions and samples sizes for questions 1–4 as well as the sample means, standard deviations, and sample sizes for questions 5–6) in the respective fields of the template. The sample statistics were calculated for each survey question in Assessment 3. Use this prior work to complete this assessment. Note that the sample size must be the same for all six questions.

1. Calculate a 95% confidence interval for each of your survey questions (1–6). Your final product should have six confidence intervals.
2. Perform a hypothesis test for each survey question (1–6). Your final product should have six hypothesis tests.

A few notes:

• When determining the null and alternative hypotheses for each question, use the typical response values from Assessment 2. 
• You probably want to write the null hypothesis first. Then, the alternative hypothesis is the opposite of the alternative.
• Use the same numerical value for the two hypotheses. You cannot put one value for the null and another for the alternative.
• For questions 1–4, we are using the sample proportion to estimate the population proportion. For questions 5–6, we are using the sample mean to estimate the population mean. Thus, we use different formulas for their confidence intervals and for their test statistics in the hypothesis tests.

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and rubric criteria:

• Competency 3: Derive logical conclusions from inferential statistical procedures.
  • Compute 95% confidence intervals correctly for multiple variables in a study.
  • Derive appropriate conclusions based upon calculated confidence intervals for a study.
  • Choose appropriate hypothesis tests based upon the context of the questions asked.
  • Specify correct null and alternative hypotheses.
  • Calculate hypothesis tests correctly for multiple questions in a study.
  • Derive appropriate conclusions regarding hypotheses according to the results of hypothesis tests.