EX.

NO: 1
DATE:

DESCRIPTIVE STATISTICS

AIM:

To calculate Descriptive statistics using SPSS package.

PROCEDURE:

Step1: Click start all programsSPSS statistics16.0

Step2: Choose the check button type in data from SPSS statistics editor.

Step3: Declare variable in variable view window

Step4: NextDate View Enter the value.

Step5: Analyze Descriptive StatisticsDescriptive

Frequencies

Step6: Next Output Screen Descriptive Statistics Data

Step7: Statistics Data in mean ,median, mode value

Step8: The output will get displayed.

1
Input:

Output:

Result: Thus the above program has been successfully executed.

2
EX.NO: 1(a)

DATE:

PARAMETRIC TEST ONE SAMPLE T- TEST

AIM:

To calculate the one sample T-Test using SPSS package.

PROCEDURE:

Step1: Start All programsSPSSstatistics 16.0

Step2: Open the page SPSS statistics editor

Step3: Declare variable in variable view window

Step4: Next Data viewEnter the value.

Step5: Analyze compare means one sample T-test  click ok

Step6: The output will get displayed.

Input:

3
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 1(b)
DATE:

4
 NON PARAMETRIC TEST
AIM:

To calculate Non parameter test (Wilcoxon signed rank test) by using SPSS

package.

PROCEDURE:

Step1: Start All programsSPSS statistics 16.0

Step2: Open the page SPSS statistics editor

Step3: Declare variables in variable view window

Step4: Nextdate view enter the valuecreate table

Step5: Click analyze Non parametric tests 2 related samples.

Step6: Next output screen will be displayed.

Step7: Check the sig (2-tailed) relation to

0.05 aspect and non aspect

Step8: Get the result.

Input:

5
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 1(c)

6
DATE:

CORRELATION

Aim:

To calculate coefficient of correlation by using SPSS package.

Procedure:

Step1: Click start All programsSPSS statistics 16.0

Step2: Select type in data and click okdeclare variables in variable view window

Step3: NextData view Enter the value.

Step4: Analyzecorrelate Bivariate.

Step5: Bivariate correlations dialog box will appear transfer the variables.

Step6: The output screen will be displayed.

Step7: Stop the process.

Input:
7
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 1(d)
DATE:

8
 REGRESSION

Aim:

To calculate regression analysis by using SPSS package.

Procedure:

Step1: Start All programsSPSS statistics16.0

Step2: Select type in data and click okdeclare variable in the variable view window

and data in the data view.

Step3: Analyzeregression linear.

Step4: Linear regression dialog box will appear. Declare dependent and independent

variable.

Step5: Click statistics button enable confidence interval option and give continue.

Step6: Click Plots button enable normal probability and give continue.

Step7: Click save button enable unstandardized  standardized mean individual

and give ok.

Step8: The output will be displayed.

Input:

9
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 1(e)
DATE:

10
 ONE WAY ANOVA
AIM:

To calculate the one way ANOVA by using SPSS software.

PROCEDURE:

Step1: Click start all programsSPSS statistics16.0

Step2: Open the page spss statistics editor
Step3: Declare variables in variable view window
Step4: Nextdate view enter the values
Step5: Analyze hypothesis parameter
Step6: Compare meansone way ANOVA
Step7: Next output screen descriptive statistics data
Step8: Variable level2 tailed sign data
Step9: Statistics data  check the sign level relation to 0.05 aspect and non aspect.
Step10: Table value  check in descriptive statistics relationship or not relationship.
Step11: Get the result.

Input:

11
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 2
DATE:

12
 FORECASTING TECHNIQUES

Aim:

To calculate the working capital by using MS-excel.

Procedure:

Step1: start all programsMS-office MS -excel.

Step2: New excel sheet will be displayed on the screen.

Step3: Enter the data

Step4: Column A entering the x variables.

Step5: In column B entering the y variables.

Step6: Apply the function = FORECAST(x,known_y’s,known_x’s)

Step7: Apply the function in the cell and click enter button.

Step8: The forecasted output will be displayed.

Input:

13
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 3

DATE:

14
 PORTFOLIO

Aim:

To calculate portfolio analysis by using MS-excel.

Procedure:

Step1: Start all programsMS office MS-excel.

Step2: Enter the data in a table format.

Step3: Calculate the sharpe ratio and treynor ratio.

Step4: Use arithmetic functions for predicting the missing value

Step5: Start the process.

Input:

15
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 4
DATE:

16
 REVENUE MANAGEMENT

AIM:

To calculate revenue management by using MS-excel.

Procedure:

Step1: Start all programsMS-officeMS-excel.

Step2: Enter the sales value of any year minus expense (variable) to get operating

income (contribution).

Step3: Contribution minus fixed expenses to get operating income (EBIT).

Step4: EBIT minus interest or depreciation gives earning before tax after interest and

depreciation (EBTAID).

Step5: EBTAID minus tax gives earning after tax (EAT)

Step6: EAT divided by number of shareholders (N) gives earning per share (EPS).

Step7: Earning per share will be calculated.

Step8: Stop the process.

17
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 4(a)
DATE:

RATE OF INTEREST CHARGED

18
Aim:

To Calculate The rate of interest charged to loan by using MS-excel.

PROCEDURE:

Step1: Click Startall ProgramMS-officeMS-excel.

Step2: Enter the values .

Step3: Suppose we have a loan amount of rs: 100000. no of month 48,

Payment rs: -3000.

Step4: To Find the rate of interest charged on loan.

Step5: Enter the formula =Rate(nper,pmt,pv) the get result.

Step6: Stop the program.

Input:

19
Output:

Result: Thus the above program has been successfully executed.

