Excel 2013 Statistical Analysis #73: Chi-Square Test Independence 2 Categorical Var. (PivotTables)

Topics in this video:
1. (00:12) Intro to Chi-Square Hypothesis Test Independence Between 2 Categorical Variables with 2 PivotTables and one set of formulas.
2. (01:19) How to take survey results for 2 categorical variables and test whether the “Hiring Over The Next Year” variable is independent of “Firm Type” (Private or Public) variable using Chi Square.
3. (03:35) How to place the correct “Response Variable” into the row area of the cross tabulated table and how to place the correct “Explanatory Variable” into the column area of the cross tabulated table.
4. (04:23) How to think of a Test of Independence in terms of adding a second variable to the “Response Variable” to break apart “Response Variable” Proportions into Two Separate proportions based on a second variable.
5. (07:34) Formulas for Test of Independence
6. (08:42) 6 Steps in to Chi-Square Hypothesis Test Independence Between 2 Categorical Variables.
7. (10:06) How To Run Test of Independence with PivotTables and Formulas from a Proper Data Set.
8. (10:46) PivotTable for Observed Frequencies
9. (11:57) PivotTable for Sample Proportions
10. (12:46) Copy and Paste Values and Format from PivotTable to make Formula Table
11. (13:43) Formulas for Expected Frequencies in a Cross Tabulates (or Contingency Table) using Mixed and Absolute Cell References.
12. (16:40) Array Formula in AND function to check if all Expected Frequencies are Greater than or Equal to Five.
13. (19:13) Get rid of GetPivotData Function
14. (20:00) CHISQ.TEST function to calculated p-value from Observed Frequencies and Expected Frequencies.
15. (20:58) Step 5: Conclusion
16. (21:26) Step 6: If we reject the Null Hypothesis Test, calculate Sample Proportions and Charts

[Muuip]

17:00 Array Formula with AND(A1:B3>5 ) and Control + Shift + Enter

F9 to see array, Control + Z to return

Great tip! Very useful! 👍

[excelisfun]

Excel 2013 Statistical Analysis #73: Chi-Square Test Independence 2 Categorical Var. (PivotTables)
Topics in this video:
1. (00:12) Intro to Chi-Square Hypothesis Test Independence Between 2 Categorical Variables with 2 PivotTables and one set of formulas.
2. (01:19) How to take survey results for 2 categorical variables and test whether the “Hiring Over The Next Year” variable is independent of “Firm Type” (Private or Public) variable using Chi Square.
3. (03:35) How to place the correct “Response Variable” into the row area of the cross tabulated table and how to place the correct “Explanatory Variable” into the column area of the cross tabulated table.
4. (04:23) How to think of a Test of Independence in terms of adding a second variable to the “Response Variable” to break apart “Response Variable” Proportions into Two Separate proportions based on a second variable.
5. (07:34) Formulas for Test of Independence
6. (08:42) 6 Steps in to Chi-Square Hypothesis Test Independence Between 2 Categorical Variables.
7. (10:06) How To Run Test of Independence with PivotTables and Formulas from a Proper Data Set.
8. (10:46) PivotTable for Observed Frequencies
9. (11:57) PivotTable for Sample Proportions
10. (12:46) Copy and Paste Values and Format from PivotTable to make Formula Table
11. (13:43) Formulas for Expected Frequencies in a Cross Tabulates (or Contingency Table) using Mixed and Absolute Cell References.
12. (16:40) Array Formula in AND function to check if all Expected Frequencies are Greater than or Equal to Five.
13. (19:13) Get rid of GetPivotData Function
14. (20:00) CHISQ.TEST function to calculated p-value from Observed Frequencies and Expected Frequencies.
15. (20:58) Step 5: Conclusion
16. (21:26) Step 6: If we reject the Null Hypothesis Test, calculate Sample Proportions and Charts

[pphong]

Mike.., Excel for Stastical Analysis in Business & Economics is a fantastic series! A great introduction to statistics - with practical problem solving in excel! Thank you for sharing high quality learning for free!

[erichara]

Fantastic series of videos!
Really underappreciated on yt!
Tnx for sharing your knowledge!

[ascreations]

SIR, THIS IS THE BEST VIDEO I COULD MANAGED TO GET ....LIKE SERIOUSLY....I FELT SE HAPPY THAT I SAW THIS VIDEO BEFORE STARTING MY RESEARCH ANALYSIS..

THANKYOU SO MUCH SIR FOR YOUR EFFORTS!!!

[bernardpullon]

You are an awesome teacher, where were you when I was learning this stuff many years ago! A scholar and a gentleman.

[buggsmoran]

Excellent video. Just learned a lot of great tips.

[Reduce_Scan]

I want to know all the functions that deal with several pages at the same time like sum & count & max & etc

[Muuip]

19:44 Good to know that "GetPivotData" can be turned off. It is also a great function to help visualize Standard Deviation or Standard Error in interactive Dashboards!

[ProBoy]

Hi There,
Apologies I do not know your name but I must say your videos are commendable. I just wanted to know that the above video is the last of the Statistical series?

[hoangbachdao]

Please help, I can not find the file to practice, thank you so much

[Hasanahmed]

This is the last video of data analysis series or where I will get complete list?

[raycostello]

I am looking for help on a formula. I am trying to use the If function bringing in Text from another worksheet if the statement is true. SO for example, if cell in work sheet A4 is =x, then fill in the cell with the information (text) from worksheet data b12.
Any help would be appreciated.

Ray

[reecgabriel]

Hi Mr. Excel.Please I would to thank for giving us knowledge online free. Is this (73) the end of excel 2013 statistical data analysis. I would like to know where I can get more videos that continue the same analysis in 2013. I would also like to have more of IF, AND and OR videos. I normally analyse infant and young child feeding practices data and food security too. Excel has been help to me in doing those analysis. Please help to master this program.