Example of Tables with Missing Data
main topic
     interpreting results     session command    
see also 

You would like to summarize weight data for individuals in your study by gender and eye color.

1    Open the worksheet EYECOLOR.MTW.

2    Choose Stat > Tables > Descriptive Statistics.

3    In For rows, enter Gender. In For columns, enter Eyecolor.

4    Click Associated variables, enter Weight.

5    Under Display, check Means and Standard deviations. Click OK in each dialog box.

Session window output

Tabulated Statistics: Gender, Eyecolor

 

 

Rows: Gender   Columns: Eyecolor

 

        Blue  Brown  Green  Hazel  Missing    All

 

F      124.2  123.3  118.0  125.0    120.0  122.2

       19.25  10.63  13.40  18.03        *  15.06

 

M      156.3  159.1  156.8  164.7    170.0  158.4

       28.47  13.91  20.77  10.02        *  20.12

 

All    142.5  146.1  132.1  139.9        *  140.3

       29.16  21.86  24.89  25.22        *  25.36

 

Cell Contents:  Weight  :  Mean

                Weight  :  Standard deviation

You realize there are missing data. You decide to include the missing data into your table calculations to see how the marginal statistics are affected.

1    Choose Stat > Tables > Descriptive Statistics.

2    In For rows, enter Gender. In For columns, enter Eyecolor.

3    Click Associated variables, enter Weight.

4    Under Display, check Means and Standard deviations. Click OK.

5    Click Options, check Include displayed missing values in calculations. Click OK in each dialog box.

Session window output

Tabulated Statistics: Gender, Eyecolor

 

 

Rows: Gender   Columns: Eyecolor

 

        Blue  Brown  Green  Hazel  Missing    All

 

F      124.2  123.3  118.0  125.0    120.0  122.1

       19.25  10.63  13.40  18.03        *  14.72

 

M      156.3  159.1  156.8  164.7    170.0  158.9

       28.47  13.91  20.77  10.02        *  19.80

 

All    142.5  146.1  132.1  139.9    145.0  140.5

       29.16  21.86  24.89  25.22    35.36  25.36

 

Cell Contents:  Weight  :  Mean

                Weight  :  Standard deviation

Interpreting the results

By default, Minitab displays all missing values in your tables, but does not include them in calculations unless you check Include displayed missing values in calculations in the Options sub dialog box. When a data point is missing, by default, the entire worksheet row (observation) is omitted from the calculation.

In this example, you are missing eye color data for 1 female and 2 males. If you do not include missing data in your calculations, the mean weight of females in your study is 122.2 pounds. If you include the weight data when eye color is missing, the mean weight is 122.1 pounds. For males, the mean weight is 158.4 when missing data are not included and 158.9 when missing data are included.

You have to decide which statistic is more meaningful for your application. If any part of the data for an individual is missing, some researchers would eliminate the entire point from the study, while others would use the data they can.

 

Minitab help Stat Graph SixSigma DOE Glossary Reliability SPC,MSA,CPK
Create Pareto chart - Free tool

Calendar with week numbers

US Federal Holidays

Australia Public Holidays