1288 search results for "excel"

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 »

Putting a football model into JAGS

October 14, 2012
By
Putting a football model into JAGS

In this post the football model is programmed into JAGS. There are all the reasons to do so. Jags 3.3 is recently released, I was stimulated by Gianluca's post . Obviously I could copy the model in his paper, but that would be too easy a...

Read more »

Loading SPSS (.sav) into Stata

October 11, 2012
By

Most statistical softwares nowadays are able to convert their files to a wide range of other packages. Perhaps it is the reason for the discontinuity of old converter bundles like SAS Transport and DBMS. Interesting, however, Stata, a quite popular statistical package, still lack built-in support for exporting and importing files among concurrent softwares like

Read more »

Cyber Summit 2012: a bit of big data and a lot of small tweets

October 7, 2012
By
Cyber Summit 2012: a bit of big data and a lot of small tweets

Last week (October 1-3) MPK Analytics attended the annual Cyber Summit in Banff. The theme for this year was; “Leading the Way in the Age of Big Data“. As might

Read more »

Style your R charts like the Economist, Tableau … or XKCD

October 5, 2012
By
Style your R charts like the Economist, Tableau … or XKCD

As we noted last month, the new Themes feature in ggplot2 helps you customize the design of R charts to your liking. Now, R user Jeffrey Arnold has built on this feature to create standardized themes to make R graphics looks like those from major publications and other software systems. You can use his ggthemes package to make your...

Read more »