|
Create a spreadsheet that takes the following hardness data and finds the average hardness value for each heat treatment. | |
Hardness data (Hardness measurements are in Rockwell C scale) spreadsheet:
Note: that I copied this data and the titles into this document using the windows clipboard and the cut and paste function from my spreadsheet. I expanded the width of column A to 15 characters. The average values were generated with a spreadsheet formula.
Temper Temperature (F)
Measurement 1
Measurement 2
Measurement 3
Average
no temper
52
54
53
53
400 F temper
48
50
49
49
1000 F temper 39
37
38
38
 |
Make a bar graph of the average values as shown below. Note that the axes are labeled and the graph has a title. You must label and title your graph. |
|
Write a brief, formal letter to J.C. Lutz of Lutz Manufacturing detailing the results of the hardness test. Import the chart into the letter using the clipboard. |
