Weighted mean and weighted standard deviation

This macro calculates the weighted mean and weighted standard deviation of a column of data based on a frequency or weight column. Weights must be greater than or equal to 0, and can be continuous or discrete (frequencies).

Download the Macro

Be sure that Minitab knows where to find your downloaded macro. Choose File > Options > General. Under Macro location browse to the location where you save macro files.

Important

If you use an older web browser, when you click the Download button, the file may open in Quicktime, which shares the .mac file extension with Minitab macros. To save the macro, right-click the Download button and choose Save target as.

Download WSTAT.mac

Required Inputs

A column of numeric data
A corresponding column of weights or frequencies

Running the Macro

Suppose the data are in C1 and the frequencies are in C2. To run the macro, choose View > Command Line/History and type:

%WSTAT C1 C2

Click Run.