Last week you focused on choosing the appropriate statistical test. In this week’s assignment, you will apply that knowledge and actually practice using Excel to conduct a statistical test by completing a worksheet on using Excel for statistical testing. Understanding how to conduct a step-by-step statistical analysis in Excel could be important to future research or career endeavors.
Complete the Course Project Worksheet – Using Excel for Statistical Testing.
Refer to Measures of Association and Tests of Significance in Excel for help with this assignment.
Ensure your assignment addresses the criteria in the grading rubric.
RES/710 v5
Course Project Worksheet – Using Excel for Statistical Testing
RES/710 v5
Page 2 of 2
Course Project Worksheet – Using Excel for Statistical Testing
Last week’s assignment required a review of various statistical tests. Earlier this week, in Discussion 1, you explored which test might be most appropriate given your chosen variables. Now is your time to practice running the statistical test and analyzing the data. Complete each of the items below:
1. Which statistical test (T-Test, ANOVA, Chi-Square, or Regression) did you choose for your variables?
[Enter your response here.]
2. Explain why you chose this test.
[Enter your response here.]
3. Next, using Excel (refer to the handouts from this week for step-by-step instructions), run the statistical test you chose above and paste the output below.
[Paste Excel output here.]
4. Analyze the results.
[Enter your response here.]
References
[List references according to APA guidelines.]
Copyright 2021 by University of Phoenix. All rights reserved.
Copyright 2021 by University of Phoenix. All rights reserved.
