准备数据：
使用Alt= 计算出每列，每行的和，然后计算最后一列，或者最后一行的总和是4375
25行，10列，所以是250个元数据
使用python脚本：
#!/usr/bin/env python
import openpyxl
import statistics as stats
book = openpyxl.load_workbook('C:/Users/Administrator/Desktop/t.xlsx', data_only=True)
sheet = book.active
rows = sheet.rows
values = []
for row in rows:
for cell in row:
values.append(cell.value)
print("Number of values: {0}".format(len(values)))
print("Sum of values: {0}".format(sum(values)))
print("Minimum value: {0}".format(min(values)))
print("Maximum value: {0}".format(max(values)))
print("Mean: {0}".format(stats.mean(values)))
print("Median: {0}".format(stats.median(values)))
print("Standard deviation: {0}".format(stats.stdev(values)))
print("Variance: {0}".format(stats.variance(values)))
实现效果如下：
G:\Python3.8解释器\python.exe C:/Users/Administrator/PycharmProjects/pythonProject/jisuan.py
Number of values: 250
Sum of values: 4375
Minimum value: 1
Maximum value: 34
Mean: 17.5
Median: 17.5
Standard deviation: 7.777658251137417
Variance: 60.49196787148595
Process finished with exit code 0