Subscribe to Blog via Email
Copyright Notice© Mark Biegert and Math Encounters, 2017. Publication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Mark Biegert and Math Encounters with appropriate and specific direction to the original content.
DisclaimerAll content provided on the mathscinotes.com blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner of mathscinotes.com will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.
Monthly Archives: August 2017
I heard some discussion on television about all the Confederate monuments around the country and when they were erected. I decided to look for the data and plot it for myself. I very quickly found a document from the Southern Poverty Law Center that looked interesting and provided me some interesting data tidying and charting challenges. My focus here is on duplicating their chart of monuments dedications dates. This chart type is not a standard Excel type and I wanted to see how I could duplicate it. This workbook will be used in a charting seminar that I plan to present in a month or so. Continue reading
My wife and I are about half-way through the construction of a 2100 square foot home in northern Minnesota. This weekend, my neighbors and I were talking about the area of houses being built today, and no one in the conversation had any data. I grabbed my computer, jumped on the Internet, and very quickly found data from the Census Department that answered my question. Like most census information, the data is in the form of screwy tables that need to be parsed to get into a form that can easily be plotted. This exercise gave me another excellent example to use when I train staff on the use of Excel's Get and Transform tool. Figure 1 was the result of my search. For those who are interested, my workbook is here. Continue reading
Yesterday, a reader asked me how to compute the totality path width for the eclipse that will cross the US on 21 Aug 2017. I wrote a post on how to perform this calculation years ago. NASA has published a path width value of 114.7 km. This width will actually vary a bit as the shadow moves across the Earth because the distance change slightly between all the bodies involved. Also, the Earth and Moon are not perfectly round, which I assume. NASA has very detailed models that even include the variations due to mountains and valleys on the Moon. Continue reading
I am preparing to drive out to Idaho to experience totality during the August 21, 2017 eclipse. I am choosing to view the eclipse from Idaho because my granddaughter (and her parents) live in western Montana, and I can stop there for visit when I return to Minnesota. This will be a long drive through large states (Minnesota, North Dakota, Montana) that have a significant percentage of farm land. While planning my journey, I became curious as to the percentage of farmland in each of the fifty states. In this post, I compute the farm land percentage by taking the farm acreage in each state and dividing by the state's land area (water area removed). Continue reading
I have been reading about how low natural gas prices have been affecting the coal mining industry. Coal mining is affected because those coal-fired electrical generation plants that can switch fuels are converting to natural gas to achieve significant cost reductions. Also, natural gas can fuel peaking generators that are designed to provide peak load support. I had no idea what the price advantages were for natural gas so I surfed over the US Department of Energy's (DoE) web site and found two tables that provided a summary of the maintenance, fuel, and operating costs for different types of electrical generation. Continue reading