How to Calculate Variance in Excel: VAR.S vs VAR.P
Calculate variance in Excel with VAR.S for a sample or VAR.P for a population. Step by step with a worked example, plus the fix for the #DIV/0! error.

Kushagra Verma is a researcher with a BSc in Computer Science and Financial Mathematics. He focuses on data-driven analysis, statistical methods, and practical applications of financial math and computing.
Kushagra works at the intersection of technology, finance, and data. He contributes research-backed content on statistics, data analysis, and financial mathematics tools, helping readers understand complex concepts through clear, step-by-step explanations.
BSc in Computer Science + Financial Mathematics. He has studied topics including numerical methods, multivariable calculus, differential equations, data structures, algorithms, and mathematics of finance.
Calculate variance in Excel with VAR.S for a sample or VAR.P for a population. Step by step with a worked example, plus the fix for the #DIV/0! error.
Free sphere volume calculator. Solve from radius, circumference, or volume. Sphere volume formula V = 4/3 πr³ explained with worked examples and a table.
Free cone volume calculator. Solve solid or truncated cone (frustum) volume from radius or diameter. Cone volume formula V = ⅓πr²h with worked examples.
Free perimeter of a circle calculator. Solve circumference from radius, diameter, or area. Circle perimeter formula p = 2πr explained with examples and a table.
Free trapezoid area calculator. Solve area from two bases and height, plus perimeter and angles from the legs. Trapezoid area formula A = ((a+b)/2)h explained.
Free hemisphere volume calculator. Solve from radius, diameter, or volume, plus surface areas. Hemisphere volume formula V = 2/3 πr³ with worked examples.
Free area of a square calculator. Enter side, diagonal, perimeter, or area to solve the rest instantly. Square area formula A = a² explained with examples.
Free area of a rectangle calculator. Enter any two values to solve area, perimeter, sides, or diagonal instantly. Rectangle area formula A = a × b explained.
Free arc length calculator. Solve arc length, sector area, and chord from angle and radius. Arc length formula L = rθ in degrees or radians with examples.
Convert any salary to an hourly wage. See what $50,000, $60,000 or any yearly pay works out to per hour, week and month. Free calculator and full chart.
Mean absolute deviation calculator with steps. Get the MAD, mean, and full working table for any data set. MAD of 9, 13, 43, 55 is 19. Free MAD solver.
Sample size calculator for surveys and research. Find how many people to survey at any confidence level. 95% confidence, 5% margin needs 385. Free, with steps.
Learn how to find critical value in statistics with easy steps, formulas, and examples. Calculate Z, f, chi-square, and t critical values quickly.
Use this Chi Square Table to find critical values for the chi-square distribution. Includes critical values by degrees of freedom and common alpha levels.
Use this T Table to find critical values for the Student’s t-distribution. Includes t values by degrees of freedom for one-tailed and two-tailed tests.
Use this Z table (standard normal distribution table) to find probabilities Includes full positive and negative Z score tables for quick lookup.
Proportion calculator that solves for x with full steps. Enter three values, leave one blank, and get the missing number instantly. Fractions and decimals too.
Understand slope intercept form easily! Learn y=mx+b, graph lines, y-intercept, examples, calculate slope, and avoid common mistakes.
Learn significant figures (sig figs) rules, examples, and how to calculate sig fig. Master counting, rounding, and using sig figs in math and science
Confidence interval calculator with steps. Enter your mean, SD, and sample size to get the 95% CI, margin of error, and critical value, using t or z correctly.
Struggling how to find outliers in a data set? Learn 4 proven methods IQR, standard deviation, Excel, Sorting methods and clear example for beginners.
Axis of symmetry calculator finds x = -b/2a instantly. Enter standard, vertex, or factored form for the axis, vertex, and graph with full steps.
Free correlation coefficient calculator. Enter your X and Y data to get Pearson r, R squared, covariance, and a step by step solution with a scatter plot.
Free covariance calculator with step-by-step solution. Enter X and Y values for sample or population covariance, mean deviations, and worked examples.
Learn how to find degrees of freedom in statistics with clear formulas, step by step examples, t test, chi square and ANOVA explained simply.
Free critical value calculator for z, t, chi-square, and F tests. Get exact one- and two-tailed values with steps, plus full z and t critical value tables.
Free degrees of freedom calculator finds df for t-tests, chi square, ANOVA & regression. Every formula, step-by-step, plus a full df reference table.
Linear regression calculator finds y = mx + b, slope, intercept, r and R2 from your data. See worked examples and how to do linear regression by hand.
Free quadratic regression calculator finds the y = ax² + bx + c equation and R² from your data, with full step-by-step working and worked examples.
Free variance calculator finds sample and population variance with step-by-step solution, mean, sum of squares, and standard deviation. Enter data, get answer.
Free binomial distribution calculator. Find P(X=x), P(X≤x), P(X≥x), nCx, mean & standard deviation with step-by-step solutions and worked examples.
Free p value calculator. Enter a z score, t value, chi-square or F statistic and get the exact p value with full working shown, step by step.
Discover how to calculate the mean with a simple formula and examples. Find the mean of any data set and understand this key concept in statistics.
Standard error calculator with the SE formula: SE = SD / √n. Enter your SD and sample size, or raw data, for the standard error with full steps shown.
Free standard deviation calculator with steps. Find sample or population SD, mean, and variance instantly. See the full worked solution for any data set.
Free voltage drop calculator for single and three-phase circuits. Get exact volts, percent drop, and wire resistance, plus the formula and AWG drop chart.
Find the mean, median, mode, and range of any data set with full steps and worked examples. Free calculator with a sorted table and clear solution for each answer.