A company manufactures strips of metal that are supposed to have width of 10 centimeters. For purposes of quality control, the manager plans to run some statistical tests on these strips. However, realizing that these statistical procedures assume normally distributed widths, he first tests this normality assumption on 90 randomly sampled strips. In Excel, how should he proceed?

Objective:

In Excel, use the chi-square goodness-of-fit test to see whether a normal distribution of the metal strip widths is reasonable.

Part	Width
1	9.990
2	10.031
3	9.985
4	9.983
5	10.004
6	10.000
7	9.992
8	9.996
9	9.997
10	9.993
11	9.991
12	9.991
13	10.006
14	9.998
15	9.995
16	9.989
17	9.987
18	9.997
19	9.970
20	10.000
21	10.000
22	10.005
23	9.994
24	9.998
25	10.011
26	9.993
27	10.004
28	10.012
29	9.995
30	10.015
31	9.991
32	10.004
33	9.994
34	10.007
35	9.988
36	10.000
37	9.983
38	10.014
39	9.992
40	9.998
41	10.009
42	10.016
43	10.011
44	9.993
45	9.988
46	9.996
47	10.011
48	9.990
49	10.008
50	9.981
51	10.002
52	10.007
53	9.995
54	10.004
55	9.993
56	10.003
57	9.988
58	10.006
59	9.996
60	10.005
61	9.994
62	10.011
63	10.002
64	9.993
65	10.004
66	9.994
67	10.000
68	10.002
69	9.998
70	9.988
71	9.998
72	10.014
73	9.998
74	10.021
75	10.003
76	10.006
77	10.006
78	10.001
79	10.010
80	9.993
81	9.999
82	9.994
83	10.007
84	10.008
85	10.007
86	9.977
87	10.004
88	10.007
89	10.003
90	9.996