uses of spss and excel to analyze data

Bangladesh University of Professionals

Presentation on

Uses of SPSS and Excel to analyze data

Presented ByKudrat-E-KhodaID No- M1415019Course Title- Business Statistics (BUS 504)Program- MBA, Batch- 15th

Submitted ToCharls Darwin

LecturerFaculty of Business Studies

Bangladesh University of Professionals (BUP)

INTRODUCTION

FEATURE & BENEFITS

WHY SPSS?

RESEARCH & DEVELOPMENT

SPSS INTERFACE

USING SPSS

FREQUENCY ANALYSIS

CONCLUSION

CONTENTS

INTRODUCTION• SPSS is a software package used for conducting statistical

analysis, manipulating data, and generating table and graphs that summarize data.

• SPSS performs statistical analysis range from basic descriptive statistics, such as average and prevalence, to advanced inferential statistical, such as regression model, analysis of variance, factor analysis etc.

• SPSS also contains several tools for manipulating data, including functions for recording data, macros programming on visual basic editor, merging data, and aggregating complex data sets.

FEATURES AND BENEFITS • For Small And Medium Enterprises (SME)

– Resources & best practices.

– Techniques for cleaning data.

– Access Data in Relational Databases.

• For Large Scale Enterprises (LSE)

– Real time processing and online mapping.

– Online Database connectivity different networks.

– Data import & export data from different medium like SAS, Statistica.

– Compliances and Validations.

What are the options?• Many commercial products available

– SAS, Statistica, Minitab, and others

• Excel

– Widely available (part of MS Office Suite)

– Not a statistical software – spreadsheet

– Finance, math, and statistics applications

• SPSS

– Robust software for sophisticated statistical applications

– Upgrade with add-ins

WHY SPSS?• Strengths

– Very robust statistical software– Many complex statistical tests available– Good “stats coach” help with interpreting results– Easily and quickly displays data tables– Can be expanded

• Using the syntax feature • Purchasing add-ins

• Limitations – Can be expensive – Not intuitive to use

• Typically requires additional training to maximize features (at a cost) – Graphing feature not as simple as Excel

RESEARCH & DEVELOPMENTData presentation is one of the most crucial steps in research. The uses of SPSS helps the researcher to make the research work more scientific and reliable as a number of different statistical tools like ANOVA, paired t- test, chi squire test, exploratory factor analysis (EFA) and so on.

•Quality and Manufacturing.

•Compliance and Validation..

•Empower Researcher with Tools.

•Regulatory Safety Testing.

•Clinical Trails.

•Data Mining in Drug Discovery.

05/02/2023 Data Analysis with SPSS

SPSS INTERFACE Cell Editor Variable Names Max, Min, Close

Title Bar

Menu Bar

Button Bar

Row # :col

View Tabs

ScrollBar

ActiveCell

‘Data View’ is where the numbers are inputted e.g. Survey responses

SPSS INTERFACE (cont…)

‘Variable View’ is where you see behind the data i.e. where you tell SPSS what the numbers represent

SPSS INTERFACE (cont…)

This is what Data View looks like with some content added

SPSS INTERFACE (cont…)

Each row is a respondent’s answers to a survey

SPSS INTERFACE (cont…)

Each column contains all the answers to a particular question by all respondents

SPSS INTERFACE (cont…)

Each variable can be named. No spaces or special characters are allowed (just keep it to simple one word names)

SPSS INTERFACE (cont…)

SPSS can deal with words as well as numbers, but the ‘Type’ of data should mostly be numeric.

Data made up of words is called ‘String’ data

SPSS INTERFACE (cont…)

This is where you can give your variable a meaningful label.

This will be the label that appears in tables and graphs

The ‘value’ tab is where you turn your numbers into meaningful values. E.g. 1 = Female, 2 = Male

Using of SPSSFREQUENCY ANALYSISFrequency analysis is a descriptive statistical method that shows

the number of occurrences of each response chosen by the respondents. We can also calculate the mean, median, and mode to help users analyze the results and draw conclusions.

CROSSTABSCrosstabs are used to examine the relationship between two

variables. Data ManipulationData files are not always ideally organized in a form to meet

specific needs. For example, users may wish to select a specific subject or split the data file into separate groups for analysis.

05/02/2023 20

SPLITTING A FILEIf we wish to compare the response or performance differences by groups within one

variable, it is best to use the split files option.

FIND AND REPLACEIn this software we can use the Find and Replace function is more efficient to use.

Users can use Find and Replace in Data View. However, only the Find function is available for users in Variable View.

ReportingOnce the statistical analysis is complete, the final step is to create a report. In the

report, we may include PASW Statistics output (e.g., graphs and tables) for supporting your analysis. Using the Copy and Paste functions, the tables/graphs generated in PASW Statistics can be copied from the Output Viewer window and pasted into a Microsoft Word document without having to create new tables or graphs.

Using of SPSS (Cont…)

FREQUENCY ANALYSIS

To perform frequency analysis:1. Click the Open button on the Data Editor

toolbar. The Open Data dialog box opens.2. Locate and open the “Part 1.sav” file.3. Click the Analyze menu, point to Descriptive

Statistics, and select Frequencies. The Frequencies dialog box opens.

4. Select the variable(s) desired to be analyzed. In this case, select the variable “Computer Owned” from the list box on the left.

5. Click the transfer arrow button . The selected variable is moved to the Variable(s): list box.

6. Select the Display frequency tables check box if necessary.

Frequency analysis is a descriptive statistical method that shows the number of occurrences of each response chosen by the respondents. We can also calculate the mean, median, and mode to help users analyze the results and draw conclusions.

7. Click the Statistics… button. The Frequencies: Statistics dialog box opens.

8. Select the Mean, Median, and Mode check boxes in the Central Tendency section; select the Std. deviation check box in the Dispersion section.

FREQUENCY ANALYSIS (CONT…)

9. Click the Continue button. This returns you to the Frequencies dialog box.

10. Click the OK button. An Output Viewer window opens and displays the statistics and frequency table

FREQUENCY ANALYSIS (CONT…)

Conclusion

So we can say that the SPSS software plays a significant role in the process of interpreting and analyzing of the data retrieved from various methods.

It also help to represent data in remarkable way.

ANY