Does average number of total touchdowns for the season differ between teams in the divisions of the NFL? Use the “NFL TDs per Division” tab in the ANOVA Datasets file.
Obtain Summary Statistics and Create a Side-by-Side Boxplot
- Create a side-by-side boxplot. Include a title and axis labels.
- Create a table of the mean, standard deviation and sample size for each group.
- Save your table and chart to copy into your analysis.
Conduct an Analysis of Variance in excel.
- Use your option's question of interest to state the null and alternative hypotheses.
- Use the data analysis toolpak to obtain an ANOVA table.
- Save and show your work for your post.
Ways to show your work:
- Use the math formula button in Canvas.
- Take a screenshot of your excel workbook. Only the work part not the entire screen.
- Take a screenshot of handwritten work on a tablet.
- Neatly hand-write your formulas on paper take a picture with your phone and upload the image within your post. Image needs to .jpeg. (please no words/sentences)
Explain your analysis and Submit your Original Post
Use the "Original Post - Outline & Prompts" to Create Your Original Post
- Use the title "Week 8 Data Analysis"
- Use the same headers as listed below (e.g., "State and Visualize") in your post.
- Answer each question/prompt in the bulleted list below each heading in your post.
- For the math related questions, please show your work or excel functions you used to find your answers.
State and Visualize
- Which option did you choose? What is this analysis about?
- Provide a table of means, standard deviations, and sample sizes.
- Include and describe a Side-by-side boxplot. Add a title. Add axes labels. Is there visual evidence the means differ?
Plan
- State the null and alternative hypotheses to answer the question of interest.
**Many of the analyses do not meet conditions. For academic purposes skip checking conditions and just practice completing the analysis and reading the results.
Solve
- Provide the ANOVA table from excel.
Conclude
Write a four-part conclusion describing the results.
- Provide a statement in terms of the alternative hypothesis.
- State whether (or not) to reject the null (use alpha of 0.05)
- Include context and practical insights or plausible implications from the results of the data.
Information of statistics attached below