Purchase Solution

Statistics: Using the Data Analysis Toolpac in Excel

Not what you're looking for?

Ask Custom Question

See the attached file.

I need some help getting started with this assignment. I don't want the assignment done for me. I just have no idea where to start. I have limited experience with Excel. The actual assignment is attached and it includes the instructions. I would appreciate it if someone was able to direct me on the first few steps of the assignment.

Purchase this Solution

Solution Summary

The expert uses the data analysis Toolpac in excel. The solution is attached in an excel file.

Solution Preview

1) 2)

So to re-format the data into one table to show changes.
This is very simple

You can create a new excel spread sheet. Then, you can format it in any that you want. You can show the 2000 data first, then the 2004 data side by side. I will show an example in my excel spread sheet.

I also formatted it by merging cells in the category section. You left click and choose format cells, and click 'format' and merge cells. You can try to play with that.

3) total Population

to do this, you have to add the numbers. I made a total column. Then to add up the total ...

Purchase this Solution

Free BrainMass Quizzes
Measures of Central Tendency

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

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.