datawithsandesh

  Excel for Data Analysis (Beginners Edition) Wait! What? Are you serious? No way we can do data analysis in excel. Many people recognize Microsoft Excel as a tool designed to create spreadsheets and use it as a database for a small-scale business. But there are a plethora of users without a clue that Excel is one of the great tool for Data Analysis. Apart from storing and manipulating data, e x cel provides many other important features that are very useful in analyzing data and extracting a conclusive decision. For example, Pivot table is one of the best feature that a user can use in order to analyze or group large sets of data. Also, sorting can be done in excel and it is best suitable for smaller sets of data. Never heard of Pivot Tables?  Don’t worry this blog is all about getting started with Pivot tables. Pivot Tables Pivot table is a great and essential tool in Excel that helps summarize and analyze large datasets. For example, pivot table allows user to extract, grou...

  Does the Gross Domestic Product affect the suicide rate? Hypothesis : The Gross Domestic Product (GDP) is one of the factors that contributes to the increase in the suicidal rate. Suicide is a very complex issue all over the world that affects many people every year. It is one of the major causes of death of the young people. The data also predicts that every 40 seconds a person dies from suicide. The main goal of this document is to find the relation between the total GDP by country and the suicide death rates by country. To carry out the following hypothesis, we have selected 2 datasets: · suicide-death-rates.csv ·   gdp.json Both of the datasets were taken from an online website ourworldindata.org and to be specific the links to the datasets are  https://ourworldindata.org/suicide#suicide-is-a-leading-cause-of-death-especially-in-young-people  and  https://ourworldindata.org/economic-growth  . We can have a glance at the data the data set contains usin...