[go: up one dir, main page]
Scribd
Upload
127 views2 pages

VIP and Non-VIP Account Analysis

The document contains air quality and population data for 20 cities around the world in 2020, listing each city, its population for that year, and its CO (carbon monoxide) level which is classified using a scale of 0 to 4 or listed as ND (no data). It also includes a table summarizing the CO classification data by number of cities within each classification level and a second table summarizing the population data by population ranges and the number of cities within each range.

Uploaded by

surekapratham30
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
127 views2 pages

VIP and Non-VIP Account Analysis

The document contains air quality and population data for 20 cities around the world in 2020, listing each city, its population for that year, and its CO (carbon monoxide) level which is classified using a scale of 0 to 4 or listed as ND (no data). It also includes a table summarizing the CO classification data by number of cities within each classification level and a second table summarizing the population data by population ranges and the number of cities within each range.

Uploaded by

surekapratham30
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Client # Balance VIP Account?

Total commisions
1 8,000 Yes 10
2 11,000 Yes 9
3 6,000 No 5
4 15,000 Yes 10
5 10,000 No 2
6 15,000 Yes 5
7 13,000 Yes 999
8 8,000 Yes 2
9 11,000 No 5
10 9,000 Yes 6

SUMIF =SUMIF(range,criteria,[sum_range])
1 What is the total amout of money in VIP Accounts? 79000
2 What is the total amout of money in Non-VIP Accounts? 27000

3 What is the total amount of commisions from accounts that are over $10,000? 1028

4 What is the total amout of money in accounts over $10,000? 65000


5 What is the total amout of money in accounts under $9,500? 31000
Air Quality Statistics by City, 2020

City 2020 Population CO


New York 4165079 4 Complete the table using the data
London 4804428 1 CO Classification Number of cities
Amsterdam 2980521 ND 0 2
Baghdad 428537 4 1 5
Jerusalem 1584478 4 4 8
Tel Aviv 100000 1 ND 3
Milano 3317786 0
Rome 1302222 4 Population Number of cities
Oslo 4505015 1 More than 300K people 15
Soda Springs 150 ND Less than 5K People 2
Birmingham 3593954 1 Exactly 100K 1
Manchester 2599644 4
Moscow 2626890 ND
Haifa 4389308 4
Dubai 4055228 1
Los Angeles 4646966 4
Delhi 808323 4
Winterton 2500 0

You might also like