stats nfl project

I. Data Set Requirements For this group project, you will first think about a relevant business problem. This may be a business problem that you are currently facing at work or that interests you, in general. You will then collect the relevant data (primary or secondary data) that will allow you to explore this business problem. If there are variables that may influence your business problem, but they are not in your data set, collect the data on the additional variables and merge it with your data set.

The question is “how does the front office and gms determine how much money x position should be paid each season?”

Get a list of a 150 quarterbacks in the nfl And the 10 variables should be

Player Performance Metrics: Historical statistics related to the player's performance, such as scoring averages, assists, rebounds, tackles, or other relevant metrics, are analyzed to gauge the player's on-field contribution.

Player Efficiency Metrics: Advanced analytics like Player Efficiency Rating (PER), Win Shares, Box Plus-Minus (BPM), etc., help evaluate the player's overall impact on the team's success.

Injury History: The player's injury history is taken into account to assess potential risks and durability.

Player Age: Age is a crucial factor as it affects a player's peak performance and potential longevity in the league.

Comparative Market Analysis: Front offices study contracts of players in similar positions, skill levels, and age brackets to identify market trends and establish a baseline for negotiations.

Team Salary Cap Situation: Teams have salary caps, which limit the total amount they can spend on player salaries. A team's current salary cap space influences how much they can offer a player.

Market Demand and Supply: The demand for players in a particular position and the supply of available talent in the free-agent pool affect salary negotiations.

Player's Leadership and Character: Leadership qualities, work ethic, and character may be considered as they impact team chemistry and overall performance.

Potential Upside and Development: Younger players or those with untapped potential may receive higher salaries based on expected future growth.

Player's Popularity and Marketing Potential: For some sports, a player's popularity and marketability can influence their salary due to their impact on ticket sales, merchandise, and sponsorships.

Specifically, your data set MUST meet the following criteria... 1. Your data set should include a variety of data types (i.e., numerical, categorical). 2. Your data set should include no less than 10 variables with at least 150 observations each. Unique identifiers, company/team/individual names, etc. do not count as variables. 3. Your data set should be in Excel format (.xlsx). Convert .csv files to .xlsx if necessary. II. Group Project Milestone I Requirements For your group’s first milestone, you must complete the following... 1. What is your research question and why is it important? 2. Collect and build a data set that meets the requirements outlined in Part I of this document. 3. Calculate the descriptive statistics for each variable in your dataset using Excel's Data Analysis tool. Do not calculate descriptive statistics for unique identifiers. Present all descriptive statistics for each variable in a single table on a separate sheet in the Excel file. 4. Explore the data by creating the appropriate histograms, scatter plots, and/or box plots for each variable (don't forget to label each axis)