9.3

import pandas as pd
import matplotlib.pyplot as plt
import scipy.stats as stats

读取 Excel 文件中的数据

data = pd.read_excel('9.3.xlsx') # 将 'your_file.xlsx' 替换为您的 Excel 文件路径

提取各列数据

lab1 = data['Lab1']
lab2 = data['Lab2']
lab3 = data['Lab3']
lab4 = data['Lab4']
lab5 = data['Lab5']
lab6 = data['Lab6']
lab7 = data['Lab7']

plt.boxplot([lab1, lab2, lab3, lab4, lab5, lab6, lab7], labels=['Lab1', 'Lab2', 'Lab3', 'Lab4', 'Lab5', 'Lab6', 'Lab7'])
plt.xlabel('实验室')
plt.ylabel('扑尔敏有效含量')
plt.title('各实验室测量结果的箱线图')
plt.show()
f_statistic, p_value = stats.f_oneway(lab1, lab2, lab3, lab4, lab5, lab6, lab7)

if p_value < 0.05:
print("各实验室测量的扑尔敏的有效含量的均值有显著差异")
else:
print("各实验室测量的扑尔敏的有效含量的均值没有显著差异")
print("学号:3022")