Assignment:
For this project you will demonstrate competency in researching economics; that is, creatively designing a research question, locating pertinent and credible data to support an answer, and presenting results in a professional and articulate manner. Furthermore, you will also be applying fundamental statistical concepts to your data sets to more quantitively answer your research questions. Follow these steps to complete the project:
Please read the list below carefully
1. Using the data covered in the Health, Education, and Crime slides, generatesix research questions to study (e.g. "Have thyroid cancer rates have increased since 2000?", "What is the educational attainment across races in California?"). You are to create two research questions from Health, two from Education, and two from Crime. You are to use a different data source for each research question(e.g. CDC, FBI, NAEP, etc.) in the overall project. Raw data in excel form is necessary for this project (google "data source, subject, Excel" for fastest results).
2. Excel File: For each research question create an Excel sheet with your data set, one graph and the statistical metrics listed below. For the overall project you are to use each of the statistical concepts at least once and construct at least three different types of graphs. All statistical metrics are to be calculated in Excel using the functions reviewed in class.
- Mean (weighted, arithmetic, or geometric)
- Median
- Sample Variance
- Standard Deviation
- Coefficient of Variation
- Range
- 90th Percentile
- Quintiles
- Skewness
- Z-score for data points
- Discrete probability distribution histogram
3. PowerPoint Presentation: For each question, create a PowerPoint slidecontaining one graph, your statistical metrics, up to three bullet points (optional), and hyperlinks to your data source website (make sure the links work). The PowerPoint should also contain an introduction slide (e.g. name, project, and class).
Attachment:- Health.rar