how to make descriptive statistics in excel for mac

Stacked bars: this option is only checked if a column of sub-samples has been selected.

Before using advanced analysis methods like, for example, discriminant analysis or multiple regression, you must first of all reveal the data in order to identify trends, locate anomalies or simply have available essential information such as the minimum, maximum or mean of a data sample.

Available descriptive statistics and graphs in XLSTAT XLSTAT provides the following statistics: Quantitative data No.

Charts created for quantitative variables Charts created for categorical variables Box plots, Scattergrams, Strip plots, Q-Q plots, p-p plots, Stem and leaf plots.

Bar charts Pie charts Double pie charts Doughnuts Stacked bars Multiple bars Options for box plots, scattergrams and strip plots Group plots: Check this option to group together the various box plots, scattergrams and strip plots on the same chart to compare them.

It is possible to specify the Dimension corresponding to the maximum number of boxplots to group.

By default, this number is automatically chosen based on the number of variables and categories.

This number can be at most 20 for Excel 2003 and 40 for Excel 2007 and beyond.

Categories: Check this option if you want to group all categories per variable.

This option is available when the Subsamples field (general tab) is used.

Variables: Check this option if you want to group all variables per category.

This option is is available when the Subsamples field (general tab) is used.

Check the Grey line option to separate variables with grey lines on the plots.

Sort by mean: Check this option to sort the variables or categories by decreasing mean.

Notched: Check this option if you want to display notched box plots.

Adapt width: Check this option if you want that the width of the box plots depends on the sample size.

MinimumMaximum: Check this option to systematically display the points corresponding to the minimum and maximum (box plots).

Outliers: Check this option to display the points corresponding to outliers (box plots) with a hollowed-out circle.

Color inside: Activate this option to color the inside of the box plots.

Color by group: Activate this option so that the color of the box plots varies for each subsample, if subsamples have been selected.

Options for bar charts and pie-charts Bar charts: represents the frequencies or relative frequencies of the various categories of qualitative variables as bars.

Doughnuts: this option is only checked if a column of sub-samples has been selected.

These charts are used to compare the frequencies or relative frequencies of sub-samples with those of the complete sample.

How To Make Descriptive Statistics In Excel For Mac