1. The forthcoming grounds were measured in n=15 seed-plot seniors in a cross-sectional consider of alcohol expenditure. Each participant was asked their sex, year in nurture, the age at which they earliest decayd alcohol and the sum of alcoholic absorbs they decay on a illustrative absorbing death. The grounds are shown underneath.
| ID Number | Sex | Year in School | Age at Earliest Drink | Number of Drinks/Night |
| 1 | M | Freshman | 14 | 5 |
| 2 | M | Senior | 11 | 8 |
| 3 | F | Junior | 17 | 3 |
| 4 | M | Junior | 13 | 9 |
| 6 | F | Sophomore | 15 | 4 |
| 7 | F | Freshman | 15 | 0 |
| 9 | M | Senior | 15 | 7 |
| 10 | F | Junior | 21 | 5 |
| 11 | M | Junior | 18 | 3 |
| 12 | M | Senior | 14 | 6 |
| 13 | F | Junior | 19 | 3 |
| 14 | F | Sophomore | 18 | 2 |
| 15 | M | Junior | 20 | 4 |
| | | | | |
| *Students who never had a absorb were surrounding. | | |
| | | | | |
| 1. Generate abundance arrangement consultations for sex and year in nurture using the Grounds – |
Pivot Consultation and Pivot Chart Report non-interference on the menu bar.
2. Generate a abundance bar chart for sex using the Pivot Consultation and Pivot Chart Report from height #1.
3. Generate a abundance histogram for year in nurture using the Pivot Consultation and Pivot Chart Report from height #1.
| 4. Create a abundance arrangement consultation for absorbing foundation, defined by the forthcoming sums of absorbs per death: | | | | Abstinent 0 | | Light 1-3 | | Moderate 4-5 | Heavy 6 or past absorbs per death
5. Generate a abundance histogram for absorbing foundation using the Chart Wizard.
| 6. Generate a strew diagram to ostentation the alliance among age at earliest absorb and sum of absorbs per death. (Note that the exemplification dimension for dissection is n=13.) |
|
|
|
|
|
