Excel Analysis

Excel is probably the most commonly used spreadsheet for PCs. Newly purchased computers often arrive with Excel already loaded. It is easily used to do a variety of calculations and includes a collection of statistical functions and a Data Analysis ToolPak.

As a result, if you suddenly find you need to do some statistical analysis, you may turn to it as the obvious choice. We decided to do some testing to see how well Excel would serve as a Data Analysis application.

To present the results, we will use a small example. The data for this example is fictitious. It was chosen to have two categorical and two continuous variables so that we could test a variety of basic statistical techniques.

Obi services excel analysis
  • 1

    Results of Analyses

    The quickest way to get means and standard deviations for a entire group is using Descriptives in the Data Analysis tools. You can choose several adjacent columns for the Input Range (in this case the X and Y columns), and each column is analyzed separately. The labels in the first row are used to label the output, and the empty cells are ignored. If you have more, non-adjacent columns you need to analyze, you will have to repeat the process for each group of contiguous columns. The procedure is straightforward, can manage many columns reasonably efficiently, and empty cells are treated properly.

    A statistical package lets you choose as many variables as you wish for descriptive statistics, whether or not they are contiguous. You can get the descriptive statistics for all the subjects together, or broken down by a categorical variable such as treatment. You can select the statistics you want to see once, and it will apply to all variables chosen. 

    Obi services excel analysis results of analyses
  • 2

    Requesting Many Analyses

    If you had a variety of different statistical procedures that you wanted to perform on your data, you would almost certainly find yourself doing a lot of sorting, rearranging, copying, and pasting of your data.

    This is because each procedure requires that the data be arranged in a particular way, often different from the way another procedure wants the data arranged. In our small test, we had to sort the rows in order to do the t-test and copy some cells in order to get labels for the output.

    We had to clear the contents of some cells in order to get the correct paired t-test but did not want those cells cleared for some other test. And we were only doing five tasks. It does not get better when you try to do more.

    There is no single arrangement of the data that would allow you to do many different analyses without making many different copies of it. The need to manipulate the data in many ways greatly increases the chance of introducing errors.

    Obi services excel analysis requesting many analyses
  • 3

    General Issues

    Output location. The output from each analysis can go to a new sheet within your current Excel file (this is the default), or you can place it within the current sheet by specifying the upper left corner cell where you want it placed. Either way is a bit of a nuisance. If each output is in a new sheet, you end up with lots of sheets, each with a small bit of output. 

     If you place them in the current sheet, you need to place them appropriately; leave room for adding comments and labels; changes you need to make to format one output properly may affect another output adversely. Example: Output from Descriptives has a column of labels such as Standard Deviation, Standard Error, etc. You will want to make this column wide in order to be able to read the labels. But if a simple Frequency output is right underneath, then the column displaying the values being counted, which may just contain small integers, will also be wide. 

    Obi services excel analysis general issues

Why Choose OBI Services?

OBI Services team has assisted several businesses worldwide. As a distinguished data entry service provider, we ensure reliable and accurate data entry services.
Why choose OBI Services Excel Analysis Data Entry Services

A Combined 20 Years of Experience

With a combined 20 years of experience in this field, we assure you that our team will only give nothing but the best in all our services.
A combined 20 years of experience OBI Services Excel Analysis Data Entry Services

QUALITY

Data are carefully evaluated based on your requirements, and undergoes a control check before sending.
OBI Services Excel Analysis Data Entry Services Quality

AVAILABLE

Final output is delivered within the specified timeline.
OBI Services Excel Analysis Data Entry Services Available

FLEXIBLE

OBI Services is flexible in what you need. You tell us your requested task and we will work on ways that can accommodate them. You can change tasks and services anytime and we ensure to cater them all.
OBI Services Excel Analysis Data Entry Services Flexible

RELIABLE

Flexibility is also about volume. Do you only need 1 staff or 100? No worries, as OBI Services is the leading outsource provider, rest assured we can cater to all your needs.
OBI Services Excel Analysis Data Entry Services Reliable

SUPPORT

You can be at ease with our 24/7 Customer Support.
OBI Services Excel Analysis Data Entry Services Support

WORTH IT

Each task is being priced by the amount of time and difficulty it requires.
OBI Services Excel Analysis Data Entry Services Worth it

OBI Services, your go-to Data Entry Outsource Provider

We offer affordable prices and also Performance-Based Pays while ensuring you get your money’s worth. With our guaranteed quality services, OBI Services is your go-to Data Entry Outsource Provider.
 

What are you waiting for?