BA4LC53O: Analyzing Football Earnings with ICT - LSST, London, 2021-22

This assignment solution focuses on using Information Communication Technology (ICT) to analyze football earnings data. It demonstrates the application of various spreadsheet formulas, including SUM, AVERAGE, MAX, and MIN, to calculate total, average, highest, and lowest net earnings. Conditional formulas like SUMIF and AVERAGEIF are used to analyze earnings based on specific criteria, and COUNTIF is employed for data analysis. The assignment includes a chart comparing gross income and net income, providing a visual representation of the data. This analysis showcases practical ICT skills in data manipulation and interpretation within a real-world context. Desklib provides access to similar solved assignments and past papers for students.

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:
Mobile Phone
Repair Shop
Stationery Shop Confectionery
Retailer
Watch Retailer Shoes Repair
Shop
Computer Repair
Shop
-
200,000
400,000
600,000
800,000
1,000,000
1,200,000
1,400,000
1,600,000
Income vs Net Income
Income (£) Net Income

THANK YOU