Question

In addition to submitting a print-out of the worksheet(s), also...

In addition to submitting a print-out of the worksheet(s), also submit the following, referencing the data in your print-out and your textbook or Notes:

(a)Compute the Range of the Actual Data, the 3-Year Moving Average data, and the 5-Year Moving Average data columns.Type the word "Range:" and the values for the range next to each respective graph (show the maximum data value, the minimum data value, and the range value).

(b)What do the three calculated range values from part (a) and the three-line graphs show regarding the effect that averaging has upon the relative degree of fluctuation in a data series?

Actual Data 3-Yr.Aver. 125.7 139.3 126.7 142.3 160.3 194.0 177.0 163.7 125.3 126.3

110

127

140 5-Yr.Aver. 123.4 138.8 154.4 164.4 161.4 176.6 154.2 141

151

89

187

205

190

136

165

75

139