Soccer player

Click Here to Download this Answer Instantly

 

This criterion is linked to a Learning Outcome Writing Quality: Was the paper easy to read – well-organized, grammatically correct, correct spelling etc.? (Overall grade may be adjusted accordingly)
This criterion is linked to a Learning Outcome Quality of Data Analysis: Did you incorporate data from the case into a meaningful analysis? Do you use the numbers to evaluate alternatives and justify a recommendation? Are your calculations accurate, appropriate, and directly relate to the problem you identified?
This criterion is linked to a Learning Outcome Recommendation: How convincing is your recommended course of action? Is it justified and supported by evidence? Did you critically evaluate the recommendation in terms of pros and cons? Does the recommendation make sense given your analysis?
This criterion is linked to a Learning Outcome Alternative Identification: How plausible are the alternatives you identify? How thoughtfully are they developed? Do you address pros and cons?
This criterion is linked to a Learning Outcome Situation Analysis: Did you summarize the key factors most relevant to the case?
This criterion is linked to a Learning Outcome Problem Statement Definition: How precisely have you identified the problem? Did you identify the true problem and not just symptoms of the problem?
BUSI 275 Extra Credit (5%)
Transfer Value of Soccer Player
Student Name:
Student Number:
Instruction:
(1)   The extra credit work is due April 27th at noon, please submit through Connect. There will be no extension.
(2)   All your answers must be written in word—please copy & paste all your relevant analyses from Excel to this word document.
(3)   Please note that I do expect different students write different answers.
(4)   I will not answer any questions regarding the Extra Credit.
(5)   5% is based on the quality of your work.
You want to study factors that decide the transfer value of soccer players. The valuation of soccer players is determined by several factors, such as player characteristics and performance data. Because being equipped with talented players is essential for professional soccer team’s successful performance, professional clubs in top soccer leagues attempt to maintain a competitive squad by purchasing and selling players. Prior to a transaction, management and experts work collectively to explore both qualitative and quantitative variables to compute a fair price to be paid to (or received from) another team in exchange for a particular player. Due to the subjective nature and countless variables that are taken into account when valuing a player, the transfer value can be quite arbitrary and did not necessarily represent a player’s true market value.
The Excel file “Extra Credit_Transfer Value of Soccer Player” contains data for 77 transfers of notable offensive soccer players (i.e. midfielders and forwards) that moved to another team between 2009 and 2015. Let’s understand factors that are related to a players’ value and also build a functioning model that could predict a player’s market value.
Here are the explanation of the variables:
GBP: the player’s transfer price in British pounds
Y-5: Appearance over total number of league games (utilization ratio) five years prior to transfer
Y-4: Appearance over total number of league games four years prior to transfer
Y-3: Appearance over total number of league games three years prior to transfer
Y-2: Appearance over total number of league games two years prior to transfer
Y-1: Appearance over total number of league games one year prior to transfer
WA: weighted average of utilization ratio in league games over the past five years (seasons)
Goals: total number of goals scored in league games over the past five years
App: total number of appearance in league games over the past five years
G/A: ratio of goals to appearance in league games over the past five years
Age: player’s age at the time of transfer
Height: height of player
Pos: player’s position—OFF for offensive position, such as striker and wingers, MID for offensive midfielder
Foot: dominant foot—L for left, R for right, B for both
CR: Club ranking of the team that is selling the player in categories: 1=top eight in league ranking over the past five years; 2=below top eight in league ranking over the past five years
NR: FIFA ranking of the player’s national team in categories: 1=almost always enters round 16 in the FIFA World Cup, and has a high probability of reaching the semi-finals; 2=often enters round 16, but has a low probability of reaching the semi-finals; 3=often does not enter round 16, and has a very low chance of reaching the semi-finals.
Questions:
1.      With all the variables provided in the Excel, intuitively, discuss which ones you think are important determinants for soccer players’ transfer value. Please note that not all variables are necessarily important in this study.
2.      For some categorical variables, if you think they are important determinants for players’ transfer value, create dummy variables for them. Please note that you will only need to do this for the categorical variables you believe are important.
3.      For the variables that you think are important from question 1 and converted to dummy variables in question 2, make the correlation table and identify whether there’s any multicollinearity problem.
4.      Run regression to determine factors that are related to players’ transfer value (as measured by the variable “GBP”). Copy and paste your regression result to the word and briefly discuss the following:

Case Analysis Rubric Case Analysis Rubric

Criteria Ratings Pts

This criterion is linked to a Learning Outcome Problem Statement Definition: How precisely have you identified the problem? Did you identify the true problem and not just symptoms of the problem?

The problem is to determine the market value of each soccer player. This market value is essential for success of a team in league. It will help clubs to spend their money in most effective way. The determination of variable on which the market value of each player depends, is the main problem.

10.0 pts Full Marks 0.0 pts No Marks 10.0 pts

This criterion is linked to a Learning Outcome Situation Analysis: Did you summarize the key factors most relevant to the case?

The purchasing and selling of player by club depends on the market value of each player. The market value depends on both qualitative and quantitative aspects of each player. As there are many variables which may affect the market value of each player, therefore sometime the market value is arbitrary. Due to which there are possible markups and markdowns in market value in new setting.

10.0 pts Full Marks 0.0 pts No Marks 10.0 pts

This criterion is linked to a Learning Outcome Alternative Identification: How plausible are the alternatives you identify? How thoughtfully are they developed? Do you address pros and cons?

Two alternatives have been used, one is the correlation and other is the regression analysis. The correlation suggests that there is no strong correlation of each variable to market value on individual basis and even some of them do have negative correlation. But when using the regression analysis the quantitative variable gives the correct answer. However, the qualitative variables such as position, foot, NR and CR have not been included in the analysis.

10.0 pts Full Marks 0.0 pts No Marks 10.0 pts

This criterion is linked to a Learning Outcome Recommendation: How convincing is your recommended course of action? Is it justified and supported by evidence? Did you critically evaluate the recommendation in terms of pros and cons? Does the recommendation make sense given your analysis?

It is recommended to use regression analysis technique to determine the market value of each player, it is evident from the fact that the average market value is 34.20 and the regression equation gives the value of 34.64, which is near to the average market value.

20.0 pts Full Marks 0.0 pts No Marks 20.0 pts

This criterion is linked to a Learning Outcome Quality of Data Analysis: Did you incorporate data from the case into a meaningful analysis? Do you use the numbers to evaluate alternatives and justify a recommendation? Are your calculations accurate, appropriate, and directly relate to the problem you identified?

The data from the case has been used properly to use the two techniques which evident from the fact that they give accurate answer as the average value are equal to value determined by regression analysis. The qualitative variables have not been used correctly as they will have no major impact on the market value of each player; once again it is evident from the fact that exclusion of those variables produces the correct result.

50.0 pts Full Marks 0.0 pts No Marks 50.0 pts

This criterion is linked to a Learning Outcome Writing Quality: Was the paper easy to read – well-organized, grammatically correct, correct spelling etc.? (Overall grade may be adjusted accordingly)

Yes it was easy to read and understand the case study and it did not create much problem in understanding the fact and the use of data given in excel sheet.