1240 search results for "Excel"

Football (Eredivisie) goals

August 27, 2012
By
Football (Eredivisie) goals

The football season has started in Netherlands, so I went and had a look at last year's scores. I did not find downloadable data, at http://www.eredivisiestats.nl/wedstrijden.php I could copy last season's data and paste into a spreadsheet. T...

Read more »

Custom CSS for HTML generated using RStudio

August 26, 2012
By
Custom CSS for HTML generated using RStudio

People have been telling me for a while that the latest version of RStudio, the IDE for R, is a great way to generate reports. I finally got around to trying it out and for once, the hype is justified. Start with this excellent tutorial from Jeremy Anglim. Briefly: the process is not so different

Read more »

Structural Equation Modeling: Separating the General from the Specific (Part II)

August 26, 2012
By
Structural Equation Modeling: Separating the General from the Specific (Part II)

As promised in Halo Effects and Multicollinearity (my last post), I will show how to run a confirmatory factor analysis in R to test our bifactor model.  In addition, I will include a dependent variable and fit a structural equation mode...

Read more »

A Chlorpleth Map of Free and Reduced Price Lunch in R

August 26, 2012
By
A Chlorpleth Map of Free and Reduced Price Lunch in R

Charles Blow has an excellent op-ed in the New York Times about public education this week. The most important point he makes is that the defunding of public education is coming at precisely the time when American school children are most vulnerable:No...

Read more »

Why R for Mass Spectrometrist and Computational Proteomics

August 25, 2012
By
Why R for Mass Spectrometrist and Computational Proteomics

Why R:Actually, It is a common practice the integration of the statistical analysis of the resulted data and in silico predictions of the data generated in your manuscript and your daily research. Mass spectrometrist, biologist and bioinformaticians c...

Read more »

Does playing baseball shorten your lifespan? (Answer: No.)

August 24, 2012
By
Does playing baseball shorten your lifespan? (Answer: No.)

A National Institute for Occupational Safety and Health study, published in March, found that professional American football (NFL) players lived longer, on average, than similar "mere mortals" in the general population. Football is a dangerous sport, so that might seem surprising at first, until you consider the fact that NFL players are elite sportsmen: only the strongest, fastest and...

Read more »

2014 Winter Olympics: Home Court Advantage – Russia

August 22, 2012
By
2014 Winter Olympics: Home Court Advantage – Russia

"Russia is a riddle wrapped in a mystery inside an enigma."  -- Winston Churchill, radio address in 1939 A couple of weeks ago, Graph of the Week published an article describing the significant improvement in medals won by the host...

Read more »

ARMA Models for Trading

August 21, 2012
By
ARMA Models for Trading

In this tutorial I am going to share my R&D and trading experience using the well-known from statistics Autoregressive Moving Average Model (ARMA). There is a lot written about these models, however, I strongly recommend Introductory Time Series with R, which I find is a perfect combination between light theoretical background and practical implementations in

Read more »

Mid-August flotsam

August 20, 2012
By
Mid-August flotsam

Reached mid-semester point, with quite a few new lectures to prepare. Nothing extremely complicated but, as always, the tricky part is finding a way to make it meaningful and memorable. Sometimes, and this is one of those times, I sound … Continue reading →

Read more »

Another comparison of heuristic optimizers

August 20, 2012
By
Another comparison of heuristic optimizers

A herd of heuristic algorithms is compared using a portfolio optimization. Previously “A comparison of some heuristic optimization methods” used two simple and tiny portfolio optimization problems to compare a number of optimization functions in the R language. This post expands upon that by using a portfolio optimization problem that is of a realistic size … Continue reading...

Read more »