Excel Column Statistics
Calculate count, unique values, sum, average, min, max, and median
Excel Column Statistics — what it does
Pick a worksheet and a column and get its full numeric profile: count, unique values, sum, average, minimum, maximum and median. The median alongside the mean is the quick skew check — when the two diverge, a handful of extreme values is dragging the average away from the typical case.
When this tool helps
- Summarising a sales or hours column before quoting figures in a report.
- Comparing average against median pay, order size or duration to detect skew.
- Verifying that a column's minimum and maximum fall inside a plausible range after an import.
How to use it
- Choose the Excel file and the worksheet.
- Select the column to analyse.
- Calculate the statistics.
- Read the count, unique, sum, average, min, max and median values.
Accuracy, limits, and good practice
- When the mean sits well above the median, a few large values dominate — report the median as the typical figure.
- Cells holding numbers stored as text are excluded from arithmetic; a count below the row count is the tell-tale.
- Unique counts on an identifier column should equal the row count; anything lower means duplicates worth investigating.
Frequently asked questions
What does the median tell me that the average does not?
The middle value, unaffected by outliers. Median income and median deal size describe the typical case far better than the mean.
Are blank cells part of the count?
No, only populated numeric cells contribute to the calculations, which is why count can differ from the number of rows.
Can I analyse a filtered range only?
Statistics run on the whole column. Filter the rows first with the Excel row filter, then analyse the result.
Related tools on this site
- CSV Column Merger — Combine selected CSV columns into a new field
- CSV Pivot Table — Summarize CSV data by row, column, and aggregation fields
- Excel Formulas to Values — Replace formulas with their current calculated values throughout an Excel workbook
Everything above runs inside this page. Excel Column Statistics needs no account, no upload, and no server round trip — close the tab and nothing is left behind.
Excel 欄位統計能做什麼
挑選工作表與欄位，取得完整的數值輪廓：筆數、唯一值、總和、平均、最小、最大與中位數。平均與中位數並列正是最快的偏態檢查——兩者分歧時，就是少數極端值把平均拖離了典型情況。
什麼時候用得上
- 在報告中引用數字前，先摘要銷售或工時欄位。
- 比較平均與中位數的薪資、訂單金額或時長，偵測分布偏態。
- 匯入後驗證欄位的最小與最大值是否落在合理範圍。
使用步驟
- 選擇 Excel 檔案與工作表。
- 選定要分析的欄位。
- 執行統計計算。
- 查看筆數、唯一值、總和、平均、最小、最大與中位數。
精確度、限制與實務建議
- 平均明顯高於中位數時，代表少數大值主導了結果——引用「典型值」請用中位數。
- 以文字形式儲存的數字不會計入運算；筆數低於列數就是這個問題的徵兆。
- 識別碼欄位的唯一值數應等於列數，偏低就代表有值得追查的重複。
常見問題
中位數能告訴我平均值講不出的什麼？
不受極端值影響的中間值。中位數薪資、中位數成交額遠比平均更能描述典型情況。
空白儲存格算在筆數裡嗎？
不算，只有有值的數值儲存格參與計算，這也是筆數可能與列數不同的原因。
可以只分析篩選後的範圍嗎？
統計是整欄計算。請先用 Excel 資料列篩選工具過濾，再分析結果檔。
本站相關工具
- CSV 欄位合併 — 將選定 CSV 欄位合併成新欄位
- CSV 樞紐分析表 — 依列、欄與彙總欄位整理 CSV 資料
- Excel 公式轉數值 — 將 Excel 活頁簿中的公式替換為目前計算結果
以上步驟全部在這個頁面內完成，Excel 欄位統計 不需要註冊、不上傳檔案、也不經過伺服器，關閉分頁後不會留下任何資料。