Qualitative & Quantitative Methods

    avatar
    Created by
    Amber Madou

    Subdecks (6)

    Cards (98)

    • Arithmetic mean
      Average
    • Mean
      The average value of the data
    • Formula of the mean
      =AVERAGE(data)
    • Formula of the standard error
      =STDEV.S(data)/SQRT(COUNT(data))
    • Standard Error
      A measure of the variability of sample means in a sampling distribution of means
    • Formula of the median
      =MEDIAN(data)
    • Median
      The middle number in a sorted list
    • Formula of the mode
      =MODE.SNGL(data)
    • Mode
      The value that appears most frequently in the data
    • Standard Deviation

      A measure of the amount of variation in the data relative to the mean
    • Formula of the standard deviation
      =STDEV.S(data)
    • Sample variance
      A measure of the amount of variation in the data relative to the mean
    • Formula of the sample variance
      =VAR.S(data)
    • Kurtosis
      A measure that defines how heavily the tails of a distribution differ from the tails of a normal distribution
    • Skewness
      A measure of asymmetry of the data distribution
    • Formula of the skewness
      =SKEW(data)
    • Range
      The difference between the smallest and largest values in the data
      → Maximum - Minimum
    • Minimum
      Smallest value
    • Maximum
      Largest value
    • Sum
      Is the total when you add up all the values in the data
    • Formula of the sum
      =SUM(data)
    • Count
      Is the number of values in your data
    • Largest (1)
      1st largest number in the data
    • Smallest (1)
      1st smallest number in the data
    • Correlation
      Correlation analysis measures how two variables are related
    • Formula of correlation
      → Data → data analysis → correlation
    • 0=symmetrical
      -1 to 1 = fairly skewed
      < -1 or >1 = highly skewed
    • If the kurtosis is a positive value, that means that the value has heavier tails than the normal distribution. If the kurtosis is a negative value, that means that the value has less heavy tails than the normal distribution.
      • A correlation of 1 indicates a perfect positive relationship.
      • A correlation of -1 indicates a perfect negative relationship.
      • A correlation of 0 indicates no linear relationship.