Vikom Institute
Sale!
statistics

EXCEL STATS

4.47$ 2.98$

Category:

Product Description

EXCEL BUSINESS STATS allow you to interlink the statistics with EXCEL. This booklet has 64 pages which contains maths formulas and excel formulas side by side. This booklet is the answer of the question that “WHY EXCEL MUST BE USE FOR STATS”. Here is the contents.

  1. Business Statistics
  2. Excel in Business Statistics
  3. Useful Definitions
    1. Population
    2. Sample
  4. Sample Statistic
  5. Basic Statistics
    1. SUM function
    2. COUNT function
    3. MIN Function
    4. MAX function
    5. RANGE
    6. MODE function
    7. AVERAGE function (Arithmetic Mean)
    8. MEDIAN function
    9. GEOMEAN function (Geometric Mean)
    10. HARMEAN function (Harmonic Mean)
    11. STDEV function (Standard Deviation)
    12. VAR function (VARIANCE )
    13. Coefficient of Variation
  6. SKEW function (Skewness)
  7. KURT function (Kurtosis)
  8. Descriptive Statistics
  9. Normal Distribution
    1. DIST function
    2. INV function
  10. Confidence Interval for the mean
  11. Standard Error
  12. Confidence Interval for the mean
  13. Test of Hypothesis Concerning the population mean
  14. Hypothesis
    1. Hypothesis Testing
    2. Type of Hypothesis Testing
    3. Steps involved in Hypothesis
    4. Hypothesis Testing in Excel
  15. ANOAVA ANAYLSIS (Analysis of Variances)
    1. Single-Factor ANOVA Test
    2. The Two-way ANOVA without Replication
    3. Two-Way ANOVA with Replication
  16. Goodness-of-Fit Test for Discrete Random Variables
  17. Test of Independence: Contingency Tables
  18. Test Hypothesis Concerning the Variance of Two Populations
  19. Linear Correlation and Regression Analysis
  20. COVARIANCE
  21. CORRELATION
  22. Regression equation
  23. Intercept
  24. EXCEL 2016 Statistics functions List
    1. Appendix – 1
  25. NORMAL DISTRIBUTION TABLE
    1. Appendix – 2
  26. Confidence Level table
    1. Appendix – 3
  27. Hypothesis Testing Examples

Reviews

There are no reviews yet.

Be the first to review “EXCEL STATS”

top
Vikom-institute @  Developed By Velik Technologies