The ifItemsDeleted parameter
What it does
TRUE to include 'Alpha if item deleted' diagnostics.
TRUE, 1 or the text "true"/"1" turn it on; FALSE, 0, their text or empty turn it off. Anything else is an error: ifItemsDeleted must be TRUE or FALSE (or 1, 0), got "no".
The table needs at least 3 items: with 2 items the report shows alpha and the line 'Alpha if item deleted needs at least 3 items' instead of the table.
Values
Optional; default FALSE.
Should be TRUE or FALSE
In plain words
A teacher gave a survey of 5 questions, and the alpha, which shows how well they hang together, came out only about 62 parts of 100. She switched ifItemsDeleted to TRUE. Now the report also shows what the alpha would be without each question. Without question 4 it rose to about 81 parts of 100, and without any of the others it stayed near 55. So question 4 is the one that does not go with the rest. Perhaps it was asked the opposite way around. With only 2 questions this table cannot be made, and the report says so in one line.
Where you use it
STATS_ALPHA— Computes Cronbach’s Alpha — a measure of internal consistency (reliability) for a set of items, such as Likert-type questions.
Examples
TRUE— Add if item deleted for each itemFALSE
Get it in your sheet
ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)