Examples
Examples
Try the starting example
- Field names separated by |
- A|B|C
- Rows: unique ID followed by one value per named field
- R1,1,NA,3 R2,NA,NA,3 R3,1,2,NULL
- Case-sensitive literal missing tokens separated by |
- NA|NULL
- Missing count by field
- A: 1; B: 2; C: 1
- Missing percentage by field
- A: 33.3333333333; B: 66.6666666667; C: 33.3333333333
- Complete-record IDs
- None
- Complete-record percentage
- 0
- Missing cells as percentage of all supplied cells
- 44.444444
- Missingness pattern counts, 1 means missing
- 010: 1; 110: 1; 001: 1
Try another scenario
- Field names separated by |
- A|B|C
- Rows: unique ID followed by one value per named field
- R1,1,NA,3 R2,NA,NA,3 R3,1,2,NULL
- Case-sensitive literal missing tokens separated by |
- NA
- Missing count by field
- A: 1; B: 2; C: 0
- Missing percentage by field
- A: 33.3333333333; B: 66.6666666667; C: 0
- Complete-record IDs
- R3
- Complete-record percentage
- 33.333333
- Missing cells as percentage of all supplied cells
- 33.333333
- Missingness pattern counts, 1 means missing
- 010: 1; 110: 1; 000: 1
Calculation method
Calculation method
Missing count by field
Count explicitly listed missing tokens in each field.
Missing percentage by field
100×field missing count/record count.
Complete-record IDs
Records with no declared missing-token cells.
Complete-record percentage
100×complete record count/all records.
Missing cells as percentage of all supplied cells
100×missing cell count/(record count×field count).
Missingness pattern counts, 1 means missing
Binary mask follows entered field order; identical masks grouped.
Symbols and units
- a
- Field names separated by |
- b
- Rows: unique ID followed by one value per named field
- c
- Case-sensitive literal missing tokens separated by |
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- Simple unquoted comma-separated fields; use explicit nonempty tokens for missing cells. Values and tokens are trimmed and compared case-sensitively. Non-numeric values are valid observed cells unless declared missing. No imputation or data changes.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
OpenStax: arithmetic and geometry ↗
Background reading; this does not imply endorsement or independent review of SumFizz.