Share
Explore BrainMass

Generate a Scatter Diagram: Power Setting and Diameter in a

Please review attached doc.

Generate a Scatter Diagram from the given data and information:
Use the following data to generate a Scatter Diagram to show the possible relationship between Power Setting and Diameter in a drilling operation. You can do this by hand and put it into a diagram in word, or you can use Excel. If you use Excel, follow the example in the Example Spreadsheet.
Obsvn. Power Setting Diameter Obsvn. Power Setting Diameter
1 28 2 16 30 2.18
2 30 2.1 17 25 1.97
3 22 1.9 18 21 1.88
4 25 1.95 19 23 1.89
5 21 1.89 20 20 1.87
6 20 1.9 21 26 1.98
7 25 1.97 22 29 2.08
8 26 2 23 24 1.91
9 21 1.9 24 29 2
10 28 2.1 25 23 1.87
11 29 2.15 26 30 2.07
12 24 1.94 27 28 2.04
13 23 1.88 28 25 1.93
14 29 2.2 29 22 1.86
15 30 2.16 30 26 1.97
Assignment: Create the diagram as indicated above.

Attachments

$2.19