1262 search results for "Excel"

Early-February flotsam

February 7, 2012
By
Early-February flotsam

Mike Croucher at Walking Randomly points out an interesting difference in operator precedence for several mathematical packages to evaluate a simple operation 2^3^4. It is pretty much a divide between Matlab and Excel (does the later qualify as mathematical software?) … Continue reading →

Read more »

Comparing correlations update

February 5, 2012
By

I have just published R code for calculating CIs for differences between correlations on the Serious stats book blog. This covers independent correlations (taken from chapter 6 of the book) and dependent correlations (new R code written as a suppl...

Read more »

Comparing correlations: independent and dependent (overlapping or non-overlapping)

February 5, 2012
By
Comparing correlations: independent and dependent (overlapping or non-overlapping)

In Chapter 6 (correlation and covariance) I consider how to construct a confidence interval (CI) for the difference between two independent correlations.  The standard approach uses the Fisher z transformation to deal with boundary effects (the squashing of the distribution and increasing asymmetry as r approaches -1 or 1). As zr is approximately normally distributed

Read more »

RStudio Server: accessing the RStudio R IDE through your browser

February 1, 2012
By

I like having all my important documents and scripts in one single place. This saves me from having to synchronize them between the different workplaces I have, and makes backupping much less of a pain. One way of achieving this… See more ›

Read more »

Using LaTeX, R, and Sweave to Create Reports in Windows

January 30, 2012
By
Using LaTeX, R, and Sweave to Create Reports in Windows

LaTeX is a typesetting system that can easily be used to create reports and scientific articles, and has excellent formatting options for displaying code and mathematical formulas. Sweave is a package in base R that can execute R code embedded in LaTe...

Read more »

Updated Sentiment Analysis and a Word Cloud for Netflix – The R Way!

January 30, 2012
By
Updated Sentiment Analysis and a Word Cloud for Netflix – The R Way!

The Netflix investors must be happy and cheerful as the stock is up more than 78% since the beginning of the year (YES, 78%, Source: Yahoo Finance!).  I am not going to talk about what turned the stock around after a much talked/hyp...

Read more »

Using LaTeX, R, and Sweave to Create Reports in Windows

January 30, 2012
By
Using LaTeX, R, and Sweave to Create Reports in Windows

LaTeX is a typesetting system that can easily be used to create reports and scientific articles, and has excellent formatting options for displaying code and mathematical formulas. Sweave is a package in base R that can execute R code embedded in LaTeX files and display the output. This can be used to generate reports and quickly fix...

Read more »

Converting grads files to NetCDF from within R using CDO

January 30, 2012
By

A while back I wrote a blog post on the R package I wrote for reading and manipulating grads data. The library is quite basic, and does not support a number of grads data file options: Using one ctl file,… See more ›

Read more »

Printing nested tables in R – bridging between the {reshape} and {tables} packages

January 29, 2012
By
Printing nested tables in R – bridging between the {reshape} and {tables} packages

This post shows how to print a prettier nested pivot table, created using the {reshape} package (similar to what you would get with Microsoft Excel), so you could print it either in the R terminal or as a LaTeX table. This task is done by bridging between the cast_df object produced by the {reshape} package,

Read more »

Hottest 100 for 2011

January 26, 2012
By
Hottest 100 for 2011

Another year, another Australia Day. Another Australia Day, another Triple J Hottest 100. And that, of course, means an excellent excuse to  set R to work on the chart data. For those outside Australia, the Hottest 100 is a chart of the most popular songs of the previous year, as voted by the listeners of

Read more »