This criterion is linked to a learning outcome writing quality

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: