A PROJECT REPORT ON

RAILWAY RESERVATION

SYSTEM

BY:

MANIKYA SHARMA 22/016

NIKHIL PAL SINGH 22/019

V.SRINIWAS 22/029

VIPUL BHATIA 22/031

PGDM 1ST YEAR

SEC - A

INTRODUCTION

RAILWAY RESERVATION SURVEY

Indian railways are the life line of the country. They are more than 150 years

old. It is the largest railway system under one management. It is the biggest

employer in the world (14, 06,430). No strike in last 30 years in spite of 70 lakh

workers.

Our Team conducted the Survey on feedback of passengers satisfaction with

rail services (TEAM 2- Manikya, Nikhil, Sriniwas & Vipul) to examine INDIAN

rail passengers satisfaction with various features of the rail services, including

the trains punctuality, railway timings and the behaviour of railway staff(to

name a few) in the country. The survey was conducted via online survey form

by circulating and hence taking respective samples of rail passengers (aged 15

and older). A rail passenger was defined as someone who had travelled by

train within their country in the 12 months prior to the survey; passengers who

had used suburban trains or trains across the country. We got our target

sample size as 70 respondents and the age limit is from 15-60 years in the

period from 9 Feb to 16 Feb, 2015. More details on the survey are given in this

report.

RAILWAY RESERVATION SURVEY REPORT

OBJECTIVES:

To review the facilities provided to the passengers right from ticket

booking to the on-board travel experience in the trains.

To assess if facilities provided in trains were adequate and effectively

maintained or not, from the point of Passenger Satisfaction view in

Station Maintenance Practices.

To know the priority areas so that these can be strengthened to

optimize passenger satisfaction.

To assess the overall travel experience of the passengers in the Indian

Railways and their perception of the organization.

IMPLEMENATION:

To use the function like VLOOKUP, COUNTIF, COUNTIFS , FILTER, PIVOT

TABLE, SORTING (ascending and descending) to sort and optimize data

analysis that we got from the survey.

To know whether adequate safety measures are being provided or not

and the punctuality of the trains.

To know whether people in India are using more internet facility

efficiently or not and hence to find out the E-ticket awareness and

modes of booking the ticket.

To know what is the perception of the consumer in recent years and the

behavior of the staff in the stations which automatically caters to the

ultimate experience of the consumer.

SOFTWARE

Microsoft Excel is a spreadsheet application developed

by Microsoft for Microsoft Windows and Mac OS. It features calculation,

graphing tools, pivot tables, and a macro programming language called Visual

Basic for Applications. It has been a very widely applied spreadsheet for these

platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as

the industry standard for spreadsheets. Excel forms a part of Microsoft Office.

Basic operation

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager). It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface, for example, a stock analyser, or in general, as a design tool that asks the user questions and provides answers and reports.

In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule, analyse the results, make a Word report or PowerPoint slide show, and e-mail these presentations on a regular basis to a list of participants.

RAILWAY SURVEY FORM

This survey is created to know your feedback on the service provided by Indian Railways.

* Required Name *

Enter your name

Age *

Enter you age.

Sex *

Enter your gender.

o M

o F

o Other:

Occupation *

Enter your occupation.

o Business

o Service

o Student

o Self-employed

o Other:

How frequently do you travel by Indian Railways?

o Once a week

o Once a month

o Once in 6 months

o Once a year

Are you aware of E-ticket/I-ticket service introduced by Indian Railway?

o Yes

o No

What mode of reservation do you prefer?

o Travel Agent

o Internet

o Self-service

o Other:

What is your perception of passenger services provided by Indian Railways over the years?

o Improved significantly

o Improving

o Worsening

o Can't Say

How do you find the punctuality of the trains, when arriving on your destination station?

o Always on time

o Mostly on time

o Sometimes on time

o Never on time

Are the security arrangement in trains adequate to prevent crimes/thefts in trains?

o Yes

o No

How do you find the behavior of Railway staff at inquiry counters?

o Always courteous

o Mostly courteous

o Rude

o Can't Say

How do you rate your overall experience of the services provided by Railways on a scale of 1 to 10?

o 1

o 2

o 3

o 4

o 5

o 6

o 7

o 8

o 9

o 10

Submit

RESPONSES

SORTING

As you add more content to a worksheet, organizing that information becomes

especially important. You can quickly reorganize a worksheet by sorting your

data. For example, you could organize a list of contact information by last

name. Content can be sorted alphabetically, numerically, and in many other

ways.

Types of sorting

When sorting data, it's important to first decide if you would like the sort to

apply to the entire worksheet or just a cell range.

Sort sheet organizes all of the data in your worksheet by one column.

Related information across each row is kept together when the sort is

applied.

Sort range sorts the data in a range of cells, which can be helpful when

working with a sheet that contains several tables. Sorting a range will

not affect other content on the worksheet.

To sort a sheet:

Select a cell in the column you wish to sort

Select the Data tab on the Ribbon, and then click

the Ascending command to Sort A to Z, or the Descending

command to Sort Z to A.

The worksheet will be sorted by the selected column.

To sort a range:

Select the cell range you wish to sort

Select the Data tab on the Ribbon, and then click the Sort command.

The Sort dialog box will appear. Choose the column you wish to sort

Decide the sorting order (either ascending or descending).

Once you're satisfied with your selection, click OK.

The cell range will be sorted by the selected column.

If your data isn't sorting properly, double-check your cell values to make sure

they are entered into the worksheet correctly. Even a small typo could cause

problems when sorting a large worksheet.

Custom sorting

Sometimes you may find that the default sorting options can't sort data in the

order you need. Fortunately, Excel allows you to create a custom list to define

your own sorting order.

To create a custom sort:

1. Select a cell in the column you wish to sort by. 2. Select the Data tab, and then click the Sort command. 3. The Sort dialog box will appear. Select the column you want to sort by,

and then choose List... from the field. 4. The Lists dialog box will appear. Select NEW LIST from the Lists: box. 5. Type the items in the desired custom order in the List entries. 6. Click Add to save the new sort order. The new list will be added to

the lists: box. Make sure the new list is selected, and then click OK. 7. The Lists dialog box will close. Click OK in the Sort dialog box to perform

the custom sort. 8. The worksheet will be sorted by the custom order.

For Example: we have done the custom sorting of AGE in sheet 1 AS in from smallest to largest:-

COUNTIF FUNCTION

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

Syntax: COUNTIF (range, criteria)

For example:

=COUNTIF(A2:A5,"apples") =COUNTIF(A2:A5,A4)

Argument name Description

Range (required) The group of cells you want to count. Range can contain numbers, arrays, or references that contain numbers. Blank and text values are ignored.

Learn how to select ranges in a worksheet.

Criteria (required) A number, expression, cell reference, or text string that determines which cells will be counted.

For example, you can use a number like 32, a comparison like ">32", a cell like B4, or a word like "apples".

COUNTIF uses only single criteria. Use COUNTIFS if you want to use multiple criteria

COUNTIFS FUNCTION

This article describes the formula syntax and usage of the COUNTIFS function in Microsoft Excel.

Description

Applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

Syntax

COUNTIFS (criteria_range1, criteria1, *criteria_range2, criteria2+)

The COUNTIFS function syntax has the following arguments:

Criteria_range1 Required. The first range in which to evaluate the associated criteria. Criteria1 Required. The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32". Criteria_range2, criteria2, Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.

IMPORTANT - Each additional range must have the same number of rows and columns as the criteria_range1argument. The ranges do not have to be adjacent to each other.

COUNTA FUNCTION

This article describes the formula syntax and usage of the COUNTA function in Microsoft Office Excel.

Description

The COUNTA function counts the number of cells that are not empty in a range.

Syntax

COUNTA (value1, [value2], ...)

The COUNTA function syntax has the following arguments:

Value1 Required. The first argument representing the values that you want to count. Value2,.. Optional. Additional arguments representing the values that you want to count, up to a maximum of 255 arguments.

COUNTBLANK FUNCTION

This article describes the formula syntax and usage of the COUNTBLANK function in Microsoft Excel.

Description

Counts empty cells in a specified range of cells.

Syntax

COUNTBLANK (range)

The COUNTBLANK function syntax has the following arguments:

Range Required - The range from which you want to count the blank cells.

PIVOT TABLE

INTRODUCTION

A pivot table is an interactive worksheet table that quickly summarizes large

amounts of data using calculation methods you choose. It is called a pivot table

because its row and column headings can be rotated around the core data area

which gives different views of the source data. The pivot table is simply a tool

which is used to create a unique perspective on the data. With a pivot table

report, one can quickly and easily categorize the data into groups, summarize

large amounts of data into meaningful information, and perform a wide variety

of calculations in a fraction of item it takes by hand. The pivot table is often the

fastest and most efficient way to calculate and shape data.

USAGE OF PIVOT TABLE

Pivot table is used in the following situations:

When there is large amount of transactional data and it has increasingly

become difficult to analyze and summarize in a meaningful way.

To find the relationships and groupings within the data.

To find the list of unique values for one field in the data.

To find data trends using various time periods.

To organize the data into a format thats easy to chart.

COMPOSITION

A pivot table is composed of four areas. The data place in these areas defines

the appearance of the pivot table. The four areas are described as follows:

Row area: It is composed of the headings that go down the left side of

the pivot table. Dropping a field into the row area displays the unique

values from the field down the left side of the pivot table.

Column area: The column area is composed of headings that stretch

across the top of columns in the pivot table.

Value area: It is the large rectangular area below and to the right of the

headings.

Report filter area: Is an optional set of one or more drop-downs at the

top of the pivot table dropping fields into the report filter area that

would allow filtering the data items in the fields.

STEPS TO CREATE PIVOT TABLE

1. To start, click on any single cell in the data source. This ensures that the

pivot table captures the range of the data source by default.

2. Select the Insert tab and find the Tables group. In the tables group select

Pivot Table and then choose Pivot Table from the drop down list.

3. The Create Pivot Table window displays. Notice the data range has been

selected by Excel.

4. Click OK.

5. The Pivot Table Field List window displays to begin creating the pivot

table.

IF FUNCTION

The Excel IF function tests a user-defined condition and returns one result if

the condition is true and another result if the condition is false.

The syntax of the function:

IF (logical_test, value_if_true, value_if_false)

Where the argument are as follows:

Logical_test: the user defined condition that is to be tested and

evaluated as either TRUE or FALSE.

Value_if_true: the result that is to be returned from the function if the

supplied logical_test evaluates to TRUE.

Value_if_false: the result that is to be returned from the function if the

supplied-test evaluates to FALSE.

The IF function in Excel helps in solving many problems. It adds flexibility to the

spreadsheet by bringing decision making. With 'IF' one can perform

calculations with Excel data based on defined conditions and can analyse excel

data based on set criteria. Therefore, using 'IF' helps to analyse and calculate

the data according to the problem definition.

FILTER FUNCTION Filtering data in a spreadsheet means to set conditions so that only certain data is displayed. It is done to make it easier to focus on specific information in a large database or data. Filters works with records or rows of data in the database. The conditions that are set are compared with one or more fields in the record. If the conditions are met, the record is displayed. If the conditions are not met, the record is filtered out so that it isn't displayed with the rest of the data records.

Types of Filtering:

Filtering Numeric Data

Numerical data can be filtered based on:

Whether or not the data equals a certain number.

Whether or not the data is greater than, less than a specific number.

The data is above or below the average value of the data as a whole.

Filtering Text Data

Text data can be filtered based on:

Whether or not the data matches a certain word.

Whether the data is a word containing one or more letters.

Whether the data is a word that begins or ends with a specific letter of the

alphabet.

VLOOKUP FUNCTION

This article describes the formula syntax and usage of the VLOOKUP function in Microsoft Office Excel.

Description

You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range. For example, suppose that you have a list of employees contained in the range A2:C10. The employees' ID numbers are stored in the first column of the range, as shown in the following illustration.

If you know the employee's ID number, you can use the VLOOKUP function to return either the department or the name of that employee. To obtain the name of employee number 38, you can use the formula =VLOOKUP (38, A2:C10, 3, FALSE). This formula searches for the value 38 in the first column of the range A2:C10, and then returns the value that is contained in the third column of the range and on the same row as the lookup value ("Axel Delgado").

Syntax

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

CONCLUSION

Sample Size/Target Respondents

The sample size of the survey was around 101 passengers. The general

passengers age profile was from 18 years to 51 years with maximum response

coming in from the young adults/youth i.e. 18-30 years of age. About 36.63%

were female respondents and balance (63.37%) was males.

Passenger Survey Findings

Top Efficiencies

1. Punctuality

2. Mode of Ticket booking

3. Awareness of E-ticket

Top Deficiencies

1. Perception of the consumer

2. Safety

Top Three Concerns/Priority Areas

1. Punctuality

2. Perception of the consumer

3. Awareness of E-ticket

Satisfactory Services (Rated as Good)

1. Using E ticket.

2. Internet being used as the mode to book ticket.

Other Findings of the Survey

More than 78% of the people have used IT Enabled services such as Internet

Ticketing.

73% of the passengers surveyed confirmed that they have seen service

improvements in the Railways.

66.33 % of the passengers surveyed are satisfied with the train mostly on

time.

74.2 % of the passengers surveyed think that Railwaysare not good in the

security arrangement in trains adequate to prevent crimes/thefts in trains.

58.4% of the passengers feel that the behaviour of Railway staff at inquiry

counters are mostly courteous.

55.5 % of the passengers surveyed rated Overall Services provided by the

Railways as Good.

********