Practice Problems 57 3.5 PRACTICE PROBLEMS 4. Using the data in Table 3-1. create a frequency dis- tribution table for drinking status, defined by the fol- 1. The following data were measured in 15 college sen- lowing numbers of drinks per night: iors (n = 15) in a cross-sectional study of alcohol consumption. Each participant was asked their sex, Abstinent Light 1-4 year in school, the age at which they first consumed Moderate alcohol, and the number of alcoholic drinks they con- Heavy 6 or more drinks per night sume on a typical drinking night. The data are shown in Table 3-4. Generate frequency distribution tables 5. Using the data in Table 3-4, generate a frequency his- for sex and year in school using the Data/Pivot Table togram for drinking status using the Chart Wizard. and Pivot Chart Report option on the menu bar. 6. Using the data in Table 3-4, generate a scatter dia- 2. Generate a frequency bar chart for sex using the fre- gram to display the association between age at first quency distribution tables from Problem I. drink and number of drinks per night. (Note that the 3. Generate a frequency histogram for year in school sample size for analysis is n = 13.) using the Pivot Table and Pivot Chart Report from Problem I. TABLE 3-4 Data for Practice Problems ID - Number Sex Year in School Age at First Drink Number of Drinks/Night M Freshman M Senior Junior 17 M Junior 14 Freshman Sophomore 15 Freshman 15 Freshinan Junior ETTEETT Junior Senior Junior Sophomore Junior "Students who never had a drink were excluded 9 e