Individual Assignment— Business Statistics and Data Analysis

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

  1. Report the descriptive statistics (summary statistics) for each variable (House price, Interest rate, and Stock price).

(15 Marks)

  1. 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)

  1. 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)

  1. 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)

  1. 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.

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
Still stuck on your due assignments?
Hire our experts now and get it delivered within hours!