Purchase Solution

Microsoft Excel Commands

Not what you're looking for?

Ask Custom Question

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?

Attachments
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Microsoft Excel Worksheet Function

    60081 Microsoft Excel Worksheet Function Select the worksheet function that will return the largest number in a specified range of cells, the function should ignore text and logical values.

  • interface features

    Microsoft Word ? Microsoft Excel ? Microsoft PowerPoint ? Microsoft Outlook 1. The common user interface and features in the Microsoft Office application: In Microsoft Office suite, the individual applications share many common features.

  • Microsoft Office applications

    Be sure to list your installed version for all of these required applications: Microsoft Word Microsoft Excel Microsoft PowerPoint Microsoft Outlook 1.

  • equtions typed using WORD equation editor

    96689 Microsoft Word Equation (See attached file for full problem description) --- 1. Access Microsoft Word. 2. To start the Equation Editor, use the menu choice Insert / Object; under the Create New tab, select Microsoft Equation 3.0. ?

  • software categories

    Application software: these are Microsoft Word (word processor), Adobe Photoshop (graphic tool), Excel (spreadsheets), Microsoft Access (database), Games and Communication (chat room).

  • Drawing Venn Diagram for Gas Well Completions

    NOTE: You can use the drawing commands in Microsoft Excel to draw the Venn diagram. You can also make the diagrams rectangles instead of circles if that is easier. Please explain how to draw a Venn diagram.

  • Microsoft SQL Server

    This is definitely not the correct way. the following sentences are tested and can be work in Microsoft SQL Server . SELECT DISTINCT Type, AVG(Price) AS 'AVG(Price)' FROM book GROUP BY Type Microsoft SQL Server help is attained.

  • Help Please

    Click the Other Task Panes drop-down list Shows the different task panes. 4.to obtain help in Microsoft Office: Microsoft Office supplies a Help system that makes it easy for you to look up information on application commands and features as

  • PC Commands: Copy, Xcopy, Chkdsk, Scandisk

    Microsoft has A HUGE REFERENCE of information about these copy commands and their syntax and parameters.

  • Excel functions for use in statistics

    Between the three spreadsheets, all solutions are in Excel. Be sure to place your cursor in the answer cells to see the Excel formula commands used in each case.

View More Related Solutions