Leslie Major
Leslie Major
  • Видео 174
  • Просмотров 1 148 313
Chi Squared Test for Independence (Cross Tabs)
How to test if there is a dependence between populations. In this case, we ask if player's purchasing decisions (buy and add-on pack or not) depend on the level of an online player. Want to know more on this topic or download the Excel file shown here? Go to my free openEd textbook: pressbooks.bccampus.ca/1130sandbox/chapter/chi-squared-test-example/
Просмотров: 112

Видео

How to perform a pooled variance t-test
Просмотров 1145 месяцев назад
We revisit our example where we are testing for differences in patients' cholesterol levels. In this case, we have two independent samples with similar enough standard deviations. We use a pooled test. To download the Excel file or know more - visit: pressbooks.bccampus.ca/1130sandbox/?post_type=chapter&p=2842&preview=true
Test if a medication has improved patient outcomes (conducting a paired two sample for means test).
Просмотров 595 месяцев назад
This video steps you through how to perform a paired two sample for means test to determine if a cholesterol medication has helped reduce patients' average cholesterol levels. Want to know more about this subject or download the files shown in this video? Go to my free OpenEd book: pressbooks.bccampus.ca/1130sandbox/chapter/example-of-a-matched-pair-differences-test/
Testing for a difference in response rates between two groups
Просмотров 805 месяцев назад
This video steps through how to perform a hypothesis test to determine if there is a difference in rates (for responses to a survey). I write out the solutions by hand. Want to download the solutions or learn more on the topic? Go to my free OpenEd textboook: pressbooks.bccampus.ca/1130sandbox/chapter/examples-of-testing-for-differences-in-proportions/
Hypothesis test for difference in click-through rates (two proportions)
Просмотров 925 месяцев назад
This videos steps through how to perform a hypothesis test to determine if the click through rate (proportion) is higher after a certain feature is turned on than before. Want to download the Excel file shown in this video or read more on this topic? Visit my openEd free Online Textbook section: pressbooks.bccampus.ca/1130sandbox/chapter/examples-of-testing-for-differences-in-proportions/
Hypothesis Test to Determine if Replacing Machines Decreases the Defective Rate
Просмотров 485 месяцев назад
This video steps you through how to perform a hypothesis test to determine if a change in production decreases defective rates. It is a left-tailed one-sample proportion test. I use Excel and write out the solutions by hand as well. Want the Excel file, written solutions and further explanations? See the folllowing section in my openEd online free textbook: pressbooks.bccampus.ca/1130sandbox/ch...
How to determine if you have increased your click through rate with a Hypothesis Test
Просмотров 1235 месяцев назад
In this video, I step through how to use a one-sample hypothesis test to determine if the click-through rate (CTR) has been increased by a change in an advertising campaign. Want the file shown in this video or a deeper explanation? See my free open-Ed textbook section on this topic: pressbooks.bccampus.ca/1130sandbox/chapter/hypothesis-testing-for-proportions-examples/
How to calculate the required sample size to reduce the margin of error for a 99% confidence level.
Просмотров 1566 месяцев назад
This video steps through how to calculate the sample size for a 99% confidence level when sigma is unknown. A sample of hexagon screws is analyzed. Want to download the Excel file or know more on this topic? Go to my free openEd book: pressbooks.bccampus.ca/1130sandbox/chapter/example-of-quality-control-for-space-fasteners/
Using Excel's T.INV function to build up a 90% Confidence Interval when Sigma is Unknown
Просмотров 1876 месяцев назад
This video steps through how to construct a 90% confidence interval when sigma is unknown. We use Excel's T.INV function. A sample of shear bolt lengths is analyzed. Want to download the Excel file or know more on this topic? Go to my free openEd book: pressbooks.bccampus.ca/1130sandbox/chapter/example-of-quality-control-for-space-fasteners/
How to use CONFIDENCE.T to build up a confidence interval when sigma is unknown
Просмотров 646 месяцев назад
This video steps through how to construct a 90% confidence interval when sigma is unknown. We use Excel's CONFIDENCE.T function. A sample of shear bolt lengths is analyzed. Want to download the Excel file or know more on this topic? Go to my free openEd book: pressbooks.bccampus.ca/1130sandbox/chapter/example-of-quality-control-for-space-fasteners/
How to build a confidence interval using T.INV.2T (for the true mean where sigma is unknown)
Просмотров 3176 месяцев назад
This video steps through how to construct a 99% confidence interval when sigma is unknown. We use Excel's T.INV.2T function. A sample of hexagon head screw lengths is analyzed. Want to download the Excel file or know more on this topic? Go to my free openEd book: pressbooks.bccampus.ca/1130sandbox/chapter/example-of-quality-control-for-space-fasteners/
The Flaw of Averages in Predicting Future Demand
Просмотров 1236 месяцев назад
This video explores the flaws in attempting to use means to predict future demands. We explore pseudo fictional EpiPen demands (that are a critical emergency medicine that has been known to experience shortages). Want to download the video or to know more on this subject? Go to my openEd textbook section on this topic: pressbooks.bccampus.ca/1130sandbox/chapter/confidence-intervals-for-σ-known/
How to calculate the sample size required for true mean estimations
Просмотров 1586 месяцев назад
How to calculate the sample size in order to ensure a maximum margin of error for true mean estimation and confidence interval calculations. Want to download the Excel file shown in the video or have a deeper explanation of this topic? Visit my OpenEd textbook section on this topic: pressbooks.bccampus.ca/1130sandbox/chapter/confidence-intervals-for-σ-known/
How to construct a mean confidence interval when sigma is known
Просмотров 1396 месяцев назад
How to construct a mean confidence interval when sigma is known using Excel. We build these in order to determine a range of values that the true mean will be between with the certainty equal to the confidence level. Want to download the Excel shown here or have a deeper explanation of this topic? Go to my free openEd book: pressbooks.bccampus.ca/1130sandbox/chapter/confidence-intervals-for-σ-k...
How to Solve an Inverse Sampling Problem using Excel's NORM.INV
Просмотров 1356 месяцев назад
How to use Excel's NORM.INV() function to calculate the minimum sample mean when the area/probability of that value is given. Want to download the Excel file shown in this video or have more information on Sampling Distributions? See my free OpenEd textbook: pressbooks.bccampus.ca/1130sandbox/chapter/sampling-distribution-of-the-sample-means/
Calculating probabilities for Sampling Distributions in Excel
Просмотров 5336 месяцев назад
Calculating probabilities for Sampling Distributions in Excel
How to Perform Proportional Stratified Sampling in Excel
Просмотров 1,2 тыс.6 месяцев назад
How to Perform Proportional Stratified Sampling in Excel
How to perform Simple Random Sampling using Excel's RAND() function
Просмотров 7266 месяцев назад
How to perform Simple Random Sampling using Excel's RAND() function
A quality control (applied) example using NORM.DIST and NORM.INV
Просмотров 547 месяцев назад
A quality control (applied) example using NORM.DIST and NORM.INV
Using Excel's NORM.INV() function
Просмотров 1357 месяцев назад
Using Excel's NORM.INV() function
The Empirical Rule, Outliers and Using Excel’s NORM.DIST()
Просмотров 827 месяцев назад
The Empirical Rule, Outliers and Using Excel’s NORM.DIST()
An introduction to Normal Distributions
Просмотров 747 месяцев назад
An introduction to Normal Distributions
How to use Excel's EXPON.DIST() function to calculate the probability for exponential distributions.
Просмотров 4467 месяцев назад
How to use Excel's EXPON.DIST() function to calculate the probability for exponential distributions.
Using the Exponential Distribution Formula and Understanding the Memoryless Property
Просмотров 1567 месяцев назад
Using the Exponential Distribution Formula and Understanding the Memoryless Property
How to solve for an unknown value using Goal Seek for a continuous uniform example.
Просмотров 447 месяцев назад
How to solve for an unknown value using Goal Seek for a continuous uniform example.
Solving for an unknown in Continuous Uniform Distributions
Просмотров 577 месяцев назад
Solving for an unknown in Continuous Uniform Distributions
Probability of At Most X for a Continuous Uniform Distribution
Просмотров 977 месяцев назад
Probability of At Most X for a Continuous Uniform Distribution
How to calculate the probability between two values for continuous uniform distributions
Просмотров 487 месяцев назад
How to calculate the probability between two values for continuous uniform distributions
How to calculate the probability of at least a certain number of events using Excel's POISSON.DIST
Просмотров 778 месяцев назад
How to calculate the probability of at least a certain number of events using Excel's POISSON.DIST
How to calculate at most a certain number of frauds reported using Poisson.Dist() in Excel.
Просмотров 458 месяцев назад
How to calculate at most a certain number of frauds reported using Poisson.Dist() in Excel.

