# data[].attributes.attachment_link.readable_text
Toggle the table of contents

From Wikipedia, the free encyclopedia

Cartogram of the world's population in 2018; each square represents 500,000 people.

This is a list of countries and dependencies by population. It includes sovereign states, inhabited dependent territories and, in some cases, constituent countries of sovereign states, with inclusion within the list being primarily based on the ISO standard ISO 3166-1. For instance, the United Kingdom is considered a single entity, while the constituent countries of the Kingdom of the Netherlands are considered separately. In addition, this list includes certain states with limited recognition not found in ISO 3166-1. Also given in a percentage is each country's population compared with the world population, which the United Nations estimates at 8.07 billion as of 2023.[1]

Method

Figures used in this chart are based on the most up-to-date estimates or projections by the national census authority, where available, and are usually rounded off.

Where updated national data are not available, figures are based on the estimates or projections for 2022 by the Population Division of the United Nations Department of Economic and Social Affairs.

Because the compiled figures are not collected at the same time in every country, or at the same level of accuracy, the resulting numerical comparisons may create misleading conclusions. Furthermore, the addition of figures from all countries may not equal the world total.

Areas that form integral parts of sovereign states, such as the countries of the United Kingdom, are counted as part of the sovereign states concerned. Not included are other entities that are not sovereign states, such as the European Union,[a] and independent territories that do not have permanent populations, such as the Chagos Archipelago and various countries' claims to Antarctica.[2]

Sovereign states and dependencies by population

Note: A numbered rank is assigned to the 193 member states of the United Nations, plus the two observer states to the United Nations General Assembly. Dependent territories and constituent countries that are parts of sovereign states are not assigned a numbered rank. In addition, sovereign states with limited recognition are included, but not assigned a number rank.

See also

Explanatory notes

1. The European Union is a ^ sui generis supranational union whose sovereign members delegate to it by treaty certain powers that are often exercised by sovereign states. Its combined population has been estimated at 447,319,916 on 1 January 2020, and it would be ranked 3rd if it were included in the list. It has 5.55% of the world's population - see "Eurostat-Tables, Graphs and Maps Interface（TGM）table". European Commission.

2. Refers to ^ Mainland China; excludes China's special administrative regions of Hong Kong and Macau, which returned to Chinese sovereignty in 1997 and 1999, respectively.

3. Includes the population of the ^ India-administered union territories of Jammu and Kashmir, and Ladakh. According to UN estimates, India is set to surpass China by the end of Apr 2023.[6]

4. Includes the ^ Republic of Crimea and Sevastopol, administrative areas on the Crimean Peninsula occupied by Russia. The Ukrainian government and most of the world's other states consider the Crimean Peninsula part of Ukraine's territory.

5. Includes the integral 18 ^ regions of France (including 5 overseas departments and regions). Excludes France's 5 overseas collectivities: French Polynesia, Saint Barthélemy, Saint Martin, Saint Pierre and Miquelon, and Wallis and Futuna, and the sui generis collectivity of New Caledonia, which are shown separately. The French Southern and Antarctic Lands (an Antarctic territorial claim hosting only government officials and research station staff) and Clipperton Island (an uninhabited state private property of France) are not listed at all due to their extraordinary nature.

6. Excludes the 3 ^ British Crown Dependencies and the 14 British Overseas Territories, listed separately. Four British Overseas Territories are not listed due to their extraordinary nature. The 4 not listed are British Antarctic Territory (an Antarctic territorial claim hosting only government officials and research station staff), the British Indian Ocean Territory (a military base), South Georgia and the South Sandwich Islands (hosts only government officials and research station staff), and the Sovereign Base Areas of Akrotiri and Dhekelia (a military base where permanent residency is limited to citizens of the Republic of Cyprus).

7. Excludes the ^ Autonomous Republic of Crimea and the city of Sevastopol, Ukraine's de jure territory which is occupied by Russia (however, includes the Donbas region, partly occupied by Russia).

8. ^ Taiwan includes Penghu, Kinmen, Matsu and other minor islands.

9. Excludes the three constituent countries of the ^ Kingdom of the Netherlands in the Caribbean Sea (Aruba, Curaçao, and Sint Maarten), but includes the three special municipalities of the Caribbean Netherlands (Bonaire, Sint Eustatius and Saba).

10. Includes ^ East Jerusalem and the Golan Heights. Also includes Israeli settlers within Area C of the West Bank.

