Dr. Mark Gardener

Home
About

Providing training for:

  • Ecology
  • Data analysis
  • Statistics
  • R The statistical programming language
  • Data management
  • Data mining

Tips and Tricks - for R and Excel

On these pages you can find tips, tricks and hints for using both R and Excel. The lastest tip is previewed at the top and you can follow the see more link to view the entire posting. There is an index of R tips and a corresponding index of Excel tips.

For most analytical purposes the combination of Excel and R is unbeatable! Excel is great as a data management tool and for preparing data for analysis. You can also use it to get an overview of your data or to make simple (and not so simple) graphs. R is an analytical "swiss army knife" and can carry out a mind-boggling array of analytical routines as well as producing great graphics.

Tips & Tricks for R | Tips & Tricks for Excel | An Introduction to R | MonogRaphs | Writer's Bloc


 

Latest Tip

Jun 16th 2016
Index of R Tips Index of Excel Tips
 

Use multiple columns as row names

Top

Use multiple columns as row names

Sometimes your data contains more than one column that you want to use as labels. You may want "combination" labels for graphs or perhaps to use as row names.

This is where the paste() command comes in useful, as it allows you to combine items into a new item...

...see more.


Follow me...
Facebook Twitter Google+ Linkedin Amazon
More links:

An introduction to R

See my Publications about Excel, R, statistics and data analysis Courses in R, data analysis, data management and statistics Visit the R Project website
 

Writers' Bloc – my latest writing project including R scripts

Tips for Excel

Top

Tips & Tricks for using R

A collection of useful hints, tips and tricks for using R: The Statistical Programming Language


Index of R Tips
(Newest first)

 

Tips for R

Top

Tips & Tricks for using Excel

A collection of useful hints, tips and tricks for using Excel


Index of Excel Tips
(Newest first)
 

See my Publications about statistics and data analysis.

MonogRaphs: random topics in R

Writer's Bloc – my latest writing project includes R scripts

Courses in data analysis, data management and statistics.


See DataAnalytics on Facebook

Top

DataAnalytics.org.uk on Facebook:

Top Home
Data Analysis
Contact GardenersOwn Homepage