ICT Presentation: Data Manipulation and Analysis of Business Incomes

This presentation showcases the use of Information and Communications Technology (ICT) in analyzing business incomes. It demonstrates data manipulation using various Excel functions such as SUM, AVERAGE, COUNT, MAX, MIN, and IF statements to process a dataset of business incomes. The presentation includes a chart comparing income and net income, along with interpretations of the manipulated data. The analysis reveals key insights such as total net income, average income, and income distribution among different businesses, highlighting the effectiveness of Excel as a tool for data analysis and presentation.

Information
Communication
Technology

CONTENTS
 INTRODUCTION
 Data Manipulation
 Selection of Dataset
 Dataset A – Business Incomes
 Application of different excel formula
 Income vs Net Income Chart
 Interpretation
 CONCLUSION

INTRODUCTION
Information and communications technology (ICT) is a term that
emphasizes the role of unified communications and the
integration of telecommunications (telephone lines and wireless
signals) and computers, as well as the necessary enterprise
software, middleware, storage, and audiovisual, to enable users to
access, store, transmit, understand, and manipulate information.
The following presentation highlights the case of different
businesses and their incomes. These figures of incomes and net
incomes are manipulated using Excel functions and the results are
presented in this presentation.

Data Manipulation
 The practice of editing or changing data to make it more
structured and legible is known as data manipulation.
 To manipulate data using excel, following functions are
used which are inserted using a formula of same:
Sum,
Average,
Count,
Max,
Min
IF function

Selection of Dataset
 The dataset collected for the scope of this
presentation is Dataset A- Business Incomes.
 The dataset presents information related to amounts
of income being made in a month by various
businesses
 Different excel functions are performed on these
values and data is manipulated to attain conclusions

Dataset A – Business Incomes
Date 29-03-2022
No of Businesses 6 Tax 21%
Business Income Rank High/Low Income Tax Net Income
Mobile phone repair shop £7,50,070.00 1 High £1,57,514.70 £5,92,555.30
Stationery Shop £13,60,600.00 1 High £2,85,726.00 £10,74,874.00
Confectionery Retailer £5,80,000.00 2 High £1,21,800.00 £4,58,200.00
Watch Retailer £1,50,650.00 4 Low £31,636.50 £1,19,013.50
Shoes Repair Shop £4,80,000.00 2 High £1,00,800.00 £3,79,200.00
Computer Repair Shop £2,30,000.00 3 High £48,300.00 £1,81,700.00
Total Net Income £28,05,542.80 Total Net Income of rank 2 £5,80,000.00
Average Net Income £4,67,590.47 Average Net Income of Rank 1 £10,55,335.00
Highest Net Income £10,74,874.00 Count of Net Income >£500k 3
Lowest Net Income £1,19,013.50 Count of Net Income <£500k 3

Application of different excel formula
Date =TODAY()
No of Businesses =COUNTA(A4:A9) Tax 0.21
Business Income Rank High/Low Income Tax Net Income
Mobile phone repair shop 750070 1 High =B4*$D$2 =B4-E4
Stationery Shop 1360600 1 High =B5*$D$2 =B5-E5
Confectionery Retailer 580000 2 High =B6*$D$2 =B6-E6
Watch Retailer 150650 4 Low =B7*$D$2 =B7-E7
Shoes Repair Shop 480000 2 High =B8*$D$2 =B8-E8
Computer Repair Shop 230000 3 High =B9*$D$2 =B9-E9
Total Net Income =SUM(F4:F9) Total Net Income of rank 2 =MAXIFS(B4:B9,C4:C9,2)
Average Net Income =AVERAGE(F4:F9) Average Net Income of Rank 1 =AVERAGEIF(C4:C9,1,B4:B9)
Highest Net Income =MAX(F4:F9) Count of Net Income >£500k =COUNTIF(B4:B9,">500000")
Lowest Net Income =MIN(F4:F9) Count of Net Income <£500k =COUNTIF(B4:B9,"<500000")

Income vs Net Income Chart
Mobile phone repair shop
Stationery Shop
Confectionery Retailer
Watch Retailer
Shoes Repair Shop
Computer Repair Shop
0 200000 400000 600000 800000 1000000 1200000 1400000 1600000
Income vs Net Income of Businesses
Net Income
Income
Income
Businesses

Interpretation
From the above manipulated dataset related to the incomes of
different businesses it can be said that the total net income of
all businesses is recorded as 2,805,542. The average income
of the data set recorded was 467,590. And there was only
one business, i.e., Watch retailer which had income less than
200,000.

CONCLUSION
From the above presentation it can be said that excel is a
great tool to be used in the ICT. It helps the individuals and
the businesses to critically analyze the data set using the
different formula and functions. The presentation using chart
is also a great technique which presents a data set in better
and more understanding way.