Month: September 2017

Thursday Data Dump: Foreclosures in Minneapolis in 2016

As today’s data will illustrate, foreclosures are not distributed throughout the city equally. So here are a couple of things to keep in mind while sifting through this data table.

First, 37 percent of the foreclosures in Minneapolis resided on the north side of the city in 2016 – 22.4 percent of the foreclosures were in the 4th Ward and 14.6 percent of the foreclosures were in the 5th Ward.

Second, these were the only two wards with a foreclosure percentage greater than 10 percent. Of course, these two wards have been like this for sometime.

I wrote about this very subject a few times back in 2015. As I explained back then in A Comparison of Minneapolis’ Foreclosure Rates by Ward and Foreclosure Rates: Wards 4, 5, and 10 from 2006 to 2015, the 4th and 5th Wards accounted for about 40 percent of the foreclosures in the city. And as this current data illustrates, these two wards still account for about the same percentage.

Minneapolis: 2016 Foreclosure Data

Ward 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total Percent
1 3 7 8 5 23 6.71
2 6 3 4 1 14 4.08
3 2 4 4 8 18 5.25
4 26 16 19 16 77 22.4
5 19 17 7 7 50 14.6
6 3 5 1 1 10 2.92
7 2 4 4 3 13 3.79
8 9 7 8 5 29 8.45
9 13 5 7 3 28 8.16
10 3 1 4 2 10 2.92
11 6 8 4 3 21 6.12
12 5 7 9 12 33 9.62
13 4 6 4 3 17 4.96
Total 101 90 83 69 343 100.0

(Source: City of Minneapolis)

So as far as proportionality is concerned, not much has changed.

The bright side is that foreclosures have definitely decreased in both wards. However, the question is what will happen to these wards when the market decides to take another nose dive?

The 4th and 5th Wards are not as economically stable as other parts of the city. But the point here is that education, as we’ve seen, provides greater earnings power, and thus greater economic stability and security. Of course as the readers of this blog know very well, earnings increases with education according to the data that has been observed so far.

So it should follow that more education will facilitate greater earnings which will in turn facilitate greater economic stability and security which in turn will decrease foreclosures.

Going forward, what does the foreclosure data look like for 2017 and how does it compare to 2016? And what does the system’s behavior of this foreclosure data look like over the period of a few years? Are foreclosures decreasing throughout Minneapolis and are there any wards  that are bucking this trend? And the big question, will this even have an impact on the mayoral and city council races?

 

Matt has a Bachelor of Science in Systems Science, with focuses in applied mathematics and economic systems, from Iowa State University. He is also a professional member of the Society of Industrial and Applied Mathematics and the International Society for the Systems Sciences and a scholarly member of Omicron Delta Epsilon, which is an International Honors Society for Economics. 

You can connect with him directly in the comments section, and follow him on Facebook

You can also follow The Systems Scientist on Twitter or Facebook.

 

Photo Credit: Wikimedia Commons

 

 

 

 

 

 

Copyright ©2017 – The Systems Scientist

Wednesday Data Dump: The Most crime ridden neighborhood in Minneapolis in 2017

There are a couple of things to consider while sifting through today’s data. First, crime increases as the year progresses. This is a pretty common pattern in cities in the midwest, where temperatures change as the seasons change and there can be a 120 degree temperature difference between the middle of summer and the middle of winter. Second, larceny is the most abundant crime in the Downtown West neighborhood at 73 percent. Robbery is second at 11.2 percent.

Table 1: Crime in the Downtown West Neighborhood

Month Homicide Rape Robbery Aggravated Assault Burglary Larceny Auto Theft Arson Total
Jan 1 5 19 9 8 139 6 0 187
Feb 0 2 19 13 8 137 9 0 188
Mar 0 6 14 7 6 158 6 0 197
Apr 0 0 13 20 12 145 10 0 200
May 0 4 35 17 4 133 3 0 196
June 0 7 33 9 13 155 7 0 224
July 1 4 30 18 8 195 6 0 262
Total 2 28 163 93 59 1062 47 0 1454
(Crime/Total) x 100% 0.14 1.93 11.2 6.40 4.06 73.0 3.23 0 100

(Source: City of Minneapolis)

And finally, there have been 1,454 reported crimes in the Downtown West neighborhood through July 31st according to the data in Table 1. Minneapolis as a whole has experienced 13,511 reported crimes through July 31st. With a simple computation, Downtown West has experienced approximately 11 percent of the reported crimes in the City of Lakes.

