22bap03-Dabm Lab Manual
22bap03-Dabm Lab Manual
22bap03-Dabm Lab Manual
(Autonomous), Erode-52
Approved by AICTE, New Delhi. Affiliated to Anna University, Chennai. Accredited by NAAC A+ Grade
LAB MANUAL
SEMESTER- II
May - 2023
NANDHA ENGINEERING COLLEGE
(Autonomous)
ERODE-52
CERTIFICATE
MISSION
To be a learner centric environment to cater the changing business needs of the society.
❖ To provide quality management education through managerial activities to meet the global needs.
PEO 1: Core Competency: To work with multidisciplinary teams for problem solving and
understand the group dynamics and team work.
PEO 3: Ethical and Committed Professional: To develop lifelong learning attitude, ethics and
values for a successful profession.
PO5. Lead themselves and others in the achievement of organizational goals, contributing effectively
to a team.
PROGRAMME OUTCOMES
PO 2. Foster analytical and critical thinking abilities for data-based decision making.
PO 4. Understand, analyze and communicate global, economic, legal, and ethical aspects of business.
TABLE OF CONTENTS
PAGE FACULTY
S.NO TITLE MARKS
NUMBER SIGN
1. DESCRIPTIVE STATISTICS 1
2. HYPOTHESIS-PARAMETRIC 7
3. HYPOTHESIS-NON PARAMETRIC 10
7. PORTFOLIO SELECTION 23
9. REVENUE MANAGEMENT 29
REVENUE MANAGEMENT
10. LINEAR PROGRAMMING 32
EXTENDED EXPERIMENT -2
Date :
Question:
Calculate the frequency distribution and measures of central tendency from following table.
Height in Weight in
Gender Cms Kgs
1 140 56
1 146 45
2 156 68
1 149 51
2 154 54
1 156 53
2 151 69
1 148 51
2 158 70
1 150 49
1 151 45
2 159 68
1 153 50
2 148 55
1 155 61
1 146 53
2 150 65
2 152 64
1 149 47
2 156 59
1
DESCRIPTIVE STATISTICS
ALGORITHM:
Step-2: Click variable view and enter the data of gender, height and weight
Step-3: Click data view and enter gender values, height and weight.
Step-4: Select analyse icon, Select descriptive statistics and select frequencies
Step-5: Click statistics, select Mean, median, mode and also check display frequency table
column
INTERPRETATION
Height Weight
Mode : 156 45
RESULT:
2
OUT PUT
Frequencies:
Statistics
N Valid 20 20 20
Missing 0 0 0
Frequency:
Height in cm
Cumulative
Frequency Percent Valid Percent Percent
3
Statistics
N Valid 20 20 20
Missing 0 0 0
Weight in gm
Cumulative
Frequency Percent Valid Percent Percent
4
Weight in gm
Cumulative
Frequency Percent Valid Percent Percent
5
Histogram:
6
Ex.No:2 HYPOTHESIS-PARAMETRIC
Date :
Question:
The life time of tube for a random sample of 20 provides following figures:
Item 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Life (in
years) 5 6 6 5 2 3 7 7 5 6 6 6 6 9 6 7 9 59 5 5
7
HYPOTHESIS-PARAMETRIC
AIM:
ALGORITHM:
Step-2: Click variable view and create variables and click data view enter life of tubes
Step-3: Then select analyze, click One-sample T test, a dialogue box will appear
Step-4: Select the test variable and enter the test value as 5 then click OK
INTERPRETATION:
The significant value (0.030) is less than 0.05, the null hypothesis is rejected and alternative
hypothesis is accepted.
RESULT:
8
OUTPUT
T-Test
One-Sample Statistics
One-Sample Test
Test Value = 5
9
Ex.No:3 HYPOTHESIS-NON PARAMETRIC
Date :
Question:
The sales of two retails stores of Delhi (store1) and Mumbai (store2) are compared by Ganesh.
The sales are in Rs.Lacs. There are 20 respondents, 10 from each store. Apply Mann – Whitney
non-parametric t-test of independent groups to prove the hypothesis.
Null hypothesis: There exists no significant difference in the sales of two retails shop
Alternative hypothesis: There exists significant difference in the sales of two retails shop.
Retail store 1 2 1 1 2 2 2 1 2 1
Sales (Rs 40 30 60 45 55 25 60 80 100 20
Lacs)
Retail store 2 1 1 2 1 1 2 2 1 2
Sales (Rs 10 80 85 90 120 85 60 55 56 25
Lacs)
10
HYPOTHESIS-NON PARAMETRIC
AIM:
ALGORITHM:
Step-2: Click variable view and create variables and click data view enter life of tubes
Step-3: Then select analyze, click Nonparametric, and click 2 independent samples to get the
dialogue box
Step-5: Click define Groups, assign code 1 to group 1 and 2 to group 2 and click continue button
Step-6: Click options button, select Descriptive and Quartiles options in statistics frame by
clicking them
Step-7: Click continue button to go back to the previous dialogue box and keeping all other
options unchanged click OK
INTERPRETATION:
The calculated value (0.288) is greater than 0.05 the null hypothesis is accepted.
RESULT:
11
OUTPUT
NPar Tests
Descriptive Statistics
Percentiles
Mann-Whitney Test
Ranks
Retail
Store N Mean Rank Sum of Ranks
2 10 9.10 91.00
Total 20
b
Test Statistics
Mann-Whitney U 36.000
Wilcoxon W 91.000
Z -1.061
12
Ex.No:4 CORRELATION AND REGRESSION
Date :
Question:
Twenty students have taken their common entrance test after their graduation. The
selection committee wants to see the relationship between the scores of CET and the
percentage achieved in graduation through correlation analysis.
Frame a hypothesis and show the type of relationship (positive or negative relationship)
between the variables.
CET % in UG
Scores degree
70 71
60 82
65 73
68 64
70 75
75 69
87 75
89 88
90 90
96 90
97 88
65 82
80 73
86 74
77 65
13
CORRELATION AND REGRESSION
AIM:
ALGORITHM:
Step-1: Click start button, All programs, IBM STATISTICS, Create a new document
Step-3: Click data view and enter the CET Scores and % in UG degree
Step-5: In bivariate dialog box, select the variables, click Pearson and click ok button.
Step-7: To find regression, click again analyse icon from the output window, click regression,
select linear.
Step-8: In regression dialog box, select the dependent and independent variable and click ok
INTERPRETATION:
Hypothesis:
H0: There is no significant relationship between the CET Score and the UG percentage
H1: There is a significant relationship between the CET Score and the UG percentage
The calculated value (0.031) is less than table value 0.05 so alternative hypothesis is accepted.
Hence there is a significant relationship between the CET Score and the UG percentage
RESULT:
Thus the relation between the CET Scores and % in UG degree is found
14
OUTPUT
Correlation:
N 20 20
*
% in UG degree Pearson Correlation .482 1
N 20 20
Regression:
b
Variables Entered/Removed
Variables Variables
Model Entered Removed Method
a
1 % in UG degree . Enter
Model Summary
a
1 .482 .233 .190 .459
15
b
ANOVA
a
1 Regression 1.152 1 1.152 5.458 .031
Total 4.950 19
a
Coefficients
Standardized
Unstandardized Coefficients Coefficients
16
Ex.No:5 FORECASTING
Date :
Question:
Tata Consulting Services Profit since March 2009-12 is shown in the following table:
Time
Sl.No Profit(in RS.Cr) Period
1 4696.21 Mar-09
2 5618.51 Mar-10
3 7569.99 Mar-11
4 10975.98 Mar-12
17
FORECASTING
AIM:
ALGORITHM:
Step-1: Click start, All Programs, Microsoft Office, Microsoft office Excel
Step-3: Type the predict value of known X in B6th cell as “March 2013”
Step-4: Type the forecast formula in A6th cell as “=FORECAST (B6,A2:A5,B2:B5)” press enter
INTERPRETATION:
RESULT:
Thus the predict value of known Y using Forecasting Analysis for the year March 2013 is
calculated.
18
OUTPUT
Time
Sl.No Profit(in RS.Cr) Period
1 4696.21 Mar-09
2 5618.51 Mar-10
3 7569.99 Mar-11
4 10975.98 Mar-12
12413.74665 Mar-13
19
Ex.No:6 FORECASTING EXTENDED EXPERIMENT - 1
Date :
The quantity of sales of a department store for the last 5 years is as follows:
Forecast the sales for the year 2015 for each quarters.
20
FORECASTING EXTENDED EXPERIMENT - 1
AIM:
To find the quantity of sales for the year 2015 for 4 quarters by using forecasting method.
ALGORITHM:
Step-4: Type the forecast formula in A7th cell as “=FORECAST (E7,A2:A6,E2:E6)” and then
press enter
Step-6: Similarly calculate the predicted value for the remaining 3 quarters.
INTERPRETATION:
The quantities of sales for the year 2015 for 4 quarters are 54600, 67100, 61100, and 72500
RESULT:
21
OUTPUT
22
Ex.No: 7 PORTFOLIO SELECTION
Date :
Question:
Raja purchased 100 shares of stock at a cost of Rs.55 per share. To hedge the risk that the stock
may decline in value, he purchased 60 six-months European put option. Each option has an
exercise price of Rs.45 and costs Rs.5. How can he develop a worksheet that indicates 6 months
percentage returns on his portfolio for a variety of possible future prices?
23
PORTFOLIO SELECTION
AIM:
ALGORITHM:
Step-4: Create five columns for Final Stock Price, Final Put Value, Final Share Value,
Percentage Return Hedged and Percentage Return unhedged respectively
Step-6: Calculate final put value by using the formula =(IF(A8<=exercise, exercise-
A8,0))*Nputs
INTERPRETATION:
If stock price drops below exercise price then the hedged portfolio has a larger expected return
than the unhedged portfolio.
If the stock price increase above the exercise price then the unhedged portfolio has a larger
expected return than the hedged portfolio.
RESULT:
Thus the percentage returns on both hedged and unhedged portfolio is calculated.
24
OUTPUT
Nputs 60
Nshares 100
Exprice 45
Pticenow 55
Putcost 5
Startvalue 5800
Final Stock Price Final Put Value Final Share value Percentage Return Hedged Percentage Return Unhedged
25
Ex. No: 8 RISK ANALYSIS & SENSITIVITY ANALYSIS
Date :
Question:
Term : 60 Months
26
RISK ANALYSIS & SENSITIVITY ANALYSIS
AIM:
ALGORITHM:
Step-3: Click cell B4 and on the main menu click Insert function (fx)
Step-4: In select a category list click Financial, in the Function Name list double click PMT
Step-5: Click the box of Rate and on the worksheet click cell B2 and type /12
Step-6: Click the box of Nper and on the worksheet click cell B3
Step-7: Click the box of Pv and type – and on the worksheet click cell B1 and click OK
INTERPRETATION:
RESULT:
27
OUTPUT
Term 60
Repayment 394.14
28
Ex.No:9 REVENUE MANAGEMENT
Date :
Question:
The current price and quantity is given below for ABC Company :
Quantity : 560
The firm wants to increase the revenue by changing the price with .23 paise and quantity 20.
29
REVENUE MANAGEMENT
AIM:
ALGORITHM:
Step-3: Select the Midpoint and give value for price & quantity
Step-6: Point out the Maximum Revenue value and Original Price
INTERPRETATION:
RESULT:
This the Maximum Revenue and original price for the product of ABC Company is calculated
30
OUTPUT
31
Ex.No:10 EXTENDED EXPERIMENT -2
Date :
Question:
Linear Programming – Minimizing
To obtain feasible solution through Linear Programming using TORA
Problem:
Minimize Z = 2x1+3x2
Subject to x1=x2>=5
X1=2x2>=6
And x1,x2>=0
32
LINEAR PROGRAMMING
AIM:
To obtain feasible solution through Linear Programming using TORA
ALGORITHM:
Step-1: Click TORA Software in Desktop
Step-2: In main menu click module, select Linear programming
Step-3: Enter problem title as “Linear Programming” and Give the title in the name of Linear
Programming
Step-4: Enter the X1 and X2 Values
Step-5: Click solve in the top menu
Step-6: The output will be displayed in the output window.
INTERPRETATION:
X1 6.000
Slack 1 1.000
Z 12.000
RESULT:
Thus the minimum feasible solution is obtained.
33
OUTPUT
34
Ex.No :11 TRANSPORTATAION AND ASSIGNMENT
Date :
Question:
A Texas company is shipping units from three factories to five distribution centre. The
supply at each of the factories and the demand at each of the centre are given. The total supply
and demand are equal. The cost to ship one unit from each factory to each distribution centre is
given below.
F1 20 48 10 30 40 100
F2 70 60 55 90 70 80
F3 45 80 50 30 60 150
Demand 50 70 65 55 90 330
35
TRANSPORTATAION AND ASSIGNMENT
AIM:
To calculate the total cost for shipping to five distribution centre of Texas company.
ALGORITHM:
INTERPRETATION
RESULT
37
Ex.No :12(a) NETWORKING MODEL – CRITICAL PATH METHOD
Date :
Question:
A project consists of 7 activities for which the relevant data are given below.
A - 4
B - 7
C - 6
D A,B 5
E A,B 7
F C,D,F 6
G C,D,E 5
38
NETWORKING MODEL – CRITICAL PATH METHOD
AIM:
ALGORITHM:
Step 2: In the main menu select Project Planning Module Choose CPM-Critical Path Method.
Step 4: Enter the name of the activity, its duration and its preceding activity.
INTERPRETATION
39
RESULT
OUTPUT
--------------------------------------------------------------------------
CRITICAL PATH(S):
B F
40
Ex.No :12(b) Networking Model – Program Evaluation and Review Technique
Date :
Question:
A project consists of 8 activities for which the relevant data are given below.
A - 1 1 7
B - 1 4 7
C - 2 2 8
D A 1 1 1
E B 2 5 14
F C 2 5 8
G D&E 3 6 15
H F&G 1 2 3
41
Networking Model – Program Evaluation and Review Technique
AIM:
ALGORITHM:
Step 1: Click Start ----> All Programs ----> POM Software Library.
Step 4: Enter the name of the activity, its optimistic, pessimistic, most likely time and its
preceding activity.
INTERPRETATION:
RESULT:
42
OUTPUT
*** PROGRAM EVALUATION AND REVIEW TECHNIQUE (PERT) ***
--------------------------------------------------------------------------
PROBLEM NAME: PERT
--------------------------------------------------------------------------
--------------------------------------------------------------------------
CRITICAL PATH(S):
B E H
43
Ex.No :13 QUEUEING THEORY
Date :
Question:
A TV repair man finds that the time spend on his job has an exponential distribution with
mean 30 minutes, if he repair sets in the order in which they came in and if the arrival of sets is
approximately Poisson with an average rate of 10 per 8 hour a day, What is the repairman’s
expected idle time each day?
44
QUEUEING THEORY
AIM:
ALGORITHM:
Step 1: Click Start ----> All Programs ----> POM Software Library.
Step 3: Enter the problem title, enter the appropriate values and select single channel model.
INTERPRETATION:
RESULT:
45
OUTPUT
--------------------------------------------------------------------------
46
Ex.No:14 INVENTORY MODEL – ALWAYS BETTER CONTROL
Date :
Question:
The product number, description, cost per piece and the yearly usage of Shanthi Ltd., is given
below:
Note:
A – 0-70
B – 70-95
C – 95-100
47
INVENTORY MODEL – ALWAYS BETTER CONTROL
AIM:
ALGORITHM:
Step-3: Find the yearly turnover by using the formula “=(c2*d2) and press enter
Step-6: Find the % of yearly turnover by using the formula “=(E2/E12)*100” and press enter
Step-8: Then click Sort and Filter icon in the menu bar, select custom sort then a dialogue box
appears
Step-9: In that column sort by select % of yearly turnover, values, in order select largest to small
and then click ok
Step-10: Find the cumulative of annual usage by using the formula and categorize the annual
turnover % based on their value
INTERPRETATION:
RESULT:
Cost % of the
Product Product Yearly Yearly Cumalative
Sequence per Yearly Category
number Description Usage Turnover %
Piece Turnover
49
Ex.No:15 EXTENDED EXPERIMENT - 3
Date :
Question:
The annual demand for an automobile component is 36000 units. The carrying cost is Rs.
0.50/unit/year, the ordering cost is Rs 25.00 per order. Find the EOQ and the Maximum
Inventory Level.
50
INVENTORY MODEL – EOQ
AIM:
ALGORITHM:
Step-3: To find the Order Quantity Type the formula in B4 Cell as “=SQRT(2*B1*B3/B2)” and
press enter result will show.
Step-4: To find the annual stocking Cost type formula in B5 cell as “=B4*B2” press the enter
result shows
Step-5: To find the Expected No. of Orders per year give formula in B6 cell as “=B1/B4”
Step-6: To find the Maximum inventory level shows as the same in EOQ.
INTERPRETATION:
52