import pandas as pd
import scipy.stats as stats
data = pd.read_excel('9.2.xlsx')
data_values = data.values.flatten().tolist()
statistic, p_value = stats.shapiro(data_values)
print("Shapiro-Wilk 統計量：", statistic)
print("p 值：", p_value)
if p_value > 0.05:
print("滾珠直徑服從正態分佈 N(15.0780, 0.4325^2)")
else:
print("滾珠直徑不服從正態分佈 N(15.0780, 0.4325^2)")
