Hits: 8 (Basic Statistics for Citizen Data Scientist) Discrete Probability Distributions We now define the concept of probability distributions for discrete random variables, i.e. random variables that take a discrete set of values. Such random variables generally take a finite set of values (heads or tails, people who live in London, scores on an IQ test), …

# Month: January 2021

Hits: 14 (Basic Statistics for Citizen Data Scientist) Basic Probability Concepts Definition 1: Typically in the field of statistics we study data that results from experiments. An experiment can be considered to be a series of trials, each with a particular outcome. An event is a collection of outcomes corresponding to some result in the experiment. The number of outcomes …

Hits: 6 (Basic Statistics for Citizen Data Scientist) Excel Data Analysis Tools Excel provides a number of data analysis tools, which are accessible via Data > Analysis|Data Analysis. If this option is not visible you may need to first install Excel’s analysis tool pack. This is done by selecting Office Button > Excel Options > Add-Ins in Excel …

Hits: 4 (Basic Statistics for Citizen Data Scientist) Sorting and Filtering Functions Excel Functions: Excel 365 provides the following sorting and filtering array functions. SORT(R1, sortcol, order): returns an array with the data in R1 in sorted order based on the elements in column sortcol (the “sort key”) of R1 (default 1). If order = 1 (default), the sort is in …

Hits: 12 (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 …

Hits: 26 (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 …

Hits: 4 (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 …

Hits: 3 (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 – …

Hits: 24 (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 …

Hits: 16 (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 …

Hits: 46 (Python Tutorials for Citizen Data Scientist) Python Program to Illustrate Different Set Operations In this example, we have defined two set variables and we have performed different set operations: union, intersection, difference and symmetric difference. Python offers a datatype called set whose elements must be unique. It can be used to perform different …

Hits: 16 (Python Tutorials for Citizen Data Scientist) Python Code to Sort Words in Alphabetic Order In this program, you’ll learn to sort the words in alphabetic order using for loop and display it. In this example, we illustrate how words can be sorted lexicographically (alphabetic order). Source Code # Program to sort alphabetically the …

Hits: 5 (Python Tutorials for Citizen Data Scientist) Python Code to Remove Punctuation From a String This program removes all punctuation from a string. We will check each character of the string using for loop. If the character is a punctuation, empty string is assigned to it. Sometimes, we may wish to break a sentence …

Hits: 13 (Python Tutorials for Citizen Data Scientist) Python Code to Multiply Two Matrices In this example, we will learn to multiply matrices using two different ways: nested loop and, nested list comprehension. In Python, we can implement a matrix as nested list (list inside a list). We can treat each element as a row …

Hits: 36 (Python Tutorials for Citizen Data Scientist) Python Code to Add Two Matrices In this program, you’ll learn to add two matrices using Nested loop and Next list comprehension, and display it. In Python, we can implement a matrix as a nested list (list inside a list). We can treat each element as a …

Hits: 15 (Python Tutorials for Citizen Data Scientist) Python Code to Convert Decimal to Binary Using Recursion In this program, you will learn to convert decimal number to binary using recursive function. Decimal number is converted into binary by dividing the number successively by 2 and printing the remainder in reverse order. Source Code # …