Is there a difference between the average number touchdowns between conferences

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 PostUse 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.