BHARATHIAR SCHOOL OF MANAGEMENT AND
ENTREPRENEUR DEVELOPMENT
Bharathiar University, Coimbatore – 641 046.
BUSINESS ANALYTICS
LAB PRACTICALS RECORD
Submitted by
SOUNDARRAJAN M
(Register No: 22MBAB44)
BHARATHIAR UNIVERSITY,
Coimbatore
APRIL 2023
BHARATHIAR SCHOOL OF MANAGEMENT AND
ENTREPRENEUR DEVELOPMENT
Bharathiar University, Coimbatore – 641 046.
CERTIFICATE
Register No :
Course : Master of Business Administration
Subject : BUSINESS ANALYTICS - PRACTICAL
This is to certify that the Practical Work done by Mr. / Ms. ----
at the Computer
Lab at BSMED, Bharathiar University, Coimbatore during the Period
from January 2023 to March 2023.
Course Faculty
Submitted for the Practical Examination held on 10th April 2023 at the
Computer Lab, Bharathiar School of Management and Entrepreneur
Development, Bharathiar University, Coimbatore.
INTERNAL EXAMINER EXTERNAL EXAMINER
INDEX
Page
Ex. No. Program Description
No.
UNIT I: Introduction to SPSS-
Use the saved dataset employee. Sav for excercise 1.2 to 1.8
Create demographic factors for 20 employees of an
1.1 organisation, feed the data in variable view. Name your
data set and save it as employee.Sav.
1.2 Run Descriptives for the variables Age
1.3 Run frequencies for the variable Gender
1.4 Run frequencies for the variable Qualification
1.5 Run frequencies for the variable salary
1.6 Run frequencies for the variable Experience
1.7 Draw a pie chart showing the gender.
1.8 Draw a bar chart for salary.
UNIT II: Descriptive Statistics-
Refer Table 2 indicates the growth of Internet users' for exercise 2.1 to 2.4
Prepare a data file in SPSS with relevant variables using
2.1
appropriate scales.
2.2 Prepare a line chart corresponding to months and years
2.3 Prepare clustered chart for Internet Users
2.4 Prepare stacked bar chart for rural and urban users
Check for any outliers on Table 3 that you would be
2.5
concerned about in the data
Check whether the scores of the student recalled before
2.6
training and after training are normally distributed
Page
Ex.No. Program Description
No.
Unit – III: Predictive Analytics I
Perform a One-sample t-test on the data and write down
3.1 the null and alternative hypotheses for the One-sample t
test
Perform a Paired-samples t test (dependent t test) on the
3.2 dataset (Paired t test. Sav). Formulate the null and
alternative hypotheses.
Use Independent Sample t- test to determine whether the
male and female population differ on their opinion towards
3.3
processed convenience food. Refer dataset Independent
Sample t test
Use One way ANOVA (Analysis of variance) to find the
difference age of respondents differs in opinion towards
3.4 processed convenience food. Refer dataset Independent
Sample t test, ANOVA. Sav
Unit – IV: Predictive Analytics II
Perform the correlation analysis to find whether there is an
4.1 association between CAT percentage and graduation
percentage
Perform the regression analysis to find the strength of
4.2 relationship between CAT percentage and graduation
percentage
Perform Wilcoxon Sign test to find the difference in
4.3
appraisal scores before and after training
Perform Friedman rank test to find differences between
4.4 groups when the dependent variable being measured is
ordinal
Unit – V : Introduction to R programming
5.1 Installation of R-studio on Windows
5.2 Installation of R-packages on R studio
Run R – Data Types (String, Vectors, Matrix, Array, List,
5.3 Data Frame, Factors)
5.4 Downloading and importing data, on R- Programming
Measures of Central Tendency (mean, median, and range)
5.5
and Variable (standard deviation) on R-Programming
5.6 Data Visualization on R-Programming Charts and Graphs
