Download the Excel files to follow along with the book.

Click here to download all files

Download files individually below.

• Q1. AVERAGE.xlsx
   
• Q2. AVERAGEA.xlsx
   
• Q3. MEDIAN.xlsx
   
• Q4. MODE.SNGL_.xlsx
   
• Q5. MODE.MULT_.xlsx
   
• Q6. GEOMEAN.xlsx
   
• Q7. STDEV.S.xlsx
   
• Q8. STDEV.P.xlsx
   
• Q9. VAR.S.xlsx
   
• Q10. VAR.P.xlsx
   
• Q11. FREQUENCY.xlsx
   
• Q12. NORM.DIST_.xlsx
   
• Q13. PERCENTILE.INC_.xlsx
   
• Q14. PERCENTRANK.INC_.xlsx
   
• Q15. QUARTILE.xlsx
   
• Q16. RANK.AVG_.xlsx
   
• Q17. STANDARDIZE.xlsx
   
• Q18. COVARIANCE.xlsx
   
• Q19. CORREL.xlsx
   
• Q20. PEARSON.xlsx
   
• Q21. INTERCEPT.xlsx
   
• Q22. SLOPE.xlsx
   
• Q23. TREND.xlsx
   
• Q24. FORECAST.xlsx
   
• Q25. RSQ.xlsx
   
• Q26. CHISQ.DIST_.xlsx
   
• Q27. CHISQ.TEST_.xlsx
   
• Q28. F.DIST_.xlsx
   
• Q29. CONFIDENCE.NORM_.xlsx
   
• Q30. F.TEST_.xlsx
   
• Q31. T.DIST_.xlsx
   
• Q32. T.TEST_.xlsx
   
• Q33. Z.TEST_.xlsx
   
• Q34. SMALL.xlsx
   
• Q35. LARGE.xlsx
   
• Q36. AVERAGEIF.xlsx
   
• Q37. COUNT.xlsx
   
• Q38. COUNTA.xlsx
   
• Q39. COUNTBLANK.xlsx
   
• Q40. COUNTIF.xlsx
   
• Q41. DESCRIPTIVE STATISTICS.xls
   
• Q42. MOVING AVERAGE.xls
   
• Q43. RANDOM NUMBER GENERATOR.xlsx
   
• Q44. RANK AND PERCENTILE.xlsx
   
• Q45. SAMPLING.xlsx
   
• Q46. ZTEST.xlsx
   
• Q47. TTEST - PAIRED.xlsx
   
• Q48. TTEST - UNEQUAL.xlsx
   
• Q49. TTEST - EQUAL.xlsx
   
• Q50. ANOVA - SINGLE FACTOR.xlsx
   
• Q51. ANOVA - WITH REPLICATION.xlsx
   
• Q52. ANOVA - WITHOUT REPLICATION.xlsx
   
• Q53. CORRELATION.xlsx
   
• Q54. REGRESSION.xlsx
   
• Q55. HISTOGRAM.xlsx