Free research tool

Cronbach's alpha calculator online

Copy your questionnaire responses from Excel or SPSS and paste them here: one row per respondent, one column per item. Cronbach's alpha, standardized alpha and the item table are calculated just like SPSS Reliability Analysis, and you get a ready-made sentence for the methods chapter of your thesis. Everything runs in your own browser; no data is sent anywhere.

Reports guide

Paste your questionnaire data

Copy from Excel or SPSS Data View. Tab, comma, semicolon or space separators and Persian digits are accepted.

What is Cronbach's alpha?

Cronbach's alpha is the most widely used reliability index for questionnaires; more precisely, it measures internal consistency. Say you have written five items to measure job satisfaction. If the items really measure one thing, someone who scores high on one usually scores high on the others too. Alpha sums up that agreement in a single number, usually between zero and one. Lee Cronbach introduced the coefficient in 1951.

Alpha is a property of your data, not a fixed property of the questionnaire. The same standard questionnaire may give a different alpha in another population or in another translation. So even when you use a validated, published instrument, recalculate alpha on your own sample and report it.

Alpha shows reliability, not validity. A questionnaire that precisely measures the wrong thing can still have a high alpha. Check validity separately: content validity with expert judgement, and construct validity with factor analysis.

Cronbach's alpha formula

Formula

  • α = k ÷ (k − 1) × (1 − Σσᵢ² ÷ σₜ²)Raw alpha; the value SPSS reports as Cronbach's Alpha
  • α_std = k × r̄ ÷ (1 + (k − 1) × r̄)Standardized alpha, based on the mean inter-item correlation
  • k: number of items.
  • σᵢ²: variance of each item; Σσᵢ² is the sum of all item variances.
  • σₜ²: variance of the total score, i.e. the variance of each respondent's sum across all items.
  • r̄: mean pairwise correlation between items.

The logic is simple. When items move together, the variance of the total score is much larger than the sum of the individual item variances, because the positive covariances between items are added to it. The fraction in the brackets then shrinks and alpha rises. When items are unrelated, the two quantities are almost equal and alpha is close to zero.

Example: four items, item variances summing to 4.2 and total-score variance 11

  • α = 4 ÷ 3 × (1 − 4.2 ÷ 11) = 0.82Good reliability

Standardized alpha is alpha computed as if every item had been put on the same scale before summing. When all items use the same scale, e.g. all are five-point items, the two values are close and raw alpha is reported. When items use different scales, standardized alpha is more meaningful.

Interpreting Cronbach's alpha: what value is good enough?

Common interpretation of Cronbach's alpha
Alpha valueInterpretationWhat it means for your study
0.9 and aboveExcellentVery high internal consistency. Above 0.95, several items are probably repeating the same question.
0.8 to 0.9GoodFully acceptable for most research and theses.
0.7 to 0.8AcceptableThe minimum most reviewers and supervisors accept.
0.6 to 0.7QuestionableSometimes accepted in exploratory research or very short scales, provided you explain why.
Below 0.6WeakThe items do not move together; review the data and the item wording before any analysis.
The 0.7 threshold comes from Nunnally's Psychometric Theory (1978), and George and Mallery (2003) popularised this classification; they call values below 0.5 'unacceptable'. These cut-offs are conventions, not statistical laws.

Alpha is sensitive to the number of items. With more items, alpha rises even when the correlations between them are only moderate: with a mean inter-item correlation of 0.3, three items give an alpha of 0.56, ten items 0.81 and twenty items 0.9. So an alpha of 0.65 on a three-item scale may reflect better consistency than 0.8 on a twenty-item scale. For short scales, also look at the mean inter-item correlation, which the tool above shows; Clark and Watson (1995) consider 0.15 to 0.5 desirable.

If your questionnaire has several dimensions, e.g. satisfaction with pay, with the supervisor and with co-workers, calculate and report alpha separately for the items of each dimension. Alpha for a whole multidimensional questionnaire usually comes out high simply because there are many items, and says little about each dimension. In the tool above, untick items to see the alpha of each dimension on its own.

How to calculate Cronbach's alpha in SPSS, step by step

  1. Prepare the data

    Each respondent should be one row and each item one variable. Reverse negatively worded items before anything else: Transform, then Recode into Different Variables; on a 1–5 scale define 1 → 5, 2 → 4, 4 → 2 and 5 → 1, and leave 3 as 3.

  2. Open the reliability dialog

    From the Analyze menu choose Scale, then Reliability Analysis.

  3. Select the items

    Move the items of one dimension into the Items box and make sure Model is set to Alpha.

  4. Turn on the statistics

    In the Statistics dialog tick Item, Scale and Scale if item deleted. To see the mean inter-item correlation, also tick Correlations under Summaries. Then Continue and OK.

  5. Read the output

    The Reliability Statistics table shows raw alpha and standardized alpha (Based on Standardized Items). In the Item-Total Statistics table, the Corrected Item-Total Correlation column is each item's correlation with the rest, and the Cronbach's Alpha if Item Deleted column shows what alpha would be without that item.

  6. Cross-check with this tool

    Paste the same data here; the numbers should match. Like this tool, SPSS drops incomplete rows and reports how many in the Case Processing Summary table.

