Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using this dataset I created, NFLStandings, how would I make a table that displays the min, max, and average of each statistic (margin of victory,

Using this dataset I created, "NFLStandings", how would I make a table that displays the min, max, and average of each statistic (margin of victory, strength of schedule, etc.) for each year 2015-2019? This is in R. Please help

image text in transcribed

I started by combining team (city) and team name together because there was no reason to have two seperate columns. Then I narrowed down the data to only showing 2015 to 2019 because I got into football around 2015 and I want to see which teams were the best and worst during that time period. Then I put the teams in order of decreasing wins, so the teams with the most wins were shown at the top for each year. Lastly, for this project, I wanted to focus on margin of victory, strength of schedule, simple rating, and offensive and defensive rankings, so I left out the points for, against, and differential, becausee margin of victory calculates those statstics into it. NFLStandings %>% unite(team, team name, sep = iI") %>% filter ( year >2014)%>% arrange(year, desc(wins)) %% select(team, year, wins, loss, margin_of_victory, strength_of_schedule, simple_rating, offensive_ranking, defensive_ranking, playoffs, sb_winner) NFLStandings %>% head

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Databases Technologies And Applications

Authors: Zongmin Ma

1st Edition

1599041219, 978-1599041216

More Books

Students also viewed these Databases questions

Question

9. Who would drink more pure watersomeone wit

Answered: 1 week ago

Question

=+ Are they breakable for any reason?

Answered: 1 week ago

Question

Explain the function and purpose of the Job Level Table.

Answered: 1 week ago