Version 1.2 of EasyER has now been released. The main change is the addition of a chart builder interface for interactively creating charts. The chart builder plugs into the popular ggplot2 package allowing ggplot2 charts in Excel. Some bugs have also ...
We need to teach all our students how to design, create, test, debug and use spreadsheets. We need to teach this integrated with mathematics, statistics and computational thinking. Spreadsheets can be a valuable tool in many other subject areas including … Continue reading →
Reposted from Abhijit’s blog. Some <- have been replaced by = due to idiosyncracies of the WordPress platform. Well, here’s what I was dealing with: Exemplar Excel file from collaborator Notice that we have 3 header rows, first with patient IDs, second with spine region, and third with variable names (A and B, to protect […]
Statistical software for worried students: Appearances matter Let’s be honest. Most students of statistics are taking statistics because they have to. I asked my class of 100 business students who choose to take the quantitative methods course if they did not … Continue reading →
This is a quick script showing how to make multi-tabbed .xlsx files. I recently had the need to do this and used the flexible openxlsx package maintained by : Alexander Walker. The package is described by the author like this: … Continue reading →
In the last EasyER update (Version 1.1) the ability to use date time values was added. This makes it easier to deal with time series in Excel, allowing analysis and forecasting methods to be used. Time Series in Excel Excel doesn’t do time series and...
In the last EasyER update (Version 1.1) the ability to use date time values was added. This makes it easier to deal with time series in Excel, allowing analysis and forecasting methods to be used. Time Series in Excel Excel doesn’t do time series and...
There are many applications and tools for working with Excel and R. R code can be run from Excel and R can be used to output result to Excel sheets. Typically all these tools require some knowledge of using the command line or code. Data and results ne...
There are many applications and tools for working with Excel and R. R code can be run from Excel and R can be used to output result to Excel sheets. Typically all these tools require some knowledge of using the command line or code. Data and results ne...
Most people are familiar with Excel Histograms and understand that data is divided into a series of intervals, or bins and then how many values are in each bin are counted. These counts or frequencies are then typically shown on a chart that uses a bar...
