Save 40% on Coursera Plus Annual
Excel for Statistical Analysis in Business and Economics

Excel for Statistical Analysis in Business and Economics

ExcelIsFun via YouTube Direct link

11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745

78 of 79
Previous
Next

78 of 79

11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel for Statistical Analysis in Business and Economics

Automatically move to the next video in the Classroom when playback concludes
  1. 1 Free YouTube Excel for Statistical Analysis in Business & Economics Course
  2. 2 Excel 2013 Statistical Analysis #00: Excel Workbooks For This Class
  3. 3 Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)
  4. 4 Excel 2013 Statistical Analysis #2: Install Data Analysis Add-in For Amazing Excel Statistical Tools
  5. 5 Excel 2013 Statistical Analysis #03: Download & Install Power Query for Data Transformation Tools
  6. 6 Excel 2013 Statistical Analysis #4: What Is / Are Statistics? Download Stock Data Create Information
  7. 7 Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, Ratio
  8. 8 Excel 2013 Statistical Analysis #06: Frequency Distributions & Column Charts, Categorical Variables
  9. 9 Excel 2013 Statistical Analysis #07: Subtle Chart Junk
  10. 10 Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable
  11. 11 Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula
  12. 12 Excel 2013 Statistical Analysis #10: Description of Dot Plot and Stem and Leaf Charts
  13. 13 Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year
  14. 14 Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Paradox
  15. 15 Excel 2013 Statistical Analysis #13: Scatter Chart & Trendline, X Y Data, 2 Quantitative Variables
  16. 16 Excel 2013 Statistical Analysis #14: VLOOKUP to Add New Field To Table & Create Cross Tabulation
  17. 17 Excel 2013 Statistical Analysis #15: Create Dot Plot in Excel Using COUNTIFS and REPT functions
  18. 18 Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location
  19. 19 Excel 2013 Statistical Analysis #17: Weighted Mean & SUMPRODUCT Function & Accounting Example
  20. 20 Excel 2013 Statistical Analysis #18: Geometric Mean, Average Compounding Rate GEOMEAN & RRI
  21. 21 Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank
  22. 22 Excel 2013 Statistical Analysis #20: Standard Deviation: How Fairly Does Mean Represent Data Points?
  23. 23 Excel 2013 Statistical Analysis #21: SKEW Function and Asymmetry in a Distribution of Data Points
  24. 24 Excel 2013 Statistical Analysis #22: Z-Score = # of Standard Deviations, Chebshev’s &Empirical Rule
  25. 25 Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots
  26. 26 Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient
  27. 27 Excel 2013 Statistical Analysis #25: Probability Basics: Sample Points, Events & Event Probabilities
  28. 28 Excel 2013 Statistical Analysis #26: Combinations & Permutations and Listing Sample Points
  29. 29 Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)
  30. 30 Excel 2013 Statistical Analysis #28: Multiplication Law of Probability AND Events (16 Examples)
  31. 31 Excel 2013 Statistical Analysis #29: Create Joint Probability Table from Raw Data & Calc Event Probs
  32. 32 Excel 2013 Statistical Analysis #30: Bayes’ Theorem to Calculate Posterior Probabilities
  33. 33 Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD
  34. 34 Excel 2013 Statistical Analysis #32: Expected Value Standard & Deviation Discrete Prob. Distribution
  35. 35 Excel 2013 Statistical Analysis #33: Binomial Probability Distributions: Tables, Charts, Functions
  36. 36 Excel 2013 Statistical Analysis #34: POSSION Distribution and POISSON.DIST Function
  37. 37 Excel 2013 Statistical Analysis #35: Hypergeometric Distribution and HYPGEOM.DIST Function
  38. 38 Excel 2013 Statistical Analysis #36: Dynamic Binomial Probability Charts (3 Examples)
  39. 39 Excel 2013 Statistical Analysis #37: Introduction to Continuous Probability Distributions
  40. 40 Excel 2013 Statistical Analysis #38: Uniform Probability Distribution
  41. 41 Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution
  42. 42 Excel 2013 Statistical Analysis #40: Normal (Bell) Probability Distribution Area Chart, X & Z Values
  43. 43 Excel 2013 Statistical Analysis #41: Answering Probability Questions With NORM.DIST Function
  44. 44 Excel 2013 Statistical Analysis #42: Exponential Probability Distribution & EXPON.DIST function
  45. 45 Excel 2013 Statistical Analysis #43: Simple Random Sampling in Excel: Process & Theory
  46. 46 Excel 2013 Statistical Analysis #44: Sampling Distribution of Xbar and the Central Limit Theorem
  47. 47 Excel 2013 Statistical Analysis #45: Sampling Distribution of Pbar (Binomial Sample Proportion)
  48. 48 Excel 2013 Statistical Analysis #46 Standard Error: Standard Deviation of Xbar Sampling Distribution
  49. 49 Excel 2013 Statistical Analysis #47: Central Limit Theorem To Compare Sample Mean To Normal Curve
  50. 50 Excel 2013 Statistical Analysis #48: Introduction to Confidence Intervals
  51. 51 Excel 2013 Statistical Analysis #49: Create Confidence Intervals Sigma Known Z-Score (3 Methods)
  52. 52 Excel 2013 Statistical Analysis #50: t Distribution Confidence Intervals Sigma NOT Known 3 Examples
  53. 53 Excel 2013 Statistical Analysis #51: Confidence Intervals for Pbar Sample Proportion
  54. 54 Excel 2013 Statistical Analysis #52: Determine Sample Size for Sample Mean & Sample Proportion
  55. 55 Excel 2013 Statistical Analysis #53: 5 Steps Hypothesis Testing: P-value & Critical Value Methods
  56. 56 Excel 2013 Statistical Analysis #54: 1 Tail Left Mean Hypothesis Z Test: P-value & Critical Value
  57. 57 Excel 2013 Statistical Analysis #55: 2 Tail Z Score Mean Hypothesis Testing P-value Critical Value
  58. 58 Excel 2013 Statistical Analysis #56: NORM.S.DIST = p-value, NORM.S.INV = Critical Value Sigma Known
  59. 59 Excel 2013 Statistical Analysis #57: 1 Tail Right Mean Hypothesis T Test P-value & Critical Value
  60. 60 Excel 2013 Statistical Analysis #58: 1 Tail Left T Score Mean Hypothesis Test P-value Critical Value
  61. 61 Excel 2013 Statistical Analysis #59: 2 Tail Mean Hypothesis T Test: P-value & Critical Value
  62. 62 Excel 2013 Statistical Analysis #60: T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T functions
  63. 63 Excel 2013 Statistical Analysis #61: Hypothesis Test for Proportions using p-value or Critical Value
  64. 64 Excel 2013 Statistical Analysis #62: Calculate Slope and Intercept for Regression Line
  65. 65 Excel 2013 Statistical Analysis #63: Sampling Distribution of Xbar1 – Xbar2 & Standard Error
  66. 66 Excel 2013 Statistical Analysis #64: Confidence Interval for Population Differences Sigma Known
  67. 67 Excel 2013 Statistical Analysis #65: Hypothesis Testing for Population Differences Sigma Known
  68. 68 Excel 2013 Statistical Analysis #66: Confidence Interval for Population Differences Sigma NOT Known
  69. 69 Excel 2013 Statistical Analysis #67: Hypothesis Testing for Population Differences Sigma NOT Known
  70. 70 Excel 2013 Statistical Analysis #68: Matched/Paired Samples Population Differences Sigma NOT Known
  71. 71 Excel 2013 Statistical Analysis #69: ANOVA Tables for Comparing More Than 2 Population Means
  72. 72 Excel 2013 Statistical Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error
  73. 73 Excel 2013 Statistical Analysis #71: Inference About Difference Between 2 Pop. Proportions Z Method
  74. 74 Excel 2013 Statistical Analysis #72: Chi-Square Test For 2 or More Population Proportions (Formulas)
  75. 75 Excel 2013 Statistical Analysis #73: Chi-Square Test Independence 2 Categorical Var. (PivotTables)
  76. 76 Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719
  77. 77 PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720
  78. 78 11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745
  79. 79 Average Excluding Min and MAX Values. TRIMMEAN function. 6 Formula Examples. EMT 1744

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.