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.