HomeToolsUX researchCronbach’s alpha calculator
Cronbach’s alpha calculator: reliability with the item analysis SPSS prints
Check the internal consistency of a questionnaire scale without Excel or SPSS. Paste one row per respondent and one column per item and get Cronbach’s alpha with a confidence interval, the standardised alpha, the corrected item-total correlation and alpha if item deleted for every item — with negatively worded items found for you and reverse-scored in one field.
—
Item-total statistics
| Item | Mean | SD | Item-total r | Alpha if deleted | Check |
|---|
Method. Alpha = k / (k − 1) × (1 − sum of item variances / variance of the total score), with sample variances (n − 1), as in SPSS and R. Standardised alpha uses the mean of the inter-item correlations instead. The item-total correlation is corrected: each item against the sum of the other items. The interval is Feldt’s, from the F distribution with n − 1 and (n − 1)(k − 1) degrees of freedom.
Everything is calculated in your browser — nothing you enter is sent anywhere.
How to use it
- One scale at a timeAlpha describes items that are meant to measure one thing. Paste only the items of one scale or subscale; running it over a whole questionnaire of different constructs gives a number with no meaning.
- Paste rows of respondentsCopy the block from your spreadsheet with the header row. Ids, names and dates before the first answer are ignored; empty cells mark a skipped answer.
- Reverse the negatively worded itemsIf an item is phrased the other way round (“I found the system unnecessarily complex”), list it in the reverse field. The page flags any item that correlates negatively with the rest so you can see which ones.
- Read alpha with its intervalThe point value is one sample’s estimate. The interval tells you how far it could move with another sample of the same size.
- Use the item table, not just the totalA low item-total correlation and an alpha that rises without the item point at the item to read again. Decide on wording, not on the number alone.
How Cronbach’s alpha is calculated
Lee Cronbach published the coefficient in 1951 as a general form of the Kuder–Richardson formula 20. It compares the variance of each item with the variance of the total score: if the items move together, the total varies much more than the items do on their own, and alpha approaches 1.
Raw alpha is what SPSS prints as Cronbach’s Alpha and R’s psych::alpha as raw_alpha; standardised alpha is SPSS’s Cronbach’s Alpha Based on Standardized Items. The two differ when items have very different variances. The interval is Feldt’s (1987), which assumes the items are measured on comparable scales and is the one most reliability software reports.
A worked example
Four respondents answer three items: (1, 2, 2), (2, 3, 3), (3, 3, 4), (4, 5, 4). The item variances are 1.667, 1.583 and 0.917, summing to 4.167. The totals are 5, 8, 10 and 13, with variance 11.333. So α = 3 / 2 × (1 − 4.167 / 11.333) = 1.5 × 0.632 = 0.949. Paste those rows into the calculator and it shows the same number — and an interval from 0.66 to 1.00, which is what four respondents buy you.
What is a good Cronbach’s alpha
There is no law, only conventions, and they are older and looser than the precision with which they are quoted. The bands most theses and papers cite come from George and Mallery’s SPSS textbook:
| Alpha | Internal consistency |
|---|---|
| ≥ 0.9 | Excellent |
| 0.8 – 0.9 | Good |
| 0.7 – 0.8 | Acceptable |
| 0.6 – 0.7 | Questionable |
| 0.5 – 0.6 | Poor |
| < 0.5 | Unacceptable |
The 0.70 threshold everybody uses traces back to Nunnally’s Psychometric Theory (1978), which asked for 0.70 in early-stage research and 0.80 for basic research, and 0.90 or more where individual decisions are made from the score. Three things the bands do not tell you:
- Higher is not always better. Above about 0.95 the items are probably near-duplicates: the scale is longer than it needs to be, or measures a narrow slice of the construct.
- Alpha grows with the number of items. Twenty mediocre items can reach 0.90; three good ones may sit at 0.70. Compare the mean inter-item correlation (0.15–0.50 is the usual range for a coherent scale) when scales differ in length.
- Alpha is a property of this sample, not of the questionnaire. A published scale that reached 0.85 elsewhere can fall to 0.65 in a group with less spread in the trait. Report your own alpha, with its interval.
Alpha if item deleted and the item-total correlation
The total alpha says whether the scale holds together; the item table says which item does not. For each item the page shows two numbers:
- Corrected item-total correlation — the item against the sum of the other items. Values above 0.3 are usually taken as a sign the item belongs; near zero it measures something else; negative almost always means the item is worded in reverse and has not been reverse-scored.
- Alpha if item deleted — what alpha would be for the remaining items. If it is clearly higher than the current alpha, the item is pulling the scale down.
In the example data, Q4 is a negatively worded item. Without reverse scoring, alpha is 0.57 and Q4’s item-total correlation is negative; reversing it lifts alpha to 0.85. Q6 then stands out with an item-total correlation of 0.09: deleting it would raise alpha to 0.90. Whether to delete it is a question about wording and content, not arithmetic — an item that covers a real part of the construct can be worth keeping at a small cost in alpha, and dropping items until alpha peaks capitalises on chance in this one sample.
When alpha misleads you
- It is not proof of one dimension. A questionnaire with two correlated factors can still have a high alpha. To claim a scale is unidimensional, run a factor analysis; alpha assumes it, it does not test it.
- It assumes every item counts equally. Alpha is a lower bound on reliability when items load unequally on the construct. McDonald’s omega, from a one-factor model, is the alternative modern methodologists prefer; with roughly equal loadings the two agree closely.
- It is not validity. A perfectly consistent scale can consistently measure the wrong thing.
- Skipped answers change the sample. Leaving out incomplete rows (listwise, as here and in SPSS by default) is honest but can bias alpha if the people who skip are different. Report how many rows were left out.
- Ordinal answers with few points lower Pearson-based alpha a little; ordinal alpha from polychoric correlations is the fix for 3–4 point scales.
Using alpha on product and UX surveys
Product teams write their own questionnaires all the time — an onboarding satisfaction survey, a “how confident do you feel” block after a tutorial, a five-item trust scale for a fintech app. Before averaging those items into one number for a dashboard, alpha is the check that the average means something.
- Standard instruments come with their scoring. The System Usability Scale has alternating item wording and its own grade curve; the UEQ calculator reports alpha per scale with the UEQ team’s cleaning rules. Use this page for scales you built yourself or adapted.
- Pilot before the launch survey. Thirty respondents are enough to find a reverse-worded item nobody reversed or an item people read differently. Two hundred respondents later is too late.
- Check the size of the sample you will need. The survey sample size calculator tells you how many responses a given margin of error takes.
Sources
- Cronbach L. J. “Coefficient alpha and the internal structure of tests.” Psychometrika 16(3), 1951, 297–334.
- Feldt L. S., Woodruff D. J., Salih F. A. “Statistical inference for coefficient alpha.” Applied Psychological Measurement 11(1), 1987, 93–103 — the confidence interval used here.
- Nunnally J. C. Psychometric Theory, 2nd ed. New York: McGraw-Hill, 1978 — the 0.70 / 0.80 / 0.90 recommendations.
- George D., Mallery P. SPSS for Windows Step by Step: A Simple Guide and Reference, 4th ed. Boston: Allyn & Bacon, 2003 — the excellent-to-unacceptable bands.
- Streiner D. L. “Starting at the beginning: an introduction to coefficient alpha and internal consistency.” Journal of Personality Assessment 80(1), 2003, 99–103 — on alphas above 0.90 and redundancy.
- Tavakol M., Dennick R. “Making sense of Cronbach’s alpha.” International Journal of Medical Education 2, 2011, 53–55.
- McNeish D. “Thanks coefficient alpha, we’ll take it from here.” Psychological Methods 23(3), 2018, 412–433 — alpha’s assumptions and omega.
FAQ
What is Cronbach’s alpha?
A coefficient of internal consistency: how closely the items of one scale move together. It runs up to 1; values around 0.7 and above are conventionally taken as acceptable for research use. It was published by Lee Cronbach in 1951.
How do I calculate Cronbach’s alpha?
Alpha = k / (k − 1) × (1 − sum of item variances / variance of the total score), where k is the number of items. This page does it from the raw answers: paste one row per respondent and one column per item.
What is a good Cronbach’s alpha?
By the common rule of thumb, 0.9 and above is excellent, 0.8–0.9 good, 0.7–0.8 acceptable, 0.6–0.7 questionable, 0.5–0.6 poor and below 0.5 unacceptable. Above about 0.95 the items may be redundant. Report the confidence interval with the value.
What does alpha if item deleted mean?
It is the alpha the scale would have without that item. If it is clearly higher than the current alpha, the item is weakening the scale — check whether it is worded in reverse or measures something else before deleting it.
Why is my Cronbach’s alpha negative?
Almost always because one or more items are worded in the opposite direction and were not reverse-scored, so they correlate negatively with the rest. The page flags those items; list them in the reverse field and alpha is recomputed.
Does this match SPSS?
Yes: raw alpha, standardised alpha, the corrected item-total correlation and alpha if item deleted are computed the way SPSS prints them in Reliability Statistics and Item-Total Statistics, with sample variances and listwise deletion of incomplete rows.
How many respondents do I need?
Alpha can be computed from three, but it is unstable below about 30 — the confidence interval shows how much. For a pilot of a new scale, 30 to 50 respondents is a common minimum.
Is my data uploaded anywhere?
No. Parsing and every calculation run in your browser. Only what you put into the URL yourself, by copying the share link, leaves the page.
More in UX research
- Survey sample size calculator
How many responses does a survey need for a given margin of error?
- Kano model survey analyzer
Which features are must-haves, performance features or delighters for users?
- Van Westendorp calculator
What price range do buyers accept, and where do the price sensitivity meter curves cross?
- Gabor–Granger analysis
At which price on the ladder does revenue peak, and how elastic is demand?
- NPS, CSAT and CES calculator
What is the Net Promoter Score of these answers, with a confidence interval?
- CSAT & CES calculator
What are the CSAT and Customer Effort Score of these survey results?
- SUS calculator
What is the System Usability Scale score, and is the usability good?
- UEQ calculator
How does the product score on the six UEQ scales, and where does it sit against the benchmark?
- NASA-TLX calculator
How heavy did this task feel, and which kind of demand made it heavy?
- Cohen’s kappa calculator
Do two or more raters agree beyond chance, and which label or rater is behind the disagreement?