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


1. The aftercited grounds were measured in n=15 academy seniors in a cross-sectional examine of alcohol lessening. Each participant was asked their sex, year in discipline, the age at which they primitive wasted alcohol and the calculate of alcoholic absorbs they waste on a normal absorbing duskiness. The grounds are shown under.

ID NumberSexYear in SchoolAge at Primitive DrinkNumber of Drinks/Night
1MFreshman145
2MSenior118
3FJunior173
4MJunior139
6FSophomore154
7FFreshman150
9MSenior157
10FJunior215
11MJunior183
12MSenior146
13FJunior193
14FSophomore182
15MJunior204
     
*Students who never had a absorb were outside.  
     
1. Generate quantity dispensation consultations for sex and year in discipline using the Grounds –
Pivot Consultation and Pivot Chart Report discretion on the menu bar.
2. Generate a quantity bar chart for sex using the Pivot Consultation and Pivot Chart Report from substance #1.
3. Generate a quantity histogram for year in discipline using the Pivot Consultation and Pivot Chart Report from substance #1.
4. Create a quantity dispensation consultation for absorbing condition, defined by the aftercited calculates of absorbs per duskiness:
 
Abstinent 0
Light 1-3
Moderate 4-5
Heavy 6 or more absorbs per duskiness
5. Generate a quantity histogram for absorbing condition using the Chart Wizard.
6. Generate a disseminate diagram to vault the fraternity betwixt age at primitive absorb and calculate of absorbs per duskiness. (Note that the exemplification greatness for anatomy is n=13.)