1243 search results for "Excel"

Ggplot2, PubMed citation frequency and DSM-IV Axis I disorders by year

March 31, 2012
By
Ggplot2, PubMed citation frequency and DSM-IV Axis I disorders by year

I searched PubMed for several major DSM-IV disorders and downloaded the hits. Using ggplot2 I plotted the number of publications each year for each disorder.

Read more »

See how Deloitte uses R for actuarial analysis

March 29, 2012
By

Many thanks to Jim Guszcza (Predictive Analytics lead at Deloitte Consulting and Assistant Professor at UW-Madison) who gave a great webinar presentation yesterday on actuarial analysis with R. Jim's demo (starting at the 20 minute mark in the video replay below) is a great way to get a sense of how R is used for exploratory data analysis and...

Read more »

Updates to the Deducer family of packages

March 29, 2012
By

Over the past month there have been a number of package updates in the deducer ecosystem. Deducer is a general purpose, extensible, data analysis GUI. It is designed to be a free easy to use alternative to proprietary data analysis software such as SPSS, JMP, and Minitab. It has a menu system to do common

Read more »

Popularity of Programming Languages

March 25, 2012
By
Popularity of Programming Languages

As you can see, R is relatively popular (but more so on StackOverflow than GitHub):For the original graph, click here. This scatter plot is a reminder that R is useful to learn not only for statistical modeling (since there are so many excellent packag...

Read more »

knitr, github, and a new phase for the lab notebook

March 21, 2012
By
knitr, github, and a new phase for the lab notebook

I have recently modified the basic workflow of my lab notebook since discovering knitr. Before, I would write code files which I could track on github, push figures created by the code to flickr, and then write a notebook entry on wordpress describing what I was doing. I’d embed each figure I wanted into the

Read more »

Simple ROC plots with ggplot2 – Part 2

March 21, 2012
By
Simple ROC plots with ggplot2 – Part 2

In the first part of this article we built a function (rocdata) to calculate the co-ordinates for the ROC plot and its summary statistics. Now we need to actually produce the plot. I make most of my plots in ggplot2 because of it’s versatility. However there’s no reason why these plots couldn’t be produced

Read more »

Copy and paste small data sets into R

March 21, 2012
By
Copy and paste small data sets into R

How can I embed a small data set into my R code? That was the question I came across today, when I prepared my talk about Dynamical Systems in R with simecol for the forthcoming Cologne R user group meeting. I wanted to add all the R code of the talk t...

Read more »

Data Analysis Training

March 20, 2012
By
Data Analysis Training

I'm training some of my colleagues on Big'ish data analysis this week. Here's how I'm running the class. Would love your ideas to make it better. CLASS OBJECTIVES (LEARNING OUTCOMES)After completion of the course, you will be able to:Understand concept...

Read more »

Backtesting Asset Allocation portfolios

March 18, 2012
By
Backtesting Asset Allocation portfolios

In the last post, Portfolio Optimization: Specify constraints with GNU MathProg language, Paolo and MC raised a question: “How would you construct an equal risk contribution portfolio?” Unfortunately, this problem cannot be expressed as a Linear or Quadratic Programming problem. The outline for this post: I will show how Equal Risk Contribution portfolio can be

Read more »

Download and Parse DJ/UBS Commodities Indexes

March 16, 2012
By
Download and Parse DJ/UBS Commodities Indexes

Here is another data downloading and parsing script, this one for the Dow Jones/UBS Commodities Indexes. Compared to the last post, this parser deals with multiple sheets and multiple columns in each sheet. It also constructs monthly series from the daily data, and stores it using a different symbol. Finally, it’s a good example of

Read more »