How to Create Summary Statistics in Google Sheets

Sdílet
Vložit
  • čas přidán 10. 09. 2024
  • In this video, I show you how to generate Summary Statistics like mean, standard deviation, etc in Google Sheets.
    Functions and Sample Usage:
    Mean: =AVERAGE(A1:A10)
    Median: =MEDIAN(A1:A10)
    Standard Deviation (Sample): =STDEV(A1:A10)
    Standard Deviation (Population): =STDEVP(A1:A10)
    Variance (Sample): =VAR(A1:A10)
    Variance (Population): =VARP(A1:A10)
    Maximum: =MAX(A1:A10)
    Minimum: =MIN(A1:A10)
    Count: =COUNT(A1:A10)
    Sum: =SUM(A1:A10)
    First Quartile (Q1): =QUARTILE(A1:A10, 1)
    Third Quartile (Q3): =QUARTILE(A1:A10, 3)
    Interquartile Range (IQR): =QUARTILE(A1:A10, 3) - QUARTILE(A1:A10, 1)
    Mode: =MODE(A1:A10)
    Range: =MAX(A1:A10) - MIN(A1:A10)

Komentáře •