Question 1: Analysis of firearms data [code 25 marks; results 25 marks]
Your boss provided you three datasets. The gunData-deathsMale.xlsx and gunData-deathsFemale.xlsx contain data on the annual number of deaths due to suicide in Australia from 1978 to 2015 for male and female, respectively. The gunData-pop.csv file contains the population data from 1978 to 2015 by sex. Note that two of these files are Excel and one is a comma separated value file, so they will need different importation methods. Your boss is quite annoying, isn’t he!
The variables are listed below.
• Year: the year, from 1978 – 2015
• Sex: labeled as “Male” and “Female”
• gunRelated: 0 for non firearm-related, 1 for firearm-related
• deaths: number of deaths in the given year, firearm, sex category
• pop: population of men or women in Australia at the nearest census
Our goal in this question is 1) Data processing and manipulation; 2) plot deaths by suicide type and sex; 3) examine the relative risk of firearm-related suicide over time in this data set; and 4) identify a turning point in mortality risk in men.
1. Create a final dataset gunData.csv that contains data on the annual number of deaths due to suicide by sex in Australia, from 1978 to 2015, along with the population. This data set should contain two observations for each sex each year, one for firearm-related suicide deaths and one for non firearm-related suicide deaths. So there are four observations for each year. You need this in stata format so you can analyze it, and in csv format to send back to your annoying boss.
TIPS: You can use the append command to do this task
First, import gunData-deathsMale.xlsx or gunData-deathsFemale.xlsx
Then, append the male data to the female (or vice versa) to create a single death set. (remember that you will need the same variable names of 2 datasets to use append command, and you will need to create a new variable of sex before appending)
Then, import the population data and make sure all variable names are correct.
Then, merge the death data and population data and export to a new dataset called gunData.csv. When you do this make sure the first row of the csv file contains variable names. You need to upload this file along with your solutions.
When you perform this step you should generate several Stata files, one of which will be a final data file of deaths and population. You will use this file in the following steps.
2. Now use the final mortality and population file to generate a variable for the mortality rate per 100,000 population. The mortality rate is the number of deaths divided by the population at risk
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
