Information Communication Technology: Population Analysis of UK Cities

This assignment focuses on analyzing population data for UK cities using Information Communication Technology (ICT) tools. It demonstrates the application of various formulas in spreadsheet software, including SUM, AVERAGE, MAX, MIN, SUMIF, AVERAGEIF, and COUNTIF, to calculate total population, average population, highest and lowest population, and conditional sums and averages. The assignment also includes a graphical representation of population changes between 2019 and 2020, providing a visual interpretation of the data. The analysis helps in understanding population trends and distributions across different cities in the UK.

Information Communication Technology

Total Population
For Total number of population Formula that is used is of the SUM. The
formula for calculating Sum = Sum ( Number1, Number 2 and so on)

Formula of Average Population
For the Average population the formula which has been used is AVERAGE .
The Formula for Calculating average = Average ( Number 1 , Number 2 ,
Number 3 and son on )

Formula of Highest Population
For the Highest population the formula which is used is MAX. The
Formula for calculating the missing value of the provided set of
data = Max(Number 1 : Number 10 ) Respectively

Lowest population
For the Lowest population, the formula which is used is of MIN.
The Formula for Calculating Minimum value for the provided
set of the number is = Min ( Number 1 : Number 9 )

Formula of Sum with conditions
The formula for sum on complying with the certain condition =
SUMIF(C4:C10, “2”, F4:F10) which clearly shows the condition that
sum of the population if they had rank 1.

Formula of Average with Condition
The formula which is used for calculating the Average formula
after complying with the certain condition is =
AVERAGEIF(Range of Cells selected, condition applied)

Formula of Count:
Formula used in this case, If = Count if( Range of Cells Selected,
Special Mark ) The above formula is being applied in the Selected
Range F4 to F9 and count only those that are Greater then 600,000.

Formula of Count with Conditions:
The formula that is used in above cells is of the count if which
is based on condition. The formula used = count if ( Range of
the Cells selected, Special Condition) The above count is being
made between F4:F10 in which such values are lesser then 500,
000

INTERPRETATION- The below chart shows population
between 2019 and 2020 for UK cities. The increase in the
population have been shown with the help of graphical
representation.
Birmingham
City
Glasgow City Glasgow City Leeds City Bradford
City
London City Sheffield
City
0
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
Populations between 2019 and 2020 for UK
Cities
Populations (2019) Populations (2020)

THANK YOU