857 search results for "excel"

from OTU table to HEATMAP!

February 23, 2013
By
from OTU table to HEATMAP!

In this tutorial you will learn: what is a heatmap how to create a clean, highly customizable heatmap using heatmap.2 in the gplots package in R how to remove samples with poor output (not very many sequences) how to rearrange your samples by a metadata category how to make a color coded bar above the heatmap

Read more »

Why does IFELSE logic work differently on what appear to be the same values?

February 22, 2013
By

 Embarrassingly I'm stumped on this...I have a program in R for looking at grade distributions in my class. I found something weird recently with my 'ifelse' processing. I noticed that my program seemed to be over counting Cs and under counting...

Read more »

±∞

February 21, 2013
By
±∞

The Cauchy distribution (?dcauchy in R) nails a flashlight over the number line

http://upload.wikimedia.org/wikipedia/commons/thumb/9/93/Number-line.svg/1000px-Number-line.svg.png

and swings it at a constant speed from 9 o’clock down to 6 o’clock over to 3 o’clock. (Or the other direction, from 3→6→9.) Then counts Read more »

Quandl: A Wikipedia for Time Series Data

February 20, 2013
By

This guest post is by Tammer Kamel, Founder of Quandl Finding and formatting numerical data for analysis in R or Excel or indeed any application is a pain that all real world data analysts know all too well. In aggregate I have probably spent weeks of my life trying to find data on the web. And several more weeks...

Read more »

Revisiting Cleveland’s The Elements of Graphing Data in ggplot2

February 18, 2013
By
Revisiting Cleveland’s The Elements of Graphing Data in ggplot2

I was flipping through my copy of William Cleveland’s The Elements of Graphing Data the other day; it’s a book worth revisiting. I’ve always liked Cleveland’s approach to visualization as statistical analysis. His quest to ground visualization principles in the context of human visual cognition (he called it “graphical perception”) generated useful advice for designing

Related posts:
  1. Read more »

Change fonts in ggplot2, and create xkcd style graphs

February 17, 2013
By
Change fonts in ggplot2, and create xkcd style graphs

Installing and changing fonts in your plots comes now easy with the extrafonts-package. There is a excellent tutorial on the extrafonts github site, still I will shortly demonstrate how it worked for me. First, install the package and load it. You can now install the desired system fonts (at the moment only TrueType fonts): The

Read more »

Automatic spatial interpolation with R: the automap package

February 17, 2013
By
Automatic spatial interpolation with R: the automap package

In case of continuously collected data, e.g. observations from a monitoring network, spatial interpolation of this data cannot be done manually. Instead, the interpolation should be done automatically. To achieve this goal, I developed the automap package. automap builds on

Read more »

Some of Excel’s Finance Functions in R

February 16, 2013
By

Last year I took a free online class on finance by Gautam Kaul. I recommend it, although there are other classes I can not compare it to. The instructor took great efforts in motivating the concepts, structuring the material, and enable critical thinking / intuition. I believe this is an advantage of video...

Read more »

A must-read paper on statistical analysis of experimental data

February 13, 2013
By
A must-read paper on statistical analysis of experimental data

Russ Lyons points to an excellent article on statistical experimentation by Ron Kohavi, Alex Deng, Brian Frasca, Roger Longbotham, Toby Walker, Ya Xu, a group of software engineers (I presume) at Microsoft. Kohavi et al. write: Online controlled experiments are often utilized to make data-driven decisions at Amazon, Microsoft . . . deployment and mining

Read more »

Did an Excel error bring down the London Whale?

February 11, 2013
By

When JP Morgan Chase announced it had lost more than 2 billion dollars on the capital markets back in May 2012, many pointed to the actions of rogue trader Bruno Iksil as the cause. But was the "London Whale" — the nickname he was given by other traders for his outsized positions — the victim not of hubris, but...

Read more »