Hi,
I have a panel dataset with observations for approx 400 cities over a number of years. I would like to make a simple graph showing how the mean value of the y-variable (in my case cinema tickets purchased) has changed over the years. The problem is, as far as I have understood using the syntax "xtline", it is only possible to either choose a single city to display graphically, or all of them. What I would like to do specifically, is graph a single line which represents the overall mean value calculated from ALL of the cities combined. The "overlay" option puts all the cities onto one graph, but then I end up with 400 lines, one for each city, when what I really want is just one. Is this possible, and if so, how do I do it? It must be a very simple action but I just havn't figured it out!
Thanks in advance!
I have a panel dataset with observations for approx 400 cities over a number of years. I would like to make a simple graph showing how the mean value of the y-variable (in my case cinema tickets purchased) has changed over the years. The problem is, as far as I have understood using the syntax "xtline", it is only possible to either choose a single city to display graphically, or all of them. What I would like to do specifically, is graph a single line which represents the overall mean value calculated from ALL of the cities combined. The "overlay" option puts all the cities onto one graph, but then I end up with 400 lines, one for each city, when what I really want is just one. Is this possible, and if so, how do I do it? It must be a very simple action but I just havn't figured it out!
Thanks in advance!
Comment