Fun with Graphs

You are viewing an old revision of this post, from September 19, 2009 @ 16:02:31. See below for differences between this version and the current revision.

Here’s a simple graph in Microsoft Excel illustrating (i) the growing unemployment in New York City, and (ii) how it contrasts with New York State overall. The tentative conclusion is that the employment situation in New York City isn’t getting better, and that it’s actually harder to get a job in the city than the rest of the state. This makes a certain degree of sense, if you assume that the financial industry cutting back on expenditures (payroll, capital, etc) means fired white-collar workers and fired blue-collar workers who were working on projects financed with money that’s no longer around. To compare, note that the unemployment rate a year ago was 5.9% in the city, so we’re now 4.4% above that.

The green line is a simple linear regression line, courtesy of Excel. It’s not, of course, authoritative – but hey, that is a pretty high r squared value!

Needless to say, we would expect unemployment to top out at some point as businesses reach the end of what they can cut, and wages are driven down. Still, a U3 unemployment rate this high isn’t a happy situation. To compare, the nationwide U6 rate is 16.8% – probably a bit higher in New York City these days.

Note: this is in no way a complete or even useful picture of the unemployment situation. It’s just a cute graph. We’d need to delve into quite a bit more to get an idea of the true unemployment situation.

Post Revisions:

Changes:

September 19, 2009 @ 16:02:31Current Revision
Content
<p>Here's a simple graph in Microsoft Excel illustrating (i) the growing unemployment in New York City, and (ii) how it contrasts with New York State overall. The tentative conclusion is that the employment situation in New York City isn't getting better, and that it's actually harder to get a job in the city than the rest of the state. This makes a certain degree of sense, if you assume that the financial industry cutting back on expenditures (payroll, capital, etc) means fired white-collar workers and fired blue-collar workers who <em>were</em> working on projects financed with money that's no longer around. To compare, note that the unemployment rate a year ago was 5.9% in the city, so we're now 4.4% above that. <p>Here's a simple graph in Microsoft Excel illustrating (i) the growing unemployment in New York City, and (ii) how it contrasts with New York State overall. The tentative conclusion is that the employment situation in New York City isn't getting better, and that it's actually harder to get a job in the city than the rest of the state. This makes a certain degree of sense, if you assume that the financial industry cutting back on expenditures (payroll, capital, etc) means fired white-collar workers and fired blue-collar workers who <em>were</em> working on projects financed with money that's no longer around. To compare, note that the unemployment rate a year ago was 5.9% in the city, so we're now 4.4% above that.
</p><p>The green line is a simple linear regression line, courtesy of Excel. It's not, of course, authoritative – but hey, that <em>is</em> a pretty high r squared value!  </p><p>The green line is a simple linear regression line, courtesy of Excel. It's not, of course, authoritative – but hey, that <em>is</em> a pretty high r squared value!
</p><p>Needless to say, we would expect unemployment to top out at some point as businesses reach the end of what they can cut, and wages are driven down. Still, a U3 unemployment rate this high isn't a happy situation. To compare, the nationwide U6 rate is 16.8% - probably a bit higher in New York City these days. </p><p>Needless to say, we would expect unemployment to top out at some point as businesses reach the end of what they can cut, and wages are driven down. Still, a U3 unemployment rate this high isn't a happy situation. To compare, the nationwide U6 rate is 16.8% - probably a bit higher in New York City these days.
</p><p><img src="Book1" alt=""/>  </p><p><img src="http://www.inscitia.com/ wp-content/uploads/091909_ 2102_FunwithGrap11.png" alt=""/>
</p><p>Note: this is <em>in no way</em> a complete or even useful picture of the unemployment situation. <strong>It's just a cute graph</strong>. We'd need to delve into quite a bit more to get an idea of the true unemployment situation. </p>  </p><p>Note: this is <em>in no way</em> a complete or even useful picture of the unemployment situation. <strong>It's just a cute graph</strong>. We'd need to delve into quite a bit more to get an idea of the true unemployment situation. </p>

Note: Spaces may be added to comparison text to allow better line wrapping.

  • Hello from Russia!
    Can I quote a post in your blog with the link to you?

  • Hello from Russia!
    Can I quote a post in your blog with the link to you?