Excel Magic Trick 1136

Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

DESCRIPTION

See how to calculate
(08:00) Basics of Correlation
(02:17) CORREL and PEARSON functions for data from two columns
(03:45) Basics of CHOOSE function
(04:37) CHOOSE and an array constant to mash data from two columns together into a rectangular array of values. This is an array formula because it is spitting out an array of values.
(05:07) CORRELL and 2 CHOOSE functions to take x and y data from 4 columns and mash them together so the CORREL can calculate Correlation.
(08:36) Playlist of Statistics video:

WORKBOOKS




Be the first to comment

Leave a Reply