1227 search results for "Excel"

Optimization for Finance with R

January 9, 2012
By

Last year, the Statistics and Mathematics Department of the Vienna University School of Economics and Business presented a research seminar series on optimization, taught by R Core Group member Kurt Hornik (with Ronald Hochreiter and Stefan Theussl). Even if you couldn't make it to Austria to attend the course, the course materials are available online, and make an excellent...

Read more »

Creating LaTeX Tables from Zelig and Statnet objects

January 9, 2012
By

As a PhD student that uses quantitative methods a lot, one annoying part of my job is to type up my results, especially formatting tables with regression models can be a lot of work. Luckily there is an excellent package in R, apsrtable, which will gen...

Read more »

getting ICES 1903-1949 catch statistics into R

January 5, 2012
By
getting ICES 1903-1949 catch statistics into R

in the last post i showed how to get the nominal north east atlantic landings data from 1950 onwards into a usable format in R. this time around a script that shows how to import zipped excel files from 1903 to 1949 is provided. finalizing with a ggplo...

Read more »

Working with data frames

January 5, 2012
By

R, just like other programming languages, has different types of objects. Matrices, arrays, data.frames, lists, vectors, tables, etc. But by far the most important for working with baseball data is going to be dataframes.I'm not sure of the level of ex...

Read more »

Lesson 1: Overview of R Language & CloudStat School

January 2, 2012
By
Lesson 1: Overview of R Language & CloudStat School

This is the first lesson of CloudStat School, Lesson 1: Overview of R Language & CloudStat School. The objective of this lesson is introducing R Language and how you can be a R programmer or a data analyst through CloudStat School. At the end of this l...

Read more »

R resources

January 2, 2012
By

Earlier we spoke about PITCHfx resources, and now we will learn about R resources. Well, what is R? Straight from wikipedia:R is a programming language and software environment for statistical computing and graphics. The R lang...

Read more »

Example

January 2, 2012
By
Example

Here is a little example of what I do. While learning R isn't easy, it can be very powerful and efficient once you get your feet wet. I intend for this example to whet  your appetite. This should take you less than 20 minutes. By the end, you will...

Read more »

How much is a shower?

December 29, 2011
By
How much is a shower?

After looking at my heating expenses, I turned to the costs for water heating. For some time, I looked at my water meter before and after taking a shower or a bath. Quite often, I forgot one or the other measurement, but I collected about 40 observations. Here is what they look like:The data suggest that for a...

Read more »

Fed Loan Data Part 1

December 27, 2011
By
Fed Loan Data Part 1

This is the start of analyzing the Federal Reserve and Banking data mentioned in my "A Christmas Miracle". The file is a combination of summary data and actual data from each of the 400+ banks that recieved funds from the Federal Reserve during 2007-20...

Read more »

Legislative Activity in the Danish Parliament

December 22, 2011
By
Legislative Activity in the Danish Parliament

As mentioned in this post, I have been using the powerful combination of the Beautiful Soup and Mechanize modules in Python to build a web scrapers. The amount of data on the web is amazing, and I believe that any quantitatively oriented social scienti...

Read more »