Math

Discussion 1

Using Excel, complete the following exercises out of your textbook:  

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

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

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

Discussion 2 I have upload attachment for this question

Submit the Milestone One Worksheet. In this milestone, you will address the following:

1. Indicate what data set you have chosen and why. If you chose a particular data set to align with your concentration in psychology, describe in a sentence or two why you have chosen this concentration.
2. Describe the involved parties in the data set presented and the question you can answer by the data.
3. Discuss why the data set exemplifies a study that agrees with the APA’s Ethical Principles of Psychologists and Code of Conduct.
4. Discuss ethical issues that may arise when analyzing and reporting statistical data.
5. Describe one way in which you will ensure your reporting of results in your data analysis will align with the APA’s Ethical Principles of Psychologists and Code of Conduct.