Why is my alpha low, and what can I do?

  • A reversed item was not recoded. A statement such as "I am tired of my job" in a job-satisfaction questionnaire must be reversed before calculating. The tell-tale sign is a negative correlation with the other items. In the tool's sample data, item Q4 has a negative correlation of 0.58, and alpha is 0.44 before reversing it and 0.81 after.
  • Blank cells were filled with numbers. If non-responses were coded as 0 or 99, those numbers are treated as real answers and distort alpha. Delete them before pasting so the cells stay empty.
  • One or two items do not move with the rest. Look at the alpha if item deleted column: an item whose removal clearly raises alpha and whose corrected item-total correlation is below 0.3 is a candidate for revision. In the sample data, removing Q6 raises alpha from 0.81 to 0.85.
  • The questionnaire is multidimensional. Don't confuse overall alpha with the alpha of each dimension; calculate each dimension's items separately.
  • The sample is small or homogeneous. With fifteen respondents, or when almost everyone gives the same answer, variance is low and alpha becomes unstable. Thesis pilot studies usually use about 30 people.
  • Items are vague or double-barrelled. A question that asks about two things at once, such as "pay and benefits are adequate", gets scattered answers. For tips on writing good items and choosing a scale, see the guide to designing a standard questionnaire and Likert scale: 5 or 7 points.

Don't delete an item just to push the number up. If removing it takes part of the concept out of the questionnaire, content validity suffers. Report every item you removed, with the reason, in your thesis.

Sample reliability paragraph for the methods chapter of a thesis

The methods chapter usually has a paragraph on the instrument's reliability. Always state three things: how many people alpha was calculated on (pilot or full sample), alpha for each dimension and for the whole questionnaire, and whether any items were reversed or removed. Example:

"Cronbach's alpha was used to assess the reliability of the questionnaire. The questionnaire was administered in a pilot study to 30 members of the target population. After reverse-coding the negatively worded items, Cronbach's alpha was 0.86 for the whole questionnaire and 0.81, 0.78 and 0.84 for satisfaction with pay, satisfaction with the supervisor and satisfaction with co-workers respectively. Since all coefficients exceed 0.7, the reliability of the questionnaire was judged acceptable."

Sample table for reporting the reliability of questionnaire dimensions
DimensionNumber of itemsCronbach's alpha
Satisfaction with pay40.81
Satisfaction with the supervisor50.78
Satisfaction with co-workers40.84
Whole questionnaire130.86
These numbers are only an example. The tool at the top of the page writes a ready-made sentence for your own data that you can copy with one click. In APA style the coefficient is written with two decimals and no leading zero (α = .86).

Collect questionnaire data that is ready for analysis

If you run your questionnaire online, the responses are a clean table from the start that goes straight into this tool or SPSS. Porsino has Likert scales and matrix questions, and gives you an Excel export or an SPSS file (.sav) with codes and option labels. Just copy the item columns and paste them here. For the questionnaire itself, see Build an online questionnaire and to decide on the sample size see the Cochran's formula calculator for details.

Frequently asked questions

What is the minimum sample size for Cronbach's alpha?

There is no hard rule. Thesis pilot studies usually use about 30 people, and with fewer than 20 alpha is very unstable. The bigger the sample, the more precise the estimate; for your final report, also calculate alpha on the full sample.

What does a negative Cronbach's alpha mean?

It means the average covariance between items is negative. The cause is almost always a reversed item that was not recoded, or a data-entry error. Check the corrected item-total correlation column, look at the item with a negative correlation and reverse it if needed.

Should I report raw or standardized alpha?

When all items use the same scale, such as a five-point Likert scale, report raw alpha, which is what most papers report. Standardized alpha is for items on different scales.

How are missing values handled?

As with the SPSS default, any respondent who skipped even one of the selected items is excluded (listwise deletion) and the number excluded is shown next to the result. Empty cells, a dot, NA and a dash are treated as missing.

Can I upload an Excel file directly?

Not an .xlsx file; in Excel select and copy the item columns and paste them here, or save the file as CSV with Save As and pick that. In SPSS you can copy the columns from Data View.

Is an alpha above 0.95 good?

Not necessarily. A very high alpha often means several items ask almost the same thing in different words. That makes the questionnaire needlessly long; review the items that are very similar.

Is my data stored anywhere?

No. The calculation runs in this browser; the data you paste or the file you pick is not sent to a server and is gone when you close the page.

Related guides:Field typesReports

Survey & analysis guides

All posts

Collect your next questionnaire online

Build your questionnaire with Likert scales and matrices for free, share the link, and take the responses to alpha with an Excel or SPSS export.