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 …
Month: January 2021
(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 …
(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 …
(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 …
(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 …
(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. …
(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 …
(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; …
(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 …