- Using Excel, complete the following exercises out of your textbook:
- Exercise 17: Academy Award-Winning Male Actors (Section 3.1 p. 80)
- Exercise 15: Academy Award-Winning Male Actors (Section 3.2 p. 92)
- In these exercises, you will practice construction of frequency tables and histograms, respectively.
Submit both a Word document and two Excel documents as needed to show calculations and interpret the results.
17. Academy Award-Winning Male Actors. The following data show the ages of all Academy Award Winning Male Actors at the time when they won the award (through 2016). Construct a frequency table for the data using bins of 20-29, 30-39 and so on. What ages are the most common for these winners?
44 41 62 53 47 35 34 34 49 41 37 38 34 32 40
43 48 41 39 49 57 41 38 39 52 51 35 30 39 36
43 49 36 47 31 47 37 57 42 45 42 45 62 43 42
48 49 56 38 60 30 40 42 37 76 39 53 45 36 62
43 51 32 42 54 52 37 38 32 45 60 46 40 36 47
29 43 37 38 45 50 48 60 50 39 55 44 33 41
15. Academy Award Winning Male Actors
Exercise 17 required the construction of a frequency table for the ages of Academy Award Winning Male Actors at the time when they won the award. Use that frequency table to construct the corresponding histogram
