Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    final ppt Statistics with Computer Application(cheryl)

    Uploaded by

    cheryldialogo7

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    final ppt Statistics with Computer Application(cheryl)

    Uploaded by

    cheryldialogo7
    2 views23 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    2 views23 pages

    final ppt Statistics with Computer Application(cheryl)

    Uploaded by

    cheryldialogo7

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 23

    Statistics with

    Computer
    Application
    CHERYL G. DIALOGO
    Discussant

    CRISTINE ROSE MONTENEGRO


    Professor
    SCRAMBLED LETTER
    1. DARDTAN TIONDEVIA
    2. ECNAVARI
    3.SISTOKUR
    4.SSNEWEKS
    SCRAMBLED LETTER
    1. DARDSTAN TIONDEVIA
    STANDARD
    DEVIATION
    2. ECNAVARI
    3.SISTOKUR
    4.SSNEWEKS
    SCRAMBLED LETTER
    1. DARDSTAN TIONDEVIA
    STANDARD
    DEVIATION
    2. ECNAVARI
    VARIANCE
    3.SISTOKUR

    4.SSNEWEKS
    SCRAMBLED LETTER
    1. DARDSTAN TIONDEVIA
    STANDARD
    DEVIATION
    2. ECNAVARI
    VARIANCE
    3.SISTOKUR
    KURTOSIS
    4.SSNEWEKS
    SCRAMBLED LETTER
    1. DARDSTAN TIONDEVIA
    STANDARD
    DEVIATION
    2. ECNAVARI
    VARIANCE
    3.SISTOKUR
    KURTOSIS
    4.SSNEWEKS

    SKEWENESS
    STANDARD
    DEVIATION
    AND
    VARIANCE
    OBJECTIVES:
    • define the variance and standard
    deviation;
    • compute for the variance and
    standard deviation of a group data;
    • formulate solution using excel;
    OBJECTIVES
    • Define standard deviation and
    variance;
    • Identify the skewed and kurtosis;
    • Formulate solution using Excel;
    •
    What are the Variance
    and Standard Deviation?
    in statistics, Variance and standard
    deviation are related with each other
    since the square root of variance is
    considered the standard deviation for
    the given data set.
    What is Standard Deviation?

    A standard deviation (or σ) is a measure of


    how dispersed the data is in relation to the mean.
    Low, or small, standard deviation indicates data are
    clustered tightly around the mean, and high, or
    large, standard deviation indicates data are more
    spread out.
    WHAT IS VARIANCE?
    Variance is a measure of how data points
    differ from the mean. According to Layman, a
    variance is a measure of how far a set of data
    (numbers) are spread out from their mean
    (average) value. Variance means to find the
    expected difference of deviation from actual
    value.
    Measures of Skewness and Kurtosis
    Skewness refers to the degree of symmetry, or
    more precisely, the degree of lack of symmetry.
    Distributions, or data sets, are said to be
    symmetric if they appear the same on both
    sides of a central point. Kurtosis refers to the
    proportion of data that is heavy-tailed or light-
    tailed in comparison with a normal distribution.
    What Is Skewness?
    Skewness is used to measure the level of asymmetry in our
    graph. It is the measure of asymmetry that occurs when
    our data deviates from the norm.

    Sometimes, the normal distribution tends to tilt more on


    one side. This is because the probability of data being
    more or less than the mean is higher and hence makes the
    distribution asymmetrical. This also means that the data is
    not equally distributed. The skewness can be on two types:
    1. Positively Skewed: In a distribution that is
    Positively Skewed, the values are more concentrated
    towards the right side, and the left tail is spread out.
    Hence, the statistical results are bent towards the left-
    hand side. Hence, that the mean, median, and mode are
    always positive. In this distribution, Mean > Median >
    Mode.
    2. Negatively Skewed: In a Negatively Skewed
    distribution, the data points are more concentrated
    towards the right-hand side of the distribution. This
    makes the mean, median, and mode bend towards the
    right. Hence these values are always negative. In this
    distribution, Mode > Median > Mean.
    What Is Kurtosis?
    Kurtosis is used to find the presence of outliers in our
    data. It gives us the total degree of outliers present.

    The data can be heavy-tailed, and the peak can be flatter,


    almost like punching the distribution or squishing it. This is
    called Negative Kurtosis (Platykurtic). If the distribution is
    light-tailed and the top curve steeper, like pulling up the
    distribution, it is called Positive Kurtosis (Leptokurtic).
    The expected value of kurtosis is 3. This is observed in a
    symmetric distribution. A kurtosis greater than three will
    indicate Positive Kurtosis. In this case, the value of kurtosis
    will range from 1 to infinity. Further, a kurtosis less than
    three will mean a negative kurtosis. The range of values
    for a negative kurtosis is from -2 to infinity. The greater
    the value of kurtosis, the higher the peak.
    VARIANCE
    EXAMPLE: Find variance of the given data set.
    Score of Grade 7 in mathematics summative test.
    Formula:
    Ⴟ = ξfx Scores f Classmark fx Ⴟ (x-Ⴟ) (x-Ⴟ)2 f(x-Ⴟ)2 Formula:
    (x)
    ξf
    36 - 40 3 σ2 = ξf(x-Ⴟ)2
    ξf-1
    Ⴟ= 31 - 35 11
    26 - 30 14 σ2 =
    21 - 25 10
    Ⴟ= σ2 =
    16 - 20 8
    10 - 15 4
    STANDARD
    DEVIATION
    Formula:

    • S.D = ξf(x-Ⴟ)2 σ2 = ξf (x-Ⴟ)2


    ξf – 1 ξf – 1

    • S.D = σ2 σ2 =

    • S.D =

    • S.D =
    SOLUTION OF STANDARD DEVIATION
    IN EXCEL

    XLSX Worksheet
    THANK YOU
    &
    GOD
    BLESS!!!

    You might also like