Statistics/spreadsheet homework

Based on B.S. Mitchell, "Use of spreadsheets in introductory statistics and probability" Chem. Engr. Education, 31: (Summer 1997) pp. 194-200

These data are for Example #1. You can capture this page, pop into a word processor, and cut out all except the data. They will be accepted by Excel. The statistical analysis features of Excel are available but seldom installed. You must use the Tools menu and install the Analysis Toolpak to get "Descriptive Statistics" to work this example. There is nothing to hand in for Example #1, but you are expected to report on Example #7 about control charts. Instructions are at the bottom of this page. 

Worker hours
128
113
146
124
100
119
109
128
131
112
95
124
103
133
111
97
132
135
131
150
124
97
114
88
117
128
138
109
118
122
142
133
100
116
97
98
136
111
98
116
108
120
131
112
92
120
112
113
138
122

Example for control charts

This is simply busy work to fill in a spreadsheet given the data and formulae. It would be a good idea to work with a group to divide up the tedium. Nevertheless, this example is interesting because it ties in with the lecture and our web pages about control charts. To get credit for this homework, send a very brief e-mail telling what happens when you change n and when you change some data entries.