Skip to content

Cronbach's alpha calculator

A Cronbach's alpha of .70 or higher is the most widely cited threshold for acceptable reliability (Nunnally, 1978). Paste your whole questionnaire (one row per respondent, one column per item) and this calculator groups the items into scales by their code, then reports alpha with a 95% confidence interval, McDonald's omega, the SPSS Item-Total Statistics columns and a results paragraph with APA references.

  1. Copy your item columns, with the header row, from Excel, SPSS or Google Forms.
  2. Paste them and click Compute reliability; recode or drop items with one click.
  3. Download the Word file or copy the results paragraph into your thesis.
One row per respondent, one column per item. You can paste the whole questionnaire: items are grouped into scales by their code (SAT1, SAT2… become SAT; TRU_1, TRU_2… become TRU), and ID, timestamp, gender and text columns are set aside and listed. Columns may be separated by tabs, semicolons, commas or spaces; decimals may be written 3.5 or 3,5; Likert labels such as “Agree” or “Strongly agree” are converted to scores. An empty cell or SPSS’s “.” counts as missing. Your data is processed only in your browser and is never uploaded.
Options: reverse-worded items, dropping items, defining groups
New score = lowest + highest scale point − old score.
The results show run 1 (all items) and run 2 (after dropping).
Cells holding these values are treated as blank.
Use this when item names do not follow a code (Q1, Q2…) or to give the constructs names. Write “SAT1-SAT4” for a run of adjacent columns.
Results paragraph and tables
The Word file contains the summary table, the Item-Total Statistics table for each scale (both runs if you dropped items), the results paragraph and the references. Replace scale codes with construct names if you did not name the groups.

How to read each number: see the guide below. To run EFA and regression next, use survey data analysis.

Send to your study group

When the whole group uses one tool, your numbers match when you merge chapters.

Was this tool useful? Feedback / report a bug (by email; please do not paste real data).

Worked example: the Openness scale of the bfi data set

What Cronbach's alpha is acceptable? The usual threshold is .70 (Nunnally, 1978); values from .60 to just under .70 are accepted in exploratory research (Hair et al., 2010). The example below is a real result, not an illustration: the Openness scale (O1–O5) of the public bfi data set in the R package psych (Revelle, 2026), a 6-point scale, with the two reverse-worded items O2 and O5 recoded (7 − score). The calculator reproduces these numbers and matches R to four decimal places; see the verification page. To rerun it, download bfi.csv, reverse-score O2 and O5, and paste the five columns O1–O5 into the data box above.

Reliability Statistics: Openness scale (bfi), n = 2,726 complete responses
Cronbach's AlphaCronbach's Alpha Based on Standardized ItemsN of Items95% CI (Feldt)
.603.6095.578 to .626
Item-Total Statistics
ItemWordingScale Mean if Item DeletedScale Variance if Item DeletedCorrected Item-Total CorrelationSquared Multiple CorrelationCronbach's Alpha if Item Deleted
O1Am full of ideas18.15311.979.389.184.536
O2 (reversed)Avoid difficult reading material18.67210.420.340.143.566
O3Carry the conversation to a higher level18.53311.120.452.230.500
O4Spend time reflecting on things18.07412.887.220.061.614
O5 (reversed)Will not probe deeply into a subject18.45610.896.416.179.516

Reading it in three steps:

  1. Alpha = .603: below .70, so acceptable only by the exploratory-research standard; the lower bound of the confidence interval (.578) is below even .60.
  2. O4 has a corrected item-total correlation of .220, below the .30 cut-off (Nunnally & Bernstein, 1994), and it is the only item whose “alpha if item deleted” (.614) is higher than the overall alpha.
  3. Dropping O4 lifts alpha only to about .61, still below .70. The honest conclusion is that the scale has low reliability: report the figure and discuss it as a limitation rather than “fixing” the data. The results doctor walks through the legitimate next steps.

Checking by hand: the five item variances are 1.272, 2.440, 1.491, 1.481 and 1.756, so Σσᵢ² = 8.437; the variance of the total score is σₜ² = 16.289. Hence α = 5/4 × (1 − 8.437/16.289) = 1.25 × .482 = .603. If you forget to reverse-score O2 and O5, the same data give alpha = −.157: a negative alpha almost always means a reverse-worded item has not been recoded.

How to read the output

Drop one item at a time, starting with the weakest, and rerun; every number changes after each deletion. Read the item wording first, and keep at least three items per construct.

How to report Cronbach's alpha in APA 7

Give alpha to two or three decimals without a leading zero, with the number of items and the threshold you applied. For the example above: “Cronbach's alpha for Openness was .60, 95% CI [.58, .63], below the .70 threshold (Nunnally, 1978). Item O4 had a corrected item-total correlation of .22; deleting it would raise alpha only to .61, so the scale was retained and its low reliability is discussed as a limitation.” The calculator writes this paragraph for you, with the references, and the Word file adds one Item-Total Statistics table per scale.

Do not fabricate, filter or edit responses to reach the threshold

A low alpha is a result, not an error to hide. Generating responses that no real person gave, changing real answers so items “move together”, or deleting genuine respondents because they pull alpha down are fabrication and falsification, the core forms of research misconduct (Steneck, 2006). Legitimate steps are screening responses by rules written before you look at the results, recoding reverse-worded items, dropping an item for a content reason while reporting results before and after, and reporting alpha with its confidence interval and omega.

Frequently asked questions

What is a good Cronbach's alpha?

.70 is the most cited minimum (Nunnally, 1978), and .60 to .70 is acceptable in exploratory research (Hair et al., 2010). Lance et al. (2006) point out that Nunnally suggested .70 for early-stage research, .80 for basic research and .90 when scores are used to make decisions about individuals.

What does “Cronbach's alpha if item deleted” mean?

It is the alpha the scale would have without that item, the SPSS column of the same name. A value above the overall alpha means the item makes the scale less consistent, like O4 above (.614 versus .603). Consider dropping it only if its corrected item-total correlation is also below .30 and the construct is still adequately covered.

Why is my Cronbach's alpha negative?

Alpha is negative when the average covariance between items is negative, which almost always means a reverse-worded item has not been recoded. Find the item with a negative item-total correlation and click Reverse.

Will the results match SPSS and SmartPLS?

SPSS: yes, for the same data and the same handling of missing values (listwise deletion per scale, as the RELIABILITY command does). SmartPLS standardises indicators, so its alpha corresponds to the SPSS column “Based on Standardized Items” (bfi Openness: .609 versus .603). For PLS-SEM, also report rho_a and composite reliability (rho_c), with a range of .70 to .95 (Hair et al., 2019).

Should I compute alpha for the whole questionnaire?

No. Alpha is meaningful only for items that measure the same construct, so the tool computes it per scale and warns when a group has more than 12 items. A high alpha does not show that a scale is unidimensional either; that needs EFA, available in the survey data analysis tool.

References

One of the free research tools of Research Corner.