1144 search results for "Excel"

Mortgage Calculator (and Amortization Charts) with R

November 10, 2010
By
Mortgage Calculator (and Amortization Charts) with R

Mortgage rates have been at historic lows recently.  The rates are posted various places online along with simple mortgage calculators.  Such calculators illustrate the payment schedule for a mortgage based upon selected terms. But with less ...

Read more »

Mortgage Calculator (and Amortization Charts) with R

November 10, 2010
By
Mortgage Calculator (and Amortization Charts) with R

Mortgage rates have been at historic lows recently.  The rates are posted various places online along with simple mortgage calculators.  Such calculators illustrate the payment schedule for a mortgage based upon selected terms. But with less ...

Read more »

Any R packages to solve Vehicle Routing Problem?

November 9, 2010
By
Any R packages to solve Vehicle Routing Problem?

Are there any R packages to solve Vehicle Routing Problem (VRP)?I looked around but could not find any... Any leads?VRP is a classic combinatorial optimization challenge and has been an active area of research for operations research gurus fo...

Read more »

Any R packages to solve Vehicle Routing Problem?

November 9, 2010
By
Any R packages to solve Vehicle Routing Problem?

Are there any R packages to solve Vehicle Routing Problem (VRP)?I looked around but could not find any... Any leads?VRP is a classic combinatorial optimization challenge and has been an active area of research for operations research gurus fo...

Read more »

R Beginner’s Guide Book Update: Statistical Analysis with R Released

November 8, 2010
By
R Beginner’s Guide Book Update: Statistical Analysis with R Released

In the final days of October, my beginner's guide to R was released. The book's official title is Statistical Analysis with R and it can be found on the Packt Publishing website. The primary focus of Statistical Analysis with R is helping new users bec...

Read more »

R Beginner’s Guide Book Update: Statistical Analysis with R Released

November 8, 2010
By
R Beginner’s Guide Book Update: Statistical Analysis with R Released

In the final days of October, my beginner's guide to R was released. The book's official title is Statistical Analysis with R and it can be found on the Packt Publishing website. The primary focus of Statistical Analysis with R is helping new users bec...

Read more »

Dress your R code for the Web with Pretty R

November 4, 2010
By
Dress your R code for the Web with Pretty R

If you have some R code to include in a document, especially a Web-based document like a blog post, the new "Pretty R" feature on inside-R.org can help you make it look its best. Given some raw R code, it will create a HTML version of the code, adding syntax highlighting elements and links. Functions, strings, comments and literals...

Read more »

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

October 31, 2010
By
How to buy a used car with R (part 1)

I’m in the process of buying a used car. Since I enjoy making these decisions as complicated as possible, I’ve written some R code to scrape relevant websites for informative data. I’ve written this up as a blog entry because I think it’s a decent example of how one might use the XML...

Read more »

Bayesian Model Averaging (BMA) with uncertain Spatial Effects

October 27, 2010
By
Bayesian Model Averaging (BMA) with uncertain Spatial Effects

This file illustrates the computer code to use spatial filtering in the context of Bayesian Model Averaging (BMA). For more details and in case you use the code please cite Crespo Cuaresma and Feldkircher (2010). In addition, this tutorial exists as ...

Read more »

Handling Large Datasets in R

Handling large dataset in R, especially CSV data, was briefly discussed before at Excellent free CSV splitter and Handling Large CSV Files in R. My file at that time was around 2GB with 30 million number of rows and 8 columns. Recently I started to collect and analyze US corporate bonds tick data from year...

Read more »