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

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)
1. Provide a brief description of the types of analysis you conducted.
2. 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.
  1. 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)
1. If you are comparing or looking for a relationship between two groups, list the sample size for each group
2. You will need to add every case/number in each category
3. Example:
  1. HIV: N = 11,133
  2. Hepatitis C: N = 13, 333

What are the results of your study? (Results)
1. Present these results just as they are represented in the final analysis
2. Example:
  1. Independent T-Test
    1. t(51) = 2.1 p < .04
    2. Drug group Mean = 480 Standard Deviation = 34.5
    3. Alcohol group Mean = 425 Standard Deviation = 31
    4. 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.
    5. Note: t(degrees of freedom) = the t statistic, p = p value

Part 2. Conclusions

What do your results mean?
1. 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:

1. Pie graph
2. Column graph
3. Pie chart
4. Bar graph
5. 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