Month: January 2021

Year 1 – Math Worksheet 001 – Decomposition of Numbers within 10

  Year 1 – Mathematics Worksheet 001 – Decomposition of Numbers within 10     Personal Career & Learning Guide for Data Analyst, Data Engineer and Data Scientist Applied Machine Learning & Data Science Projects and Coding Recipes for Beginners A list of FREE programming examples together with eTutorials & eBooks @ SETScholars 95% Discount …

Statistics for Beginners – Measures of Variability

(Basic Statistics for Citizen Data Scientist) Measures of Variability We consider a random variable x and a data set S = {x1, x2, …, xn} of size n which contains possible values of x. The data set can represent either the population being studied or a sample drawn from the population. The mean is the statistic used most often to characterize the center of the …

Statistics for Beginners – Measures of Central Tendency

(Basic Statistics for Citizen Data Scientist) Measures of Central Tendency We consider a random variable x and a data set S = {x1, x2, …, xn} of size n which contains possible values of x. The data set can represent either the population being studied or a sample drawn from the population. We seek a single measure (i.e. a statistic) which somehow represents …

Statistics for Beginners – Continuous Probability Distributions

(Basic Statistics for Citizen Data Scientist) Continuous Probability Distributions We now extend the definition of probability distribution from discrete to continuous random variables. Such variables take on an infinite range of values even in a finite interval (weight of rice, room temperature, etc.). While for a discrete random variable x, the probability that x assumes a value between a and b (exclusive) is …

Statistics for Beginners – Discrete Probability Distributions

(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), but they …

Statistics for Beginners – Basic Probability Concepts

(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 in event E (i.e. …

Statistics for Beginners – Introduction to Excel Data Analysis Tools

(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 2007 or File …

Statistics for Beginners – Introduction to Excel Sorting and Filtering Functions

(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 ascending order; …

Statistics for Beginners – Introduction to Excel Sorting and Filtering

(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 …

Statistics for Beginners – Introduction to Excel Array Formulas and Functions

(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 …