Downloadable excel data sets

If you work with statistical programming long enough, you're going ta want to find more data to work with, either to practice on or to augment your own research. Here are a handful of sources for data to work with. All of the datasets listed here are free for download. If you want more, it's easy enough to do a search.

World Bank Data - Literally hundreds of datasets spanning many decades, sortable by topic or country. This is an outstanding resource. Gapminder - Hundreds of datasets on world health, economics, population, etc. All of it is viewable online within Google Docs, and downloadable as spreadsheets. Most of these datasets come from the government.

Kaggle - Kaggle is a site that hosts data mining competitions. Each competition provides a data set that's free for download.

Just click the download button and start playing with a Excel file. Product Pivot Data. While working in MS Excel, sometimes the data gets so much that it is very difficult to see them together. In this case, the Pivot table is used. Just understand that the pivot table shows all your data in the shortest possible place. Many skilled people of MS Excel believe that the pivot table gives you the ability to analyze the data as best as you can by using no other function.

Ashok Patel I'm a software engineer, having good experience in software programming web designing with great command on ASP. View all posts. Sample Files Download. You may also like. Sample files Uncategorized. Categories Sql Server Asp. Soical Media. The first set of sample data on this page is sales data for an imaginary office supply company, and each row represents one order.

Each row shows:. In addition to the data, this file includes the pivot tables that I showed in my blog post on hockey player data analysis. For example, one pivot table shows player counts, for each position, plus age, height and weight.

Get this data, with the data analysis, in Excel format, in the download section at the end of this page. After you copy the Office Supply Sales sample data from the table above, and paste it into Excel, you can format the data as a named Excel table.

This will make it easier to sort and filter the data. Watch this short video to see the steps, and there are written instructions on the Creating an Excel Table page.