1476 search results for "Excel"

Importing Data to R

March 30, 2013
By

There are number of ways in importing data into R, and several formats are available,From Excel to R From SPSS to RFrom Stata to R, and more hereIn this post, I'm going to talk about importing common data format that we often encounter, such as Excel, ...

Read more »

Creating a Business Dashboard in R

March 28, 2013
By
Creating a Business Dashboard in R

Business dashboards are available in many shapes and sizes. Business dashboards are useful to create an overview of key performance indicators (KPIs) important for the business strategy and/or operations. There are many flavours of dashboard frameworks and apps available, ranging in price from thousands of dollars to open-source implementations. Apparently  Read more »

Creating a Business Dashboard in R

March 28, 2013
By
Creating a Business Dashboard in R

Business dashboards are available in many shapes and sizes. Business dashboards are useful to create an overview of key performance indicators (KPIs) important for the business strategy and/or operations. There are many flavours of dashboard frameworks and apps available, ranging in price from thousands of dollars to open-source implementations. Apparently there are four key elements to a good dashboard: Simple, communicates easily Minimum distractions…it could cause...

Read more »

Moving to R 3.0.0 on Ubuntu

March 27, 2013
By

As you may (or may not) be aware of, R 3.0.0 is scheduled to be released on April 3rd. Since this is a major release and there may be some growing pains (but I hope not) in the move 3.0.0, here is some information about how I will handle R 3.0.0 on CR...

Read more »

Python vs R vs SPSS … Can’t All Programmers Just Get Along?

March 26, 2013
By
Python vs R vs SPSS … Can’t All Programmers Just Get Along?

Programmers have long been very proud and loyal with their tools, and often very vocal. This has led to well-contested rivalries and “fights” about which tool is better: emacs or vi; Java or C++; Perl or Python; Django or Rails; … Continue reading →The post Python vs R vs SPSS … Can’t All Programmers Just Get Along?...

Read more »

Rcpp 0.10.3

March 23, 2013
By

A new relase 0.10.3 of Rcpp is now on CRAN and in Debian. This is the fourth release in the 0.10.* series, and further extends and solidifies the excellent Rcpp attributes. A few other bugs were fixed as well, and support for wide character string...

Read more »

Maximum Sharpe Portfolio

March 21, 2013
By
Maximum Sharpe Portfolio

Maximum Sharpe Portfolio or Tangency Portfolio is a portfolio on the efficient frontier at the point where line drawn from the point (0, risk-free rate) is tangent to the efficient frontier. There is a great discussion about Maximum Sharpe Portfolio or Tangency Portfolio at quadprog optimization question. In general case, finding the Maximum Sharpe Portfolio

Read more »

XLConnect on github

March 20, 2013
By
XLConnect on github

Mirai Solutions GmbH (http://www.mirai-solutions.com) is pleased to announce the availability of XLConnect on github. Whether you want to browse the code or simply want access to the latest development version of XLConnect, visit us on github. XLConnect can be directly … Continue reading →

Read more »

On the acceptance of R

March 20, 2013
By

Some history and a prediction. Past A discussion broke out on the R-help mailing list in January 2006 about a technical report put out by the statistical computing group at UCLA.  The report in question talked mainly about SAS, SPSS and Stata.  It talked briefly — and not especially positively — about R.  Someone accused The post On...

Read more »

Behavioral Economics and Beer… highly correlated

March 19, 2013
By
Behavioral Economics and Beer… highly correlated

Short: I plot the frequency of wikipedia searches of “Behavioral Economics”, and “Beer” – who knew the correlation would be 0.7! Data reference:Data on any wikipedia searches (back to 2007) are available at http://glimmer.rstudio.com/pssguy/wikiSearchRates/. The website allows you to download frequency hits per day as a csv, which is what I've done here....

Read more »