1. Choose a health topic, disease, or trend that you want to find more information about. Note that this data and topic will be used throughout the semester for other assignments 2. Use one o

1. Choose a health topic, disease, or trend that you want to find more information about. Note that this data and topic will be used throughout the semester for other assignments 2. Use one o
Data Discovery & Collection Assignment Due 09/26/2021 100 Points In chapter 1, we discussed the different types of secondary data available for download. This assignment is part 1 of a series of assignments you will build on throughout the semester. The purpose is for you to find a secondary data set, create variables, and enter the data in excel. Upon completion of this assignment, you should be able to find and download free, public, secondary data sets from readily available government agencies, as well as successfully create an excel file, which includes a data dictionary. Instructions Choose a health topic, disease, or trend that you want to find more information about. Note that this data and topic will be used throughout the semester for other assignments Use one of the websites covered in chapter 1 to find your data or any website you would like. Data is everywhere so if you find it, use it. CDC FDA/USDA Census Baltimore City Health Department Maryland Department of Health Any website you find interesting Enter your data in excel You need a minimum of sample of 50 to complete this assignment Example: if you choose cancer, you will need at least 50 cases of cancer Create a data dictionary on the second sheet of your excel file A data dictionary defines the variables in your data set You must include these variables in your data set. Feel free to add any other variables you want to add to your data set. This information may be useful to you Gender Female Male other Ethnicity Age Employment Education State County For each variable, have the following Number (count) Percent Rate (if applicable)
1. Choose a health topic, disease, or trend that you want to find more information about. Note that this data and topic will be used throughout the semester for other assignments 2. Use one o
Assignment-Data Mining and Analysis Use the data you downloaded and organized in part 1 to complete the following analyses in Microsoft Excel. You have been provided with instructional videos and tutorials by the professor to complete this assignment. Your rubric is attached. For this assignment, you are only conducting data analysis. You will interpret the results in the next assignment. Directions: Use 1 Excel file to complete all analyses. Complete each analysis on a different sheet. Note: Excel files have different sheets at the bottom of the page. Rename each sheet by the title of the analysis you are completing (example-change sheet 1 to Independent T Test) Conduct the following statistical analyses in Excel Independent T-Test T-test Pearson’s Correlation Test ANOVA Chi Square Test Assignment-Data Mining and Analysis Rubric Organization & Formatting Information is very well organized by using appropriate variables and labels, as well as the appropriate advanced formatting, including shading, alignment tools, borders, special fonts, and appropriate column/row height & width Information is mostly organized by using appropriate variables and labels and the appropriate formatting Some Information is organized, using standard formatting tools. Some labels or other important formatting tools are missing. 25 Computations & Formulas All data required is entered correctly. 100% use of correct applicable formulas as required. Most data required is entered with correctly. 100% use of correct applicable formulas as required. Several errors. Some required data may be missing. Incorrect use of applicable formulas as required 35 Directions Followed all directions accurately and fully completed the assignment Followed most of the directions accurately and fully completed assignment Did not follow any of the directions or, Followed some directions but missed many of the details required 20 Data Entry Successfully entered all data correctly Entered almost all data correctly with minor to no corrections needed Data entered but major corrections needed Several errors noted Data missing 20
1. Choose a health topic, disease, or trend that you want to find more information about. Note that this data and topic will be used throughout the semester for other assignments 2. Use one o
Final Report-Data Analysis and Conclusion Due 12/08/2021 by 11:59 pm Now that you have collected and organized your data in excel, it is time to analyze the data and draw conclusions from it. After you analyze the results in excel, you are to create a report to present your data. In the report, be sure to use the formats of charts, graphs, and other visual representation you learned in assignment 4. Below are the guidelines for this assignment. Part 1 does not need to be a formal essay or paragraph. You can start by stating the research question and then the analysis results of that research question by using a bulleted format. See my example below. These are just examples, so the information presented in the examples are not accurate. You should present your actual information. I am only providing an example of the format to use to present part 1. Also keep in mind that you will have two research questions, so that means you have two sections to present Example for Part 1: Research Question 1: Is there a difference between drug addiction and alcoholism? Sample Size Drug Addiction: N = 1234 Alcoholism: N = 3323 Data Analysis Pearson’s Correlation (r) is a test statistic that evaluates the statistical relationship, or association, between two continuous variables. There are different degrees of correlation. The correlation coefficient ranges between -1 and +1. Results Analysis 1: Independent T-Test t(51) = 2.1 p < .04 Drug group Mean = 480 Standard Deviation = 34.5 Alcohol group Mean = 425 Standard Deviation = 31 The sample size of 25 in the drug addiction group (M = 480, SD = 34.5) compared to the sample size of 28 in the alcohol group (M = 425, SD = 31) demonstrated significantly higher scores, t(51) = 2.1, p = .04. Instructions for Assignment Part 1. Data Analysis and Results What type of analysis did you do in excel? (Data Analysis) Provide a brief description of the types of analysis you conducted. Example: This is a small example below, but you would need to provide a bit more information. Please do not copy and paste directly from the internet. Pearson’s Correlation (r) is a test statistic that evaluates the statistical relationship, or association, between two continuous variables. There are different degrees of correlation. The correlation coefficient ranges between -1 and +1. What is your sample size (N)? (Sample Size) If you are comparing or looking for a relationship between two groups, list the sample size for each group You will need to add every case/number in each category Example: HIV: N = 11,133 Hepatitis C: N = 13, 333 What are the results of your study? (Results) Present these results just as they are represented in the final analysis Example: Independent T-Test t(51) = 2.1 p < .04 Drug group Mean = 480 Standard Deviation = 34.5 Alcohol group Mean = 425 Standard Deviation = 31 The sample size of 25 in the drug addiction group (M = 480, SD = 34.5) compared to the sample size of 28 in the alcohol group (M = 425, SD = 31) demonstrated significantly higher scores, t(51) = 2.1, p = .04. Note: t(degrees of freedom) = the t statistic, p = p value Part 2. Conclusions What do your results mean? This is where you draw conclusion about your results. Tell me the significance of this results and how they align with your study and interests in this topic. Interpret the results and make inferences and assumptions about them. Part 3: Visual Presentation Present some of your data from excel into visual interpretations using graphs and charts. Remember the work you did with the cancer registry data and let that be an example for you also. You can use a combination of the following: Pie graph Column graph Pie chart Bar graph Line graph Criteria Very Good-Good Satisfactory Unsatisfactory Points Data Visualization 1) Data visualization formats used appropriately represents the data 2) Data presented is easy to understand 3) Legends and other information provide readability and clarity 1) Data visualizations showcase the data but not as easy to understand all data points represented 1)Other data visualization formats should have been presented 2)Data not adequately represented 15 Report 1) Student provided a concise written report 2) Reader can understand and interpret the data 3) Presentation was clear and concise with no errors 1) Student provided a written report 2) Reader can understand the speaker 3) Report had had minor errors 1) No Report Submitted 2)Student only submitted data elements 20 Infographics 1) Infographics chosen clearly supports the content and topic used for assignment 2)Objects, charts, graphs, etc. used support various types of data and make it readable 1) Infographics chosen represents content, but another form of the content would have better represented the data 2)Not enough objects and elements used 1) Infographics do not adequately represent the data or content of the project 10 Organization 1) Writing structure was clear and concise. 2) Information flowed into logical sequence. 3) Readers can follow along. 1) Readers can follow along in a logical sequence. 1) No supporting sources/references provided. 10 Computations & Formulas All data required is entered correctly. 100% use of correct applicable formulas as required. Most data required is entered with correctly. 100% use of correct applicable formulas as required. Several errors. Some required data may be missing. Incorrect use of applicable formulas as required 30 Conclusions & Assumptions Made relevant and correct conclusions and assumptions Partially correct, relevant explanation but poorly/clearly presented A relevant explanation is provided but is illogical, incorrect, and incoherent No explanation is provided 15 1. Choose a health topic, disease, or trend that you want to find more information about. Note that this data and topic will be used throughout the semester for other assignments 2. Use one o Professor email feedback: “This data is not sufficient. Therefore, your analyses and reports are not correct either.   I have videos and screenshots of what your downloaded data should look like.  As I told you, you should have numbers/cases. See my example Say you are getting data on HIV, you would need the data by states or counties, whichever you prefer. County is always better. These numbers are just examples but hopefully, you get the picture. County                     HIV           BLACK         WHITE Baltimore                 4,326         2,025          2301 Baltimore City         2,011          1,200           811 Anne Arundel          1,258   Please find some better data and do your analyses. You should also read the instructions for this assignment because it is clear that you have not read it well. I have instructions on the variable that are needed in your data set. “ Instructions: Secondary Data Sources & Collection Assignment (part 1)   Hi All, I do my best to show you all how to download and search for data. Please view them as they may be helpful to you. In the videos I use several websites that are good for getting data. They are below. Amfar  https://opioid.amfar.org/MD COUNTY HEALTH RANKINGS https://www.countyhealthrankings.org/app/maryland/2017/rankings/allegany/county/outcomes/overall/snapshot CENSUS DATA https://data.census.gov/cedsci/table?q=All%20counties%20in%20Maryland&tid=ACSDP1Y2019.DP05&hidePreview=false DATA USA How to run Indpendent t test How to run Pearson's R How to Download and Find Date Finding CDC Data Instructions: Data Mining and Analysis (part 2)   Chi Square Test Pearson's R (Correlation) Instructions: Final Report (part 3)   No links