11. Excludes the ^ Faroe Islands and Greenland.

12. Excludes ^ Abkhazia (242,862, census 2011) and South Ossetia (53,559, census 2015).

13. ^ Disputed territory with undetermined political status. Administration is split between Morocco and the Sahrawi Arab Democratic Republic, both of which claim the entire territory. The Sahrawi Arab Democratic Republic's administrative control is limited to approximately 20% of the territory, with the remaining 80% of the territory occupied by Morocco (see Western Sahara conflict).

14. ^ De facto independent, de jure part of Cyprus.

15. ^ De facto independent, de jure part of Moldova.

16. The political status of Abkhazia is disputed. Having unilaterally declared independence from ^ Georgia in 1992, Abkhazia is formally recognised as an independent state by 5 UN member states (two other states previously recognised it but then withdrew their recognition), while the remainder of the international community recognizes it as as de jure Georgian territory. Georgia continues to claim the area as its own territory, designating it as Russian-occupied territory.

17. ^ De facto independent, de jure part of Azerbaijan.

18. ^ South Ossetia's status is disputed. It considers itself to be an independent state, but this is recognised by only a few other countries. The Georgian government and most of the world's other states consider South Ossetia de jure a part of Georgia's territory.

19. 764 residents regardless of citizenship, 618 citizens regardless of residence, 246 resident citizens.^ [231]

References

# data[].attributes.attachment_link.title
List of countries and dependencies by population - Wikipedia

# data[].attributes.attachment_link.description
Toggle the table of contents From Wikipedia, the free encyclopedia This is a list of countries and dependencies by population. It includes sovereign states, inhabited dependent territories and, in some cases, constituent countries of sovereign states, with inclusion within the list being primarily based on the ISO standard ISO 3166-1.

# data[].attributes.headline
Dataset for Histogram chart using pivot table

# data[].attributes.subject
Dataset for Histogram chart using pivot table

# data[].attributes.attachment_link.readable_text
Insert a Pivot Table | Drag fields | Sort | Filter | Change Summary Calculation | Two-dimensional Pivot Table

Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

Our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country.

Insert a Pivot Table

To insert a pivot table, execute the following steps.

1. Click any single cell inside the data set.

2. On the Insert tab, in the Tables group, click PivotTable.

The following dialog box appears. Excel automatically selects the data for you. The default location for a new pivot table is New Worksheet.

3. Click OK.

Drag fields

The PivotTable Fields pane appears. To get the total amount exported of each product, drag the following fields to the different areas.

1. Product field to the Rows area.

2. Amount field to the Values area.

3. Country field to the Filters area.

Below you can find the pivot table. Bananas are our main export product. That's how easy pivot tables can be!

Sort

To get Banana at the top of the list, sort the pivot table.

1. Click any cell inside the Sum of Amount column.

2. Right click and click on Sort, Sort Largest to Smallest.

Result.

Filter

Because we added the Country field to the Filters area, we can filter this pivot table by Country. For example, which products do we export the most to France?

1. Click the filter drop-down and select France.

Result. Apples are our main export product to France.

Note: you can use the standard filter (triangle next to Row Labels) to only show the amounts of specific products.

Change Summary Calculation

By default, Excel summarizes your data by either summing or counting the items. To change the type of calculation that you want to use, execute the following steps.

1. Click any cell inside the Sum of Amount column.

2. Right click and click on Value Field Settings.

3. Choose the type of calculation you want to use. For example, click Count.

4. Click OK.

Result. 16 out of the 28 orders to France were 'Apple' orders.

Two-dimensional Pivot Table

If you drag a field to the Rows area and Columns area, you can create a two-dimensional pivot table. First, insert a pivot table. Next, to get the total amount exported to each country, of each product, drag the following fields to the different areas.

1. Country field to the Rows area.

2. Product field to the Columns area.

3. Amount field to the Values area.

4. Category field to the Filters area.

Below you can find the two-dimensional pivot table.

To easily compare these numbers, create a pivot chart and apply a filter. Maybe this is one step too far for you at this stage, but it shows you one of the many other powerful pivot table features Excel has to offer.

# data[].attributes.attachment_link.description
Insert a Pivot Table | Drag fields | Sort | Filter | Change Summary Calculation | Two-dimensional Pivot Table Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Our data set consists of 213 records and 6 fields.

