Excel for Data Analytics 2

What's inside

Excel for Data Analytics 2: 12 courses, 241 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 12 complete courses, 241 lessons, 240 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Bayesian Statistics in Excel: Priors, Posteriors & Bayesian A/B Tests
• Nonparametric Statistics: Rank Tests, Spearman & Bootstrap
• Cross-Tabs & Chi-Square: Analysing Categorical Data in Excel
• Network & Graph Analysis in Excel: Degree, Paths & Centrality
• Customer Churn & Survival Analysis: Hazard Rates, Kaplan-Meier & Retention Curves
• Market Basket Analysis: Support, Confidence, Lift & Cross-Selling
• Causal Inference for Business: Difference-in-Differences, Matching & Natural Experiments
• ANOVA & Experimental Design in Excel: One-Way, Two-Way & Post-Hoc Tests
• Polling & Survey Sampling: Margin of Error, Weighting & Poll Averages
• E-commerce Cohort Analysis: Repeat Purchase, Revenue per Cohort & Payback
• Data Privacy in Practice: Pseudonymisation, k-Anonymity & Re-identification Risk
• Queue Simulation with Spreadsheets: Arrivals, Service Times & Waiting Lines

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	621
Series	The Tabellab Workbook, volume 2
Author	Babala Özdemir
Delivery	Instant download after payment