*Project Title: Devins-Lewis Independent Agency Paper
*Date Started: March 6, 2017//August 10, 2021
*Current date: January 21, 2022
*Data: Agency Skills Ratings, 2014 and 2020
*Notes: Devins and Lewis Analysis of the skills ratings.

import excel "C:\Users\lewisde\Documents\Devins Independent Agency Project\skills_ratings_2020_2014.xlsx", sheet("Sheet1") firstrow

**Small independents
generate minor=0
replace minor=1 if indcom==1&irc==0

**Analysis of the difference of means: 2014
summarize skills_mean
ttest skills_mean, by(year)
ttest skills_mean if year==2014, by(indcom)
ttest skills_mean if year==2014&indcom==1, by(irc)
ttest skills_mean if year==2014&minor==0, by(irc)
ttest skills_mean if year==2014&irc==0, by(indcom)

**Analysis of difference of means: 2020
ttest skills_mean if year==2020, by(indcom)
ttest skills_mean if year==2020&indcom==1, by(irc)
ttest skills_mean if year==2020&minor==0, by(irc)

**Which agencies drop out
tab agency if drop==1
tab agency if drop==1&indcom==1
ttest skills_mean if year==2014, by(drop)
ttest skills_mean if year==2014&indcom==1, by(drop)
ttest skills_mean if year==2014&drop==1, by(indcom)