ANOVA & Final Synthesis Week 8 Assignment
2 min read 1. Capstone Mini Report (3 pages): Choose a small dataset relevant to your interests. Perform descriptive statistics, confidence intervals, hypothesis tests with ANOVA/regression as appropriate, and interpret the results in context. Include visual displays (charts, tables) and clear narrative.
Excel Directions:
1. ANOVA (one-way):
a. Use Data → Data Analysis → ANOVA: Single Factor.
b. Select grouped data for different categories.
c. Excel generates ANOVA table with Between-group, Within-group variance, F-statistic, and p-value.
2. For post-hoc tests (if supported): Excel’s built-in is limited; you might compute pairwise t-tests with Bonferroni corrections manually or use supplemental tools.
3. For final project:
a. Use Excel to compile descriptive stats, compute confidence intervals, run hypothesis tests/regressions/ANOVA as needed.
b. Create charts and tables (histograms, scatterplots, boxplots) using Excel’s chart features.
c. Use cell references so results update if data change.
d. Export charts and tables to embed in your report.
Submission Instructions:
[Enter the expectations for the student’s submissions. Samples are below]
· A 3–5-page Word Document
· Must include a title page, abstract, and references. These are not counted in the page count/slide count.
Be sure to review the following prior to submitting your assignment:
· Academic Integrity Guidelines [content page]
· Assignment Rubric
· If you do not see the rubric, in the blue horizontal navigation bar select Course Tools, then Assignments. Select the appropriate assignment, and the rubric will be located near the bottom of the page.
This assignment aligns with the following:
· Course Objectives 3, 4, 5 & 6 [content page]
· Learning Objectives 1.1 & 2.3 [content page]
Resources & Supports
· Office 365 [wepbage]: You have free access as an APUS student. Sign in with your MyCampus Email credentials.
· Submitting and Confirming a Submission : Watch this 3-minute video if you need guidance on submitting your assignment.
