Teaching analytics with modern Excel
This post serves as a follow-up on a previous post about scheduled collection of Weather.gov's XML feed in R, which itself was a follow-up to retrieving real-time data from Weather.gov in …
Continue Reading about Downloading 24-Hour Weather Updates in R →
I have loved Seinfeld ever since college, when as an RA on duty I spent many a Southern Michigan weekend night watching the show with my fellow on-duty RAs. The Bottle Deposit held particular …
Continue Reading about The Great Bottle Deposit Financial Model →
Download the exercise file here. Requires Excel 2013 or greater. These are new functions in Excel. You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) …
