Statistical Data Analysis Lab detailed Syllabus for MBA (Human Resource), R22 regulation has been taken from the JNTUH official website and presented for the students affiliated to JNTUH course structure. For Course Code, Subject Names, Theory Lectures, Tutorial, Practical/Drawing, Credits, and other information do visit full semester subjects post given below. The Syllabus PDF files can also be downloaded from the universities official website.
For all other MBA (Human Resource) 1st Sem Syllabus for R22 Regulation JNTUH, do visit MBA (Human Resource) 1st Sem Syllabus for R22 Regulation JNTUH Subjects. The detailed Syllabus for statistical data analysis lab is as follows.
Course Objectives:
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
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
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
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
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
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 and 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.
For detail Syllabus of all other subjects of MBA Human Resource, R22 scheme do visit Human Resource 1st Sem Syllabus for R22 scheme.
For all the MBA results, visit JNTUH MBA Human Resource all semester results direct links.