Skip to content

R for Excel Users

Menu
  • Home
  • Book

Category: Thought Starters & Analysis

Conditional Formatting in R
Thought Starters & Analysis

Learning Analytics? Crawl Before you Walk

[This post was also published on LinkedIn.] Today I met a colleague in the marketing team in Ireland. He is taking one of these popular online Data Analytics courses and …

Thought Starters & Analysis

Time Series Clustering of Baby Names

Who names their kids John anymore?! Kids don’t know what an awesome name they’re missing out on. It makes me wonder which other names are fading away. Which ones are …

Thought Starters & Analysis

Names at a Party – Bootstrap Sampling with R

You’re strolling in the park and bump into a party of 30 babies. What is the chance that at least two of them have the same name? We’re going to …

googleVis - Distinct Names per Million Births
Thought Starters & Analysis

The growing number of baby names – using dplyr

So many friends and family members have had babies in the past few years, and I can’t think of a single baby whose name has been repeated. Are parents getting more …

Excel Stuff Done in R

  • Find nth largest or smallest in a group
  • Calculate percent of column in R
  • How to do MID, RIGHT an LEFT in R
  • Excel Formulas and R Functions
  • Column to Text in R

General R Stuff

  • Calculate percent of row in R
  • How to Remove Dollar Sign in R (and other currency symbols)
  • Looping: lapply, sapply, mapply & apply
  • Delete Data Frame in R
  • R Vectors: A Must-Learn

Thought Starters & Analysis

  • Learning Analytics? Crawl Before you Walk
  • Time Series Clustering of Baby Names
  • Names at a Party – Bootstrap Sampling with R
  • The growing number of baby names – using dplyr
Copyright © 2021 R for Excel Users – OnePress theme by FameThemes