# data[].attributes.body
https://www.data.gov.my/ -->Malaysia public data

https://www.kaggle.com/datasets

https://datasetsearch.research.google.com/

https://data.worldbank.org/

https://github.com/awesomedata/awesome-public-datasets

https://data.gov/ -->US data

# data[].attributes.headline
How to create Normal Histogram Chart in Excel

# data[].attributes.subject
How to create Normal Histogram Chart in Excel

# data[].attributes.attachment_link.description
Pivot tables in excel✔️ summarize the data of a more extensive table. Read this article to ✔️learn how to create a pivot table in excel, and apply filters.

# data[].attributes.attachment_link.readable_text
1. Select the cells you want to create a PivotTable from.

Note: Your data should be organized in columns with a single header row. See the Data format tips and tricks section for more details.

2. Select Insert > PivotTable.

3. This creates a PivotTable based on an existing table or range.

Note: Selecting Add this data to the Data Model adds the table or range being used for this PivotTable into the workbook's Data Model. Learn more.

4. Select OK.

By clicking the down arrow on the button, you can select from other possible sources for your PivotTable. In addition to using an existing table or range, there are three other sources you can select from to populate your PivotTable.

Get from External Data Source

Get from Data Model

Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.

Get from Power BI

Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have access to.

1. To add a field to your PivotTable, select the field name checkbox in the PivotTables Fields pane.

Note: Selected fields are added to their default areas: non-numeric fields are added to Rows, date and time hierarchies are added to Columns, and numeric fields are added to Values.

2. To move a field from one area to another, drag the field to the target area.

If you add new data to your PivotTable data source, any PivotTables that were built on that data source need to be refreshed. To refresh just one PivotTable, you can right-click anywhere in the PivotTable range, and then select Refresh. If you have multiple PivotTables, first select any cell in any PivotTable, then on the ribbon go to PivotTable Analyze > select the arrow under the Refresh button, and then select Refresh All.

Summarize Values By

By default, PivotTable fields placed in the Values area are displayed as a SUM. If Excel interprets your data as text, the data is displayed as a COUNT. This is why it's so important to make sure you don't mix data types for value fields. You can change the default calculation by first selecting the arrow to the right of the field name, and then select the Value Field Settings option.

Next, change the calculation in the Summarize Values By section. Note that when you change the calculation method, Excel automatically appends it in the Custom Name section, like "Sum of FieldName", but you can change it. If you select Number Format, you can change the number format for the entire field.

Show Values As

Instead of using a calculation to summarize the data, you can also display it as a percentage of a field. In the following example, we changed our household expense amounts to display as a % of Grand Total instead of the sum of the values.

Once you've opened the Value Field Setting dialog box, you can make your selections from the Show Values As tab.

Display a value as both a calculation and percentage.

Simply drag the item into the Values section twice, and then set the Summarize Values By and Show Values As options for each one.

You can change the data sourcefor the PivotTable data as you are creating it.

1. In the Insert PivotTable pane, select the text box under Source. While changing the Source, cards in the pane won't be available.

2. Make a selection of data on the grid or enter a range in the text box.

3. Press Enter on your keyboard or the button to confirm your selection. The pane updates with new recommended PivotTables based on the new source of data.

Get from Power BI

Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have access to.

In the PivotTable Fields pane, select the check box for any field you want to add to your PivotTable.

By default, non-numeric fields are added to the Rows area, date and time fields are added to the Columns area, and numeric fields are added to the Values area.

You can also manually drag-and-drop any available item into any of the PivotTable fields, or if you no longer want an item in your PivotTable, drag it out from the list or uncheck it.

Summarize Values By

By default, PivotTable fields in the Values area are displayed as a SUM. If Excel interprets your data as text, it is displayed as a COUNT. This is why it's so important to make sure you don't mix data types for value fields.

Change the default calculation by right-clicking any value in the row and selecting the Summarize Values By option.

Show Values As

Instead of using a calculation to summarize the data, you can also display it as a percentage of a field. In the following example, we changed our household expense amounts to display as a % of Grand Total instead of the sum of the values.

Right-click any value in the column you'd like to show the value for. Select Show Values As in the menu. A list of available values displays.

Make your selection from the list.

To show as a % of Parent Total, hover over that item in the list and select the parent field you want to use as the basis of the calculation.

