1455 search results for "excel"

Getting data in and out of R

October 22, 2012
By
Getting data in and out of R

One of the great advantages of R is that it recognizes almost any data format that you can throw at it. There are a myriad of different possible file formats but I'll concentrate on the four files that we see almost exclusively in public health: Excel ...

Read more »

Predict User’s Return Visit within a day part-3

October 22, 2012
By
Predict User’s Return Visit within a day part-3

Welcome to the last part of the series on predicting user’s revisit to the website. In the  first part of series, I generated the logistic regression model for prediction problem whether a user will come back on  website in next 24 hours. In the second part, I discussed about model improvement and seen the model accuracy.

Read more »

Classes and Objects in R

October 21, 2012
By

Classes and objects in R Welcome back! In this blog post I'm going to try to tackle the concept of objects in R. R is said to be an “object oriented” language. I touched on this in my last post when we discussed the concatenate function c() and I'll go a bit beyond that this time. Speaking of the c() function, I'll begin this...

Read more »

Basics of JavaScript and D3 for R Users

October 21, 2012
By
Basics of JavaScript and D3 for R Users

Hadley Wickham, creator of the ggplot2 R package, has been learning JavaScript and its D3 library for the next iteration of ggplot2 (tentatively titled r2d3?)… so I suspect it’s only a matter of time before he pulls the rest of the … Continue reading →

Read more »

Recoding Variables in R: Pedagogic Considerations

October 20, 2012
By

I was creating a dataset this last week in which I had to partition the observed responses to show how the ANOVA model partitions the variability. I had the observed Y (in this case prices for 113 bottles of wine), … Continue reading →

Read more »

Tidbit: Correlation and Simple Linear Regression

October 19, 2012
By

In business "Correlation" is generically used as a mutual relationship or connection between two or more things; statistically speaking correlation is the interdependence of variable quantities. I overhear many end users request information on the correlation of variables for prediction use, what they are referring to is actually simple linear regression. I don't mean to outline all

Read more »

Company Valuation using Discounted Cash Flows

October 18, 2012
By
Company Valuation using Discounted Cash Flows

Today I want to show a simple example of how we can value a company using Discounted Cash Flow (DCF) analysis. The idea is to compute the company’s Intrinsic Value based on the discounted future cash-flows. To compute future cash-flows I will use the historical Free Cash Flow growth rate. To compute present value of

Read more »

Basic ideas on aggregate, plyr and crosstables!

October 17, 2012
By
Basic ideas on aggregate, plyr and crosstables!

A common task using R is the investigation of one particular dataset. Usually we have a mixture of numerical and categorial data and are interested in some statistics (e.g. means and so on). And there are a lot of threads, blogs etc around that. Sorry for adding another one, but so I remember myself. Let’s

Read more »

Not Much of a Grand Finale. What if We Go To 0?

October 15, 2012
By
Not Much of a Grand Finale. What if We Go To 0?

When I ask the question “What if the US 10 year goes to 0?", most do not know the effect, the catalyst, or if 0 has ever happened before.  The math is fairly simple to do in Excel or with an old-school calculator, but let’s use RQuantLib to do...

Read more »

Review of “R For Dummies”

October 15, 2012
By
Review of “R For Dummies”

The authors are Andrie de Vries and Joris Meys. Executive summary Pretty much all I’d hoped for — and I had high hopes. Significance The “Dummies” series is popular for introducing specific topics in an inviting way. R For Dummies is a worthy addition to the pack. There is a competitor by the name of … Continue reading...

Read more »