How to view basic statistics quickly of a table or column | R for Excel Users & Beginners
The hardest thing with learning anything new is just starting. The idea behind R for Excel Users is purely for that, by using common excel tasks as examples, so that barrier to learning something new, is not quite so daunting.
In this video, I'll be covering how to quickly view statistical data from your dataset as a whole, or column at a time. Statistics covered are mean, median, quantiles, min and max.
📁 Data Set used can be found here -
https://data.world/deanchereden/covid...
📁 The R code file can be found here -
https://data.world/deanchereden/covid...
▶️ How to Download R & R Studio
• How to Download R & R Studio, Run R Studio...
▶️ How to Import CSV & XLSX Files into R Studio & View the Data
• How to Import CSV & XLSX Files into R Stud...
🔖c h a p t e r s 🔖
00:00 - Intro
00:17 - Quick overview
01:09 - Add data & view structure - str()
02:14 - View statistical data of each column in a dataset - summary()
03:24 - View statistical data of 1 column only - summary()
04:02 - View the mean of 1 column only - mean()
04:38 - Issues when there are n/a in columns
05:17 - Remove n/a - na.rm = TRUE
06:11 - Median - median()
06:31 - 1st, 2nd & 3rd Quantile - quantile()
08:05 - Min & Max - range()
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - / deanchereden
🎵 Music - Misha, Jussi Halme - Higher https://chll.to/4ec991f9
🙌 Follow Misha
・ SoundCloud: https://chll.to/386e721b
・ Spotify: https://chll.to/5f0bc9ba
・ Apple Music: https://chll.to/5a239af3
・ Chillhop: https://chll.to/2b2bc310
🙌 Follow Jussi Halme
・ Spotify: https://chll.to/dd4a82d2
・ Apple Music: https://chll.to/4961c878
・ Chillhop: https://chll.to/eb17b45e
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - Bliss (A Felicidade)...