Roselyn\'s SPSS vs. Excel PDF

Preview

Summary

Download Roselyn's SPSS vs. Excel PDF

Description

Overview In the digital economy, data have become a valuable commodity, much in the way that oil is in the rest of the economy (Wedel and Kannan 2016). Data enable market researchers to obtain valuable and novel insights. There are many new sources of data, such as web traffic, social networks, online surveys, and sensors that track suppliers, customers, and shipments. A Forbes (2015a) survey of senior executives reveals that 96% of the respondents consider data-driven marketing crucial to success. In this regard, we will compare the most leading statistical data analysis software used by data analysts. The IBM SPSS and the Microsoft Excel.

IBM SPSS SPSS Stands for statistical packages for Social Science. It is the market leader in terms of statistical packaging tools. There are several uses of SPSS that are considered 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.

Microsoft Excel Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager). It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface, for example, a stock analyzer, or in general, as a design tool that asks the user questions and provides answers and reports. In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule, analyze the results, make a Word report or PowerPoint slide show, and e-mail these presentations on a regular basis to a list of participants. Excel was not designed to be used as a database. Microsoft allows for a number of optional command-line switches to control the manner in which Excel starts.

Compare and Contrast. Discuss the similarities and differences of Excel and SPSS. In the process, identify and emphasize the advantages and disadvantages of these tools. Complete the table. SPSS Excel Similarities SPSS and Excel both consists of rows and columns. Their cells can be identified whether it’s number, date or text (string in SPSS). They are both used as data storage and data statistical analysis tool.  Excel is the Differences  There are two view mode spreadsheet itself. You in SPSS. The data view can change the cell and the variable view. type via Number Data view is like a Format to number, spreadsheet where you date, percentage and input the datas or text. Any cell (rows or numbers. The rows columns) could be the represent subjects, subject and participants or case. The participants or columns represent



Advantages



 Disadvanta ges





variable or a type of measurements. To change the variable type in columns you need to go to variable view and under the Type column (numeric, date, currency and string). SPSS is all about dealing with statistics algorithms. That’s why it’s always ready for the new statistics algorithm updates. It uses this algorithm for data manipulation. There is the analyze menu where you can find statistical menu depending on what statistical analyzation you want. Then it will direct you to another window where the output is done. The SPSS will do analyzation for you. It is good for data storage since it is made to be used as data storing. Complicated and too confusing to use. For example, the variable view could be just in menu just like in excel. It is purely for statically analyzation and data storing.

variable.



Excel is all about the combination of mathematics such as algebra, calculus, statistics, and advanced statistics and data storages in various formats.



Its simplistic and easy to understand. You can do any mathematical formula.



It doesn’t produce the result for you. You have to analyze everything and retype them on another sheet or in the same sheet. Though it is also used as data storing application, it lacks the process for a good data storing tools since its main purpose is for data computations. Microsoft office has another application for data storing which is the Microsoft Access.



Summarize the key features found in SPSS and Excel. Emphasize which features are important and identify the features that are not important in your chosen field of Accountancy....