(Basic Statistics for Citizen Data Scientist) Descriptive Statistics Tools Excel provides a data analysis tool called Descriptive Statistics which produces a summary of the key statistics for a data set. Example 1: Provide a table of the most common descriptive statistics for the scores in column A of Figure 1. Figure 1 – Output from Descriptive Statistics data …
(Basic Statistics for Citizen Data Scientist) Ranking Functions in Excel Excel Functions: Figure 1 summarizes the various ranking functions available in all versions of Excel for a data set R1. We describe each of these functions in more detail on the rest of this webpage, plus we describe additional ranking functions that are only available …
(Basic Statistics for Citizen Data Scientist) Symmetry, Skewness and Kurtosis 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. Looking at S as representing a distribution, the skewness of S is a measure of symmetry while kurtosis is …
(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; …