Skip to main content
Menu Study Site Homepage
  • Student Resources
  • Help
  • Login

    Access

    • New User?
    • Request new password
    • Create a new account

Excel Statistics: A Quick Guide

Third Edition
by Neil J. Salkind

Student Resources

  1. Quick Guide Data Sets
  2. Check Your Understanding Data Sets

Quick Guide Data Sets

Download the Excel files to follow along with the book.

Click here to download all files

Download files individually below.

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

© 2023 Sage Publications Sage Publications India Pvt. Ltd.

Terms of Service • Copyright Notice • Privacy PolicyPrivacy Policy

Browser not supported close

You are using a browser version that is no longer supported by this website and could result in a less-than-optimal experience.

To ensure full site functionality, please use an alternative web browser or upgrade your version of Internet Explorer.

Internet Explorer Firefox Opera Google Chrome

To enhance your experience on our site, SAGE stores cookies on your computer. By continuing you consent to receive cookies. Learn more. Close