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

[@HardikParmarPrince0612]

I just found a Great Person who have Superb Techniques and Great Method to Teach..!!! Thanks Mr.Brandon Foltz...!!!

[@BrandonFoltz]

Hardik Parmar Thank you Hardik! So glad I can be of help. Means a lot to me. Keep on learning! Best, B.

[@HardikParmarPrince0612]

Yes *****​ I am learning hypothesis, Anova, chi square Thanks for your effort glad to know one good Faculty like you..!!

[@billabongbabe56]

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.

[@raymnundkat04]

How did you come up with degree of freedom of 16 in the data? Thanks

[@ratanpsm]

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?????

[@rainmakr9555]

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]

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! :)

[@joanmutesi5051]

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.

[@letustalk-w4e]

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

[@rainmakr9555]

i am going through these videos at such a fast rate cause i understand them so well. please keep making more videos.

[@florgum89]

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!!

[@vinceivanov1020]

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.

[@mostakduwrc]

always I found what I'm looking for from your tutorials. You always answers the hidden questions . Thank you for your efforts.

[@Roland1907]

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.

[@Mikeybikey88]

Thank you for taking your time to make videos like this for us. They are super helpful! Thanks again.

[@seanspraguesr]

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

[@yrainykwok1533]

Goddd you are the best. Love the look of the PowerPoint and the clear lecture!! Thanks for put so much effort to help us!

[@sharriettefinley467]

I believe this is the most helpful video so far. Thank you!

[@anuradhasrivastava1592]

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!!

[@Jmwlk07]

Thanks for being such a great teacher. Exam tomorrow and you are saving me from having many many panic attacks :)

[@lafavemark]

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.

[@wandamontalvo7265]

Totally practical and easy to follow the logic, thank you!

[@deepakishore1891]

Brandon you have the gift of explaining! You removed my fear of statistics. Do you teach PCA (Principle Component Analysis)?

[@elena-mihaelagrigore6669]

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 !

[@williamhass9747]

BRANDON THANK YOU FOR THESE STATS VIDEOS!

[@elizabethdickson-gavney6017]

The link to the blog post is not working and I cannot find the excel data file to use with these exercises. Thanks

[@Eureka2101]

Thank you very much, Brandon. I've learnt much about Chi-Square Testing.

[@lagayle2007]

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

[@farhimouad2860]

THANK YOU SO MUCH. JUST A SMALL THING: FOR COMING STUDENTS, PLEASE INVERSE THE ORDER OF VIDEOS 2 AND 3.

[@pjgdba306]

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.

[@lakshitmendiratta1155]

Great lesson! I am just not able to find this excel sheet on the link you provided for learning.

[@desert00200]

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!

[@karannchew2534]

14:26 What is the intuition behind this please? (row_total x column_total)/grand_total = Expected Value

[@maisamrafiee2007]

Thanks Thanks THANKS YOU ARE AMAZING and GREAT WISHING YOU ALL THE BEST

[@valor36az]

What a fantastic series

[@amirhosseinyazdavar]

Excellent as always!!!

[@by2358]

So clear - thank you!

[@nasrmhm]

Thanks can we use it to check for technical error between replicates

[@patravs2]

Hi Mr Brandon, GR8 VIDEOS! kindly do video on log linear analysis

[@skelmoss]

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.

[@SyedKollol]

HI, Is the expected value in the table=forecasted or budgeted value? its very interesting!

[@SimplifiedEconomics]

Can you please share the file. The link is not working. Thanks in advance.

[@ponnadanarayana7680]

Thanks for a great presentation. Can you also include some examples that are relevant to medical field?

[@nitinraj5560]

Hey Mr Brandon, what was the real reason for this change in enrollment data though?

[@nikolaoplandsavic1833]

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

[@poojakhemani3865]

any video like this where I can understand value of P ?

[@elizabethdickson-gavney6017]

Also - do you ever give examples in using STATA?

[@capsfan9816]

Can you tell us how you cam up with 16 degrees of freedom?

[@RealAjGhimire]

You, sir, are my hero !!

[@kevinglynn525]

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

[@vipkoul]

Great Series of videos @Brandon Foltz however Excel file is no longer available, is there any other alternative link

[@electricaltechnology1970]

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]

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"

[@sinemkayan2734]

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.

[@MuhammedShiharMZaid]

I am finding difficulties in accessing n downloading the xl

[@Grassy20]

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.

[@liranzaidman1610]

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

[@ariesmayani]

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.

[@perfectionist810]

Brandon, I downloaded the Excel file, says your file is corrupt. Please double-check.

[@ArijitBiswasdotcom]

In the problem the university is 4 year old and how're we looking at 5 year enrollment statistics?

[@sanyfin]

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?

[@rogermylan6528]

THANK YOU! :) You are a life saver!

[@30MinutesAroundTheBrain]

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]

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.

[@brentb1411]

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]

kzbin.infoplaylists Hello! Everything is in order by playlist, topic, and sequence there. Thanks for watching! - B

[@daneshhomayoon]

That was excellent. Thank you.

[@BrandonFoltz]

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]

i just tried the blog link, and it says page cannot be found :( what now huhu

[@ashton353]

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]

Never mind you thoroughly explained it that it is, (row-1)*(column-1)

[@rongfuwang4041]

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.

[@lanmeister9334]

Great Video! Thank you so much!

[@estiaanjoubert479]

Isn't the p-value = 0.003561809 and not 0.05?

[@brookeellis2537]

Yes, I believe he meant alpha value is 0.05

[@estiaanjoubert479]

Brooke Ellis Thanks Brooke! :)

[@DuApril]

can someone help me understand why is expected calculated as : (c11*h6) /h11?

[@desert00200]

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 )

[@mouhamaadibrahim]

Gold !

[@noelambalong270]

ty

[@marcoycaza1920]

Gold!!!!

[@perfectionist810]

You are awesome, btw.

[@Dyokoto]

Thank you so much!

[@marmaratp319]

thank you so much

[@denissedeo895]

I came to learn, but I definitely missed the reassurance that I will be okay...

[@perfectionist810]

I just realized it was my download that was corrupt.

[@DuApril]

never mind i found the other video

[@TheGibberingGoblin]

bump