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.

M. Abdullah Arshad is an MPhil Statistics scholar and Google-certified data analyst. He specializes in statistical analysis, data mining, hypothesis testing, time series modeling, and regression techniques.
Abdullah works with statistical methods and data analysis tools. He creates clear, practical content on statistics topics such as p-values, standard deviation, sum of squares, and data interpretation to help readers apply concepts effectively.
MPhil in Statistics (University of the Punjab). He also holds multiple certifications in data analysis, SQL, practical time series analysis, Python, Excel, and Google data tools.
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 hexagon calculator. Enter side, area, perimeter, diagonal, or apothem to solve the rest. Regular hexagon area formula A = (3√3/2)a² with examples.
Free equilateral triangle calculator. Enter side, height, area, or perimeter to solve the rest. Area formula A = (√3/4)a² with height, radii, and examples.
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 cylinder volume calculator. Solve solid or hollow cylinder (pipe) volume from radius or diameter. Cylinder volume formula V = πr²h with liters and gallons.
Free area of a triangle calculator. Solve from base and height, three sides, or two sides and an angle. Triangle area formula A = ½ × b × h explained with 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 Pythagorean theorem calculator. Enter any two sides to find the third with a² + b² = c². Solve the hypotenuse or a leg, plus area and perimeter.
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.
Time and a half means 1.5 times your hourly rate. Enter your wage to see your overtime rate and pay in seconds, with a rate chart for common wages.
Convert grams to kg fast. 1000 grams equals 1 kilogram, so divide grams by 1000. Free grams to kilograms calculator with a conversion chart and formula.
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.
Free test grade calculator. Enter questions wrong or your score to get the percentage and letter grade, plus how many you can miss for an A, B, or C.
BODMAS and PEMDAS calculator with steps. Enter any expression and see each operation solved in order: brackets, exponents, division, multiplication, addition, subtraction.
Percentile calculator with steps. Find the value at any percentile, or the percentile rank of a number. 25th percentile of 45–90 is 56.25. Free 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.
Use this Z table (standard normal distribution table) to find probabilities Includes full positive and negative Z score tables for quick lookup.
Learn how to find p value step by step with formulas, examples, and charts. Calculate p values for Z, T, and Chi square tests easily.
Learn the axis of symmetry definition, formula, and equation with step-by-step examples. Find axis of symmetry of a parabola easily.
Understand slope intercept form easily! Learn y=mx+b, graph lines, y-intercept, examples, calculate slope, and avoid common mistakes.
Learn what sum of squares is, sum of squares formula, SSR, residual sum of squares, and how to calculate sum of squares step by step with examples.
Learn significant figures (sig figs) rules, examples, and how to calculate sig fig. Master counting, rounding, and using sig figs in math and science
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 log calculator finds log base 10, base 2, or any custom base with step-by-step solutions. Solve exact log values and doubling-time problems fast.
Free slope intercept form calculator. Enter two points, a slope, or an equation like 4x-20y=-160 to find y = mx + b with steps and a graph.
Geometric Mean Calculator with steps. Find the geometric mean of any numbers instantly, plus worked answers for common pairs like 9 and 25 or 8 and 32.
Quadratic formula calculator solves ax²+bx+c=0 with full steps, roots, and discriminant. Paste your equation and get worked-out answers instantly.
Sum of squares calculator with the SS formula: SS = Σ(x − x̄)². Enter your data to get the mean, each squared deviation, and the total, with steps shown.
Free 5 number summary calculator with steps. Find min, Q1, median, Q3, max, then build a box plot. Solved examples for any dataset.
Learn how to read a standard deviation graph with clear examples. Understand standard deviation charts, graphing methods, Excel steps, and data interpretation.
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.
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 pie chart generator. Enter your labels and values to make a pie or donut chart with percentages, then download it as a PNG. No sign up, no skills needed.
Free asphalt calculator. Enter length, width, and thickness to get exact tonnage, cubic yards, and cost. See how much asphalt you need in seconds.
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.
KG to lbs calculator with instant results. Multiply kg by 2.2046 to get pounds. See stones, ounces, and a full kilograms to pounds chart.