Excel, Statistics, Pivot Tables, V-Loopup, Correlation Tables, Box Plots

Crosstabs Using the Supermarket data set, create crosstabs for Marital Status and Annual Income expressing the counts as percentages. Then, create a stacked 2D column chart. (Select the crosstab table and insert stacked 2D column chart). If you need to swap the x and y values, then right click on the chart, click select data, and switch …

Excel, Statistics, Pivot Tables, V-Loopup, Correlation Tables, Box Plots Read More »