Explore BrainMass

Time Series Graphing

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

The marketing manager of a company that manufactures and distributes heavy-duty equipment used in the road construction industry recorded the number of farming units sold quarterly for the period 2007 to 2012. The data is displayed in the table below.

2007 2008 2009 2010
Summer 70 74 79 78
Autumn 64 69 73 75
Winter 63 66 71 71
Spring 69 73 80 82

1. Draw a time-series graph representing the above data.
2. Determine adjusted seasonal indices for each of the four quarters.
3. Do seasonal forces significantly affect the sales of farming equipment? Comment
4. Derive a least-squares trend line for the sales of farming equipment.
5. Obtain seasonally-adjusted trend estimates for the number of farming units that the company can expect to sell in each quarter of 2011.

© BrainMass Inc. brainmass.com March 22, 2019, 12:43 am ad1c9bdddf

Solution Summary

The expert examines time series graphing.