Individual Assignment— Business Statistics and Data Analysis
Background
You are thinking of investing in the property market, you know that different factors can impact the house prices and you are particularly interested to find out if there is a significant relationship between house price and interest rate and house price and stock price so that you can predict the house prices based on the movements of these variables.
Use the provided data set, perform appropriate analysis, and write a report of 2000 words based on your analysis. To write your report and justify the findings, you are encouraged to refer to 3 to 5 related peer-reviewed academic journal articles as well as textbooks.
Your report should contain the following:
- Abstract (No more than 50 words) (5 Marks)
- Introduction (10 Marks)
- Main body, which should also be organised under appropriate headings* (75Marks)
- Conclusion (5 Marks)
- References (5 Marks)
Total:100 Marks
* In the main body of the report you are required to
- Report the descriptive statistics (summary statistics) for each variable (House price, Interest rate, and Stock price).
(15 Marks)
- Plot time series graph for each variable (House price, Interest rate, and Stock price) and provide a summary of the movement of the variables in the period of the study.
(15 Marks)
- Plot scatter graphs of House price against Interest rate and Stock price and explain the graphs (Dependent Variable: House price, Independent Variable: Interest rate, Independent Variable: Stock price).
(10 Marks)
- Calculate the correlation between House price and Interest rate and House price and Stock price and report your findings. Justify your results with the scatter graphs in part c.
(15 Marks)
- Calculate the equation of the regression line between House price and Interest rate, and House price and Stock price then interpret regression analysis results based on P-Values and Coefficients (Dependent Variable: House price, Independent Variable: Interest rate, Independent Variable: Stock price); explain which variable seems to be a better predictor for the House price.
(20 Marks)
***Note: In the provided data set you have below monthly time series data for the period of 29/03/2018 to 28/02/2023.
Below indices are used for the variables (Dependent Variable: House price, Independent Variables: Interest rate, and Stock price):
House price: UK House Price Index (UKLHUK Index)
Interest rate :3-month LIBOR UK (BP0003M Index)
Stock price: FTSE 250 Index (MCX Index)
Student Assignment Guidelines
In your report, you should demonstrate your knowledge of and ability to explain and apply statistics theory. You must justify any conclusion you reach on the basis of evidence provided by you by reference to, or quotation from, the course notes, textbooks, other course readings, or any other source you choose to use. As long as your report gives a good justification and demonstrate your reasoning ability and your knowledge, you can obtain a good grade.
Presentation
Your work should be word processed in accordance with the following:
- Font style, Lucida Sans, font size 12
- 1.5 line spacing.
- The page orientation should be ‘portrait’
- Margins on both sides of the page should be no less than 2.5 cm
- Pages should be numbered
- Your name should not appear on the script.
- Your student number should be included on every page.
Skills Advice
Refer to your material provided in your skills modules to make sure that you have conformed to academic conventions. Pay particular attention to:
- Your introduction,
- Your conclusion,
- The use of headings and/or signpost words
- Paragraph structure
Referencing
The university expects students to use Harvard referencing as specified in the book Cite them Right.
- Refer to Referencing Information | University of East London (uel.ac.uk) for further advice and a link to an online version of Cite them Right
- You should be careful to include citations within your work as well as a reference list at the end.
Word Count
Your word count should not include your title page, table of contents, reference list or appendices. You should provide your word count at the end of your report. Exceeding the word count by more than 10% will result in a penalty of 10% of your marks for your work.
If your work is significantly shorter, then you will probably have failed to provide the level of detail required.
Submission to Turnitin of Work Submitted for Assessment
Our policy on the use of Turnitin recognises the educational desirability that all of our students should enjoy the opportunity to self-submit their work to Turnitin (before submitting for assessment). We also recognise that Turnitin Originality Reports will sometimes assist in the identification of plagiarised work submitted for assessment.
Work that is submitted to Turnitin generates a Turnitin originality report, showing which parts of it have been reproduced from which sources. The system compares submissions to material that is to be found: on the world-wide web; in its database of previous submissions; and in its growing number of databases of published articles. You should not assume that a Turnitin originality report with a low similarity index is evidence that the piece of work concerned is free from plagiarism.
Our policy provides that a Module Leader may decide, in accordance with the policy of RDBS, that all student submissions for a particular component of assessment should be submitted to Turnitin, provided that the relevant Module Guide includes a notice to that effect.
Notice is hereby given that all submissions of reports for this Module must be submitted to Turnitin. Detailed guidance on how to submit your work to Turnitin will be made available on this Module’s UEL Plus site.
If you fail to submit your report to Turnitin, in accordance with the guidance on the UEL Plus site, you will be awarded a mark of 0 for the component.
Submission
The material that you submit to Turnitin will be marked. The deadline applies so you are advised not to submit after 17:00, because it could take some time for your submission to upload, and the delay could cause the work to be received after 17:00.
Please be aware that the Turnitin site will advise you that late submissions are accepted. This is only for the purposes of allowing students who are claiming extenuation to submit their work.
Please read the material in the submission folder and make sure that you attach the feedback sheet as requested and save the document using the format for the name of the document as specified.
Late Submissions Using Turnitin
UEL has permitted students to be able to submit their coursework up to 24 hours after the deadline. Assessments that are submitted up to 24 hours late are still marked, but with a 5% deduction. However, you have to be very careful when you are submitting your assessment. If you submit your work twice, once using the original deadline link and then again using the late submission link on Turnitin, your assignment will be graded as late with the 5% deduction.
Extenuating Circumstances
Extenuating Circumstances are circumstances which:
- impair your examination performance in assessment or reassessment, or
- prevent you from attending for assessment or reassessment, or
- prevent you from submitting assessed or reassessed work by the scheduled date
If you need to apply for extenuating circumstances please find the relevant information at:
Extenuation Procedures | University of East London (uel.ac.uk)
Student Appeals
Students who wish to appeal against Field and ward Boards decisions can find the relevant information at:
http://www.uel.ac.uk/qa/qualityass_appeals.htm
Data sets
| Date | UKLHUK Index | BP0003M Index | MCX Index |
| 3/31/2018 | 223772 | 0.7118 | 19460.47 |
| 4/30/2018 | 225910 | 0.71034 | 20285.05 |
| 5/31/2018 | 226834 | 0.61149 | 20846.26 |
| 6/30/2018 | 228355 | 0.67413 | 20830.97 |
| 7/31/2018 | 231187 | 0.79825 | 20877.87 |
| 8/31/2018 | 231898 | 0.8005 | 20689 |
| 9/30/2018 | 231454 | 0.80025 | 20307.04 |
| 10/31/2018 | 231211 | 0.81675 | 18917.68 |
| 11/30/2018 | 230224 | 0.89338 | 18480.83 |
| 12/31/2018 | 229729 | 0.91244 | 17502.05 |
| 1/31/2019 | 228315 | 0.912 | 18711.75 |
| 2/28/2019 | 227738 | 0.852 | 19181.35 |
| 3/31/2019 | 227104 | 0.84838 | 19117.49 |
| 4/30/2019 | 228749 | 0.81688 | 19824.81 |
| 5/31/2019 | 229061 | 0.79588 | 18970.25 |
| 6/30/2019 | 230049 | 0.77375 | 19462.1 |
| 7/31/2019 | 232618 | 0.77263 | 19666.52 |
| 8/31/2019 | 233366 | 0.75925 | 19393.63 |
| 9/30/2019 | 233536 | 0.758 | 19936.67 |
| 10/31/2019 | 232919 | 0.80925 | 20021.5 |
| 11/30/2019 | 232096 | 0.79313 | 20812.6 |
| 12/31/2019 | 231792 | 0.79163 | 21883.42 |
| 1/31/2020 | 231940 | 0.76475 | 21143.49 |
| 2/29/2020 | 230609 | 0.67275 | 19330.92 |
| 3/31/2020 | 232684 | 0.5955 | 15101.13 |
| 4/30/2020 | 230318 | 0.59425 | 16454.46 |
| 5/31/2020 | 231508 | 0.22775 | 17042.96 |
| 6/30/2020 | 234703 | 0.14088 | 17119.16 |
| 7/31/2020 | 236687 | 0.08438 | 16932.65 |
| 8/31/2020 | 238998 | 0.064 | 17788.33 |
| 9/30/2020 | 241541 | 0.06088 | 17315.3 |
| 10/31/2020 | 243575 | 0.0445 | 17214.38 |
| 11/30/2020 | 246065 | 0.04463 | 19336.32 |
| 12/31/2020 | 247983 | 0.0255 | 20488.3 |
| 1/31/2021 | 249690 | 0.03938 | 20228.58 |
| 2/28/2021 | 249586 | 0.066 | 20910.37 |
| 3/31/2021 | 253506 | 0.08788 | 21518.71 |
| 4/30/2021 | 250210 | 0.08388 | 22497.37 |
| 5/31/2021 | 251285 | 0.08125 | 22683.95 |
| 6/30/2021 | 265676 | 0.07788 | 22376.02 |
| 7/31/2021 | 252960 | 0.074 | 22948.83 |
| 8/31/2021 | 260429 | 0.06838 | 24102.19 |
| 9/30/2021 | 269003 | 0.08188 | 23031.29 |
| 10/31/2021 | 263333 | 0.22825 | 23106.61 |
| 11/30/2021 | 267370 | 0.09388 | 22519.72 |
| 12/31/2021 | 268115 | 0.26225 | 23480.81 |
| 1/31/2022 | 272738 | 0.6374 | 21926.62 |
| 2/28/2022 | 272454 | 0.878 | 21081.05 |
| 3/31/2022 | 273787 | 1.0354 | 21160.07 |
| 4/30/2022 | 277168 | 1.2305 | 20708.71 |
| 5/31/2022 | 280903 | 1.4247 | 20417.95 |
| 6/30/2022 | 283164 | 1.6692 | 18666.78 |
| 7/31/2022 | 289025 | 1.9357 | 20164.9 |
| 8/31/2022 | 291452 | 2.5342 | 19063.75 |
| 9/30/2022 | 292404 | 3.3444 | 17168.34 |
| 10/31/2022 | 292288 | 3.3627 | 17889.93 |
| 11/30/2022 | 292552 | 3.6827 | 19163.33 |
| 12/30/2022 | 291361 | 3.874 | 18853 |
| 1/31/2023 | 288778 | 4.1249 | 19853.45 |
| 2/28/2023 | 288363 | 4.3247 | 19903.28 |