How you use the graph commands (and to some extent the output) depends upon how the data are organized. However, the simplest way to use data may not always be the simplest way to collect it. You can organize data that are categorized by groups in a number of ways:
Unstacked Data You can enter the data for each group in separate columns. This method is useful if you are going to graph or analyze a group separately. |
or |
Stacked Data You can stack the same data by year, eliminating the need for the column Year. Stacked data can be simpler to collect and scan in the worksheet. |
||||||
Row |
Quarter |
Year |
Sales |
|
Row |
Qtr |
Sales91 |
Sales92 |
1 |
1 |
1991 |
94 |
|
1 |
1 |
94 |
106 |
2 |
2 |
1991 |
99 |
|
2 |
2 |
99 |
116 |
3 |
3 |
1991 |
98 |
|
3 |
3 |
98 |
113 |
4 |
4 |
1991 |
92 |
|
4 |
4 |
92 |
108 |
5 |
1 |
1992 |
106 |
|
|
|
|
|
6 |
2 |
1992 |
116 |
|
|
|
|
|
7 |
3 |
1992 |
113 |
|
|
|
|
|
8 |
4 |
1992 |
108 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Raw Data You can enter an observation each time it occurs. This method might be necessary if you have several grouping variables related to each observation. |
or |
Frequency Data You can list each observation once and use a frequency column to record the number of instances of each. Most Minitab graphs accept frequency columns. Frequency data can be simpler to collect and scan in the worksheet. |
||||||
Repair |
|
Mechanic |
|
|
Repair |
RepFreq |
Mechanic |
MechFreq |
Exhaust |
|
Steve |
|
|
Exhaust |
15 |
Steve |
20 |
Exhaust |
|
Steve |
|
|
Body |
22 |
Roger |
14 |
Body |
|
Roger |
|
|
Trans |
8 |
Debbie |
16 |
Trans |
|
Debbie |
|
|
Engine |
5 |
|
|
Body |
|
Debbie |
|
|
|
|
|
|
Engine |
|
Roger |
|
|
|
|
|
|