use  data_9


glm w c.z_wpg , family(binomial games) link(logit) vce(oim)
predict yhat

predict mw_resid,re


gen mwwins=(mw_resid*.24)
gsort -year
keep teamID yearID mwwins
duplicates drop

save "[your drive partition]\team_mwins.dta",replace







use [DF_10],clear


. drop name

. drop team

. gen gm=w+l

. bys teamID:egen gp=sum(gm)

append using DF_11
drop w l
drop if mgrID ==""
save mgr_game_file_25.dta,replace

merge m:1 yearID teamID using team_mwins.dta,nogen

duplicates drop
gen season_mwar=mwwins*(gm/gp)
drop mwwins
gsort -season_mwar


	
		
merge m:1 mgrID using [DF_12], replace update nogen	
	
	merge m:m mgrID yearID using [D_13],nogen
keep mgrID name_first  season_mwar name_last yearID teamID wp gm
order yearID name_first name_last teamID  season_mwar

drop if mgrID ==""

drop if season_mwar==.

duplicates drop
	gsort -year -season_mwar

export delimited using mwar_p.csv, replace


save mwar_p.dta, replace

_pctile season_mwar,p(1 5 10 33 50 67 90 95 99)

return list


egen rank = rank(season_)
gen percentile = 100 * (rank - 1) / (_N - 1)



list percentile if season_ <-2

gen diff = abs(season_ - 2)
summarize diff,d
list season_ percentile if diff == r(min)
list season_ percentile if diff == r(max)

use mwar_p.dta,clear





preserve
* Keep just 2024 and 2025
keep if inlist(yearID,  2024, 2025)
keep mgrID yearID season_mwar
* Ensure one obs per mgr-year
capture isid mgrID yearID
if _rc {
    collapse (mean) season_mwar, by(mgrID yearID)
    isid mgrID yearID
}

* Reshape wide: one row per mgr, one variable per year
reshape wide season_mwar, i(mgrID) j(yearID)

* Keep only managers with both years
drop if missing(season_mwar2024) | missing(season_mwar2025)

* Run Friedman (Goldstein's friedman expects wide inputs)
friedman season_mwar2024 season_mwar2025

spearman season_mwar2024 season_mwar2025
restore


kdensity season_mwar,yscale(off) lcolor(black) bw(0.6) title("") xlabel(-5/5,nogrid) ylabel(,nogrid) note("") xtitle("")


* Vector exports (pick what you need)
graph export "baby_pdf.pdf", replace       
graph export "baby_pdf.eps", replace       
graph export "baby_pdf.svg", replace       
graph export "baby_pdf.emf", replace       
