1) Download the excel file Econ 299 Lab A03.1" 2) Create a bar chart showing flossing frequency a) Edit your chart and insert elements as appropriate. Make sure to include titles, labels, etc. 3) Create a pie chart showing brushing tool a) Edit your chart and insert elements as appropriate. Make sure to include labels and percentages. 4) Create a pivot table showing brushing frequency a) Group your frequencies, starting at 3 and ending at 15, with a range of 3 for each category. b) Convert your pivot table to a histogram. b) Edit your chart and insert elements as appropriate. Make sure to include titles, labels, etc. Reduce the gap between the categories. 5) Insert titles and format ONE Excel page to be handed in, with name, student ID and Econ 299 section on the page. Assignment is due at the START of the following lab. All lab assignments will receive a mark of 1, 12, or zero, and NO late labs will be accepted. University of Olberto Dental Care Survey Results Observation Brushing Tool 1 Toothbrush 2 Electric Toothbrush 3 Electric Toothbrush 4 Toothbrush 5 Electric Toothbrush 6 Toothbrush 7 Toothbrush 8 Toothbrush 9 Toothbrush 10 Toothbrush 11 Electric Toothbrush 12 Other 13 Toothbrush 14 Electric Toothbrush 15 Other 16 Toothbrush 17 Toothbrush 18 Other 19 Toothbrush 20 Toothbrush 21 Other 22 Toothbrush 23 Electric Toothbrush 24 Other 25 Toothbrush 26 Electric Toothbrush 27 Electric Toothbrush 28 Electric Toothbrush 29 Electric Toothbrush 30 Other 31 Toothbrush 32 Electric Toothbrush 33 Other 34 Toothbrush 35 Electric Toothbrush Brushing Frequency (per week) Flossing Frequency 8 Daily 10 Daily 14 Weekly 21 Daily 14 Weekly 8 Weekly 9 Daily 14 Rarely 6 Weekly 12 Daily 10 Weekly 5 Rarely O Rarely 12 Weekly 6 Weekly 13 Rarely 12 Never 7 Rarely 10 Weekly 10 Weekly 9 Daily 9 Daily 10 Daily 12 Daily 6 Daily 10 Weekly 1 Daily 11 Rarely 6 Weekly 14 Rarely 5 Never 12 Weekly 14 Weekly 5 Rarely 5 Weekly 36 Toothbrush 37 Toothbrush 38 Toothbrush 39 Toothbrush 40 Toothbrush 41 Toothbrush 42 Electric Toothbrush 43 Electric Toothbrush 44 Other 45 Toothbrush 46 Electric Toothbrush 47 Toothbrush 48 Toothbrush 49 Electric Toothbrush 50 Toothbrush 51 Toothbrush 52 Electric Toothbrush 53 Toothbrush 54 Toothbrush 55 Electric Toothbrush 56 Toothbrush 8 Rarely 8 Daily 13 Rarely 8 Weekly 5 Weekly 6 Rarely 6 Daily 10 Weekly 5 Rarely 12 Daily 13 Daily 14 Weekly 11 Rarely 6 Rarely 5 Weekly 9 Weekly 6 Weekly 7 Rarely 18 Weekly 13 Daily 5 Rarely