Is there a difference between the average number touchdowns between conferences in the National Football League? Use the 2023 NFL Season Stats data to test whether there is a significant difference between average total season Touchdowns among teams of the AFC and NFC. Use variables total_TD and Conference. Data attached below
Create a summary table and side-by-side boxplot.
- Create a table with the mean, standard deviation and sample size of each group. Save your table to copy into your analysis.
- Create a side by side boxplot. Include a title and axis labels. Save as an image to upload into your post.
Conduct a hypothesis test and calculate a 90% confidence interval
- Use your option's question of interest to state the null and alternative hypotheses.
- Using your sampled information calculate the test statistic and obtain a p-value. You can use excel or pen and paper.
- Using your sampled information calculate the confidence interval. You can use excel or pen and paper.
- 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 6 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? State the question of interest.
- Provide summary statistics and graphical display of your sampled data.
Plan
- State the null and alternative hypotheses to answer the question of interest.
- Describe whether it is (or is not) fair to assume the sample is an unbiased representation of the population of interest.
- Justify whether the sample sizes for each group are large enough to meet the conditions.
Solve
- Calculate the test statistic. Show work.
- What is the p-value? Is it one or two sided?
- Calculate a 90% confidence interval. Show work.
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.10)
- Give an interpretation of the point and interval estimate. Be sure to include a direction to your estimate like which mean is bigger/smaller than the other.
- Include context and practical insights or plausible implications from the results of the data.