School: SBS Batch: 2023-2025

Program: MBA Current Academic Year: 2024-2025

Branch: Semester: III
1 Course Code DSC148
2 Course Title Data Management Using R and Excel
3 Credits 3
4 Contact 3-0-0
Hours (L-T-
P)
5 Course Type Compulsory
6 Course 1. To develop a foundational understanding of R and Excel including
Objective running programs, managing datasets, and utilizing formulas and
functions for data manipulation and analysis.
2. To learn key statistical analysis techniques, including measures of
central tendency and dispersion, graphical analysis methods, and
hypothesis testing procedures
3. To understand and apply parametric tests such as Z-test, t-test, and
ANOVA, as well as non-parametric tests like Kruskal-Wallis test,
for comparing means and proportions across groups.
4. To gain proficiency in simple and multiple regression analysis,
including interpretation of regression output and assessment of
model significance and fit.
5. To apply learned concepts to real-world datasets, both in R and
Excel, and develop skills in interpreting analysis results to derive
meaningful insights for decision-making purposes.
7 Course 1. The student will be able to recall and explain the basic concepts
Outcomes of R and Excel, including running programs, managing datasets,
and utilizing formulas and functions.
2. The student will be able to demonstrate an understanding of
techniques for importing and preparing datasets in both R and
Excel environments.
3. The student will be able to apply statistical analysis techniques
such as measures of central tendency, dispersion, and hypothesis
testing to analyze datasets.
4. The student will be able to analyze and evaluate datasets using
parametric tests (Z-test, t-test, ANOVA) and non-parametric tests
(Kruskal-Wallis test) to compare means and proportions across
groups.
5. The student will be able to evaluate and interpret the results of
regression analysis, including assessing model significance,
goodness of fit, and the significance of regression coefficients.
6. The student will be able to create meaningful insights and
conclusions from analysis results derived from real-world
datasets, demonstrating the ability to apply learned concepts in
practical scenarios.
8 Course This course provides a comprehensive introduction to data analysis
Description using R and Excel. Students will develop foundational skills in data
management, statistical analysis, and interpretation of results. Topics
include importing and preparing datasets, applying statistical techniques
such as measures of central tendency and dispersion, hypothesis testing,
parametric and non-parametric tests, and regression analysis. Through
hands-on exercises and real-world applications, students will gain
proficiency in analyzing data, interpreting results, and deriving
meaningful insights to support decision-making processes.
9 Outline syllabus CO Mapping
Unit 1 Fundamental of R and Excel
A Intro to R, Running R programs,Getting familiar with CO1, CO2
R data sets, Creating R data sets
B Intro to Excel, Formulas- If, Sumif, Sumifs, CO1, CO2
Countif, Countifs, Averageif, Averageifs,
VLOOKUP, HLOOKUP, Match, Index, Filters,
Quick Filtering, Filtering by Multiple Criteria,
Saving the Filtered Data, Performing
Calculations on Filtered Data
C Importing data into R and Excel CO1, CO2
Unit 2 Fundamental of Data Science
A Measures of Central Tendency with emphasis on CO2, CO3
choosing right central tendency
B Measures of Dispersion- Absolute and Relative CO2, CO3
C Introduction to Skewness and Kurtosis- Stem and Leaf CO2, CO3
Plot, Box and Whiskers Plot
Unit 3 Hypothesis Testing
A Null and Alternative Hypothesis, Type I Error, Type CO2, CO3
II Error, checking normality of data- Shapiro wilk test,

B Definition of Parametric and Non Parametric Test, CO3, CO4

Parametric Test: Test for Equality of Means- Z test, t
test, Equality of proportions for one and two samples
using R and Excel- when data is given, when mean
and standard deviation is given
C Equality of variances- F test using R and Excel- when CO3, CO4
data is given, when mean and standard deviation is
given, Test for consistency/uniformity/stability
Unit 4 Analysis of Variance (ANOVA) and Kruskal
Wallis Test
A Definition, need for ANOVA, assumptions of CO4
ANOVA

B One Way ANOVA using R and Excel, Two Way CO4

ANOVA using R and Excel
C Non Parametric Test- Kruskal Wallis Test, Run test CO4
for randomness, sign test
 Unit 5 Regression Analysis
A Simple and Multiple Regression CO5
B Interpreting Regression output from R and Excel- CO5,CO6
R Square, Adjusted R Square, VIF, Significance
of model, goodness of fit, Significance of
Regression coefficients
C Interpreting Regression coefficients for predicting CO5,CO6
dependent variable for given values of dependent
variables, Identifying the most and least
contributing variables
1 Mode of Theory
0 examination
1 Weightage CA MTE ETE
1 Distribution 25% 25% 50%
1 Text book/s* Introduction to Data Science" by Jeffrey Stanton.
2 Paperback. September 2015
1 Other
3 References R for Data Science" by Hadley
Wickham and Garrett Grolemund.
Paperback. September 2015.
1. Statistics for Data Science" by James
D. Miller. Paperback. September 2015.

Course Articulation Matrix

POs PO1 PO2 PO3 PO4 PO5 PO6

COs
CO1 - 2 - - 2 -
CO2 - 2 - - 2 -
CO3 1 3 - - 2 -
CO4 1 3 - - 2 -
CO5 1 3 - - 2 -
C06
2 3 - - 2 -
Avg 0.83 2.66 - - 2 -

1. Slight (Low) 2. Moderate 3. High