JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

Course Objectives:

• To highlight the importance of application of Statistical tools to Research Problem / Projects.
• To enable the practice of MS- EXCEL / SPSS.
• To demonstrate the management and analysis of data using graphs, tables, worksheets, pivot tables etc.
• To educate students on the significance of data from external Sources.
• To highlight the importance of statistical analysis for better decision making.

Course Outcomes

Students will be able to

• Understand the importance of the main functions of MS- Excel /SPSS.
• Practice advance Excel Tools for conduction of Data Analysis
• Evaluate Data Analysis using Pivot Tables and Pivot Charts.
• Analyze the Data using Descriptive Statistics
• Conduct various Parametric and Non-parametric Tests using MS Excel / SPSS .

UNIT - I: Introduction to Statistical Packages

MS – EXCEL or SPSS: Introduction, Uses, Functions

and Features of Statistical Packages, Getting started with Excel/SPSS, Highlights and Main Functions: Home, Insert, Page Layout, Formulae, Data, Review, View, Add-inns, Using Help Function, Customizing the Quick Access Toolbar.

UNIT - II: Creating and Using Templates

Working with Data: Entering, Editing, Copy, Cut, Paste,

Paste Special, Formatting Data and Using the Right Mouse Click, Saving, Page Setup, and Printing, Using Headers and Footers, Manipulating Data, Using Data Names and Ranges, Filters and Sort and Validation Lists.

UNIT - III: Data from External Sources

Using and Formatting Tables, Basic Formulae and Use of

Functions, Data Analysis Using Charts and Graphs, Managing, Inserting, and Copying Worksheets, Securing the Document, Advanced Formulae and Functions, Worksheet Features, Data Analysis using Pivot Tables and Pivot Charts.

UNIT - IV: Data Analysis – I

Tabulation, Bar Diagram, Multiple Bar Diagram, Pie Diagram, Measures

of Central Tendency: Mean, Median, Mode. Measures of Dispersion: Variance, Standard Deviation, Coefficient of Variation. Correlation and Regression Lines.

UNIT - V: Data Analysis – II

t-test, F-test, ANOVA One-way classification, Chi-square Test,

Independence of attributes. Time series: Forecasting Method of Least Squares, Moving Average Method. Inference and Discussion of Results.

Suggested Readings:

• R. Panneerselvam, Business Statistics Using MS Excel, Sage Publications, 2022.
• Glyn Davis, Branko Pecar, Business Statistics Using Excel, Oxford University Press, 2e, 2014.
• D P Apte: Statistical Tools for Managers USING MS EXCEL, Excel, 2012.
• David M Levine, David. F. Stephan & Kathryn A. Szabat, Statistics for Managers – Using MS Excel, PHI, 2015.
• Bruce Bowerman, Business Statistics in Practice, TMH, 5e, 2012.
• Ajai.S. Gaur, Sanjaya S. Gaur, Statistical Methods For Practice and Research, Response, 2009.  14 MBA SEMESTER - II