Day: January 22, 2021

Statistics for Beginners in Excel – ROC Curve

(Basic Statistics for Citizen Data Scientist) ROC Curve The ROC Curve is a plot of values of the False Positive Rate (FPR) versus the True Positive Rate (TPR) for a specified cutoff value. Example 1: Create the ROC curve for Example 1 of Classification Table. We begin by creating the ROC table as shown on the left side …

Statistics for Beginners with Excel – Classification Table

(Basic Statistics for Citizen Data Scientist) Classification Table The Classification Table compares the predicted number of successes  to the number successes actually observed and similarly the predicted number of failures compared to the number actually observed. We have four possible outcomes: True Positives (TP) = the number of cases which were correctly classified to be positive, i.e. …

Statistics for Beginners with Excel – Dot Plots

(Basic Statistics for Citizen Data Scientist) Dot Plots A Dot Plot is another way to view data graphically. A dot plot is somewhat similar to a box plot, except that instead of summarizing the data in each group (the brands in Example 1 of Box Plots), the actual data values are plotted. Real Statistics Data Analysis Tool: To …

Statistics for Beginners with Excel – Creating Box Plots

(Basic Statistics for Citizen Data Scientist) Creating Box Plots in Excel Another way to characterize a distribution or a sample is via a box plot (aka a box and whiskers plot). Specifically, a box plot provides a pictorial representation of the following statistics: maximum, 75th percentile, median (50th percentile), mean, 25th percentile and minimum. Box plots are especially useful when comparing samples …

Statistics for Beginners with Excel – Histograms

(Basic Statistics for Citizen Data Scientist) Histograms A histogram is a graphical representation of the output of the FREQUENCY function (as described in Frequency Tables). Example 1: Create a histogram for the data and bin selection for Example 1 from Frequency Tables. We start by replicating the data and bin section for Example 1 in Figure 1. …