Question

1. What are Excel and SPPS statistical tools?

2. What are the pros and cons of using each?

3. For each statistical  tool, provide at least one example of how it functions and what types of questions it will help to answer.

Answer 1

SPSS Stands for statistical packages for Social Science. It is the market leader in terms of statistical packaging tools. SPSS is used as the derivative for data manipulation and storage. It is having two methods for batch processing, i.e., interactive batches and noninteractive batches.

SPSS inc developed it, but later on, it was acquired by IBM in 2009. The earlier name of SPSS was “under the umbrella. But after acquiring by IBM, SPSS was renamed as IBM SPSS in 2015.

SPSS also comes with an open source version that is known as PSPP. This version has used the process of statistics and the formulation of data manipulation techniques with very few exceptions. These statistics and formulation are used for the professional manipulation of large data chunks.

The open source version of SPSS is quite decent, and it won’t expire in the future.

Anyone can use the same SPSS software for the lifetime. SPSS is one of the best analytical software that provides high-quality graphics for more analytical features.

The best part of this software is when you create standard graphics in this software. Then you can output the graphics as HTML5 files. It means that you can access these files through your browser too.

Excel

Excel is one of the most powerful and easy to use statistics software. It allows you to store the data in tabular format, i.e., in rows and column format. It also allows you to interact with your data in various ways.

You can sort and filter the data using some of the most potent formulas. The pivot tables one is the best feature of Excel. You can use pivot tables to create a new insight by manipulating the data.

Excel has various features that can help you with statistics. There are multiple ways to importing and exporting the data. You can also integrate the data into the workflow.

Like no other statistics software, Excel allows you to create the custom function using its programming abilities.

The primary purpose of Excel is to create records of data and to manipulate the data as per the users’ demands. As mentioned earlier, Excel allows you to use the external database to analyze, make reports, and so on.

Now a day, Excel is offering the best graphical user interface along with the use of graphics tools and visualization techniques.

Pros and Cons of excell

Pros =

1.Easy to program

2. multiple worksheets

3.Great for Calculation

4Table function allowed you to Fillter the Data 5.Anyone can use the excel

6.Has descent Graphics graph Chart etc to show your data.

Cons :=

1 . Its not data base.

2.Its not useful for storing the large scale data.

3.You can't run report's.

SPSS

Pros=

1.Easy to Understand

2.Usefull for quick Data Analysis.

3.Easy to import and export files.

Cons =

• Default graphics are far from publication quality. ...
• Information about effect size and confidence intervals is missing for many techniques. ...
• It is expensive compared to many competitive alternatives. ...
• Documentation about algorithms is sometimes difficult or impossible to find.