If you add new data to your PivotTable data source, any PivotTables built on that data source must be refreshed. Right-click anywhere in the PivotTable range, and then select Refresh.

If you created a PivotTable and decide you no longer want it, select the entire PivotTable range and press Delete. This won't have any effect on other data or PivotTables or charts around it. If your PivotTable is on a separate sheet that has no other data you want to keep, deleting the sheet is a fast way to remove the PivotTable.

Your data should be organized in a tabular format, and not have any blank rows or columns. Ideally, you can use an Excel table.

Tables are a great PivotTable data source, because rows added to a table are included automatically in the PivotTable when you refresh the data, and any new columns are included in the PivotTable Fields list. Otherwise, you need to either Change the source data for a PivotTable, or use a dynamic named range formula.

Data types in columns should be the same. For example, you shouldn't mix dates and text in the same column.

PivotTables work on a snapshot of your data, called the cache, so your actual data doesn't get altered in any way.

If you have limited experience with PivotTables, or are not sure how to get started, a Recommended PivotTable is a good choice. When you use this feature, Excel determines a meaningful layout by matching the data with the most suitable areas in the PivotTable. This helps give you a starting point for additional experimentation. After a recommended PivotTable is created, you can explore different orientations and rearrange fields to achieve your desired results. You can also download our interactive Make your first PivotTable tutorial.

1. Select a cell in the source data or table range.

2. Go to Insert > Recommended PivotTable.

3. Excel analyzes your data and presents you with several options, as in this example using the household expense data.

1. Select a cell in the source data or table range.

2. Go to Insert > PivotTable.

3. Excel displays the Create PivotTable dialog box with your range or table name selected. In this case, we're using a table called "tbl_HouseholdExpenses".

4. In the Choose where you want the PivotTable report to be placed section, select New Worksheet, or Existing Worksheet. For Existing Worksheet, select the cell where you want the PivotTable placed.

PivotTable Fields list

In the Field Name area at the top, select the check box for any field you want to add to your PivotTable. By default, non-numeric fields are added to the Row area, date and time fields are added to the Column area, and numeric fields are added to the Values area. You can also manually drag-and-drop any available item into any of the PivotTable fields, or if you no longer want an item in your PivotTable, simply drag it out of the Fields list or uncheck it. Being able to rearrange Field items is one of the PivotTable features that makes changing its appearance so easy.

PivotTable Fields list

Summarize by

By default, PivotTable fields placed in the Values area are displayed as a SUM. If Excel interprets your data as text, the data is displayed as a COUNT. This is why it's so important to make sure you don't mix data types for value fields. You can change the default calculation by first selecting the arrow to the right of the field name, and then by selecting the Field Settings option.

Next, change the calculation in the Summarize by section. Note that when you change the calculation method, Excel automatically appends it in the Custom Name section, like "Sum of FieldName", but you can change it. If you select Number... , you can change the number format for the entire field.

Tip: Since changing the calculation in the Summarize by section changes the PivotTable field name, it's best not to rename your PivotTable fields until you're finished setting up your PivotTable. One trick is to select Replace ( on the Edit menu) > Find what > " Sum of", and then Replace with > leave blank to replace everything at once instead of manually retyping.

Show data as

Instead of using a calculation to summarize the data, you can also display it as a percentage of a field. In the following example, we changed our household expense amounts to display as a % of Grand Total instead of the sum of the values.

Once you've opened the Field Settings dialog box, you can make your selections from the Show data as tab.

Display a value as both a calculation and percentage.

Simply drag the item into the Values section twice, right-click the value and select Field Settings, and then set the Summarize by and Show data as options for each one.

If you add new data to your PivotTable data source, any PivotTables that were built on that data source must be refreshed. To refresh just one PivotTable you can right-click anywhere in the PivotTable range, and then select Refresh. If you have multiple PivotTables, first select any cell in any PivotTable, and then on the ribbon go to PivotTable Analyze > select the arrow under the Refresh button, and then select Refresh All.

1. Select a cell in the source data or table range.

2. Go to Insert > PivotTable.

3. Choose where you want the PivotTable to be placed. Select Insert on new sheet  to place the PivotTable in a new worksheet or  select the cell where you want the new PivotTable placed in the Destination field.

4. Select Insert.

