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.

Attachments
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.

View More Free Quizzes
Related BrainMass Solutions

  • Data Analysis and Reporting

    622963 Data Analysis and Reporting Using SPSS, analyze your survey data using descriptive statistics (mean, standard deviation, mode and variation, for categorical data use frequencies and percentages) and inferential statistics (correlation, regression

  • Methods of Data Analysis with Excel

    522550 Methods of Data Analysis with Excel Excel provides many different ways in which to analyze data. Discuss the different methods by which you can analyze data in your spreadsheet.

  • Real Estate Data: Statistical Analysis using EXCEL

    295647 Statistical Data Analysis using Excel See attached file. Assume you are researching about housing in a neighborhood encompassed by 5 townships in the attached Real Estate Data Set (Excel).

  • Sample Mean, Variance, Standard Deviation and Quartiles

    Using the box and whisker method identify potential outliers. (Careful data is given in descending order!) - Using Data ? Descriptive Statistics ? Summary statistics find mean and standard deviation.

  • Descriptive Statistics Data Analysis

    This solution contains a data analysis to calculate the measures of central tendency, dispersion and skew of the data. It shows the descriptive statistics for different variables using Microsoft Excel 2007 and their associated graphs.

  • Descriptive Statistics and Histogram

    the appropriate tool in the data analysis toolpak in Excel, calculate the descriptive statistics.

  • Presentation on definitions, and uses of statistics

    You can find the formula for all these functions in any spreadsheet program. In MS Excel, you may have to load the "Data Analysis ToolPak". To do this follow these steps: o Click on the Microsoft Office Button in the far upper left.

  • How to Perform Multiple Regression with Excel and Megastat

    You might ask, "Why don't I just use the internal functions of Excel or Excel's Data Analysis ToolPak?"

  • Portfolio analysis.

    If this does not appear as an option, you have to do an "add-in" for the analysis tool pak. Under data analysis, you can select descriptive statistics, summary statistics, for the means and standard deviation (return and risk).

View More Related Solutions