HLTH 501 EXCEL: GRAPHS AND CHARTS For this exercise, please refer to the downloaded Essentials Excel Workbook (See Excel Workbook Instructions) from the JB Learning website with your access code. Please upload your answers as an excel file with properly labeled answers. At the end of the chapter 3 workbook you will find Practice problems. Please answer in excel only under practice problems 3.5 questions: 1, 2, 3, 4, 5 and 6. If help is needed, tutorials are found in the workbook with relevant problems. 9781284106217_WORK_ Excel2007.pdf (SECURED) - Adobe Acrobat Pro DC File Edit View Window Help Tools 9781284108217_W. x 1 62 /231 149% . . PPQQ Share Practice Problems 57 3.5 PRACTICE PROBLEMS 4. Using the data in Table 3-4, create a frequency dis- 1. The following data were measured in 15 college sen- tribution table for drinking status, defined by the fol- iors (n = 15) in a cross-sectional study of alcohol lowing numbers of drinks per night: consumption. Each participant was asked their sex, Abstinent Light 1-3 year in school, the age at which they first consumed Moderate 4-5 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. O 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 1. 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 1. 1+ 1:49 PM AVENG 9/27/2019 9 9781204108217_WORK_Excel2007.pdf (SECURED) - Adobe Acrobat Pro DC