Home>Jon Johansson

About Jon Johansson

This author has not yet filled in any details.
So far Jon Johansson has created 14 blog entries.

A Simple Model of Covid-19 Data With Excel

We currently (as of Jan, 2021) have large amounts of data concerning the Covid-19 pandemic available. We have daily updates through various news outlets and we can download data from different country's public data websites. Aggregated data is available for viewing at Worldometers coronavirus page, and for download at Our World in Data's Covid-19 data [...]

By |2021-02-11T17:12:54-07:00February 8th, 2021|Excel, Exponential trendline, Trendline|0 Comments

“Standard Error” Error Bars in Excel

In previous articles we discussed adding fixed error bars and Standard Deviation error bars to Excel charts. The last option available on the Format Error Bars dialog is the standard error,  short for "standard error of the mean". Using the same data set that we used for the post Standard Deviation Error Bars in Excel, [...]

By |2020-12-14T17:36:39-07:00December 16th, 2020|Error bars, Excel, Tutorials and How-Tos|0 Comments

Error Bars in Excel

Error bars on a chart/graph provide a visual representation of our uncertainty of knowledge about the values of the data points. These are helpful in understanding the accuracy of our data and have the benefit of being relatively easy to interpret. We are going to discuss how to add error bars to charts in Excel [...]

By |2020-11-16T18:09:20-07:00October 22nd, 2020|Error bars, Excel, Tutorials and How-Tos|0 Comments

Instructor Led Online Teaching

Videoconferencing is fairly old technology now. There have been a variety of expensive commercial systems available, but the system that most people may be familiar with is probably Skype™ by Microsoft. Since 2003 Skype™ has allowed people to see and talk with friends, relatives and colleagues using computers and eventually tablets and phones. The software [...]

Go to Top