Statistics for Business Decisions Practical

Paper Code: 
CBBA 402
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

Course Objectives:

• Calculate the correlation between two variables. & simple/Multiple linear regression equation for a set of data using MX Excel/SPSS

• Apply concepts of Probability distributions in Decision making in a simulated environment • Apply hypothesis tests on data in MS Excel/ SPSS for comparing means & Utilize them for decision making.

• Apply hypothesis tests on data in MS Excel/ SPSS for comparing variance using Chi Square test & ANOVA and Utilize them for decision making.

Course Outcomes (COs): 

 

Learning outcomes

(at course level)

Learning and teaching strategies

Assessment

Strategies

 
 

CO 269: Calculate the correlation between two variables. & simple/Multiple linear regression equation for a set of data using MX Excel/SPSS

CO 270: Apply concepts of Probability distributions in Decision making in a simulated environment

CO 271: Apply hypothesis tests on data in MS Excel/ SPSS for comparing means & Utilize them for decision making.

CO 272: Apply hypothesis tests on data in MS Excel/ SPSS for comparing variance using Chi Square test & ANOVA and Utilize them for decision making.

CO 273: Prepare formal research report

Approach in teaching:

Interactive Hours, Discussion, Tutorials, Reading assignments, Demonstration, Team teaching

 

Learning activities for the students:

Self learning assignments, Effective questions, Simulation, Seminar presentation, Giving tasks.

Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects

 

 

6.00
Unit I: 
Unit I

Correlation Analysis: Calculation of various types of correlation using statistical softwares like SPSS, Excel, etc.

6.00
Unit II: 
Unit II

Regression Analysis: Linear regression using statistical softwares like SPSS, Excel, etc.

6.00
Unit III: 
Unit III

t-test: One Sample, Independent Sample, Paired t test using statistical softwares like SPSS, Excel

6.00
Unit IV: 
Unit IV

Analysis of variance: One way ANOVA and Two way ANOVA using statistical softwares like SPSS, Excel

6.00
Unit V: 
Unit V

Chi square Test: Test of Independence, 2x2 Cross tabulation, Layered cross tab, Goodness of fit using statistical softwares like SPSS, Excel

Essential Readings: 

1. James B Cunningham (2011), Using SPSS: An interactive hands- on Approach, Peacock publisher, 3rd Edition.
2. Mervyn(2015), SAS Data Analysis, Springer (SIE) Publishing House.
3. Venkat Reddy Konasani and Shailendra Kadre (2015), Practical Business Analytics Using SAS: A Hands-on Guide, Dreamtech Press.
4. A. Rajathi & P. Chandran (2012), SPSS for You, mjp publishers.
5. Seyed Reza Hashemian Rahaghi, Farnaz Abed Ashtiani (2011), Basic of Statistics & SPSS, create space independent publishing platform.
6. Robert H. Carver (2013), Doing Data Analysis with SPSS version 18.0, Cengage publishers, 5th edition.
7. S. Ajai Gaur (2009), Statistical methods for practice & research: A guide to Data Analysis using SPSS, Sage Publishers, 2nd edition.

Academic Year: