SRM INSTITUTE OF SCIENCE AND TECHNOLOGY
Ramapuram, Chennai-600089
FACULTY OF MANAGEMENT
MBG23209L-BUSINESS ANALYTICS
Record Work
Academic Year 2023-2024
ROSHNI A
STUDENT NAME
REGISTER NUMBER
RA2352001020166
NAME OF THE PROGRAMME M.B.A.
YEAR & SEMESTER I YEAR & II SEMESTER
SECTION C
SRM INSTITUTEOF SCIENCE AND TECHNOLOGY
Ramapuram-600089
Bonafide Certificate
This is to certify that the Bonafide record of work done by ROSHNI A
Registration No. RA2352001020166 Of First Year M.B.A. Degree Course
MBG23209L- Business Analytics in the Faculty of Management, SRM Institute
of Science and Technology, Ramapuram during the academic year 2023-2024.
Faculty in-charge Dr .R. Arulmoli
Date :
HOD/MBA
Submitted for the University Examination held on , SRM Institute of Science and
Technology, Ramapuram
Internal Examiner-I Internal Examiner-II
INDEX
SIGNATURE OF
EX No. DATE NAME OF THE EXERCISE PAGE No.
THE FACULTY
1 Mathematical Functions in Excel 1
2 Statistical Functions in Excel 3
3 Financial Functions in Excel 5
4 Logical Functions in Excel 7
Date & Time Functions in Excel
5 8
6 Measure of Distribution 9
7 Measure of Central Tendency 10
Measure of Variability
8 11
Measure of Association Between Two
9 13
Variables
10 Conditional Formatting 14
11 Compare Two List 15
12 Data Visualization using Excel 16
Data Analytical Processing using MS-Excel
13 18
Pivot Table
Online Data Analytical Processing using MS
14 19
Excel Slicer
15 Advanced-Data Visualization using Excel 20
16 Data Dashboard 21
17 Linear Regression and Correlation 22
18 Simple Linear Regression Model 23
19 Multiple Regression Model 24
20 Least Square Method 25
21 Inference and Regression 26
22 Moving Average 27
23 Exponential Smoothing 28
24 Forecasting Model in Excel 29
25 Forecast Accuracy 30
26 Regression Analysis for Forecasting 32
27 Spreadsheet Model 33
28 Linear Optimization Model 35
29 Influence Diagram 36
30 Performing Solver in Excel 37
31 What if –Analysis 38
32 Functions for modelling In Excel 39
33 Simple Maximization Problem 41
34 Simple Minimization Problem 42
35 Sensitivity Analysis 43
36 Preparing a Code Book 44
Data Transformations, Recoding Variables,
37 46
and Selection Cases
38 Sorting Data, Splitting, and Merging Files 48
39 Descriptive Statistics 50
40 Correlation Analysis 52
41 Multiple Regression 53
42 Factor Analysis 54
43 Non-Parametric Statistics 55
44 T-Test in SPSS 56
45 One-way Analysis of Variance 57
46 Two-way ANOVA between Groups 58
47 Data Visualization 59
Recent Developments in Visualization
48 60
Software
49 Data Visualization using Power BI 61
50 Data Visualization using Tableau 62
51 Introduction to Rapid Miner 63
52 R Programming 64
53 Python Programming –Simple Exercises 65
Python program to find the largest number among
54 66
the three input number
55 Python program to find the square root 67
Python program to calculate the area of
56 68
triangle
