Share
Explore BrainMass

Computing Seasonal Effects in Excel

The U.S. Department of Agriculture publishes statistics on the production of various types of food commodities by month. Shown here are the production figures on broccoli for January of a recent year through December of the next year. Using these computed values, determine the seasonal effects (S ? I).

Broccoli Broccoli
Month (millions pounds) Month (millions pounds)
January (1st year) 132.5 January (2nd year) 104.9
February 164.8 February 99.3
March 141.2 March 102.0
April 133.8 April 122.4
May 138.4 May 112.1
June 150.9 June 108.4
July 146.6 July 119.0
August 146.9 August 119.0
September 138.7 September 114.9
October 128.0 October 106.0
November 112.4 November 111.7
December 121.0 December 112.3

Attachments

Solution Summary

Detailed solution to problem in attached excel file.

$2.19