1306 search results for "Excel"

omg lol brb txt l8r – Text Message Analysis, 2011-2012

September 3, 2012
By
omg lol brb txt l8r – Text Message Analysis, 2011-2012

IntroductionI will confess, I don't really like texting. I communicate through text messages, because it does afford many conveniences, and occupies a sort of middle ground between actual conversation and email, but that doesn't mean that I like it. E...

Read more »

New Attribution Functions for PortfolioAnalytics

September 1, 2012
By
New Attribution Functions for PortfolioAnalytics

Another Google Summer of Code (GSoC) project this summer focused on creating functions for doing returns-based performance attribution. I’ve always been a little puzzled about why this functionality wasn’t covered already, but I think that most analysts do this kind of work in Excel. That, of course, has its own perils. But beyond the workflow

Read more »

Three ways of visualizing the growth of Walmart

August 30, 2012
By
Three ways of visualizing the growth of Walmart

It's a wonderful thing when people make interesting data sets available to the public. When Thomas Jones wrote a paper in Econometrics about the growth of US retail giant Walmart, he made the data he collected about every Walmart store opening in history (location and date) available to the public. Since then, several people have used different techniques to...

Read more »

Virginia: Comparison of Registered Voter Counts to Census Voting Age Population

August 29, 2012
By
Virginia: Comparison of Registered Voter Counts to Census Voting Age Population

By Earl F Glynn | Franklin Center A comparison of US Census voting age population data in Virginia to voter registration data shows only one locality, Surry County, with about 100% of the voting age population registered to vote. Six other localities have about 95% of their voting age population registered:  Craig County, Isle of

Read more »

Integrating R into a SAS shop

August 29, 2012
By

I work in an environment dominated by SAS, and I am looking to integrate R into our environment. Why would I want to do such a thing? First, I do not want to get rid of SAS. That would not only take away most of our investment in SAS training and hiring good quality SAS programmers, but...

Read more »

Generate simple HTML slides using deck.js and markdown

August 29, 2012
By

RStudio and knitr are an excellent conbination for generating dynamic reports. But in this blog, I will show you how to generate HTML-style presentaion using R only. OK, I confess that we still need something else: deck.js and markdown and R.utils. ...

Read more »

Football (Eredivisie) goals

August 27, 2012
By
Football (Eredivisie) goals

The football season has started in Netherlands, so I went and had a look at last year's scores. I did not find downloadable data, at http://www.eredivisiestats.nl/wedstrijden.php I could copy last season's data and paste into a spreadsheet. T...

Read more »

Custom CSS for HTML generated using RStudio

August 26, 2012
By
Custom CSS for HTML generated using RStudio

People have been telling me for a while that the latest version of RStudio, the IDE for R, is a great way to generate reports. I finally got around to trying it out and for once, the hype is justified. Start with this excellent tutorial from Jeremy Anglim. Briefly: the process is not so different

Read more »

Structural Equation Modeling: Separating the General from the Specific (Part II)

August 26, 2012
By
Structural Equation Modeling: Separating the General from the Specific (Part II)

As promised in Halo Effects and Multicollinearity (my last post), I will show how to run a confirmatory factor analysis in R to test our bifactor model.  In addition, I will include a dependent variable and fit a structural equation mode...

Read more »

A Chlorpleth Map of Free and Reduced Price Lunch in R

August 26, 2012
By
A Chlorpleth Map of Free and Reduced Price Lunch in R

Charles Blow has an excellent op-ed in the New York Times about public education this week. The most important point he makes is that the defunding of public education is coming at precisely the time when American school children are most vulnerable:No...

Read more »