Black Friday 2024: 25+ Ways to Save on Online Learning
Statistics and Probabilities in Excel

Statistics and Probabilities in Excel

Dr. Todd Grande via YouTube Direct link

INDEX and MATCH Functions in Excel to Return Value in Different Column than Search Value

81 of 114
Previous
Next

81 of 114

INDEX and MATCH Functions in Excel to Return Value in Different Column than Search Value

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.