histograms
Using Excel, complete the following exercises out of your textbook:
· Exercise 17: Academy Award-Winning Male Actors (below)
· Exercise 15: Academy Award-Winning Male Actors (below)
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.
Exercise 17: Academy Award-Winning Male Actors
1 7. 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 com-mon 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
Exercise 15: Academy Award-Winning Male Actors
15. Academy Award–Winning Male Actors. Exercise 17 in Section 3.1 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 con-struct the corresponding histogram