Excel Magic Trick 1208


Combine 4 Columns into 1 Table For PivotTable Report (without Power Query)

DESCRIPTION

See how to take 4 columns with Survey results for error rates (Yes/No) for the years 2011, 2012, 2013 and 2014 and combine them into 1 table so that we can create our PivotTable Report. Also see a Chi Square Test to test whether 4 population proportion error rates are significantly different.
(00:10) Problem set up.
(01:14) Manually combine 4 tables into one table
(03:54) PivotTable to create Cross Tabulated Frequency Distribution
(05:34) PivotTable to calculate Proportions for each year (% of Column Total)
(06:33) Chi Square Test to test whether 4 population proportion error rates are significantly different
(07:25) Formula for Expected Frequencies using Mixed Cell References and Absolute Cell References.
(09:34) CHISQ.TEST function to calculate p-value from Observed Frequencies and Expected Frequencies.

WORKBOOKS







Be the first to comment

Leave a Reply