Data Analysis: Footballers' Earnings using Excel and Visualization

This assignment analyzes a dataset of footballers' earnings using Microsoft Excel. The student applies various Excel formulas to calculate and display data, including current date, number of players, player status, tax amounts, and net earnings. The analysis covers total and average net earnings, highest and lowest earnings, and specific calculations based on player positions. A clustered horizontal bar chart is created to visualize the earnings and net earnings of the players. The conclusion highlights key findings, such as the highest-earning player and the differences between earnings and net earnings among the players, demonstrating proficiency in data manipulation and presentation using Excel.

Name of Student
Name of University
Footballers’ Earnings Analysis

Introduction
The given data of Footballer’s earnings are analysed using suitable
formulas in excel. At first the given data is copied and formatted
accordingly in excel as given below. Then suitable formulas are applied
to answer the given questions as described in Procedure.

Procedure
1. Displaying current Date
2. Number of Soccer players

Procedure
3. Status of each Player
4. Amount of tax to be paid

Procedure
5. Net Earnings
6. Total Net Earnings
7. Average Net Earnings

Procedure
8. Highest Net Earnings
9. Lowest Net Earnings
10.Total Net Earnings for Players with Position 2

Procedure
11. Average Net Earnings for Players with Position 1
12. Number of Players with Net Earnings greater than £50,000
13. number of Players with Net Earnings less than £50,000

Creating Clustered horizontal Bar
chart
This is created in excel by selecting the two columns of Earnings and
Net Earnings. Then the y axis label is changed through ‘select data’
feature in excel and the Player column names are added. Finally, the
legend is switched in the same ‘select data’ wizard.

Clustered horizontal Bar chart

Conclusion:
Hence, the footballer’s earnings dataset is analysed with appropriate
excel formulas as shown in earlier screenshots. The data analysis
reveals that Messi is the Highest earning player out of the six players in
the list. Also, there is significant difference between earnings and net
earnings of players. Messi, Ronaldo and Neymar earns significantly
higher than other three players namely Oscar Paul Pogba and Gareth
Bale.