Using the fictional raw survey data provided to you in the Excel spreadsheet, you will calculate frequencies and percentages for the various survey questions from the respondent answers. You will then use Excel to create various types of charts/graphics that tell the story of your data. Once you have done the calculations and created your charts, you will then copy-paste them into a PowerPoint presentation that tells your sample's story.
All of the below must be included in your presentation slide set. All of the below chart types are available in Excel, so you will not need any special software to make the charts. You will be working from raw data, so you will have to tally the results, calculate percentages, and so forth to get it into a table that can then be translated by Excel's built- in charts. Be careful about how you work with the data, to ensure you have accurate results (make sure you have captured all relevant rows and that your formulas are referencing all the right cells, etc.)
Title Slide (slide 1)
Section 1: Sample Demographics (Slide 2)
3. Pie chart showing proportion of sample by race/ethnicity
4. Pie chart showing proportion of sample by gender (sex)
5. Pie chart showing proportion of sample by education
6. Column chart showing distribution of age range
7. Treemap showing distribution of employment status
Section 2: Family Characteristics & Insurance Status (Slide 8)
9. Column chart showing distribution of the number of people in each household (see in the examples below)
- On the above slide, you will add in a textbox (the number, not a chart) the average number of children in each household under the age of 18
- Also, you will add a small table that tells me the mean, median, mode, and standard deviation for the number of people in each household
10. Pie chart showing proportion of insured vs uninsured for the participants
11. Column chart showing distribution of source of insurance for the participants
12. Pie chart showing proportion of insured vs uninsured for the participants’ dependents
13. Column chart showing distribution of source of insurance for the participants’ dependents
Section 3: Healthcare Services Received & Postponed (Slide 14)
15. Compare/contrast the top 5 healthcare services received for participants that are insured vs uninsured (use a clustered column chart). Use the Insured as your reference/index case for the top 5. Be sure to indicate this as instructed in the demonstration video.
16. Compare/contrast the top 5 healthcare services postponed for participants that are insured vs uninsured (use a clustered column chart). Use the Uninsured as your reference/index case for the top 5. Be sure to indicate this as instructed in the demonstration video.
Section 4: Conclusions, Interpretation & Decision Making (Slide 17)
When answering the below questions, you cannot just eyeball things and make a decision. There are statistical ways that you can determine the representativeness of a sample. I have provided you with a document that guides you step-by-step in how to do these calculations to determine the representativeness of your sample (How to Determine Whether Your Sample Size is Representative of the Population.pdf Download How to Determine Whether Your Sample Size is Representative of the Population.pdf). For each question set below, you must provide your evidence (your calculations using the instructions in this document) and discuss your answers and reasoning to the questions being asked. (This is likely to take more than one slide, which is why I don't provide all the exact slide numbers below, other than the first one. Be sure not to crowd your slides with too much text/information.)
18-?. How well does this sample represent the population of Harris County on age, gender (sex), race/ethnicity, and education? Based on this, do you think that it is close enough to feel confident in generalizing this data to the larger Harris County population? Use the following link for data to use in your comparison and be sure to cite appropriately: https://www.census.gov/quickfacts/harriscountytexasLinks to an external site.
?-?. How does the proportion of insured vs uninsured in this sample compare to the proportion in Harris County? Do you believe it is close enough, along with the number of people surveyed, to draw firm enough conclusions on whether you should proceed to plan an intervention to ensure that the uninsured get basic preventive services (primary care, dental, and vision checkups)? Even if you conclude that it is not enough to base an expensive and time-consuming intervention on, how might this information advise your next steps?
REFERENCES (Slides ?-?)
OTHER IMPORTANT INSTRUCTIONS
1. No answer is not the same thing as answering zero (or none, or no). Sometimes people choose not to answer a given question for a variety of reasons, which we cannot know. Do not categorize them the same as someone that answers with zero, none, or no. Include those who do not answer the question as their own category (No Answer). If you do not do this, any of your charts with percentages will be incorrect.
2. Ensure that every slide has the appropriate title and the N= (the total number of participants in the sample) behind/under the title. It should look like the below, but with the correct N from your sample:
Age Distribution (N=150)
3. Ensure that you have answered every part of every question.
4. Ensure that you have cited all your resources (such as the U.S. Census Bureau, where you got your population data for Harris County) and be sure that you have formatted your references using APA style (7th Ed.).
5. Make sure that your charts are labeled (including value labels), so that it is clear what was measured and the amounts. I have provided examples at the end of these instructions. (The example charts below are NOT based on the same data, so do not think you can use them. This is only for the purpose of illustrating what your charts might look like.)
6. Make sure you have included the N (the total number of participants in the sample), or the n (the number of participants who answered the question) for each chart, or statistic.
7. Ensure that your analysis and discussion are yours. If you trust another student enough to have them help you understand how to do your assignment, that is fine. But do not duplicate their work. No two people are going to talk about the same thing in exactly the same way. If you do not understand the assignment and just try to paraphrase what your friend wrote, it will be obvious. Finally, if you are the person helping someone else and you allow someone to just copy/paraphrase what you wrote, you are as guilty of cheating as that other person. Be wise about how you help your friends.
8. When you are copy-pasting your charts into PowerPoint, be sure that you are not pasting them in as "pictures", because it will not bring the data with it and I will not be able to provide you with appropriate feedback were something to be incorrect. I TAKE OFF POINTS WHEN YOU HAVE PASTED THE CHART IN AS A PICTURE, EVEN IF THE CHART IS CORRECT!
9. Choose one of the built-in "styles" to apply to your slide set, making sure that all the content on your charts is easily readable. You may need to resize/move somethings to ensure that it is easily readable. (Stay away from styles that use stark colors, or fancy fonts. Remember that you must only use Calibri/Arial fonts. If you find a style you like, but the font is one you are not allowed to use in this course, just change the font style.)
10. Be sure to view the demonstration video and follow all the instructions provided there also! This instruction document, combined with the demonstration video is your key to scoring well on this assignment. As you should know by now, failure to follow the instructions provided to you always results in lost points on the assignment.