You are required to investigate some data, concentrating on the manipulation and presentation together with an appropriate analysis.


This data is a devised list of property transactions for the borough of Kingston-upon-Thames, in the years 2005-2010, keeping in mind the economic climate in the UK in those years. It may be helpful to consult appropriate resources in order to inform yourself on this, if necessary.


You should select your data from the Excel file provided to you by your tutor. You may find it useful to generate more columns from the data given, in order to interpret it.


You should submit a single Word document consisting of the following:


  1. A short research paper of no more than 1000 words (plus appendices and references). You should use the template provided by your tutor.


  1. An appendix containing any charts, graphs, tables and statistical measures.


Notes and tips for using Excel: 


  1. You should spend some time to formulate your research question (which will be the title of your short paper). You may find it easier to write the abstract last of all.


  1. If you have never used Excel spend time getting to grips with the software. Knowing how to use Excel functions such as IF, IFS, COUNTIF, COUNTIFS, etc. could save you time later on.


  1. In your short research paper, you will need to limit your analysis to the essentials, and write in clear and concise English.


  1. You are not trying to find “right” or “wrong” answers, but you should summarise your analysis with your conclusions and recommendations. Be careful to avoid causal language (“X is caused by Y”) when it is not defensible.


  1. Making reasonable conclusions from your data, particularly in relation to the current affairs of the time, is encouraged. However avoid inferring too much. Pay attention to how your figures are distributed, as well as their numerical value.


  1. In the appendix, you should take care to ensure your output is formatted and presented to a professional standard, instead of accepting the default output from Excel or any other packages. Creative and imaginative graphs and charts can be helpful, as well as engaging. Remember to number and title your graphs and tables, label axes and select the most appropriate output and charts.


  1. There are no “right answers” for this assessment. Your results will depend on what data you choose to look at, what question you decide to investigate, and what analysis you do. For this reason, you should explain what you did as well as what you found. You may get different answers and conclusions from your classmate, but this does not mean that one is “right” and one is “wrong”. The most important is to be able to evidence any claims you make with your analysis.