1253 search results for "excel"

How to Import MS Excel Data into R

September 26, 2009
By
How to Import MS Excel Data into R

s Sir Francis Bacon said, “Histories make men wise; poets witty; the mathematics subtile; natural philosophy deep; moral grave; logic and rhetoric able to contend.” And Windows stupid. He should have added the last sentence if he were a Windows user in this age. 1. Avoid Using M$ Excel A lot of R users often ask this question:

Read more »

Negative Scalability Coefficients in Excel

May 12, 2009
By
Negative Scalability Coefficients in Excel

Recently, several performance engineers, who have been applying my universal scalability law (USL) to their throughput measurements, reported a problem whereby their Excel spreadsheet calculations produced a negative value for the coherency parameter (...

Read more »

Statistics on Microsoft Excel

February 6, 2007
By

Here is an interesting document on problems of using Microsoft Excel for statistical analysis. http://gcrc.ucsd.edu/biostatistics/Excel.pdf Technorati Tags: statistics, excel, microsoft

Read more »

TURF Analysis: A Bad Answer to the Wrong Question

September 29, 2014
By
TURF Analysis: A Bad Answer to the Wrong Question

Now that R has a package performing Total Unduplicated Reach and Frequency (TURF) Analysis, it might be a good time to issue a warning to all R users. DON'T DO IT!The technique itself is straight out of media buying from the 1950s. Given some number of...

Read more »

DescTools: a new R "misc package"

September 25, 2014
By
DescTools: a new R "misc package"

by Joseph Rickert One of the most difficult things about R, a problem that is particularly vexing to beginners, is finding things. This is an unintended consequence of R's spectacular, but mostly uncoordinated, organic growth. The R core team does a superb job of maintaining the stability and growth of the R language itself, but the innovation engine for...

Read more »

Data Science Toolbox Survey Results… Surprise! R and Python win

September 24, 2014
By
Data Science Toolbox Survey Results… Surprise! R and Python win

This is a re-publication of a blog post from a blog I created not long before...

Read more »

PubMed Publication Date: what is it, exactly?

September 23, 2014
By
PubMed Publication Date: what is it, exactly?

File this one under “has troubled me (and others) for some years now, let’s try to resolve it.” Let’s use the excellent R/rentrez package to search PubMed for articles that were retracted in 2013. 117 articles. Now let’s fetch the records in XML format. Next question: which XML element specifies the “Date of publication” (PDAT)?

Read more »

In-depth introduction to machine learning in 15 hours of expert videos

September 23, 2014
By
In-depth introduction to machine learning in 15 hours of expert videos

In January 2014, Stanford University professors Trevor Hastie and Rob Tibshirani (authors of the legendary Elements of Statistical Learning textbook) taught an online course based on their newest textbook, An Introduction to Statistical Learning with Applications in R (ISLR). I found it to be an excellent course in statistical learning (also known as "machine learning"), largely...

Read more »

How to publish R and ggplot2 to the web

September 23, 2014
By
How to publish R and ggplot2 to the web

by Matt Sundquist, Plotly Co-founder It's delightfully smooth to publish R code, plots, and presentations to the web. For example: Shiny makes interactive apps from R. Pretty R highlights R code for HTML. Slidify makes slides from R Markdown. Knitr and RPubs let you publish R Markdown docs. GitHub and devtools let you quickly release packages and collaborate. Now,...

Read more »

Newcastle R course, a write-up

September 22, 2014
By

I recently attended a week-long R course in Newcastle, taught by Colin Gillespie. It went from “An Introduction to R” to “Advanced Graphics” via a day each on modelling, efficiency and programming. Suffice to say it was an intense 5 days! Overall it was the best R course I’ve been on so far. I’d recommend it to others,...

Read more »