Comparing Downtown west to the other 6 neighborhoods in Table 2, a simple computation will show that Downtown West contained about 38 percent of the reported crimes in the Top 7 neighborhoods. So two questions reveal themselves immediately. First, is it normal for Downtown West to contain 11 percent of the crimes in Minneapolis? What would the historical data say? And second, is it normal for Downtown West to contain 38 percent of the reported crimes in the Top 7 neighborhoods? Again, what would the historical data say?

Table 2: Crime in the Top 7 Neighborhoods 

Neighborhood Homicide Rape Robbery Aggravated Assault Burglary Larceny Auto Theft Arson Total
Downtown West 1 4 30 18 8 195 6 0 262
Whittier 0 1 6 5 12 59 5 0 88
Loring Park 0 2 7 3 2 55 3 0 72
Longfellow 0 1 6 2 12 46 3 0 70
Lowry Hills East 0 3 3 6 11 43 3 0 69
Marcy Holmes 0 1 5 2 6 40 12 0 66
Jordan 0 0 8 17 10 22 5 1 63
Total 1 12 65 53 61 460 37 1 690
(Crime/Total) x 100% 0.14 1.74 9.42 7.68 8.84 66.7 5.36 0.14 100

(Source: City of Minneapolis)

Downtown West was the most crime ridden neighborhood in Minneapolis. And it has been this way for sometime. This is nothing new. Although Graph 1 doesn’t provide contrasting, dynamical data with any of the other neighborhoods in Minneapolis, it does provide a few details concerning this system behavior nonetheless. For example, it appears as though there have been more reported crimes between 2014 and today than there were between 2010 and 2013.

This is indeed the case. Between 2010 and 2013, there were a total of  9,293 reported crimes in the Downtown West neighborhood; and between 2014 and today, there have been a total of 9,598 in the Downtown neighborhood (a 3.3 percent increase for those keeping track), and there are still 5 months of crime data left to report. This fact illustrates that crime has not only increased from last year, but it has been increasing for a longer period time. And so what will this mean for the Minneapolis mayoral race and city council races?

A couple of tidbits to ponder until the next data dump. Downtown West resides in Ward 3 and Ward 7. Ward 3 is represented by Jacob Frey. Council Member Frey is currently running for Mayor of Minneapolis. Second, Ward 7 is represented by Lisa Goodman, who is also up for re-election. Apparently, Lisa Goodman likes to put her already chewed gum in another person’s hand, i.e., Teqen Zéa-Aida, who is also running for the Ward 7 city council seat. Weird. Perhaps focusing on crime would be better time spent?

 

Matt Johnson is a blogger/writer for The Systems Scientist and the Urban Dynamics blog. He has also contributed to the Iowa State Daily and Our Black News.

Matt has a Bachelor of Science in Systems Science, with focuses in applied mathematics and economic systems, from Iowa State University. He is also a professional member of the Society of Industrial and Applied Mathematics and the International Society for the Systems Sciences and a scholarly member of Omicron Delta Epsilon, which is an International Honors Society for Economics. 

You can connect with him directly in the comments section, and follow him on Facebook

You can also follow The Systems Scientist on Twitter or Facebook.

 

Photo Credit: The Systems Scientist

 

 

 

 

 

 

Copyright ©2017 – The Systems Scientist

Data Dump Saturday: United States Earnings by Education and Sex, 2015

In today’s data dump, there are three observations to keep in mind while sifting through the data. First, Graph 1 through Graph 4 illustrate that as education increases, earnings increase. This is the case for both men and women. Mathematically these observations are confirmed by a positive slope.

Graph 1

Second, there is an obvious earnings discrepancy between men and women at each level of the education ladder. As an example, the earnings of “Some College or associate’s degree” for men, $41,407, is slightly lower than the earnings of a “Bachelor’s degree” for women, $41,763. This is a fascinating statistic.

It should be noted that the purpose of this data dump is to provide information; the purpose of this data dump is not to take a side on earnings differences between men and women, nor is it to examine why it is so.

With that said, it should be noted that these discrepancies will change, increase or decrease, at different levels of the Super-system, which is the United States. For example, earnings differences between men and women will vary at the regional, the state level, the county, level, the city level, the zip code level, and so and so forth. And these earnings differences will change depending on geography, education (obviously), and industry and type of job, just to name a few parameters.

