Analyzing ICT Business Incomes with Excel: A Formula-Based Approach

This assignment focuses on analyzing Information Communication Technology (ICT) business incomes using various Excel formulas. The solution demonstrates the use of the SUM formula to calculate total income, the AVERAGE formula to determine the average income, the MAX formula to identify the highest income, and the MIN formula to find the lowest income. Conditional formulas like SUMIF and AVERAGEIF are applied to calculate sums and averages based on specific criteria, such as rank. Additionally, COUNTIF is used to count incomes that meet certain conditions (e.g., greater than or less than £500K). A comparative analysis is also conducted between total and net income to illustrate the impact of tax deductions, presented in a chart. This assignment showcases the practical application of Excel in business income analysis. Desklib provides solved assignments and study tools for students.

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.

THANK YOU