Explore BrainMass

Explore BrainMass

    Microsoft Excel Commands

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I need to know how to do this in EXCEL.. Thank you

    The question below appears in the attached file as well. You may find it easier to read in the attachment.

    Given the following population data: 1,2,4,5,8,9,12, and the lists of all samples of size 2 and 5:
    Samples of n=2 -xbar
    1,2--1.5
    1,4--2.5
    1,5--3
    1,8----------------------4.5
    1,9----------------------5
    1,12---------------------6.5
    2,4----------------------3
    2,5----------------------3.5
    2,8----------------------5
    2.9----------------------5.5
    2,12---------------------7
    4,5----------------------4.5
    4,8----------------------6
    4.9----------------------6.5
    4,12---------------------8
    5,8----------------------6.5
    5,9----------------------7
    5,12---------------------8.5
    8,9----------------------8.5
    8.12---------------------10
    9.12---------------------10.5

    For population
    s = ?
    m = ?

    For n = 2
    sxbar = ?
    mxbar = ?

    For n = 5
    sxbar = ?
    mxbar = ?

    Samples of n=5----------------xbar

    1,2,4,5,8----------------------4
    1,2,4,5,9----------------------4.2
    1,2,4,5,12---------------------4.6
    1,2,4,8,9----------------------4.8
    1,2,4,8,12---------------------5.4
    1,2,4,9,12---------------------5.6
    1,2,5,8,9----------------------5
    1,2,5,8,12---------------------5.6
    1,2,5,9,12---------------------5.8
    1,2,8,9,12---------------------6.4
    1,4,5,8,9----------------------5.4
    1,4,5,8,12---------------------6
    1,4,5,9,12---------------------6.2
    1,4,8,9,12---------------------6.8
    1,5,8,9,12---------------------7
    2,4,5,8,9----------------------5.6
    2,4,5,8,12---------------------6.2
    2,4,5,9,12---------------------6.4
    2,5,8,9,12---------------------7.2
    4,5,8,9,12---------------------7.6
    2,4,8,9,12---------------------7

    a) Use Excel to find the six ? values above.

    b) Consider the three values of mean and the three values of standard deviation in a). Verify (mathematically) that the Central Limit Theorem applies using the formulas:
    µ = µxbar and σxbar = σ / √n

    c) Why are your answers from a) and b) slightly off?

    © BrainMass Inc. brainmass.com March 4, 2021, 5:42 pm ad1c9bdddf
    https://brainmass.com/statistics/standard-deviation/microsoft-excel-commands-6868

    Attachments

    $2.49

    ADVERTISEMENT