1455 search results for "excel"

RExcel

October 13, 2009
By

I am not a fan of MS Windows software. However, the reality is that majority of people use it and it is often easier for me to live with this than to convert the sorounding souls. Additionally I am find ing out lately that majority of my favourite open...

Read more »

RExcel

October 13, 2009
By

I am not a fan of MS Windows software. However, the reality is that majority of people use it and it is often easier for me to live with this than to convert the sorounding souls. Additionally I am find ing out lately that majority of my favourite open...

Read more »

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 »

15 Questions All R Users Have About Plots

July 30, 2015
By
15 Questions All R Users Have About Plots

R allows you to create different plot types, ranging from the basic graph types like density plots, dot plots, bar charts, line charts, pie charts, boxplots and scatter plots, to the more statistically complex types of graphs such as probability plots, mosaic plots and correlograms. In addition, R is pretty known for its data visualization The post

Read more »

Logistic Growth, S Curves, Bifurcations, and Lyapunov Exponents in R

July 24, 2015
By
Logistic Growth, S Curves, Bifurcations, and Lyapunov Exponents in R

If you’ve ever wondered how logistic population growth (the Verhulst model), S curves, the logistic map, bifurcation diagrams, sensitive dependence on initial conditions, “orbits”, deterministic chaos, and Lyapunov exponents are related to

Read more »

{Long Vs. Wide} Data Frames

July 24, 2015
By
{Long Vs. Wide} Data Frames

Introduction This is an excellent resource to understand 2 types of data frame format: Long and Wide. Just take a look at figure 1 inside the article 1) Long format: ggplot2 needs in certain scenarios this kind of format to work (generally grouped...

Read more »

Why I use Panel/Multilevel Methods

July 24, 2015
By
Why I use Panel/Multilevel Methods

I don’t understand why any researcher would choose not to use panel/multilevel methods on panel/hierarchical data. Let’s take the following linear regression as an example: , where is a random effect for the i-th group. A pooled OLS regression model for the above is unbiased and consistent. However, it will be inefficient, unless for all

Read more »