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 &#963;xbar = &#963; / &#8730;n