VENUE : CR:403 REG.
NO : 231201 SEAT NO : 117
M. S. Ramaiah Institute of Management
III Trimester End Term Examination, May 2024
PGDM-AICTE BATCH: 2023-25
Course Code: 23PGDBA302
Course: Python Programming for Business
Time: 2 hours Max. Marks: 50
Instructions:
1. Answer all the Questions.
2. Write detailed code for all the questions.
3. Convert the word file into single collated PDF file.
4. Ensure the images are clear and legible.
Mark CO BL
s
Q1. Use nba.csv dataset and answer the below
questions:
8 2,5 4,5
a. Find summary of the dataset and provide your 7
comments.
b. What are your findings about distribution of data
of various columns? (Use distplot)
Q2. Use Grades.csv dataset and perform univariate and 10 2,5 4,5
bivariate analysis using suitable graphs. What are your
findings?
Q3. Use penguins.csv dataset and perform: 10 2,5 4,5
a. T-test to check whether there is any significant
difference for mean scores for body mass for male
and female sex groups
b. Chi-square to check whether there is any
significant difference in species in different islands
for male and female sex groups
Q4. Use Advertising.csv dataset and perform:
a. Correlation analysis. What are your findings? 8 2,5 4,5
b. Perform linear regression analysis on Sales 7
considering the independent variables and provide
Regression Equation, R-square value and RMSE
value.
Note: Writing anything on the question paper will be considered as malpractice