Lastly, Graph 2, Graph 3, and Graph 4 are simply partitions of Graph 1. That is, the three following graphs have been created to help the reader parse out the data a bit more clearly, i.e., make the data less busy. And it provides the reader with the opportunity to see the earnings behavior of the United States from different perspectives, while also providing the capability of comparing data in Graph 1.

Here’s Saturday’s data dump on 2015 earnings by education and sex in the United States.

Total Earnings by Education and Sex

 

Graph 2

Male Earnings by Education and Sex

 

Graph 3

Female Earnings by Education and Sex

 

Graph 4

 

Matt Johnson is a blogger/writer for The Systems Scientist and the Urban Dynamics blog. He has also contributed to the Iowa State Daily and Our Black News.

Matt has a Bachelor of Science in Systems Science, with focuses in applied mathematics and economic systems, from Iowa State University. He is also a professional member of the Society of Industrial and Applied Mathematics and the International Society for the Systems Sciences and a scholarly member of Omicron Delta Epsilon, which is an International Honors Society for Economics. 

You can connect with him directly in the comments section, and follow him on Facebook

You can also follow The Systems Scientist on Twitter or Facebook.

 

Photo Credit: Flickr

 

 

 

 

 

 

Copyright ©2017 – The Systems Scientist

Minneapolis crime pattern since 2013

With the Minneapolis mayoral and city council elections only a few weeks away, crime is still a top issue. How will the mayoral candidates fair and will crime continue to remain a top issue?

Graph 1

As Graph 1 illustrates, crime is seasonal as it goes through its peaks during the summer months and valleys during the winter months. What is also interesting about this graphical representation, besides the fact that it’s dynamical, is that it shows how crime decreased each year from 2013 through 2015.

You can check for yourself by aligning a ruler with the peak crime months of 2013, 2014, and 2015. As you’ll notice, the ruler is tipping downward, i.e., a downward (negative) slop.

But 2016 illustrates an increase when compared to the previous months and years; and it appears 2017 will maintain that trend of increasing crime.

Thus, you can perform the same exercise with the ruler with the peak months of 2015, 2016, and 2017. You’ll notice an increasing slope with this set of months, i.e., increasing crime rates.

Of course, the increasing slope of crime doesn’t appear to be as pronounced as the decreasing slop of crime, but the decrease and increase are obvious nonetheless. Something to think about with city elections on the horizon.

 

Matt Johnson is a blogger/writer for The Systems Scientist and the Urban Dynamics blog. He has also contributed to the Iowa State Daily and Our Black News.

Matt has a Bachelor of Science in Systems Science, with focuses in applied mathematics and economic systems, from Iowa State University. He is also a professional member of the Society of Industrial and Applied Mathematics and the International Society for the Systems Sciences and a scholarly member of Omicron Delta Epsilon, which is an International Honors Society for Economics. 

You can connect with him directly in the comments section, and follow him on Facebook

You can also follow The Systems Scientist on Twitter or Facebook.

 

Photo Credit: Wikimedia Commons

 

 

 

 

 

 

Copyright ©2017 – The Systems Scientist

 

Minneapolis: July’s Top 7 Neighborhoods for Crime in 2017

There are few things to consider when sifting through this data set. First, the highest number of reported crimes in Minneapolis are not in the Jordan neighborhood in North Minneapolis, or any  other neighborhood in North Minneapolis for that matter. To the contrary, Downtown West has the highest number of reported crimes. In fact, it has had the highest number of reported crimes in each month this year, and it generally does year after year.

Second, 6 of the 7 neighborhoods in the top 7 are not in North Minneapolis. Of course, this doesn’t mean there aren’t other North Minneapolis neighborhoods that don’t experience a relatively high number of crimes. As a group of neighborhoods, the north side definitely illustrates a concentration of reported crimes. This will be illustrated in a future blog.

Crime: Top 7 Neighborhoods 

Neighborhood Homicide Rape Robbery Aggravated Assault Burglary Larceny Auto Theft Arson Total
Downtown West 1 4 30 18 8 195 6 0 262
Whittier 0 1 6 5 12 59 5 0 88
Loring Park 0 2 7 3 2 55 3 0 72
Longfellow 0 1 6 2 12 46 3 0 70
Lowry Hills East 0 3 3 6 11 43 3 0 69
Marcy Holmes 0 1 5 2 6 40 12 0 66
Jordan 0 0 8 17 10 22 5 1 63
Total 1 12 65 53 61 460 37 1 690
(Crime/Total) x 100% 0.14 1.74 9.42 7.68 8.84 66.7 5.36 0.14 100

