ICT - Football Earnings, Net Earnings, and Data Analysis

This assignment focuses on analyzing football player earnings and net earnings using various formulas. The solution covers calculations for total earnings (SUM), average earnings (AVERAGE), highest earnings (MAX), and lowest earnings (MIN). It also includes conditional calculations using SUMIF and AVERAGEIF, along with COUNTIF for specific criteria. The assignment demonstrates the application of these formulas and presents a chart comparing earnings and net earnings for several players, highlighting the difference between gross income and income after tax deductions. This assignment is an excellent example of how data analysis can be used to understand financial data and draw insightful conclusions.

Information Communication
Technology

Earnings from football
For Total Net Earnings Formula used is of SUM. The formula of calculating the
Sum= Sum ( Number1, Number 2 and so on)

Average Net Earnings
For Average Net Earnings formula used is of AVERAGE . The Formula of Calculating
the average = Average ( Number 1 , Number 2 , Number 3 and son on )

Highest Net Earnings
For Highest Net Earnings formula used is of MAX. The Formula of calculating the
missing value for the Given set of data = Max(Number 1 : Number 10 ) Respectively

Minimum Net Earnings
For Lowest Net Earnings formula used is of MIN. The Formula of Calculating the
Minimum value for the given set of number is = Min ( Number 1 : Number 9 )

Sum with conditions:
The formula of sum on complying with certain condition = Sum if( C4 : C9,”2”,F4:F9)
which shows condition that sum the earning of the players if they had position of 2.

Average with Condition:
The formula of calculating the Average formula after complying with certain condition
is = Average if(Range of Cells selected, condition applied )

Count:
If = Count if( Range of Cells Selected, Special Mark ) The above formula has been applied by
Selected Range F4 to F9 and count only those which are Greater then 50000

Count with Conditions:
The formula used in the above cells is of count if which is condition based. The formula used =
count if ( Range of Cells selected, Special Condition) The above count has been made between
F4:F9 which such values are less then 50000

The below chart shoes the difference between the gross income earning by the players and the net
income they receive after deducting the tax amount. The difference between the two has been shown
above in the form of chart presentation.
Interpretation:
Lionel Messi Garath Bale Paul Pogba Oscar Cristiano
Ronaldo
Neymar
0
20,000
40,000
60,000
80,000
100,000
120,000
Earnings Vs Net Earnings
Earnings(£k) Net Earnings(£k)

THANK YOU