PROBLEM SET - 1A Determine the following: Mean, Standard Deviation, Samples within +/- 1SD, and
summary statistics using Excel's Stat. Tool Pak.  Generate a graphical plot, and analyze your findings.
Complete a written report using the format provided in the syllabus.
 
     SAMPLE  
 
MELTING POINT (Degrees C)
1
 
 
320
2
 
 
331
3
 
 
322
4
 
 
323
5
 
 
324
6
 
 
325
7
 
 
326
8
 
 
320
9
 
 
335
10
 
 
324
11
 
 
314
12
 
 
328
13
 
 
325
14
 
 
320
15
 
 
318
16
 
 
314
17
 
 
312
18
 
 
319
19
 
 
318
20
 
 
317
21
 
 
313
22
 
 
308
23
 
 
318
24
 
 
310
25
 
 
322
26
 
 
329
27
 
 
327
28
 
 
305
29
 
 
313
30
 
 
324
31
 
 
320
32
 
 
316
33
 
 
314
43
 
 
328
35
 
 
320
36
 
 
329
37
 
 
308
38
 
 
329
39
 
 
330
40
 
 
324
41
 
 
317
42
 
 
321
43
 
 
323
44
 
 
322
45
 
 
311
46
 
 
316
47
 
 
319
48
 
 
327
49
 
 
310
50
 
 
317

 

Problem Set 1 B:

Using the same data set for part a, complete the following steps
to create a Normal Curve Over Data (NCOD) chart.  Graphically
analyze the raw data with respect to the normal cure, and discuss
your observations.


                           Note:  Only a partial listing of data is shown.

The resulting graph of a Normal Curve Over Data (NCOD) is shown below: