1. Choose a dataset of your choice or use one from the textbook. Put a PowerPoint presentation together which should be approximately 5 minutes. 2. Use Statistical topics from Units 1 or 2 to analyze the data a. REQUIRED - Use Excel's DESCRIPTIVE STATISTICS-FOUND IN THE ANALYSIS TOOKPAK and interpret the results during your presentation. What do the descriptive statistics tell you about your dataset? b. Use 3 other statistical procedures from Units 1 and/or 2 and interpret the results. Be sure to choose 3 DIFFERENT TYPES of statistical procedures and fully complete each to give a sensible result which you can explain to everyone. c. For Example, some ideas listed below: i. Frequency Distribution with relative frequencies, cumulative frequencies and charts with graphs Data Analysis-Rank and Percentile analysis Bayes Theorem ii. iii. iv. Interquartile Range with a Box Plot V. Bivariate financial portfolio vi. Binomial distribution vii. Hypergeometric distribution viii. Poisson distribution ix. Normal distribution X. xi. I Hypothesis Test and compute p-value More topics are listed in your textbook-choose something that you understand. 3. Create Charts, Graphs, tables, etc. to explain your data - During your presentation explain why the Chart or table you have created make sense to use. 4. Put into a Power Point Presentation - should be about 5 minutes. 5. Write a short summary explaining your findings for each analysis and save in a Textbox in your Excel file. 6. To achieve maximum points be sure to do the following: a. Organize your worksheets and clearly label spreadsheet tabs, tables and data b. Include Chart titles, legends and format each axis appropriately c. Label data series (ie. There should not be a reference to "series 1", it should be