Frequency table and descriptive statistics
Paste your data from Excel, Google Sheets or SPSS, one column per variable with names in the first row. For each variable you get a frequency table with percentages as in SPSS and, if it’s numeric, the mean, standard deviation, median, skewness and kurtosis. Tables download in APA format for Word.
The first row can hold variable names. Leave cells without an answer empty.
The calculation runs in your browser. We don’t store what you type.
How it’s calculated
Empty cells count as missing: the percentage uses the total and the valid percentage excludes missing values, just like SPSS.
The standard deviation uses n − 1 (sample). The confidence interval for the mean uses Student’s t.
The median and quartiles are computed as in SPSS (weighted average). Skewness and kurtosis match SPSS and Excel, with their standard errors.
Numeric variables with more than 15 distinct values (such as age or a total score) get descriptives instead of a frequency table.
How to read the result
- In a thesis, the frequency table opens the results to describe the sample (gender, age, major) and each variable’s levels.
- If skewness or kurtosis divided by its standard error goes beyond ±1.96, the distribution departs from normal. Confirm it with a normality test.
- With skewed data, report the median as well as the mean.
Frequently asked questions
- Does it match SPSS?
- Yes. Frequencies, valid and cumulative percentages, standard deviation, quartiles, skewness and kurtosis follow the same formulas as Analyze > Descriptive Statistics > Frequencies.
- How do I paste several variables?
- Copy the columns from Excel with names in the first row and paste them. Each column is analyzed separately and you can pick which one to view.
- What goes in the APA table?
- For categorical variables, frequency (f) and percentage. For numeric ones, n, mean, standard deviation, minimum and maximum. The tool builds both.
Know what you want to ask?
Build the survey in SurvIQ, share it by link, WhatsApp or QR code, and watch results come in live. The Free plan is free forever.
Create a free survey