Комментарии

  • @Salty0
    @Salty0 День назад

    Is there any unified way of doing this sampling? I mean on a single sheet using only formula.

  • @dice1981
    @dice1981 2 дня назад

    Great video

  • @jayjayson9943
    @jayjayson9943 5 дней назад

    Great video! One resource that also helped me: ruclips.net/video/H0_L3V8qKiY/видео.htmlsi=-01aOaZVbBapF6XI

  • @ummugulbulut1218
    @ummugulbulut1218 9 дней назад

    Thanks for the presentation, I am using this method for forecasting flight delays however, my forecasting values are getting negative after the third prediction. Does it mean my data is unsuitable for Holt Winter's method?

  • @GUSWANAADVENTUS
    @GUSWANAADVENTUS 15 дней назад

    Thanks for the video. But can I now the reference of initial values formula? I'm so confused because this method have the different initial values formula in other reference.

  • @varshneydevansh
    @varshneydevansh 16 дней назад

    what about the IntervalClosed in the Histogram? do we choose this explicitly?

  • @henon943
    @henon943 29 дней назад

    You are such a great teacher, the first video that explains the process without repeating nothing over and over, while explaining it simple and well!

  • @mohammediqbal8097
    @mohammediqbal8097 Месяц назад

    So nicely

  • @NoName-rq6be
    @NoName-rq6be Месяц назад

    u are the GOAT

  • @mukisaenoch749
    @mukisaenoch749 Месяц назад

    Thanks so much

  • @kevintran314
    @kevintran314 Месяц назад

    Hi Leslie, is this possible for daily data? so forecasting short term within 365 days out of the year? It becomes interesting with different holidays as they don't always fall on the same day of the year.

  • @tantipornanan
    @tantipornanan Месяц назад

    Can data be weekly instead of Month in quarter? the Model is still be effective?

  • @phb1955
    @phb1955 2 месяца назад

    really??? you should prepare for the video before you record.

  • @alpertopkaya7247
    @alpertopkaya7247 2 месяца назад

    thats was quite helpful, thanks so much

  • @bharatkollipara
    @bharatkollipara 2 месяца назад

    Thank you. You explained in a simple manner, easy to understand.

  • @ierinejoycaserial7049
    @ierinejoycaserial7049 2 месяца назад

    Do i still need to check if it is stationary or not?

  • @lilcheezit9338
    @lilcheezit9338 2 месяца назад

    literally thank you so much its 5 am have spent 3 hours trying to decipher my professor just for this one part and you fixed my issues in less than 10 minutes

  • @ZUBAIRNAWAB-s6r
    @ZUBAIRNAWAB-s6r 2 месяца назад

    Please share this excel file

  • @MagumoMbengeni
    @MagumoMbengeni 3 месяца назад

    ❤❤❤

  • @MagumoMbengeni
    @MagumoMbengeni 3 месяца назад

    This saved me ❤❤❤

  • @TruthLongevity
    @TruthLongevity 3 месяца назад

    Improving audio quality will make you the best.

  • @remavenkitaraman5966
    @remavenkitaraman5966 3 месяца назад

    Very useful

  • @dungar55
    @dungar55 3 месяца назад

    Thank you very much. You tought be better than my statistics teacher

  • @gg2mk
    @gg2mk 4 месяца назад

    Did you really say "times it by" in a math video?🙄

    • @9yril
      @9yril 3 месяца назад

      shut yo cornball head ahh up lil bro 🤦‍♀

  • @ElliottPrasad
    @ElliottPrasad 4 месяца назад

    this has saved my life, thankyou

  • @hajrawaheed9636
    @hajrawaheed9636 4 месяца назад

    Thankyou for this!...can we get this excel sheet? it would immensely help.

  • @monarajabifard3944
    @monarajabifard3944 4 месяца назад

    Thank you so much. I watched many videos but your video was the best solution and what exactly I needed.

  • @Roonza
    @Roonza 5 месяцев назад

    Nice video, how would you create a reverse cumulative frequency table so you get 2, 6, 16 etc?

  • @JVerstry
    @JVerstry 5 месяцев назад

    Terrible sound, it is a pity...

  • @joyrao4537
    @joyrao4537 5 месяцев назад

    what to do if one of the initial month's sales are 0, as later when I drag the formula I get division by 0 error

    • @lesliemajor6676
      @lesliemajor6676 5 месяцев назад

      @joyrao4537 that's such a good question. The initial value can be treated different ways. Some people even use solver to solve for the optimal initial values. Do you have a data set with this initial value of 0 to share? I could have a look

  • @joyrao4537
    @joyrao4537 5 месяцев назад

    my sales is 0 for a 2 months due to which I am not getting value of Level and Trend Further down the month, how do I deal with that

  • @RusselldeJesusSLP
    @RusselldeJesusSLP 5 месяцев назад

    That was the most helpful comprehensive stratified sampling tutorial I've seen yet. Thank you!

  • @timyrasegty7857
    @timyrasegty7857 5 месяцев назад

    But what should be done when neither the first condition nor the second is satisfied?

    • @lesliemajor6676
      @lesliemajor6676 5 месяцев назад

      You just satisfy the constraints and don't worry about optimizing. If the constraints can't be satisfied this is an infeasible problem. Sadly this can happen, for example in healthcare where not only is there not an optimal solution, there is no solution at all.

  • @timyrasegty7857
    @timyrasegty7857 5 месяцев назад

    But what should be done when neither the first condition nor the second is satisfied?

  • @austinbright-j3o
    @austinbright-j3o 6 месяцев назад

    How can I build forecast.ets Excel function essentially by hand so I have more control over inputs? This is for seasonality as well. I ran forecast.ets.stat so I have the smoothing parameters. Do you have videos on the equations so I can reproduce the results of the exponential triple smoothing by hand?

  • @austinbright-j3o
    @austinbright-j3o 6 месяцев назад

    How can I build forecast.ets Excel function essentially by hand so I have more control over inputs? This is for seasonality as well. I ran forecast.ets.stat so I have the smoothing parameters. Do you have videos on the equations so I can reproduce the results of the exponential triple smoothing by hand? Is this video the same thing? Or is that more complicated?

  • @vicenteangelmaldonadoperez5647
    @vicenteangelmaldonadoperez5647 6 месяцев назад

    The Best video, thank You.

  • @YasuDZN
    @YasuDZN 6 месяцев назад

    Ahmm

  • @anathardayaldar
    @anathardayaldar 6 месяцев назад

    I use notepad to compose my questions instead of word so that no invisible control characters sneak into the text.

  • @sengpanha5726
    @sengpanha5726 6 месяцев назад

    Hello teacher, can you tell me how to find alpha and beta in any data?

  • @murtuza.ahmed49
    @murtuza.ahmed49 6 месяцев назад

    Thanks 🙌.. it was helpful. Keep up the good work !!

  • @Jerry-o1j
    @Jerry-o1j 6 месяцев назад

    👍

  • @Jerry-o1j
    @Jerry-o1j 6 месяцев назад

    I saw one type of exponential distribution formula which has lambda times "e".

  • @aminf8834
    @aminf8834 7 месяцев назад

    I liked that and I will watch it again and again

  • @benmassaoudnassreddine7764
    @benmassaoudnassreddine7764 7 месяцев назад

    Please give me excel version

  • @Azkaban819
    @Azkaban819 7 месяцев назад

    Good one! Thank you for sharing!

  • @binaryblade2
    @binaryblade2 7 месяцев назад

    First!

  • @BastiaanQuast
    @BastiaanQuast 7 месяцев назад

    This is great, thank you. Is the spreadsheet available?

  • @thetank5642
    @thetank5642 7 месяцев назад

    Helped me with my assignment. Thank you very much

  • @alvarostatistics01
    @alvarostatistics01 8 месяцев назад

    Sorry. Please answer Mrs, It's aditive or multiplicatice?