Excel Statistics: A Quick Guide
Third Edition
Quick Guide Data Sets
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