convert figures in relation to bike ownership | My Assignment Tutor

GO RIDE CASE STUDYPage 1 of 17Analysis Questions linked to Task 1 [15 marks] – in a formal assessment this would be 10 marksYou were asked to convert figures in relation to bike ownership per 1000 inhabitants into two sets of indexnumbers. The figures related to three European countries: United Kingdom, Netherlands and the Republicof Ireland.A. Why do you think you have been asked to use Index numbers rather than the original figures? [2]B. What were the index numbers you calculated for Year 14? Please round to one decimal place [3] United KingdomNetherlandsRepublic of IrelandSimple indexChain index C. Using the Republic of Ireland figures in (B), explain what the two index numbers are illustrating? [2] Simple IndexChain Index D. You were also asked to construct a graph which compared the simple index numbers across thethree countries. Please a comment which you consider to be the main observation on the graph. [1]E. Would Year 17 be considered a suitable choice for setting a base year? Please provide a reason foryour answer. [2]GO RIDE CASE STUDYPage 2 of 17F. You were asked to construct a graph which compared the chain index numbers across the threecountries. Please provide a comment which you consider to be the main observation [1]G. By using the image of a spreadsheet layout below. Please state the Excel formula that would beentered into Cell E3 and would then be subsequently copied down in order to calculate the simpleindex for the UK. [2] Formula that would be entered in E3: H. Figures for Year 19 in the UK have been recently received i.e. 46.1 bikes per 1000 inhabitants.Calculate both the simple and chain index for the UK in Year 19. As a reminder the base point isYear 11. [2] Simple IndexChain Index GO RIDE CASE STUDYPage 3 of 17Analysis Questions linked to Task 2 [25 marks] in a formal assessment this would be 20 marksPrior to this examination you were asked to carry out some preparatory work which relates to the topic ofregression and correlation.A. For the relationship between total distance travelled and the hire time please provide anapproximate copy of the scatter diagram which you were asked to create. Between 10 to 20crosses should be sufficient to illustrate the graph you created in Excel. Please ensure that thisgraph is fully labelled. [3]B. Please now describe what this graph is illustrating including the context of the relationship and thecorrelation coefficient value you calculated (please round this figure to three decimal places). [3]C. Now consider the graph between age and the total distance travelled. What is unusual about thisscatter diagram? What impact could this have on the correlation coefficient? [3]GO RIDE CASE STUDYPage 4 of 17D. Which of the two relationships is the strongest? [1] Distance travelled and AgeDistance travelled and Hire time E. What is the linear regression equation for this strongest relationship? Present the numerical valuesto two decimal places [3]F. Use this regression line to predict the total distance travelled for someone who is either aged 37 orthe hire time has been 65 minutes. [2]G. Please state whether this prediction an example of Interpolation or extrapolation and provide therationale for your decision? [3]H. The European Cycling Barometer (2015) showed that the top 8 European countries for cycling werein order: Denmark; Netherlands; Sweden; Finland; Germany; Belgium; Slovenia and Hungary.The GO BIKE have carried out a survey amongst their users and asked respondents to place whatthey felt were the most popular cycling country. The results, based on percentage response ratewere: Denmark13%Germany3%Netherlands57%Belgium13%Sweden6%Slovenia1%Finland5%Hungary2% GO RIDE CASE STUDYPage 5 of 17Calculate a suitable correlation coefficient and comment on what this value indicates in respect to the levelof agreement between the two data sets. In order to assist the following grid for intermediate calculationsis provided [7] Cycling barometerGo Ride Surveydd2 r = 1 –6d2n(n2-1) GO RIDE CASE STUDYPage 6 of 17Questions linked to Task 3 [30 marks] in a formal assessment this would be 20 marksPrior to this examination you were asked to carry out some preparatory work on a data set elating toquarterly bike sales in the UK over an eight year period.A. You were asked to apply both an additive and multiplicative model to the data, which model didyou feel was the most suitable to apply to the data set and why? [4]B. Analysis of a time series produces a mass of intermediate calculations, for the model you haveselected as being the most appropriate, please state the figures (rounded to three decimal places)for: Moving average value associated with Year 3 quarter 4 [1]Additive model seasonal average for quarter 1 before residualadjustment [1] C. When carrying out a forecast into the future how would TREND be calculated, ensuring you definetime appropriately? Please present the figures used to three decimal places [3] Trend = D. If the figures provided were monthly what would the overall seasonal averages need to add up tofor the two different time series models [2]? Additive:Multiplicative: GO RIDE CASE STUDYPage 7 of 17E. For the Year 9, the following figures have now become available Please complete the table belowfor the model you selected as the most suitable to represent the data set [6] QuarterBike salesForecast of TrendForecast of SeasonForecast of Participants1383239334054415 F. Using both the graph you produced in the preparatory work and the figures above, express youropinions and appropriate rationale in respect to the accuracy of the forecasts [3]G. The graph below relates to data collated by GO RIDE company in Barcelona and illustrates thenumber of bike hires made within the city during the month of December.200210220230240250260270280290MonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunMonTueWedThuFriSatSunNumber of bike hires made in Barcelona duringDecember.GO RIDE CASE STUDYPage 8 of 17Describe what this graph illustrates in terms of… Trend [1]Seasonality [1]What model(additive ormultiplicative) ismost likely toapply and why?[2] H. The following illustrates some of analysis that would have been undertaken for a MULTIPLICATIVEMODEL on the data set for daily hires in Barcelona.Please enter into the table below the EXCEL formulae that would be entered into the following cells [6] CellFormulaCellFormulaD5:H4:E8:K2:F2P7: GO RIDE CASE STUDYPage 9 of 17Analysis Questions linked to Task 4 [65 marks] in a formal assessment this would be 40 marksPrior to this examination, you were asked to prepare a number of summary figures and graphs in respect toa SAMPLE of 175 transactions linked to the GO RIDE bike hire scheme.A. For each of the three locations you were asked to calculate what percentage of transactionsresulted in a pick-up fee being charged. Please now present this data in a suitable graph [5]B. You were also asked to calculate the revenue for an individual transaction. You were then asked todetermine for each of the locations the median and interquartile range for these revenues (inEuros). Please state what these values were? [3]Table illustrating the Median and Interquartile Value for Revenue across the three locations City/LocationMedianInterquartile rangeAmsterdamDublinNewcastle C. Please provide a comment on what both sets of figures in (B) tell you in respect to the revenuesbetween the three cities [2]GO RIDE CASE STUDYPage 10 of 17D. Please present in a suitably labelled table, the figures you calculated in respect to the averagedistance travelled across the three locations by gender. Please use two decimal places [4]E. By referring to this table, what is your main observation in relation to similarities or differencesbetween: Locations [1]Gender [1]Gender withineach location [2] F. You were also asked to calculate standard deviations by location and gender. In general, what doesa standard deviation help you make additional observations about? [2]GO RIDE CASE STUDYPage 11 of 17G. Now please present in a suitably labelled table, the figures you calculated in respect to thestandard deviations for the distance travelled across the three locations by gender. Please use twodecimal places [4]H. By referring to this table, what further observations can be made about the distances travelled bylocation and gender [2]I. The company has also received summary information in respect to the total distances travelledwithin Barcelona by Females. This is presented below Total DistanceTravelled (km)FrequencyMid-pointfxCumulative Frequency0 up to 20 km520 up to 40 km2040 up to 60 km4560 up to 80 km30Total100 GO RIDE CASE STUDYPage 12 of 17Using the information provided in this table, calculate the mean distance travelled by females withBarcelona and estimate the median distance travelled by females. [10] Mean = fx/fGraph grid: J. How does the average distance travelled by females in Barcelona compare to the other threelocations? [2] 0204060801001200 20 40 60 80 100 GO RIDE CASE STUDYPage 13 of 17K. In the preparation work you were asked to construct frequency polygons in relation to thedistances a bike has been left from one of the housing units i.e. pick up distance for each of thethree locations. Based on your observations, which of the three locations LEAST resembles thenormal distribution? [1] AmsterdamDublinNewcastle L. For each location calculate and determine the location where it is most likely to have pick-ups 20km or more away. (Hint: use the frequency & probability table you created) [6] AmsterdamDublinNewcastleMost likely location to be have pickups more than 20 km away and why M. The GO RIDE company is reviewing its policy on offering free pickups within a 30km radius andreducing this down to 20km. They have estimated the average costs for making an individual pickupof 20km or more across the three locations and these are listed below. Complete the followingtable (showing your calculations) and state (in the space below) which location has the most costsassociated with it and why [5] (Hint: use the frequency & probability table you created) LocationAverage Pickup cost(Euros)Number of pickupsof 20km or more Estimated costsAmsterdam 0.75Dublin 0.8Newcastle 1.05Most costly and why? GO RIDE CASE STUDYPage 14 of 17N. Across all three locations (sample size = 175) the average distance to a pick up point was found tobe 17.33 km and the standard deviation 7.78 km. Using these figures please calculate a 95%confidence interval to represent the pick-up distance within the true population mean will lie? [4]Formula: xO. The company are also considering changing their pricing policy. For example, they may charge forone hour blocks rather than 30 min blocks or offer a discounted rate for those hiring bikes for morethan 90 minutes. If the average time for hire is 79.35 minutes with a standard deviation of 18.85minutes, calculate the probabilities for the following scenarios.Formula: A bike is hired formore than 90minutes [3]A bike is hiredbetween one hourand 90 minutes [4] GO RIDE CASE STUDYPage 15 of 17P. What is minimum hire time for the top 5% of the distribution. Remembering the average time forhire is 79.35 minutes with a standard deviation of 18.85 minutes [4]Formula:GO RIDE CASE STUDYPage 16 of 17Analysis Questions linked to Task 5 [15 marks] – in a formal assessment this would be 10 marksAs part of the preparatory work linked to this analysis you were asked to formulate and solve a linearprogramming question to assist in the distribution of the GO RIDE bike units across Newcastle City Centre.Four locations were being considered: Central Railway Station (C), Monument Metro Station (M),Newcastle Quayside (Q) and Northumbria University’s City Campus East (U).A. By using the letters in brackets to represent each of these locations please write down an equation(algebraic) to represent how revenue is calculated [2]B. By using the letters in brackets to represent each of these locations please write down an equation(algebraic) to represent the budget available for setting up the bikes [2]C. For the Quayside (Q), please write down two equations that would be used in the linearprogramming model to represent the Minimum and Maximum number of bikes which could behosted at this location [2]D. How many bikes should be distributed across each of the four locations in order to maximiserevenue? [2] Central, CMonument, MQuayside, QUniversity, UWhat is the maximum revenue generated? [1] GO RIDE CASE STUDYPage 17 of 17E. Following consultation with the sensitivity report, what does the shadow price that is linked tocosts of distributing the bikes across the four locations indicate? Please include in your answer anexplanation of what the allowable increase and decrease illustrates. [3]F. The GO RIDE team could potentially allocate a further 2 staff to transportation and set-up each day.Is this something that you would recommend to the company? In your response please provide ajustification for your answer [2]G. By how much would the revenue from the University need to decrease by before the currentsolution would change? [1]


Leave a Reply

Your email address will not be published.