Reference no: EM132325141 , Length: 4
Assignment
You created a survey when you get the data back from the survey you are required to enter the data into the Excel database. With this data set, complete the following:
Complete the "blank shell" excel sheet with the survey data completed from the 30 participants.
Complete a data dictionary based on your survey question and response options.
The data for your short survey should be entered into the Excel database that you created. With this data set, complete the following:
Calculate descriptive statistics for your main independent and other variables you have collected information on (example: demographic variables).
Create a bar chart for the participants' gender and ethnicity.
Create a histogram for participants' age.
Calculate descriptive statistics for your dependent variable.
Create a summary table of your descriptive statistics.
Hint: For categorical variables, you should be calculating frequencies and percentages; for continuous variables, you should be calculating means and standard deviations.
Use one hypothesis-testing statistic that examines the relationship between your independent variable and dependent variable.
Hint: This test should be one of the following-independent samples t-test, paired t-test, one-way ANOVA, or Pearson's chi-squared test.
Write the null and alternate hypotheses.
What is the calculated statistic value?
What is the p and critical statistic value?
Is the p value significant? Is calculated statistic value greater than critical value?
What is your conclusion?
For your signature assignment, you will take these results and put them into a written report, similar to what you would write in your research methods course. However, this paper will focus on the results and discussion of your findings. For this paper, include the following:
State the hypothesis you tested. This includes the research question and the null and alternative hypotheses.
Describe the variables you used.
Discuss the survey you used to collect your data. Did you run into any issues? Did you have to change anything? Include that survey as an appendix.
Detail your results. What statistical test did you use? Why? What did you find? Did you calculate the results correctly?
Include at least one table or figure we discussed in class for your statistics.
What do your results mean? This is the discussion portion of your paper.
Finally, was your null hypothesis rejected, or did you fail to reject it? What are the implications of your findings? Include sources that support your implications. This is your general conclusion on your findings.
Your paper should be between four and six pages in length (not including the cover page, references, and appendix).
Use APA (6th ed.) format to style your paper and to cite your sources. Your sources should be integrated into the paragraphs. Use internal citations pointing to evidence in the literature and supporting your ideas. You will need to include a reference page listing those sources.
Need excel spreadsheet and a separate paper (of 4 pages).
Attachment:- data on firearms and suicide.rar