- 174
- 1 129 601
Leslie Major
Приєднався 9 вер 2011
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/
Переглядів: 96
Відео
How to perform a pooled variance t-test
Переглядів 884 місяці тому
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).
Переглядів 484 місяці тому
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
Переглядів 664 місяці тому
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)
Переглядів 834 місяці тому
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
Переглядів 414 місяці тому
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
Переглядів 1104 місяці тому
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.
Переглядів 1285 місяців тому
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
Переглядів 1585 місяців тому
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
Переглядів 555 місяців тому
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)
Переглядів 2825 місяців тому
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
Переглядів 1095 місяців тому
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
Переглядів 1285 місяців тому
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
Переглядів 1185 місяців тому
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
Переглядів 1125 місяців тому
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
Переглядів 4555 місяців тому
Calculating probabilities for Sampling Distributions in Excel
How to Perform Proportional Stratified Sampling in Excel
Переглядів 8915 місяців тому
How to Perform Proportional Stratified Sampling in Excel
How to perform Simple Random Sampling using Excel's RAND() function
Переглядів 4765 місяців тому
How to perform Simple Random Sampling using Excel's RAND() function
A quality control (applied) example using NORM.DIST and NORM.INV
Переглядів 375 місяців тому
A quality control (applied) example using NORM.DIST and NORM.INV
The Empirical Rule, Outliers and Using Excel’s NORM.DIST()
Переглядів 795 місяців тому
The Empirical Rule, Outliers and Using Excel’s NORM.DIST()
An introduction to Normal Distributions
Переглядів 715 місяців тому
An introduction to Normal Distributions
How to use Excel's EXPON.DIST() function to calculate the probability for exponential distributions.
Переглядів 3926 місяців тому
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
Переглядів 1436 місяців тому
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.
Переглядів 406 місяців тому
How to solve for an unknown value using Goal Seek for a continuous uniform example.
Solving for an unknown in Continuous Uniform Distributions
Переглядів 546 місяців тому
Solving for an unknown in Continuous Uniform Distributions
Probability of At Most X for a Continuous Uniform Distribution
Переглядів 956 місяців тому
Probability of At Most X for a Continuous Uniform Distribution
How to calculate the probability between two values for continuous uniform distributions
Переглядів 486 місяців тому
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
Переглядів 706 місяців тому
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.
Переглядів 426 місяців тому
How to calculate at most a certain number of frauds reported using Poisson.Dist() in Excel.
Thanks so much
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.
Can data be weekly instead of Month in quarter? the Model is still be effective?
really??? you should prepare for the video before you record.
thats was quite helpful, thanks so much
Thank you. You explained in a simple manner, easy to understand.
Do i still need to check if it is stationary or not?
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
Please share this excel file
❤❤❤
This saved me ❤❤❤
Improving audio quality will make you the best.
Very useful
Thank you very much. You tought be better than my statistics teacher
Did you really say "times it by" in a math video?🙄
shut yo cornball head ahh up lil bro 🤦♀
this has saved my life, thankyou
Thankyou for this!...can we get this excel sheet? it would immensely help.
Thank you so much. I watched many videos but your video was the best solution and what exactly I needed.
Nice video, how would you create a reverse cumulative frequency table so you get 2, 6, 16 etc?
Terrible sound, it is a pity...
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
@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
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
That was the most helpful comprehensive stratified sampling tutorial I've seen yet. Thank you!
But what should be done when neither the first condition nor the second is satisfied?
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.
But what should be done when neither the first condition nor the second is satisfied?
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?
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?
The Best video, thank You.
Ahmm
I use notepad to compose my questions instead of word so that no invisible control characters sneak into the text.
Hello teacher, can you tell me how to find alpha and beta in any data?
Thanks 🙌.. it was helpful. Keep up the good work !!
👍
I saw one type of exponential distribution formula which has lambda times "e".
I liked that and I will watch it again and again
Please give me excel version
Good one! Thank you for sharing!
First!
This is great, thank you. Is the spreadsheet available?
Helped me with my assignment. Thank you very much
Sorry. Please answer Mrs, It's aditive or multiplicatice?
The way you initialize the seasonal, level, and trend parameters was helpful to see. Solver is a bit sketchy if the parameter space is too large and that keeps the list of parameters down to just alpha, beta, and gamma. Thank you.
Thank you so much this is super helpful even after 6 years!
thank you truly
Nice
Does anyone know how to change the labels of the blue one to just one number each??
Thank you for your great video! Do you think this work correctly with 12 months data historical and some month value = 0 as well. It will be great to see how can we apply for multi sku products ?
Thank you for great video ! Do you think this model still work perfectly with 12 months data and some month with 0 value. Then is there any way to apply for multi sku products... in the same sheet?
You are the best teacher! It's so clear! Thank you!
Thank you. Compendious