20
EX.NO: 4(b)

DATE:

FUTURE VALUE

Aim:

To calculate the future value charged in to risk analysis data by using MS-excel .

PROCEDURE:

Step1: Start the programs

Step2: Suppose we have a bank account in deposit on Rs.1000 in 12% per

month.

Step3: Find the interest charged in to risk analysis data.

Step4: Open the MS-excel click the start the programs

Step5: Click the present value of interest in data enter.

Step6: The formulation of =fv(rate,nper,pmt,pv) to the get result.

Step7: Stop the process.

21
Input:

Output:

Result: Thus the above program has been successfully executed.

22
EX.NO: 4(c)
DATE:

PRESENT VALUE

Aim:

To calculate the present value of future payment in to risk analysis data by using MS-

excel.

PROCEDURE:

Step1: Start the programs

Step2: Suppose we have a current interest charged in to risk analysis data.

Step3: To find the present value of future payment.

Step4: Click the start the programs MS-officeMS-excel.

Step5: You expect to receive Rs.800/- every month over next 24 months.

Step6: If the current discount rate is 12% per annum. What is the present

value of these future payments?

Step7: Click the present value of interest in data enter

Step8: The formulation of =pv(rate,nper,pmt,fv) to the get result.

Step9: Stop the program.

23
 Input:

Output:

Result: Thus the above program has been successfully executed.

EX.NO: 4(d)

24
DATE:

NET PRESENT VALUE

Aim:

It is calculate the rate of interest charged in to risk analysis data .

PROCEDURE:

Step1: Start the program.

Step2: Suppose if you can afford only Rs.500/- per month.

Step3: If you are crediting this amount in a bank that pays an

annual interest of 12% compounded monthly.

Step4: How long will it take for your investment to accumulate to Rs.50000.

Step5: Click the start all programMS-officeMS-excel.

Step6: Click the present value of interest in data enter

Step7: The formulation of =nper(rate,pmt,pv,fv) to the get result.

Step8: Stop the program.

Input:
25
Output:

Result: Thus the above program has been successfully executed.

26
EX.NO: 05
DATE:

TRANSPORTATION PROBLEM

Aim:

To obtain the optimum transportation cost by using TORA software.

Procedure:

Step1: Start Click TORA software.

Step2: TORA window will appear, in that Press click here button.

Step3: Main menu will appearTransportation modelgive title assign source and

destination values for table creation give enter or tab.

Step4: Input screen window will appear. Enter the demand and supply values, Inserting

the data.

Step5: Solve menu click save the data

Step6: Solve problem  final iteration

Step7: The output will be displayed.

Input:

27
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 5(a)
DATE:

28
 ASSIGNMENT PROBLEM

Aim:

To obtain the optimal assignment by using tora software.

procedure:

step1: Start click tora software.

step2: TORA window will appear. In that press click here buttonmain menu will

appeartransportation model.

step3: Give title ,source and destination press enter.

step4: Inserting the data assign 1 for all demand and supply field’s

step5: Solve menu click save the data .

step6: Solve problem  final iteration

step7: Go to the output screen

step8: The output will be displayed.

29
Input:

Output:

Result: Thus the above program has been successfully executed.

EX.NO: 5(b)

30
DATE:

GRAPHICAL METHOD

Aim:

To calculate the graphical problem by using TORA software.

Procedure:

Step1: Start click TORA software

Step2: Press click here button main menu linear programming.

Step3: Click go to input screen Insert the data

Step4: Solve menu click save the data .

Step5: Solve problem graphical final solution

Step6: Go to the output screen

Step7: The output will be displayed.

Input:
31
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 5(c)

32
DATE:

SIMPLEX METHOD

Aim:

To calculate the simplex method problem by using TORA software.

Procedure:

Step1: Start click TORA software

Step2: Press click here button main menu linear programming.

Step3: Click go to input screen Insert the data

Step4: Solve menu click save the data.

Step5: Solve problemalgebraic  final solution

Step6: Go to the output screen

Step7: The output will be displayed.

33
Input:

Output:

Result: Thus the above program has been successfully executed.

34
EX.NO: 06
DATE:

NETWORKING PROBLEM

Aim:

To determine the critical path for the projects by using TORA software.

Procedure:

Step1: Go to TORA software press click here buttonproject planning  CPM

(critical path method).

Step2: Input table will be displayed.

Step3: Give problem title, and insert the data’s in a table

Step4: Assign values for (from node, to node, activity, duration)

Step5: Save the datasolve problem press go to the output screen button select

CPM bar chart or CPM calculations.

Step6: The output will be displayed.

35
Input:

Output:

Result: Thus the above program has been successfully executed.

EX.NO: 07
DATE:

36
 QUEUING ANALYSIS

Aim:

To solve the operation research problem by using TORA software.

Procedure:

Step1: Go to TORA softwarepress click here button queuing analysis go to input

screen.

Step2: Input screen will be displayed give problem title and scenarios as 1 press

enter.

Step3: Give values to the lambda and mu  select the solve menu  save the data 

go to output screen.

Step4: Output will be displayed .

Input:

37
Output:

Result: Thus the above program has been successfully executed.

EX.NO: 08

38
DATE:

INVENTORY MODELS

Aim:

To calculate the economic order quantity by using POM software.

Procedure:

Step1: Start POM software library.

Step2: POM main menu dialog box will appear  click module .

Step3: Click fixed order quantity inventory model.

Step4: Fixed-order quantity inventory model dialog box will appearproduction.

Step5: Enter values to the annual demand (D), ordering cost(S), carrying cost(C).

Step6: Click solve menu.

Step7: The output will be displayed.

39
Input:

Output:

Result: Thus the above program has been successfully executed.

40