Completed
Calculating and Interpreting Cohen's Kappa in Excel
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Statistics and Probabilities in Excel
Automatically move to the next video in the Classroom when playback concludes
- 1 Calculating Descriptive Statistics Using Excel
- 2 Calculating Percentile Rank Using Excel
- 3 Random Number Generation and Random Sampling in Excel
- 4 Calculating a Correlation Coefficient Using Excel
- 5 Chi-Square Test in Excel
- 6 T-Test in Excel including Testing for Equality of Variances
- 7 ANOVA in Excel
- 8 Regression in Excel
- 9 Pretest and Posttest Analysis Using Excel
- 10 Histogram in Excel
- 11 Calculating Cohen's d Using Microsoft Excel
- 12 Calculating Measures of Central Tendency using Excel
- 13 Calculating Z Scores using Excel
- 14 Calculating Confidence Intervals in Excel
- 15 Calculating Probabilities Using the Normal Distribution Function in Excel
- 16 Estimating Sample Size Using Excel
- 17 Poisson Function in Excel
- 18 Binomial Distribution Function in Excel
- 19 Frequency Function in Excel
- 20 The SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS Functions in Excel
- 21 The COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS Functions in Excel
- 22 Creating Pie Charts in Microsoft Excel
- 23 Creating Line Charts in Excel
- 24 Creating Bar Charts in Excel
- 25 Configuring the Scroll Bar Form Control in Excel
- 26 Conducting a Levene's Test in Excel
- 27 Conducting a Modified Levene's Test in Excel
- 28 Conducting a T-Test using the T.TEST Function in Excel
- 29 Calculating the Standard Deviation in Excel
- 30 Calculating a Correlation Coefficient in Excel Step-by-Step and with the CORREL Function
- 31 Calculating the Coefficient of Determination in Excel
- 32 The "z Test: Two Sample for Means" Analysis in Excel
- 33 Predicting Values with the TREND Function in Excel
- 34 Predicting Values with the LINEST Function in Excel
- 35 Combinations and Permutations in Excel
- 36 Creating and Interpreting Scatterplots in Excel
- 37 Multiple Mode (MODE.MULT) Function in Excel
- 38 RANK.AVG and RANK.EQ Functions in Excel
- 39 RAND and RANDBETWEEN Functions in Excel
- 40 Data Transformation for Skewed Variables Using the LOG10 Function in Excel
- 41 Calculating the Standard Error of the Mean in Excel
- 42 Calculating and Interpreting Cohen's Kappa in Excel
- 43 Identifying and Highlighting Outliers in Excel
- 44 The NORM.DIST and Related Functions in Excel
- 45 Adding Ordinal Notation to Integers in Excel
- 46 Weighted and Unweighted Averages in Excel
- 47 Spearman's Rank Correlation Coefficient in Excel
- 48 Creating Random Numbers that Follow a Normal Distribution Using Excel
- 49 Creating Random Numbers that Follow a Discrete Distribution Using Excel
- 50 Creating Random Numbers that Follow a Poisson Distribution Using Excel
- 51 Creating a Boxplot in Excel
- 52 Creating a Histogram in Microsoft Excel 2016
- 53 Creating a Boxplot in Excel 2016
- 54 Arithmetic, Harmonic, and Geometric Means in Excel
- 55 Conducting a Square Root Transformation in Excel
- 56 FORECAST.ETS Function (Exponential Triple Smoothing) in Excel
- 57 Normality Testing in Excel Compared with SPSS Output
- 58 Creating a Graph of the Standard Normal Distribution in Excel
- 59 Calculating Mahalanobis Distance Critical Values in Excel
- 60 ANOVA Step-by-Step in Excel with Interpretation of Results and Comparison to SPSS Output
- 61 Levene's Test of Homogeneity of Variance using Only Excel Functions Compared to SPSS
- 62 Reflection of a Negatively Skewed Variable using Excel
- 63 Jarque-Bera Test of Normality in Excel
- 64 95% Confidence Interval in Excel using CONFIDENCE.NORM and Standard Error of the Mean
- 65 Formula Auditing including Trace Precedents and Trace Dependents in Excel
- 66 Calculating and Interpreting the Standard Error of Measurement using Excel
- 67 Calculating and Interpreting the Standard Error of the Estimate (SEE) in Excel
- 68 Calculating Percentage Change in Excel
- 69 Calculating Effect Size (Cohen's d) for a Paired-Samples T Test
- 70 Calculating Effect Size (Cohen's d) for a One-Sample T Test
- 71 Moving (Rolling) Average in Excel 2016
- 72 Formatting and Counting Dates Occurring Before or After a Specified Date
- 73 Conditional Formatting with Icon Sets to Indicate Score Differences in Excel
- 74 Excel Data Validation to Facilitate Correct Entry of Research Data
- 75 Using the REPT Function in Excel to Display Data Graphically
- 76 Using Data Bars to Compare Pretest and Posttest Variables in Excel
- 77 Using the Ink Equation Feature in Excel to Write Equations
- 78 Manually Calculate Independent-Samples T Test in Excel
- 79 Manually Calculate Paired-Samples (Dependent-Samples) T Test in Excel
- 80 Calculating Critical Values for T Distribution in Excel and Building Chart
- 81 INDEX and MATCH Functions in Excel to Return Value in Different Column than Search Value
- 82 Reverse Coding a Likert Scale in Excel
- 83 Understanding Sample (STDEV.S) and Population (STDEV.P) Standard Deviation using Excel
- 84 One-Way ANOVA (ANOVA: Single Factor) using Excel 2016 Data Analysis Tools
- 85 Two-Way ANOVA with Replication using Excel 2016 Data Analysis Tools
- 86 Two-Way ANOVA without Replication using Excel Data Analysis Tools
- 87 Random Number Generation Function in Excel 2016 to Produce Multiple Distributions
- 88 Drawing Random Samples with the Sampling Function in Excel 2016
- 89 Calculating and Understanding Covariance (COVARIANCE.S) in Excel
- 90 Creating and Interpreting Scatterplot (Scatter Chart) in Excel 2016
- 91 Calculating and Understanding the Coefficient of Variation COV in Excel
- 92 Calculating Type II Error (Beta) and Power using Excel
- 93 Independent Samples T-Test from Only Sample Size, Mean, and Standard Deviation in Excel
- 94 One-Sample T Test using Excel
- 95 Calculating the 95% Confidence Interval after a T Test using Excel
- 96 Conducting a Multiple Regression using Microsoft Excel Data Analysis Tools
- 97 Predict Outcome Value with SLOPE and INTERCEPT Functions in Excel
- 98 Creating Waterfall Charts in Microsoft Excel 2016
- 99 Managing Histogram Bins in Microsoft Excel Including Bin Width and Number
- 100 Mean Deviation Compared to Standard Deviation in Excel
- 101 Median Absolute Deviation using Microsoft Excel
- 102 Array Formulas for Complex Calculations in Microsoft Excel
- 103 Graphing a Rolling (Moving) Average Dynamically using Microsoft Excel
- 104 Calculating Cronbach's Alpha in Microsoft Excel Compared to SPSS
- 105 Interquartile Range (IQR), Outlier Detection, and Boxplots in Excel
- 106 Stem and Leaf Plot (Stemplot) using COUNTIF and REPT Functions in Excel
- 107 One-Way ANOVA with LSD (Least Significant Difference) Post Hoc Test in Excel
- 108 Calculating the Sample Size with a Finite Population in Excel
- 109 Mann-Whitney U Test in Excel
- 110 Wilcoxon Signed-Rank Test in Excel
- 111 McNemar Test in Excel
- 112 Sign Test as a Non-Parametric Alternative to a One-Sample T Test in Excel
- 113 Kendall's Coefficient of Concordance (Kendall's W) in Excel
- 114 Calculating the Number of Unique Numbers and Unique Values in a Range using Excel