1147 search results for "Excel"

Revolution R with Eclipse Helios

January 10, 2011
By

One of the reasons that I don’t often take advantage of the cool features in Revolution R is that I absolutely can’t stand their Visual Studio interface. Previously, if I wanted to run something in RevoR, I fired up the … Continue reading →

Read more »

sab-R-metrics: Basics of Vectors and Data Calling

January 6, 2011
By

Wednesday, I began a new series called "sab-R-metrics". My hope is that it reduces the frustration that goes along with learning a new programming language and enhances others' ability to perform their own analysis in baseball or other sports. However, these tutorials will hopefully allow you to use these skills in other areas as well. ...

Read more »

sab-R-metrics: Basics of Vectors and Data Calling

January 6, 2011
By

Wednesday, I began a new series called "sab-R-metrics". My hope is that it reduces the frustration that goes along with learning a new programming language and enhances others' ability to perform their own analysis in baseball or other sports. However, these tutorials will hopefully allow you to use these skills in other areas as well. ...

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 »

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 »