Statistics 101: Chi-square in Excel using College Enrollment Data

  Рет қаралды 83,655

Brandon Foltz

Brandon Foltz

12 жыл бұрын

In this video, we discuss the basic process for computing a chi-square test for independence step-by-step in Excel using college enrollment data.
The heart of this video is the computation of chi-square to determine with 95% confidence whether or not the variation in the enrollment could be explained by random chance alone. We discuss how to find the critical chi-square value in Excel and locate both the problem and critical chi-square values on the chi-square distribution.
My playlist table of contents, Video Companion Guide PDF documents, and file downloads can be found on my website: www.bcfoltz.com

Пікірлер: 88
@HardikParmarPrince0612
@HardikParmarPrince0612 9 жыл бұрын
I just found a Great Person who have Superb Techniques and Great Method to Teach..!!! Thanks Mr.Brandon Foltz...!!!
@BrandonFoltz
@BrandonFoltz 9 жыл бұрын
Hardik Parmar Thank you Hardik! So glad I can be of help. Means a lot to me. Keep on learning! Best, B.
@HardikParmarPrince0612
@HardikParmarPrince0612 9 жыл бұрын
Yes *****​ I am learning hypothesis, Anova, chi square Thanks for your effort glad to know one good Faculty like you..!!
@ratanpsm
@ratanpsm 8 жыл бұрын
Your lectures on you tube are very interesting and clears the concepts. After going through your lectures on ANNOVA, one way and two clusters, I tried calculating it through Excel, it became fun. Now I understand the concepts well and got beautiful idea to explain my medical students the same. I am sure, they will enjoy and will understand, why this all exists....you said very well. I shall wait to hear you more. I will also search for multivariate analysis doing, its concepts...explained by you. Thanks for making it for public. You will become popular and well known to larger group. I congratulate you for this noble cause. In which country you are and the institution?????
@billabongbabe56
@billabongbabe56 10 жыл бұрын
You are a life saver! I cannot thank you enough. I learned more from watching your videos than I did from a semester of statistics. You are so good at explaining things to beginners in statistics and excel.
@seanspraguesr
@seanspraguesr 2 жыл бұрын
I am taking a course on Coursera n it was discussing chi (ki) square …. It threw in Yates correction with our disclosing that…. I got all confused why my math was not working… I go online, I find your video and felt relieved I was not crazy… Even better, I gained a better understanding between independent / dependent testing … Thank you
@joanmutesi5051
@joanmutesi5051 5 жыл бұрын
They say you don't judge a book by the cover. I love this tutorial. I feel that i can answer any questions on chi square now. Thank you.
@rainmakr9555
@rainmakr9555 5 жыл бұрын
i think one of the best part about your teaching is how you repeat stuff until its hammered down into our heads. the more complex the topic the more same reference being used helps to learn the basic concepts better. keep up the excellent work
@deannawilliamson4909
@deannawilliamson4909 6 жыл бұрын
OMG! This has been so helpful! Thank so much from the bottom of my heart! I've bookmarked all of your stats video for review. You are a life saver! :)
@Roland1907
@Roland1907 8 жыл бұрын
Thanks Brandon. This is the most awesome video . I have seen. Thanks once again for taking the time out to make these series of videos.
@rainmakr9555
@rainmakr9555 5 жыл бұрын
i am going through these videos at such a fast rate cause i understand them so well. please keep making more videos.
@sharriettefinley467
@sharriettefinley467 9 жыл бұрын
I believe this is the most helpful video so far. Thank you!
@mostakduwrc
@mostakduwrc 6 жыл бұрын
always I found what I'm looking for from your tutorials. You always answers the hidden questions . Thank you for your efforts.
@florgum89
@florgum89 7 жыл бұрын
This is the first channel that I've really understood how a statistical concept is USED. Pretty much all other channels use the standard examples of coins etc, where the application is very unclear I also feel like I have retained the ideas because you have taken viewer through the entire journey of the analysis, with the graphs etc, so thank you! Also, could you please do a degrees of freedom video!!
@glassyartist
@glassyartist 3 жыл бұрын
Fabulous really helped me get the concept of what we are doing in a chi -square test. Before I struggled to work out where to out all the variables in! Fabulous will refer to other tutorials from here on in
@wandamontalvo7265
@wandamontalvo7265 10 жыл бұрын
Totally practical and easy to follow the logic, thank you!
@williamhass9747
@williamhass9747 2 жыл бұрын
BRANDON THANK YOU FOR THESE STATS VIDEOS!
@vinceivanov1020
@vinceivanov1020 6 жыл бұрын
Mr. Brandon, I'm taking statistics in my MBA. Thank you for the great videos. Your videos helped me to complete the course with an A.
@anuradhasrivastava1592
@anuradhasrivastava1592 7 жыл бұрын
Hey Brandon!! I find your videos immensely helpful, I am a big fan of your way of teaching. Please do keep posting these amazing videos on statistical concepts!!
@Mikeybikey88
@Mikeybikey88 9 жыл бұрын
Thank you for taking your time to make videos like this for us. They are super helpful! Thanks again.
@lafavemark
@lafavemark 10 жыл бұрын
Thank you so much for making this really easy to understand. It definitely helps to go step by step through chi square with excel (or the open office equivalent) to see where the numbers come from.
@RealAjGhimire
@RealAjGhimire 7 жыл бұрын
You, sir, are my hero !!
@yrainykwok1533
@yrainykwok1533 6 жыл бұрын
Goddd you are the best. Love the look of the PowerPoint and the clear lecture!! Thanks for put so much effort to help us!
@Jmwlk07
@Jmwlk07 8 жыл бұрын
Thanks for being such a great teacher. Exam tomorrow and you are saving me from having many many panic attacks :)
@Eureka2101
@Eureka2101 10 жыл бұрын
Thank you very much, Brandon. I've learnt much about Chi-Square Testing.
@maisamrafiee2007
@maisamrafiee2007 8 жыл бұрын
Thanks Thanks THANKS YOU ARE AMAZING and GREAT WISHING YOU ALL THE BEST
@amirhosseinyazdavar
@amirhosseinyazdavar 6 жыл бұрын
Excellent as always!!!
@valor36az
@valor36az 6 жыл бұрын
What a fantastic series
@raymnundkat04
@raymnundkat04 5 жыл бұрын
How did you come up with degree of freedom of 16 in the data? Thanks
@by2358
@by2358 2 жыл бұрын
So clear - thank you!
@rogermylan6528
@rogermylan6528 9 жыл бұрын
THANK YOU! :) You are a life saver!
@lanmeister9334
@lanmeister9334 10 жыл бұрын
Great Video! Thank you so much!
@elena-mihaelagrigore6669
@elena-mihaelagrigore6669 3 жыл бұрын
Thank you for the detailed and clear exlanation of why and how is the Chi-square used. I needed to understand this concept for a Stats course. The explanation of the appointed teacher for this class are nowhere near as clear as yours. Your help is much appreciated !
@daneshhomayoon
@daneshhomayoon 10 жыл бұрын
That was excellent. Thank you.
@patravs2
@patravs2 3 жыл бұрын
Hi Mr Brandon, GR8 VIDEOS! kindly do video on log linear analysis
@Dyokoto
@Dyokoto 9 жыл бұрын
Thank you so much!
@pjgdba306
@pjgdba306 4 жыл бұрын
Great help, thanks. I find statistics course jam way too fast - at least for me! This was a well-paced, methodical explanation. Not that some of the math leaves me hanging, like what's the rationale for the expected values, but that I'll have to live with - at least for the moment.
@deepakishore1891
@deepakishore1891 6 жыл бұрын
Brandon you have the gift of explaining! You removed my fear of statistics. Do you teach PCA (Principle Component Analysis)?
@desert00200
@desert00200 6 жыл бұрын
Hi Brandon, I wasn't able to download the file that you have mentioned. If I click the link the page says "Nothing Here!". I think you removed that file. Even without that file I am still able to follow each and every point that you have explained. Hats off to you and they way you teach. If we have teachers like you then certainly we will see students enjoying going to school/college every day. Keep up the good work and may god bless you!
@farhimouad2860
@farhimouad2860 8 жыл бұрын
THANK YOU SO MUCH. JUST A SMALL THING: FOR COMING STUDENTS, PLEASE INVERSE THE ORDER OF VIDEOS 2 AND 3.
@marcoycaza1920
@marcoycaza1920 3 жыл бұрын
Gold!!!!
@mouhamadibrahim4269
@mouhamadibrahim4269 10 ай бұрын
Gold !
@marmaratp319
@marmaratp319 9 жыл бұрын
thank you so much
@perfectionist810
@perfectionist810 11 жыл бұрын
You are awesome, btw.
@noelambalong270
@noelambalong270 2 жыл бұрын
ty
@ponnadanarayana7680
@ponnadanarayana7680 6 жыл бұрын
Thanks for a great presentation. Can you also include some examples that are relevant to medical field?
@ariesmayani
@ariesmayani 8 жыл бұрын
thank you Mr. Brandon. I've follow the steps in your video and that makes my mind clearer to understand the chi square formula. if I may ask, will this formula work to know a case like: is there is any correlation between genders to their number of words spoken in a minute? I've try to calculate my data with this formula, but the chi square result is 0.095 to chi square critical value of 3.84. does it mean the correlation is absolutely no related? thank you.
@BrandonFoltz
@BrandonFoltz 11 жыл бұрын
Hello! I just downloaded the file from the blog post and was able to open it in both Google docs and Excel 2010 just fine. :( If you want send me a message and I can email it to you if you like. Best, B.
@johlibeee2660
@johlibeee2660 4 жыл бұрын
i just tried the blog link, and it says page cannot be found :( what now huhu
@nikolaoplandsavic1833
@nikolaoplandsavic1833 4 жыл бұрын
Thanks for the tutorials Mr Brandon. I wanted to download the excel file to follow along in In R commander but it said the page was unavailable., and i could not find it in the downloads list
@vipkoul
@vipkoul 7 жыл бұрын
Great Series of videos @Brandon Foltz however Excel file is no longer available, is there any other alternative link
@lagayle2007
@lagayle2007 10 жыл бұрын
So can I conduct the chi-square test to determine if any significant associations exist between responses in different categories? If so do you have a video demonstrating this procedure
@electricaltechnology1970
@electricaltechnology1970 2 жыл бұрын
First thank you so much Sir for being such a great teacher who completely exposed the secrets of statistics. Our lesson in Chi-square composed of one way classification Chi-square and a two way classification Chi-square. If I may ask, what lesson from the two is your video referring to sir?
@cococnk388
@cococnk388 Жыл бұрын
Two way is when we have two groups of categorical variables...the case in this video...(Years, level of students) One way is the exemple he did in the previous slide of "is the die fair or not"... we just have one group of categorical variable "the faces of the die"
@Grassy20
@Grassy20 7 жыл бұрын
I'm currently at 23:45. I know this isn't an excel tutorial, but you could just lock the row and column individually and your autofill function would work in every direction.
@lakshitmendiratta1155
@lakshitmendiratta1155 5 жыл бұрын
Great lesson! I am just not able to find this excel sheet on the link you provided for learning.
@sanyfin
@sanyfin 8 жыл бұрын
I have expected values from regression line and raw values. I want to compare that what is the threshold level of chi square at which difference between expected values and raw values start getting different. in other word several real values will be near to the expected values and thus are not statistically different. But several real values are far away from expected values and are statistically different. Is there a way to do the experiment in a way that this experiment is repeated in several time on small chunks or quantiles of data until it finds a data range from which difference between expected and real values starts getting statistically different?
@skelmoss
@skelmoss 9 жыл бұрын
I was wondering if the powerpoints for these lectured were published anywhere? I would love to be able to print them out to use as I follow along.
@30MinutesAroundTheBrain
@30MinutesAroundTheBrain 7 жыл бұрын
Your videos a great! I have a question that`s not very important for the practical usage but... Is there any easy explanation of the "expected value"? It`s clear with dice, there we have the probability, but what is the logic of our exprctations in this example?
@joefagan9335
@joefagan9335 2 жыл бұрын
Assume for freshman there is a linear relation between number and year AND for sophomore there is another linear relationship between number and year AND for bla bla. Then if you find those relationships and pump in the years out will pop the expected values.
@kevinglynn525
@kevinglynn525 4 жыл бұрын
Hi Brandon, I was told that you can't use time as a categorical variable? This was in response to a question I asked on researchgate on a similar dataset using years etc before I'd seen this video
@SyedKollol
@SyedKollol 11 жыл бұрын
HI, Is the expected value in the table=forecasted or budgeted value? its very interesting!
@liranzaidman1610
@liranzaidman1610 5 жыл бұрын
Hi Brandon, This is a great tool for analyzing variance. However, I tried this in real life, and it seems to have some problems. Because the Chi-Square statistic is a summation of the squared gaps between Forecast and Actual, divided by the actual - if the actual number is low (let’s say 1 or 2) or if the gaps between the actual outcomes and the forecast are rather big - than the Chi-Square will always be a big number, much more than the Chi-Square critical which is usually based on a small number of Degrees of freedom. Here’s an example: Product Location Actual Forecast X A 1 8 Y B 11 8 Z C 14 8 The Chi-Square statistic is 47.3 and the Chi-Square critical is 9.5 (95%, 4 df) How can we solve this? Is there a thumb rule that can help is with that thing? Thanks
@brentb1411
@brentb1411 10 жыл бұрын
Is there a list of videos in order of progression? I had a difficult time finding "the previous video" or "the next video" unless they were part 1 and part 2.
@BrandonFoltz
@BrandonFoltz 10 жыл бұрын
kzfaq.infoplaylists Hello! Everything is in order by playlist, topic, and sequence there. Thanks for watching! - B
@poojakhemani3865
@poojakhemani3865 4 жыл бұрын
any video like this where I can understand value of P ?
@rongfuwang4041
@rongfuwang4041 3 жыл бұрын
Thanks for the videos. But now I am confused that I got two absolutely different results from Excel and R, respectively. X² is 46.781 from R.
@nasrmhm
@nasrmhm 10 жыл бұрын
Thanks can we use it to check for technical error between replicates
@nitinraj5560
@nitinraj5560 5 жыл бұрын
Hey Mr Brandon, what was the real reason for this change in enrollment data though?
@karannchew2534
@karannchew2534 3 жыл бұрын
14:26 What is the intuition behind this please? (row_total x column_total)/grand_total = Expected Value
@denissedeo895
@denissedeo895 5 жыл бұрын
I came to learn, but I definitely missed the reassurance that I will be okay...
@elizabethdickson-gavney6017
@elizabethdickson-gavney6017 5 жыл бұрын
The link to the blog post is not working and I cannot find the excel data file to use with these exercises. Thanks
@elizabethdickson-gavney6017
@elizabethdickson-gavney6017 5 жыл бұрын
Also - do you ever give examples in using STATA?
@sinemkayan2734
@sinemkayan2734 4 жыл бұрын
Hi, I am trying to calculate the statistics of "How does CO2 emission correlate with the number of car production? " I know that I should make Goodness of fitnees for each of them but i don't konw how to calculate expected valu. Could you please help me? Thank you sir.
@capsfan9816
@capsfan9816 9 жыл бұрын
Can you tell us how you cam up with 16 degrees of freedom?
@DuApril
@DuApril 10 жыл бұрын
can someone help me understand why is expected calculated as : (c11*h6) /h11?
@desert00200
@desert00200 6 жыл бұрын
Expected values are calculated from the contingency table, (Column total x Row total)/Grand total. In other words, expected value = Column total x Row total/Grand total. Hope it helps (after four years :-P )
@ashton353
@ashton353 9 жыл бұрын
How in did you get 16 for your degrees of freedom? It does not appear to follow the rules u outline in the previous video. Could you please explain?
@ashton353
@ashton353 9 жыл бұрын
Never mind you thoroughly explained it that it is, (row-1)*(column-1)
@MuhammedShiharMZaid
@MuhammedShiharMZaid 5 жыл бұрын
I am finding difficulties in accessing n downloading the xl
@SimplifiedEconomics
@SimplifiedEconomics 4 жыл бұрын
Can you please share the file. The link is not working. Thanks in advance.
@ArijitBiswasdotcom
@ArijitBiswasdotcom 6 жыл бұрын
In the problem the university is 4 year old and how're we looking at 5 year enrollment statistics?
@estiaanjoubert479
@estiaanjoubert479 10 жыл бұрын
Isn't the p-value = 0.003561809 and not 0.05?
@brookeellis2537
@brookeellis2537 9 жыл бұрын
Yes, I believe he meant alpha value is 0.05
@estiaanjoubert479
@estiaanjoubert479 9 жыл бұрын
Brooke Ellis Thanks Brooke! :)
@perfectionist810
@perfectionist810 11 жыл бұрын
Brandon, I downloaded the Excel file, says your file is corrupt. Please double-check.
@perfectionist810
@perfectionist810 11 жыл бұрын
I just realized it was my download that was corrupt.
@DuApril
@DuApril 10 жыл бұрын
never mind i found the other video
Statistics 101: Introduction to the Chi-square Test
37:39
Brandon Foltz
Рет қаралды 390 М.
Statistics 101: Two Populations, Matched Sample t-test
34:27
Brandon Foltz
Рет қаралды 85 М.
Женская драка в Кызылорде
00:53
AIRAN
Рет қаралды 505 М.
Inside Out 2: Who is the strongest? Joy vs Envy vs Anger #shorts #animation
00:22
Double Stacked Pizza @Lionfield @ChefRush
00:33
albert_cancook
Рет қаралды 109 МЛН
Perform Chi-Square Test Of Independence In Excel (Including P Value!)
8:35
Statistics 101: Variance and its Sampling Distribution
27:20
Brandon Foltz
Рет қаралды 84 М.
Statistics 101: To z or to t, That is the Question
38:17
Brandon Foltz
Рет қаралды 208 М.
Vectors & Dot Product • Math for Game Devs [Part 1]
3:16:28
Freya Holmér
Рет қаралды 812 М.
Statistics 101: Confidence Interval Estimation, Sigma Known
44:07
Brandon Foltz
Рет қаралды 397 М.
Statistics 101: Two-way ANOVA with Replication, An Introduction
34:15
Brandon Foltz
Рет қаралды 153 М.
Женская драка в Кызылорде
00:53
AIRAN
Рет қаралды 505 М.