The following data were measured in n=15 college seniors in a


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 NumberSexYear in SchoolAge at Earliest DrinkNumber of Drinks/Night
1MFreshman145
2MSenior118
3FJunior173
4MJunior139
6FSophomore154
7FFreshman150
9MSenior157
10FJunior215
11MJunior183
12MSenior146
13FJunior193
14FSophomore182
15MJunior204
     
*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.)