1144 search results for "excel"

sab-R-metrics: Introduction to R

January 5, 2011
By
sab-R-metrics: Introduction to R

In a recent post, I briefly mentioned that I may turn a majority of the focus of this blog to teaching R commands for use with sabermetric analysis. Only a few days later, Ricky Zanker began a new column at The Hardball Times doing just that. But that's okay. Hopefully both his and mine...

Read more »

sab-R-metrics: Introduction to R

January 5, 2011
By
sab-R-metrics: Introduction to R

In a recent post, I briefly mentioned that I may turn a majority of the focus of this blog to teaching R commands for use with sabermetric analysis. Only a few days later, Ricky Zanker began a new column at The Hardball Times doing just that. But that's okay. Hopefully both his and mine...

Read more »

Customizing the Theme of Your R HTML Help

January 4, 2011
By
Customizing the Theme of Your R HTML Help

R’s default theme of the HTML help pages is too plain for me to read, but we can easily modify the theme, which is essentially a CSS file. You can find the file under: file.path(R.home('doc'), 'html', 'R.css') Simply replace this file with my version: which looks like: Of course you can design your own R.css

Read more »

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 BookThe 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 »

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 »