Microsoft Office Tutorials and References
In Depth Information
Exhibit 2.6 Line chart for products A–E
(3) the behavior of the individual product’s sales over quarters. The line graph
provides some interesting insights related to the data. For example:
1. Products A and E both appear to exhibit seasonal behavior that achieves highs
and lows approximately every 4 quarters (e.g. highs in quarter 1 for A and quarter
4forE).
2. The high for product E is offset approximately one quarter from that of the high
for A. Thus, the peak in sales for Product A lags (occurs later) the peak for E by
one quarter.
3. Product D seams to show little seasonality, but does appear to have a slight linear
trend (increases at a constant rate). The trend is positive; that is, sales increase
over time.
4. Product B has a stable pattern of quarterly alternating increases and decreases,
and it may have slight positive trend from year 1 to year 2.
Needless to say, line graphs can be quite revealing, even if the behavior is based
on scant data. Yet, we must also be careful not to convince ourselves of systematic
behavior (regular or predictable) based on little data; more data may be needed to
convince ourselves of true systematic behavior.
Finally, Exhibit 2.7 is also a Line graph, but in 3-D. It suffers from the same
visual obstructions that we experienced in the 3-D Column graph—possibly appeal-
ing from a visual perspective, but providing less information content than the simple
line graph in Exhibit 2.6 due to the obstructed view. It is difficult to see values of
Search JabSto ::




Custom Search