Use spreadsheet software to create Figures 4-2 through 4-5 in this text. Make sure your formulas work correctly.
Please click on the pictures to see a full size image
Fig 4-2
Fig 4-3
Fig 4-4
Fig 4-5
Please click on the pictures to see a full size image
Fig 4-2
Fig 4-3
Fig 4-4
Fig 4-5
In this exercise I found that in some cases my figures differed slightly from those published in the text (Figures 4-3 and 4-4 specifically). I believe this is due to rounding being used in those charts published, whereas no rounding was used in my own spreadsheets. The effects on the final outcome however were negligible.