This coursework is due in by Friday of week 13 [ 11th January 2013] The coursework is in 2 parts:
1. Analysing the results of the Travel Newton & Oldingham survey 2. Modelling Record Sales
This coursework contributes 30% of the total marks for the module; 20% for part 1 and 10% for part 2.
Part 1. Analysing the results of the Travel Newton & Oldingham survey
Travel Newtown & Oldingham is a small rail company that runs trains between 4 towns in a small region of an English county. There are only 4 stations; Appleton, Newtown, Oldingham and Sheldon. The rail service is mainly used by people who live or work in the region. The company operates a scheme whereby pensioners and disabled users can travel free using their Freedom Pass providing they travel outside the morning rush hour. Students get reduced fares with a Student Pass. The train operators were keen to get responses from customers as to: * How often passengers use the railway
* How long it takes passengers to reach the stations.
* The types of ticket used
* The reasons for the journeys
* The passengers’ views on the facilities at each station * If there are particular problems at one or more of the stations
In order to get the feedback they required, the management of Travel Newtown & Oldingham decided to survey every fifth passenger that left one of their stations each day during Monday to Friday of a particular week. Passengers were stopped by a team of market researchers who went through the questionnaire with the passengers at the stations. Unfortunately not all passengers agreed to take part in the survey and only 250 responses were collected. The responses can be found in the file TravelNandO. sav
The questionnaire used is shown in Appendix 1
Your line manager, knowing that you have passed a module in business decision making, has asked you to help with analysing the data in the file of responses. You are expected to use SPSS to produce the relevant output to inform your comments. She has asked you to provide answers to the following questions that can be incorporated into a report:
Question 2: How long did it take you to travel to your departure station? * Comment on the descriptive statistics for the length of time that passengers had to travel to the departure stations. How accurate are these statistics? * Previous research indicates that the average length of time passengers have to travel to start their train journeys is 20 minutes. Do your results match this result? * Are there any differences in the average length of time that male and female passengers take to travel to the departure stations to start their train journeys?
Question 4: How many times a month do you make this journey by train? * Comment on the descriptive statistics for the number of times a month passengers make their journeys. How accurate are these results? * Previous research indicates that the average number of times that passengers make journeys on this train service is 14 times a month. Do your results match this result? * Are there any differences in the average number of times that male and female passengers make the journeys?
Question 5: What kind of ticket did you use?
Question 6. What is the main reason for your journey?
* Do the results of these two questions indicate any pattern? Can we say that certain types of tickets are used for particular reasons for travelling?
Question 7: Thinking about the station you travelled FROM, please rate how satisfied you are with the following aspects [facilities, rail services, accessibility, public transport information, personal safety] * For each of the factors, facilities, rail services etc., is there any difference in the responses based on which station the passengers had travelled from? * Is there any difference in the responses regarding...