Here you will find daily news and tutorials about R, contributed by over 750 bloggers.
There are many ways to follow us - By e-mail:On Facebook: If you are an R blogger yourself you are invited to add your own R content feed to this site (Non-English R bloggers should add themselves- here)

Microsoft Excel is perhaps the most popular data anlysis tool out there. While arguably convenient, spreadsheet software is error prone and Excel code can be very hard to review and test.

After successfully completing this exercise set, you will be able to prepare a basic Excel document using just R (no need to touch Excel yourself), leaving behind a reproducible R-script.

Learn some of the differences between working in Excel with regression modelling and R

Learn about different statistical concepts

And much more

Exercise 5
Apply ‘freeze pane’ on the top row.

Exercise 6
Set width of columns 1 through 5 to 12, that is 84 pixels.

Exercise 7
Use Font, CellBlock and CB.setFont to make the header in bold.

Exercise 8
Using tapply generate a table with the mean of ‘petal width’ by species and write to a new sheet called pw, from row 2 down.

Exercise 9
Add a title in cell A1 above the table, merge the cells of the first three columns.

Exercise 10
Save your workbook to your working directory and open using Excel. Go back to R and continue formatting and adding information to your workbook at will.