(Source: City of Minneapolis)

And lastly, 66.7 percent of the of the reported crimes of the top 7 neighborhoods are Larceny. Matter of fact, Larceny is between 65 and 75 percent of the reported crime each month in Minneapolis. Of course this statistic varies from neighborhood to neighborhood, but it’s a fairly consistent statistic for Minneapolis.

 

Matt Johnson is a blogger/writer for The Systems Scientist and the Urban Dynamics blog. He has also contributed to the Iowa State Daily and Our Black News.

Matt has a Bachelor of Science in Systems Science, with focuses in applied mathematics and economic systems, from Iowa State University. He is also a professional member of the Society of Industrial and Applied Mathematics and the International Society for the Systems Sciences and a scholarly member of Omicron Delta Epsilon, which is an International Honors Society for Economics. 

You can connect with him directly in the comments section, and follow him on Facebook

You can also follow The Systems Scientist on Twitter or Facebook.

 

Photo Credit: Tony Webster, Flickr

 

 

 

 

 

 

Copyright ©2017 – The Systems Scientist

Educational Attainment Data: Comparing Minnesota and the United States

We can use U.S. Census Bureau data to compare the educational attainment of the United States to any of the 50 states; we can use U.S Census Bureau data to compare the educational attainment of the United States to any city contained within the United States (provided data exists);  and we can use U.S. Census Bureau data to compare the educational attainment to compare states to each other, counties to each other, cities to each other, or any combination our hearts desire.

For this blog, we will compare the educational attainment of Minnesota, and the United States. In future blogs, we will compare other city, state, and country combinations. We will also compare city, state, and county; and we will even compare zip codes to one another. Which ones will explore? We will answer this question in due time.  Let’s begin.

United States

The United States is the Super-system. This means all 50 states and their respective counties, cities, town, zip codes, etc. are contained within the borders of the United States. Readers of this blog are familiar with this idea (for a more in-depth exploration of systems and sub-systems click here). This also means the United States meets the (3) systems’ axioms:

  1. A system consists of a set of elements.
  2. Elements in a system interact.
  3. A system has a function, or purpose.

We will take this axioms to be a given for this blog. Instead we will focus on the data. As we can see, the United States is second in every category except graduate and professional.

 

As the data illustrates, the United States has a lower median annual earnings (MAE) than that of Minnesota. This is good news for many residents of Minnesota who exceed the median annual earnings at each level of the ladder.

Minnesota

As readers of this blog will know, Minnesota is a sub-system of the United States. This means Minnesota meets the  (3) systems’ axioms:

  1. A system consists of a set of elements.
  2. Elements in a system interact.
  3. A system has a function, or purpose.

Again, and for our purposes here, this will be given knowledge to us realize we are dealing with different systems and should treat each data set as its own entity. However, we will observe that the three data sets in this blog have similar behaviors. That is, earnings increase at each level of the educational ladder. However, we observe there are subtle differences.

According to the data, Minnesota has the highest median annual earnings (MAE) at each level of the ladder. For example, the MAE for Minnesota is $51,239 whereas the MAE is $50,595 for the United States. It should be noted that at the professional and graduate level MAE for Minnesota is the same as the United States.

One final thought, it should be noted that the U.S. Census Bureau decomposes its data into regions and divisions as well. So, for example, Minnesota educational attainment data can be compared to Iowa educational attainment data and/or Wisconsin educational attainment data. And this is really just the start of what could be an exhaustive exploration of the educational attainment data. One could even compare men and women at each level of the United States system, if the data exists.

 

Matt Johnson is a blogger/writer for The Systems Scientist and the Urban Dynamics blog. He has also contributed to the Iowa State Daily and Our Black News.

Matt has a Bachelor of Science in Systems Science, with focuses in applied mathematics and economic systems, from Iowa State University. He is also a professional member of the Society of Industrial and Applied Mathematics and the International Society for the Systems Sciences and a scholarly member of Omicron Delta Epsilon, which is an International Honors Society for Economics. 

You can connect with him directly in the comments section, and follow him on Facebook

You can also follow The Systems Scientist on Twitter or Facebook.

 

Photo Credit: VideoBlocks

 

 

 

 

 

 

Copyright ©2017 – The Systems Scientist