We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

# Descriptive Statistics using Excel Essay Sample

The whole doc is available only for registered users OPEN DOC
• Pages:
• Word count: 692
• Category: data

Get Access

## Descriptive Statistics using Excel Essay Sample

Open the Excel spreadsheet labeled “Example Database.” The first page is the Data Dictionary. The Variable Label is the “handle” used for computation. The Variable Name is longer and more descriptive. The Values column shows the numerical values associated with categorical variables. In the data dictionary, you can see that the only categorical (nominal) variable is SEX. The others are ratio variables (why?)

Click on the Data tab, which opens the window with the data.

We wish to obtain descriptive statistics for these data. The next step is to click on the Data tab at the top of the window.

The Data tab presents a number of data-related options. Click on the “Data Analysis” button. If you don’t see this button, the data analysis package will have to be installed. See the “Background Information” for a tutorial on how to install it.

Select “Descriptive Statistics” as shown, then click OK. This brings up the Descriptive Statistics dialog, shown below.

The program needs to know where to find the data you want analyzed. Click the icon on the right-hand side of the Input Range window. This takes you back to the Data window.

In the data window, click and drag to highlight the cells containing the data you want to analyze. Be sure to include the top line, which includes the labels. Select the cells from A1 to D13. (Excel writes this “\$A\$1:\$D\$13,”) to indicate that we’re talking about the cell addresses and not the data in the cells, which may change from one iteration of the test to another.)

Click the icon shown above to go back to the Descriptive Statistics dialog.

The “Input Range” window, at the top of the dialog box, now contains the range of data cells. Before clicking OK, make sure:

the “Group By” Columns radio button is selected.
the “Labels in the First Row” box is checked.
the “Summary Statistics” box is checked.

The last decision is where to write the results. You could go into any window and select a range of cells, following a procedure similar to the one used to locate the data. However, let’s write the results to a new worksheet. Under Output Options,

click the radio button for New Worksheet Ply
enter the new worksheet name. Call it Output.

After everything is entered, click OK.

The results appear on a new worksheet entitled “Output.” Unfortunately, it’s not very legible. We’ll fix that. Click on the “Home” tab.

Next, click on “Cells-Format.” Under this menu, click on “Autofit Column Width” (not shown).

A portion of the formatted output is shown above.
The usefulness of the statistics depends upon the nature of the data. SEX is a categorical variable, with values of either 1 or 2. The “mean” of 1.42 doesn’t mean much, except that the data set contains more men (1) than women (2). The standard deviation is equally meaningless.

AGE, on the other hand, is a ratio variable. It makes sense to speak of the mean, median, mode (there isn’t one, in these data) and the standard deviation. The program also provide the range (maximum value minus minimum value), the minimum value, and the maximum value. “Sum” is the … well, the sum… of all the values, and in this case indicates that the people we’re looking at earned a total of \$421,000. “Count” is the number of cases … in this example, the number of people for whom we have data.

Suppose we want statistics for the men only.

In the Data window, click and drag to highlight the columns containing the data. Then, click the Data tab.

In the Data window, click on Sort.

In the Sort dialog box, select the variable on which you wish to sort the data. Notice that it’s possible to sort by multiple variables. See Excel “Help” for more information.

The sorted data are shown above.
To obtain summary statistics for the men only, repeat the process described at the top; but when locating the data for analysis, select ONLY rows 1 through 8, as shown below.

We can write a custom essay

Order an essay

## You May Also Find These Documents Helpful

Roles and responsibilities of data users

In order to successfully gather data from the users, conducting an interview must be a good idea. Hence that may insufficient as users may not able to describe everything by themselves as the ideal meaning may not portrays only by words. So that it is better if the user can be observed while they use an interface they currently use which may portrays much information....

Data Handling - ICT

Choice of Problem When asked to think of ideas to base my ICT course work on I came up with the following; * Make over salon * Modelling agency * School health centre * Job centre * A tracing family trees agency I decided on the job centre for a number of reasons; * This idea was original; no one else in my year was...

Estate Agents - Problems of a Paper...

Introduction An estate agent based in a paper-based office comes across a lot of problems. It necessary to solve these problems and try to bring the system of the basic system and improve to be more efficient and more reliable in a working area. The firm is in an area that is equally part urban and part rural. Further more because of this area people...

Database Analysis and Database Design Project -...

Moving Images operates a DVD library. The library has a large number of titles, each title having at least one copy. Each title falls into a specific category some of these are adventure, thriller, fantasy, action or education. (There are others) All titles are loan only to registered members of Moving Images. Information is keep about the members is only personal details including name, address...

The ICT Theory

Data All the data for the new system will have to be collected together. All the names, addresses and phone numbers of all the client's contacts will need to be put together so that it will be easier to input the data to the new system. To collect the data together there will need to be a data sheet designed. One of the client members...

### Essays 57,473

300+
Materials Daily
100,000+ Subjects
2000+ Topics
Free Plagiarism
Checker
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

Sorry, but only registered users have full access

immediately?

Become a member

Thank You A Lot!

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?

Couldn't Find What You Looking For?