Q1: In the White textbook, useExample 11.6(starting at the bottom of page 203-207) to replicate the pivot table in the textbook. Next submit a histogram using the table you created. You need to submit the pivot tables AND the histogram to receive full credit. Submit using attached Excel spreadsheet

Q2: Using the attached Excel spreadsheet, graph appointment wait times utilizing the appropriate presentation method. I have attached both 2 questions, the 11.6 example, and the pages 203-207 to get inspired for the pivot table. please let me know how to do the assignment because otherwise i wont be able to do it.

thanks.

Data Display Report illustrating frequency distribution 203 ple 11.6. 2014 Surgeon General's Report Smoking-Attributable Mortality by Gender, United States, 1965-2014 Males 2000- 2005- 1965-1999 2004 2009 2010- Females 2014 2000- 2005- 522,360 1965-1999 2004 2010- sense 3,091,600 501,500 501,500 2009 2014 1,053,700 total cancers 3,853,200 395,700 478,000 281,880 478,000 317,000 317,000 1,685,800 246,790 325,000 325,000 Total cardiovascular ind metabolic ceases 1,440,700 268,980 291,000 291,000 Total pulmonary 715,800 247,720 274,500 274,500 diseases 54,200 2,230 2,910 2,910 40,200 1,660 2,160 2,160 Perinata conditions 41,930 2,080 1,680 1,680 33,280 Residential fires ,600 1,420 ,420 853,690 156,940 117,630 117,630 490,310 Total secondhand 90,060 88,790 88,790 smoke des the Source: HHS 2014. e in the ge with an the Table 11.6 shows a frequency distribution table of deaths attributed to smoking by gender in the US from 1965 to imber. 013. To display discrete or continuous data in the form of a frequency distribution table, the range of values of the hervations must be broken down into a series of distinct groups that do not overlap. For example, when arranging a frequency distribution table by patient age, age ranges should not be listed as 1 to 10, 10 to 20, 20 to 30, 30 to 40, and yon because a patient could be placed in two categories if he were age 20: the 10-to-20 age range and the 20-to-30 age ange. Thus, age ranges should be listed as 1 to 10, 11 to 20, 21 to 30, 31 to 40, and so on. Notice the years in table 11.6. They do not overlap each other; 1965 to 1999, then the next group is 2000 to 2004, and so on. Summarizing the data involves setting up categories and counting the number of cases that fall into each category, hereby creating a frequency distribution. Following are some general rules for choosing the classes or categories into which the data are to be grouped and the range of each: Use between 5 and 15 categories. However, the choice depends mostly on the number of values to be grouped. . Define all categories. Choose categories that cover the smallest and largest values and do not produce gaps between categories. " The categories should be mutually exclusive where each observation is grouped into one-and only one- category. Avoid successive classes that overlap or have common values. . Whenever possible, make the classes cover equal ranges (or intervals) of values. These ranges also should be made up of numbers that are easy to work with. A table should be able to stand alone; meaning, the audience should be able to review the table and understand it without supporting information. Example 11.6: The table that follows lists the patients seen last month at Community Hospital with their age and cholesterol reading. Use an Excel spreadsheet to create a table using common age categories and these ranges for cholesterol.d. Copy th Copy t Chapter 11 Presentation of Data 204 . Copy t Community Hospital Cholesterol Readings, October 20XX Step 2: Create Desirable $ 199 Borderline High 200-239 a. Sort t High 2 240 b. Label Cholesterol Age Age Cholesterol c. Ages Cholesterol Age 165 56 d. Copy Age Cholesterol 38 185 138 Cop 44 142 20 118 18 200 e . 14 204 f. Con 47 80 139 62 139 45 241 236 48 63 Step 3: Cre 42 187 37 202 175 25 186 a. Th 37 201 207 70 32 188 56 201 23 107 157 42 17 239 47 198 24 109 238 55 55 175 20 210 67 132 13 134 61 168 235 248 55 43 44 239 53 173 52 185 50 137 64 165 41 238 52 192 34 188 60 180 47 144 38 245 70 172 44 245 30 207 42 158 75 175 37 160 55 207 65 187 62 185 33 155 69 192 51 248 49 207 39 221 31 196 43 240 39 147 34 244 51 147 51 188 53 155 75 186 63 200 50 203 46 246 81 160 18 137 20 145 43 222 79 154 37 245 72 175 26 147 67 154 43 256 39 200 46 201 50 192 44 188 19 145 60 152 53 188 52 200 63 145 35 150 26 137 51 147 36 176 53 215 24 140 19 132 33 185 60 165 22 138 73 147 16 137 63 168 Note: This example will introduce functionality in Excel not previously used in this text.bos Step 1: Create the cholesterol categories. This may be completed using a number of different methods in Excel. We will use the simplest method here. It is multistep, but much easier to follow than some of the other methods. a. Copy the data so that there is one column for age and one for cholesterol. b. Sort the table by cholesterol value. c. Create a column called "Cholesterol Category" in column C.Aug Copy the term "Desirable =240 Grand Total 5 10-19 years old 8 6 20-29 years old 2 8 10 18 7 9 30-39 years old 6 3 6 6 20 8 40-49 years old 8 7 12 1 20 9 50-59 years old 14 15 60-69 years old 7 11 70-79 years old going tosell all of shorter 7 swisswor and gig 2 12 80-89 years old 10 100 24 66 Grand Total 14 offol of of build wot tables are a very powerful function in Excel that allows data to be summarized very easily. There are many tutorials and videos online that can be used to learn more about this method.E F G H K A B D QUALITY HOSPITAL HEALTH CLINIC WAIT TIMES N JANUARY 20XX AVERAGE WAIT TIMES DAY (in minutes) 1 5 2 15 3 20 4 10 5 15 6 18 20 8 15 9 12 10 25 11 20 12 20 13 19 14 17 18 15 18 19 16 35 20 17 20 21 18 22 22 19 16 23 20 18 24 21 19 25 22 16 26 23 23 27 24 25 28 25 20 29 26 17 30 27 28 31 28 18 32 29 16 33 30 14 34 31 22 35 36 37 38 Chapter 11 Q1 Histo Assignment Chapter 11 Q2 Assignment +\f256 Chapter 11 Presentation of Data Community Hospital Gr Cholesterol Readings, October, 20XX Desirable = 199 Borderline High 200-239 rela High 2 240 Age Cholesterol Age Cholesterol Age Cholesterol Age Cholesterol 39 221 31 196 43 240 39 147 34 244 51 147 51 188 53 155 75 186 200 50 203 46 246 160 18 137 20 145 43 272 79 154 37 245 72 175 26 147 67 154 43 256 39 200 46 201 50 192 44 188 19 145 60 152 53 188 52 200 63 145 35 150 26 137 51 147 36 176 53 215 24 140 19 132 33 185 60 22 165 138 73 147 16 137 63 168 Exercise 11.3 The following table shows a frequency distribution of patients with colon cancer treated at Community Hospital. Compute the proportion of patients in each category. Community Hospital Ages of Patients with Colon Cancer Age Annual Statistics, 20XX No. of Patientstually exclusive where each ranges also should be made Category. Avoid successive classes that overlap or have common values, Whenever possible, make the classes cover equal ranges (or intervals) of values. These made up of mos co of numbers that are easy to work with. . A table should be able to stand alone; that is, the audience should be able to review the table and understand it without supporting information. Exercise 11.2 for cholesterol. The table below lists the patients seen last month at Community Hospital with their age and cholesterol reading. Create a table using common age categories and these ranges Community Hospital Cholesterol Readings, October, 20XX Desirable $ 199 Borderline High 200-239 High 2 240 Age Cholesterol Age Cholesterol Age 14 118 Cholesterol 44 Age Cholesterol 138 38 165 139 47 185 204 18 142 20 187 200 48 236 62 139 45 241 37 201 25 186 37 202 175 107 56 201 32 207 185 24 109 47 198 17 157 759 67 132 20 210 55 238 55 175 55 235 43 248 13 134 169 52 185 50 137 44 239 57 173 52 192 34 188 165 238 47 144 38 245 70 172 180 42 158 75 175 44 245 207 37 160 207 65 185 55 187 33 155 49 207 69 192 51 248 (continued on next page