╔══════════════════════════════════════════════════════════╗
║  FROM EXCEL TO R — Exercise File Pack                   ║
║  From Spreadsheets to Code Series — Book 4              ║
║  Waskey Press | www.waskeypress.com                     ║
╚══════════════════════════════════════════════════════════╝

SETUP
─────
1. Install R from cran.r-project.org
2. Install RStudio from posit.co/download/rstudio-desktop
3. Open RStudio → File → New Project → Existing Directory
   → select this folder (Book4_R/)
4. Open a script from scripts/ and run line-by-line with Ctrl+Enter

INSTALL PACKAGES (run once in the R Console)
─────────────────────────────────────────────
install.packages("tidyverse")    # dplyr, ggplot2, readr, tidyr...

FOLDER STRUCTURE
────────────────
scripts/       .R exercise files, one per chapter
  ch0_setup.R        Chapter 0  — Setup and First Look
  ch1_vectors.R      Chapter 1  — Vectors
  ch2_dataframes.R   Chapter 2  — Data Frames
  ch3_dplyr.R        Chapter 3  — dplyr (filter, select, mutate, summarise)
  ch4_ggplot2.R      Chapter 4  — Charts with ggplot2
  ch5_stats.R        Chapter 5  — Statistical Analysis
  ch6_rmarkdown.R    Chapter 6  — R Markdown Reports

data/          CSV datasets
  sales.csv       2,150 orders (2023-2024, 10 columns)
  employees.csv   150 employees
  products.csv    80 products with 12-month sales history

output/        Write your charts and reports here (ggsave output)

solutions/     Available at waskeypress.com/files

CONTACT
────────
waskeypress.com/files | contact@waskeypress.com
