excel
9 posts. All tags
- 2014-10-15
Optimization In Google Sheets
Good news for those of you that use spreadsheets to do analytics: Google recently announced a Linear Optimization add on for Google Sheets, and now Frontline Systems has released
- 2014-10-09
NBA Rosters and Team Changes: 2013-2014
com, and accounted for roster changes (as of Sunday, October 5). Click here to download a CSV file with 2013 2014 NBA rosters.
- 2014-10-09
Predicting the 2014-2015 NBA Season
Over the weekend I created a model in Excel to predict the 2014 2015 NBA season.
- 2014-10-08
Predicting NBA Rookie Performance By Draft Position
Nate Silver (and others) have tracked how NBA draft position relates to total career performance, see for example this article. But what about first year performance?
- 2014-10-04
NBA Game Results: 2013-2014
The NBA preseason is in full swing! For those of you who like to fool around with data, I have prepared a CSV file with game by game results for the 2013 2014 season.
- 2014-07-07
401k Simulation Using Analytic Solver Platform
You can build a pretty decent 401k simulation in a few minutes in Excel using Analytic Solver Platform: Let’s give it a shot! You can download the completed workbook here.
- 2014-06-25
Time Series Forecasting using Analytic Solver Platform, Windows Azure Marketplace, and Power Query
In this post, I’ll show you how to use Analytic Solver Platform in Excel 2013 with Power BI to build a time series analysis model using data from the cloud.
- 2014-03-11
Beautiful Box Plots in Excel 2013
Box plots are widely used among data scientists and statisticians. They're useful because they show variation both between and within data series.
- 2013-02-11
Adding Error Bars to Charts in Excel 2013
Excel 2013 makes it easier than ever to create error bars. Hooray!