The obvious way to generate these frequency distributions is to use Excel’s FREQUENCY function, which has this syntax:
The distributions would compare the number of instances for nearly any criteria you can count: orders by product by month for two sales people, failure rates by month for two products, the number of sick days taken by age by gender in the past year, and so on. You could apply the logic of this chart to calculate frequency distributions for your own data. That is, over the past 30 years, Texas has tended to maintain a lower unemployment rate than California. The chart shows that the unemployment rates in Texas are clumped in the upper part of the chart. The source data consists of 361 unemployment rates for each state, extending from December, 1982, through December, 2012. Then I summarize the data and created this chart, technically a histogram, which I originally had set up as swipe file. So I downloaded data from the Federal Reserve Bank of St. Because the Texas and California governors have been bickering over the Texan’s attempt to poach California employers, I got curious about the distribution of the unemployment rates in the two states.
0 kommentar(er)
