1417 search results for "excel"

Export Data Frames To Multi-worksheet Excel File

October 6, 2009
By
Export Data Frames To Multi-worksheet Excel File

A few weeks ago I needed to export a number of data frames to separate worksheets in an Excel file. Although one could output csv-files from R and then import them manually or with the help of VBA into Excel, I was after a more streamlined solution, as I would need to repeat this process

Read more »

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 »

My favorite R bug

May 23, 2015
By
My favorite R bug

In this note am going to recount “my favorite R bug.” It isn’t a bug in R. It is a bug in some code I wrote in R. I call it my favorite bug, as it is easy to commit and (thanks to R’s overly helpful nature) takes longer than it should to find. The … Continue reading...

Read more »

Course on using Oracle R Enterprise

Course on using Oracle R Enterprise

BNOSAC will be giving from June 08 up to June 12 a 5-day crash course on the use of R using Oracle R Enterprise. The course is given together with our Oracle Partner in Leuven, Belgium. If you are interested in attending, contact us for further details. For R users who aren't aware of this yet....

Read more »

Benchmarking Random Forest Implementations

May 19, 2015
By
Benchmarking Random Forest Implementations

I currently have the need for machine learning tools that can deal with observations of...

Read more »

Query Multiple Google Analytics View IDs with R

May 18, 2015
By
Query Multiple Google Analytics View IDs with R

Extracting Google Analytics data from one website is pretty easy, and there are several options to do it quickly. But what if you need to extract data from multiple websites or, to be more precise, from multiple Views? And perhaps you also need to summ...

Read more »

Data Science Tweet Analysis – What tools are people talking about?

May 18, 2015
By
Data Science Tweet Analysis – What tools are people talking about?

By Chris Musselle PhD, Mango UK At ­Mango we use a variety of tools in-house to address our clients’ business needs and when these fall within the data science arena, the main candidates we turn to are either the R … Continue reading →

Read more »

The perfect t-test

May 18, 2015
By
The perfect t-test

I've created an easy to use R script that will import your data, and performs and writes up a state-of-the-art dependent or independent t-test. The goal of this script is to examine whether more researcher-centered statistical tools (i.e., a one-click analysis script that checks normality assumptions, calculates effect sizes and their confidence intervals, creates good figures,...

Read more »