Question: PART 4: Time Series Analysis The table below shows information about visits to the UK by overseas residents, and visits abroad by UK residents. The

PART 4: Time Series Analysis The table below shows information about visits to the UK by overseas residents, and visits abroad by UK residents. The data is also available as an Excel file on Blackboard. Q2 2016 03 2016 Q4 2016 Q1 2017 Q2 2017 Q3 2017 Q4 2017 Q1 2018 Q2 2018 Q3 2018 Q4 2018 Q1 2019 Q2 2019 Q3 2019 Q4 2019 Q1 2020 Q2 2020 Q3 2020 Q4 2020 Q1 2021 Q2 2021 Number of visitors to UK from overseas Thousands 10138 10892 9900 8847 11012 11899 9322 8547 10521 11536 9679 8332 10364 11864 10297 6994 398 2322 1386 195 277 Spending by overseas visitors to UK Millions 6533 8235 6200 5075 7153 10088 6080 5194 6939 8401 5974 4805 6896 9193 7555 4344 218 1037 611 248 386 Number of UK residents visits abroad Thousands 21787 27548 17450 15934 23744 28699 18865 16592 24646 29923 19409 18159 25760 30000 19167 13891 939 6191 2806 774 1000 2021-11-29T13_57_06.24965847-Data Analysis for Business 202122- Assessment 2 Brief- 52708.docx 12 Source: https://www.ons.gov.uk/ Select some of the data above and complete a time series analysis. You do not need to analyse all of the data. Clearly state and interpret all seasonal effects that you have calculated. Use your model to make relevant predictions. Use calculator or Excel (see your seminar on time series analysis). Present your results on the next pages. PART 4: Time Series Analysis The table below shows information about visits to the UK by overseas residents, and visits abroad by UK residents. The data is also available as an Excel file on Blackboard. Q2 2016 03 2016 Q4 2016 Q1 2017 Q2 2017 Q3 2017 Q4 2017 Q1 2018 Q2 2018 Q3 2018 Q4 2018 Q1 2019 Q2 2019 Q3 2019 Q4 2019 Q1 2020 Q2 2020 Q3 2020 Q4 2020 Q1 2021 Q2 2021 Number of visitors to UK from overseas Thousands 10138 10892 9900 8847 11012 11899 9322 8547 10521 11536 9679 8332 10364 11864 10297 6994 398 2322 1386 195 277 Spending by overseas visitors to UK Millions 6533 8235 6200 5075 7153 10088 6080 5194 6939 8401 5974 4805 6896 9193 7555 4344 218 1037 611 248 386 Number of UK residents visits abroad Thousands 21787 27548 17450 15934 23744 28699 18865 16592 24646 29923 19409 18159 25760 30000 19167 13891 939 6191 2806 774 1000 2021-11-29T13_57_06.24965847-Data Analysis for Business 202122- Assessment 2 Brief- 52708.docx 12 Source: https://www.ons.gov.uk/ Select some of the data above and complete a time series analysis. You do not need to analyse all of the data. Clearly state and interpret all seasonal effects that you have calculated. Use your model to make relevant predictions. Use calculator or Excel (see your seminar on time series analysis). Present your results on the next pages
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
