ICT Business Income Analysis: Spreadsheet Formula Applications

This assignment focuses on analyzing information communication technology (ICT) business incomes using various spreadsheet formulas. It demonstrates how to calculate total income using the SUM formula, average income using the AVERAGE formula, highest income using the MAX formula, and lowest income using the MIN formula. Conditional formulas like SUMIF and AVERAGEIF are applied to calculate sums and averages based on specific criteria, such as rank or income level. Additionally, the assignment illustrates the use of COUNTIF to count incomes that meet certain conditions (e.g., greater than or less than a specified amount). A comparative analysis between total and net income is presented, highlighting the impact of tax deductions. The analysis is visually represented using a line chart, providing a clear overview of the business's financial performance. This solved assignment is available on Desklib, offering students a valuable resource for understanding business income analysis techniques.

INFORMATION
COMMUNICATION
TECHNOLOGY

BUSINESS INCOMES
Total income is calculated using Sum formula which is = Sum( Number 1 :
Number N)

The average of total income has been calculated using
average formula which is = Average(Number 1: Number
N)

The highest income of the business has been calculated
using the maximum formula which is Maximum =
Max( Number 1: Number N)

The lowest income amongst all the business has been
calculated which is Minimum = Min( Number 1 : Number
N)

The sum formula has been used using the condition that
rank 2 or higher will be sum total. The formula has been =
Sum if( Number 1: Number N,” 2”,””)

The average of total income has been taken below having
the rank 1. The formula applied below has been = Average
if ( Number 1: Number 3,”1”, “”)

The below is the calculation of counting of total income
on the condition that such income if more than Pound 500
K. The formula used will be = Count
if(Range1:Range3,”500000”)

The below is the calculation of counting of total income on
the condition that such income if less than Pound 500 K.
The formula used will be = Count
if(Range1:Range3,”<500000”)

The comparative analysis has been carried
out between total and net income in the
given chart due to effect of Tax that has been
deducted from total income.

LINE CHART

THANK YOU