Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can I overlay frequency bar and proportion line graph ?

    Click image for larger version

Name:	image_15221.png
Views:	1
Size:	48.4 KB
ID:	1508772


    Hi. Always thanks to statalist.

    I have binary variable ; outcome (1: positive, 0: negative) and categorical variable grBMI

    First I draw frequency graph & proportion graph seperately.

    drop if outcome==0
    histogram grBMI, frequency discrete xsize(7) ysize(4) scale(1.4) ylabel(0 (100) 600,labsize(small)) xlabel(15 18.5 23 25 30 40 50, labsize(small)) color(navy) fintensity(inten40) lcolor(gr1) lwidth(vvthin) ytitle("Frequency of Outcome(n)") b1title("BMI")

    use "C:\Users\heebyung\data.dta", clear
    egen mean=mean(outcome),by(grBMI)
    gen mean100=100*mean
    twoway bar mean100 grBMI if grBMI <55, color(navy)fintensity(inten40) lcolor(gr1) lwidth(vvthin) xsize(7) ysize(4) scale(1.4) xlabel(15 18.5 23 25 30 40 50) xtitle("BMI") ytitle("Prevalence of outcome(%)")



    I want to make overlaying graph which include frequency(bar) and proportion(connected line) of outcome over grBMI

    Like below.

    I wish please someine help me...

    Thank you.
    Click image for larger version

Name:	dddd.png
Views:	1
Size:	927.8 KB
ID:	1508770

    Last edited by Heebyung Koh; 21 Jul 2019, 20:14.

  • #2
    Please consider providing a data example in the future.

    Code:
    webuse sp500, clear
    gen groups= floor(volume/1000)*100
    egen gr= group(groups)
    qui sum gr
    local max= r(max)
    bys gr: egen count= count(volume)
    preserve
    collapse volume count, by(gr)
    twoway (bar volume gr, xlabel(1(1)`max', angle(0)) ///
    yvarlab("")barw(0.7) yscale(axis(1) range(0)) bcolor(none)) ///
    (scatter count gr, connect(line) xaxis(1) yaxis(2) ylab(, axis(2)) ///
    scheme(s1color) leg(off) xtitle("Group") ytitle("Volume") ///
    ytitle("Frequency", axis(2)))
    Click image for larger version

Name:	Graph.png
Views:	1
Size:	86.0 KB
ID:	1508789

    Comment


    • #3
      To andrew.

      I receive your answer twice, Thank you very much.

      In your graph frequency was expressed as connected line and proportion was expressed as bar.

      So I made mean(volume) variable by gr for scatter graph and used count in bar graph.

      Then solved problem ^-^ I spend about 4~5 days for this graph..... Thank you with all sincerity.

      And next time I'll provide example data.

      Thank you.

      Comment

      Working...
      X