Share this Excel Chart on Your Site
A deadly heat wave in Tokyo, producing record high temperatures in Tokyo in July 2018. The heatwave in Tokyo has toppled temperature records across the country, with Kumagaya in Saitama outside Tokyo setting a new nationwide record on Monday with temperatures hitting 41.1 Celsius. Temperatures in Japan’s western cities of Yamaguchi and Akiotacho reached record highs of 38.8 Celsius and 38.6 C, respectively, on 25th July afternoon. An agriculture ministry official in Tokyo, the capital, warned against “pretty severe price moves” for vegetables if predictions of more weeks of hot weather held up, resulting in less rain than usual.
Japan Meteorological Agency has predicted it will remain hot for a few more weeks, and that we will have less rain than the average. I searched and downloaded some weather data from the Japan Meteorological Agency for Tokyo from the year 1875 to 2018. A total of 144 years of average monthly temperature data. You can take a look here.
Since I’m curious about the average July temperatures in Tokyo, I plotted the July temperatures as a line chart, added a linear trendline and forward forecast for 20 years. Interestingly, the Equation shows 0.0172X + 23.836. What it means is the mean July temperatures are expected to increase by 0.017 degrees Celsius every year.
So even as we can expect more wild temperature outliers like heat waves, we can expect temperatures are rising in Tokyo due to global warming.
Choose from our Most Popular Courses
Focusing on analyst grade quality training. Our courses are aimed at empowering you to acquire functional skills in Microsoft Excel and Microsoft PowerPoint.
Making Charts Beautiful with Microsoft Excel. Excel charts can look stunning! This is an advanced workshop to create professional looking charts you see in magazines.