Typically, non-numeric fields are added to the Rows area, date and time fields are added to the Columns area, and numeric fields are added to the Values area. You can also manually drag-and-drop any available item into any of the PivotTable fields, or if you no longer want an item in your PivotTable, simply drag it out of the Fields list or uncheck it. Being able to rearrange Field items is one of the PivotTable features that makes changing its appearance so easy.

If you add new data to your PivotTable data source, any PivotTables that were built on that data source must be refreshed. To refresh just one PivotTable you can select and hold on a cell anywhere in the PivotTable range, and then select Refresh. If you have multiple go to PivotTable tab on the ribbon and select Refresh.

If you created a PivotTable and decide you no longer want it, you can select the rows and columns spanning the entire PivotTable range, and then press Delete.

Use clean, tabular data for best results.

Organize your data in columns, not rows.

Make sure all columns have headers, with a single row of unique, non-blank labels for each column. Avoid double rows of headers or merged cells.

Format your data as an Excel table (select anywhere in your data, and then select Insert > Table from the ribbon).

If you have complicated or nested data, use Power Query to transform it (for example, to unpivot your data) so it's organized in columns with a single header row.

Create a PivotChart

Calculate values in a PivotTable

Delete a PivotTable

# data[].attributes.attachment_link.title
Create a PivotTable to analyze worksheet data

# data[].attributes.attachment_link.description
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

# data[].attributes.headline
How to create Histogram using data analysis PAK in Excel

# data[].attributes.subject
How to create Histogram using data analysis PAK in Excel

# data[].attributes.attachment_link.title
What is Data Mining and Why is it Important?

# data[].attributes.body
alif exercise

# data[].attributes.body
Additional resources/notes : 1. https://www.alexanderthamm.com/en/blog/data-mining-method-basics-and-practical-examples/

2.https://www.precisely.com/blog/datagovernance/top-5-data-mining-techniques

3.https://www.guru99.com/best-data-mining-tools.html

# data[].attributes.headline
Chapter 6 - Display Tabular Data in Excel (Part 1)

# data[].attributes.subject
Chapter 6 - Display Tabular Data in Excel (Part 1)

# data[].attributes.headline
Chapter 6 - Display Tabular Data in Excel (Part 2)

# data[].attributes.subject
Chapter 6 - Display Tabular Data in Excel (Part 2)

# data[].attributes.attachment_link.title
Assignment & Project Grouping & Consultation (0825 session)

# data[].attributes.body
Hi everyone..Assalamualaikum & greetings everyone.  I am Mdm. Jihadah Ahmad your lecturer.This is an additional online platform for Intro To Data Analytics class activities.  Our main platform will still be the UPTM LMS & OpenLearning platform (i will update when the platform are ready). I shall update the content weekly according to our class progress. I do hope you enjoy the class & best wishes to all.

# data[].attributes.headline
Sect 2- Course Info & Assessment Briefing

# data[].attributes.subject
Sect 2- Course Info & Assessment Briefing

# data[].attributes.headline
Sect 4 -Course Info & Assessment Briefing

# data[].attributes.subject
Sect 4 -Course Info & Assessment Briefing

# data[].attributes.headline
NUR ZUKRINA ZULAIKHA BINTI SHAMSUL RIZAL

# data[].attributes.subject
NUR ZUKRINA ZULAIKHA BINTI SHAMSUL RIZAL

# data[].attributes.attachment_link.title
FRUIT SALES (NURSAIZATUL IKMAL BT ABDULLAH)

# data[].attributes.attachment_link.title
NURAIN NADHIRAH BINTI HAIRUL ARIFFIN (FRUIT SALES)

# data[].attributes.headline
AEDELICA AVERIL ANAK BAHASAN FRUITS DATA

# data[].attributes.subject
AEDELICA AVERIL ANAK BAHASAN FRUITS DATA

# data[].attributes.attachment_link.title
AEDELICA AVERIL ANAK BAHASAN FRUITS DATA

# data[].attributes.body
AM2412017213

# data[].attributes.headline
NUR ZUKRINA ZULAIKHA BINTI SHAMSUL RIZAL

# data[].attributes.subject
NUR ZUKRINA ZULAIKHA BINTI SHAMSUL RIZAL

# data[].attributes.attachment_link.title
Exercise 1 on Excel (NUR ALIYA MAISARAH)

# data[].attributes.attachment_link.title
Exercise 1 on Excel (MIERZA HAKIMI BIN AZMAN)

# data[].attributes.body
AM2412017263