(Basic Statistics for Citizen Data Scientist) Sorting and Filtering Excel provides a number of basic capabilities for sorting and filtering data in a worksheet. These capabilities are accessible from the Data ribbon. Example 1: Sort the data in the range A3:D10 of Figure 1 by income Figure 1 – Data to be sorted Highlight the range A3:D12 …
(Basic Statistics for Citizen Data Scientist) Array Formulas and Functions Excel also allows you to define a formula that assigns values to a range of cells at the same time. These are called array formulas and they will be used quite often throughout this website. Array formulas We now show how to create formulas that modify …
(Basic Statistics for Citizen Data Scientist) Excel Charts Excel provides fairly extensive capabilities for creating graphs, what Excel calls charts. You can access Excel’s charting capabilities by selecting Insert > Charts. We will describe how to create bar and line charts here. Other types of charts are created in a similar manner. Once a chart is created …
(Basic Statistics for Citizen Data Scientist) Excel User Interface The entire interface is as follows: Figure 1 – Excel User Interface This is the layout used in Excel 2007. The layout in Excel 2010 and Excel 2013 and later versions of Excel are almost identical. The key components are as follows: Title Bar – contains the …
(Basic Statistics for Citizen Data Scientist) Excel Spreadsheets Workbooks and worksheets Excel works with files called workbooks. Each workbook contains one or more spreadsheets, called worksheets. Each worksheet consists of cells organized in a rectangular grid. The rows of a worksheet are labeled with a number and the columns are labeled with a letter or series of letters. The …
(Basic Statistics for Citizen Data Scientist) Basic Statistical Concepts Statistics plays a central role in research in the social sciences, pure sciences and medicine. A simplified view of experimental research is as follows: You make some observations about the world and then create a theory consisting of a hypothesis and possible alternative hypotheses that try …
(R Tutorials for Citizen Data Scientist) Statistics with R for Business Analysts – Random Forest In the random forest approach, a large number of decision trees are created. Every observation is fed into every decision tree. The most common outcome for each observation is used as the final output. A new observation is fed into …
(R Tutorials for Citizen Data Scientist) Statistics with R for Business Analysts – Decision Tree Decision tree is a graph to represent choices and their results in form of a tree. The nodes in the graph represent an event or choice and the edges of the graph represent the decision rules or conditions. It is …
(R Tutorials for Citizen Data Scientist) Statistics with R for Business Analysts – Nonlinear Least Square When modeling real world data for regression analysis, we observe that it is rarely the case that the equation of the model is a linear equation giving a linear graph. Most of the time, the equation of the model …
(R Tutorials for Citizen Data Scientist) Statistics with R for Business Analysts – Time Series Analysis Time series is a series of data points in which each data point is associated with a timestamp. A simple example is the price of a stock in the stock market at different points of time on a given …