1253 search results for "excel"

Example 8.19: Referencing lists of variables

January 3, 2011
By
Example 8.19: Referencing lists of variables

In section 1.11.4 (p. 50), we discuss referring to lists of variables in a data set. In SAS, this can be done for variable stored in adjacent columns with the "var_x -- var_y" syntax and for variables with sequentially enumerated suffixes with the "va...

Read more »

Empirical Bayes Estimation of On Base Percentage

December 30, 2010
By
Empirical Bayes Estimation of On Base Percentage

I guess you could call this On Bayes Percentage. *cough*Fresh off learning Bayesian techniques in one of my classes last quarter, I thought it would be fun to try to apply the method. I was able to find some examples of Hierarchical Bayes being used to...

Read more »

A Very Data Christmas

December 21, 2010
By
A Very Data Christmas

This week Google announced its Ngram Viewer, which allows you to explore the use of words in thousands of texts overtime, going back two hundred years. Given the relatively long time period covered by this massive data set, it is fun to explore how language has changed overtime. Some texts, however, seem to transcend time.

Read more »

How to buy a used car with R (part 2)

December 20, 2010
By
How to buy a used car with R (part 2)

Continued from Part 1. Part 2: Digging into the Kelley Blue Book The only thing better than a bit of data is a lot of data. Now that we can grab KBB values for a given trim of a given model in a given year, we set our ambitions higher: automating the collection of these values for...

Read more »

How to buy a used car with R (part 2)

December 20, 2010
By
How to buy a used car with R (part 2)

nStrict Standards: Non-static method StringParser_Node::destroyNode() should not be called statically, assuming $this from incompatible context in /afs/ir.stanford.edu/users/k/n/knoepfle/cgi-bin/flatpress/fp-plugins/bbcode/inc/stringparser.class.php on line 358Continued from Part 1.nnPart 2: Digging into the Kelley Blue BooknnThe only thing better than a bit of data is a lot of data. Now that we can grab KBB values for a given trim of...

Read more »

Why Use R?

December 14, 2010
By

I use R very frequently and take for granted much that it has to offer.  I forget how R is different from similar tools, so I have trouble communicating the benefits of using R.  The goal of this post is to highlight R's main strengths, but first... my story.How I got started with RI was introduced...

Read more »

Why Use R?

December 14, 2010
By

I use R very frequently and take for granted much that it has to offer.  I forget how R is different from similar tools, so I have trouble communicating the benefits of using R.  The goal of this post is to highlight R's main strengths, but first... my story.How I got started with RI was introduced...

Read more »

Visualizing Agricultural Subsidies by Kentucky County

December 12, 2010
By
Visualizing Agricultural Subsidies by Kentucky County

In this post,  I provide results from my first full blown application of R to read, merge, clean, subset, manipulate, analyze and visualize data related to agricultural subsidies by Kentucky counties. This is very similar to the work I do on a daily basis, and was a great test of the capabilities of doing these tasks open source...

Read more »

Google, The Brew’s On Me

December 3, 2010
By
Google, The Brew’s On Me

While drinking these fine liquids may up your trip count to the john, they can also make your R reports better. Not because they allow you to reach your Ballmer Peak… but because each of these elixers is the direct result of brewing. Okay, I’m rea...

Read more »

Life Is Short, Use Python

November 24, 2010
By
Life Is Short, Use Python

Life is short, use PythonI started to play with Python two weeks ago due to the limitation of R in terms of handling large data, then a friend of mine suggested me to try Python since I had to do data massage frequently, "Python is the best choice, trust me", he...

Read more »