Posts

Step by step data analysis using spreadsheet application (e.g. Microsoft Excel)

Background A spreadsheet application is an invaluable tool to gather insights from data when the data is structured and the quantity of data is less. A good rule of thumb is when the data is stored as a CSV (Comma Separated values) or in the XLS/XLSX format and the size of the data is less than 25 MB then use spreadsheet applications for analyzing the data to get insights. Also, it needs to be noted that Microsoft Excel ( https://products.office.com/en-in/excel ) is not the only spread sheet software, Open Office Calc ( https://www.openoffice.org/product/calc.html ) and LibreOffice Calc ( https://www.libreoffice.org/discover/calc/ ) are good and FREE alternatives. Dataset As part of this post we shall work through the steps that are involved to perform analysis on the Titanic dataset. This dataset contains the details of the passengers of the RMS Titanic which was involved in an unfortunate accident with an ice berg that led to the death of many people. The back ground for the...
Recent posts