Hi, I'm very new on STATA programming so I hope you can give me step by step solution using the STATA and don't forget to answer each part of the question. Here it is:
Download this database: https://drive.google.com/file/d/0B4QOkWN0EAr_THJjNDZZZVpQeUE/view?usp=sharing
or if it doesn't work: https://drive.google.com/file/d/0B4QOkWN0EAr_d2tjYnN3aTdlZmM/view?usp=sharing
This database contains information about "notable people" throughout history. Load this Excel file into Stata or you can use Excel to convert it to a csv text file and use import delimited.
a) Consider all people born between 1700 and 1900 who have an observed (non-missing) year of death. Calculate the decade of each person's birth and their lifespan in years. Then use Stata to create a clean table containing only the mean lifespan within each cell of a cross tabulation between decade of birth and gender. What do you observe about the relationship between the lifespans of notable women and notable men in the 18th and 19th centuries?
b) Use the Haversine formula (https://en.wikipedia.org/wiki/Haversine_formula) to calculate the distance between each person's birth and death location. Then create a table formatted as in part (a) showing the mean distance by decade of birth and gender (you can restrict to the same subset of people). How has this mean distance changed over time?
c) Calculate the centroid of birth locations for people born in each decade from 1700 to the present. To do this, take each birth location and view it as a point in R^3 (i.e. embedding the sphere in 3-space). Then calculate the usual geometric centroid of these points. Finally, scale this centroid point back to the surface of the sphere (note that this will be undefined if the centroid is exactly at the center of the sphere). The final result should be expressed in latitude/longitude coordinates. Describe how this centroid has varied over the decades from 1700 to the present.
Rule:
*All work should be done with STATA (others are not accepted). You should submit your Stata code as text format files with the parts clearly marked using comments. Also, submit a single PDF file containing your answers to all the questions that are posed.