1288 search results for "Excel"

Example 8.38: WriteXLS to create spreadsheets

May 16, 2011
By
Example 8.38: WriteXLS to create spreadsheets

In our last entry, we described reading Excel files. In this entry, we do the opposite: write native Excel files.RIn R, the WriteXLS package provides this functionality. It uses perl to do the heavy lifting, and the main complication is to install th...

Read more »

Why method of moments doesn’t always work

May 15, 2011
By
Why method of moments doesn’t always work

A number of years ago, someone asked me "why does my company need actuaries to fit curves, once I have the mean and standard deviation of my losses, isn't that enough?" I explained to him that not every distribution is completely determined by its mean...

Read more »

Why method of moments doesn’t always work

May 15, 2011
By
Why method of moments doesn’t always work

A number of years ago, someone asked me "why does my company need actuaries to fit curves, once I have the mean and standard deviation of my losses, isn't that enough?" I explained to him that not every distribution is completely determined by its mean...

Read more »

R-Bloggers

May 15, 2011
By
R-Bloggers

This is my first post on the R-Bloggers feed. R-Bloggers is an excellent collection of R-related blogs and sites for R enthusiasts. Add it to your bookmark list, for those who haven’t already done so, and my thanks to those who maintain the site ...

Read more »

Describing Data: Frequently Used Commands

May 13, 2011
By
Describing Data: Frequently Used Commands

Obtaining a coherent numerical summary of data is a common task, and it is common to want to port these summary statistics into a table of results. When I am in interactive mode with my data, I use the summary() command applied to my data frame. For ...

Read more »

Describing Data: Frequently Used Commands

May 13, 2011
By
Describing Data: Frequently Used Commands

Obtaining a coherent numerical summary of data is a common task, and it is common to want to port these summary statistics into a table of results. When I am in interactive mode with my data, I use the summary() command applied to my data frame. For ...

Read more »

XLConnect: Frequently Asked Questions

May 12, 2011
By
XLConnect: Frequently Asked Questions

In the two months since the first release of XLConnect we have received some great feedback from the community. Most questions we saw seemed to cluster around a few central topics – memory issues, font styling and Excel feature support. … Continue reading →

Read more »

R you ready for this? Statistics for free!

May 7, 2011
By
R you ready for this? Statistics for free!

If you’ve listened to the show for a while or if you’ve been reading the paleocave blog from the beginning (like when we actually used to update it regularly), then you might know that I’m rather fascinated with statistics. Imagine my delight a few years ago when I found out that one of the most

Read more »

Computing Odds Ratios in R

Computing Odds Ratios in R

In my last post, I discussed the use of odds ratios to characterize the association between edibility and binary mushroom characteristics for the mushrooms characterized in the UCI mushroom dataset.  I did not, however, describe those co...

Read more »

sab-R-metrics: Logistic Regression

May 5, 2011
By
sab-R-metrics: Logistic Regression

It's been a while since my last sab-R-metrics post, and I have not gotten to the real fun stuff yet. I apologize for the long layoff, and it's likely that these will be sparse for the next couple weeks. I have had some consulting opportunities come u...

Read more »