Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function

preview_player
Показать описание

See how to:
1. (00:10) Problem Setup.
2. (01:20) Mixed Cell References to calculate Expected Frequencies
3. (03:20) Array Operations on Different Sized Arrays, and the Resultant Array. And discussion of Array Syntax. Curly Brackets house the array; Commas mean Column; Semi-colons mean Rows.
4. (03:20) CHISQ.TEST function can handle array operations with using the special key stroke: Ctrl + Shift + Enter.
5. (07:00) Example of array operation in AND function that requires the special key stroke: Ctrl + Shift + Enter.
CHISQ.TEST: For Chi-Square Test, it takes observed values and expected values and calculates the p-value that you compare to alpha. If all expected values Gtreater Than Or Equal To 5 and p-value Less Than Or Equal To Alpha, Reject H0 and Accept Ha, Otherwise Fail to Reject H0. Hypothesis Test to check whether or not 2 or more (3 or more) Population Proportions Are Equal.
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:08:53

Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function

Excel Magic Trick 0:08:55

Excel Magic Trick 1254: Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula?

Excel Magic Trick 0:17:18

Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query?

Bring unlimited data 0:04:22

Bring unlimited data into Excel with PowerPivot

Maths Ki Problem 0:00:23

Maths Ki Problem 😜 PIHOOZZ

How to use 0:13:47

How to use Index Function Array & Reference

SE370: Controlling Pivot 0:11:13

SE370: Controlling Pivot Tables With VBA (2 of 3)

Match Excel - 0:05:58

Match Excel - a function to help you find what you are looking for

Alternative to Pivot 0:01:46

Alternative to Pivot tables

Compare lists to 0:10:52

Compare lists to find missing values in excel - dynamic array formulas

Index Match Function 0:10:41

Index Match Function in Excel

Fonction LET et 0:15:06

Fonction LET et comment l'utiliser dans un exemple avancé

Auto refresh a 0:06:45

Auto refresh a pivot table [Excel Macro]

Excel Tips| Determining 0:03:22

Excel Tips| Determining Top & Last 5 Values Using Functions #tutorial

How to Use 0:21:51

How to Use Group BY in POWERQUERY - Series 17

Numbers: minimum & 0:02:21

Numbers: minimum & maximum

3+ way data 0:10:09

3+ way data table sensitivity in MS Excel.

Numbers: IF function 0:04:55

Numbers: IF function

Large index match 0:02:21

Large index match with multiple criteria, duplicate values

Highlight a row/column 0:07:16

Highlight a row/column using conditional formatting in excel

PyHEP 2020 zfit 0:44:04

PyHEP 2020 zfit and hepstats tutorial

[How To] Change 0:03:20

[How To] Change the Value of a Cell Based on another Cell Using VLOOKUP in Apple Numbers

Microsoft® Excel 2010: 0:03:11

Microsoft® Excel 2010: Create a Pivot Table or Pivot Chart report on Windows® XP

Learn Excel - 0:27:18

Learn Excel - Video 171 - Pivot Vlookup & IF exercise

Комментарии
Автор

Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Function
See how to:
1. (00:10) Problem Setup.
2. (01:20) Mixed Cell References to calculate Expected Frequencies
3. (03:20) Array Operations on Different Sized Arrays, and the Resultant Array. And discussion of Array Syntax. Curly Brackets house the array; Commas mean Column; Semi-colons mean Rows.
4. (03:20) CHISQ.TEST function can handle array operations with using the special key stroke: Ctrl + Shift + Enter.
5. (07:00) Example of array operation in AND function that requires the special key stroke: Ctrl + Shift + Enter.

CHISQ.TEST: For Chi-Square Test, it takes observed values and expected values and calculates the p-value that you compare to alpha. If all expected values Greater Than Or Equal To 5 and p-value Less Than Or Equal To Alpha, Reject H0 and Accept Ha, Otherwise Fail to Reject H0. Hypothesis Test to check whether or not 2 or more (3 or more) Population Proportions Are Equal.

excelisfun
Автор

Thanks Mike. My head hurts when I try to think about statistics.

krn
Автор

I'm not familiar with statistics but what does a P value mean?? When would I find this helpful for non-statistical stuff? Thx

Sal_A