Assessment Information
This assignment is designed to assess learning outcomes 1, 2, 3, 4 and 5.
Learning outcomes
- Define and evaluate key concepts of business analytics.
- Critically apply business analytics skills for decision making.
- Critically analyse and interpret the outputs of data mining models and forecasting results for end-users.
- Solve managerial problems and make systematic decisions by applying business data analysis techniques.
- Have ability to apply business analytics to various international business contexts by
selecting appropriate techniques.
This is an individual Assignment.
Task One-Business analytics concepts [25 marks]
a. Describe descriptive, predictive and prescriptive analytics with addressing all techniques which you have
learned during the lectures. Give proper example for each [8 marks]
b. Critically discuss and analyse five published papers which have used mentioned techniques in the Task
one (a) with proper explanation. The technique, its application and the results need to be interpreted
properly [17 marks]
Assignment Brief Template
Page 2 of 10
Task Two- Regression Analysis [25 marks]
An analysis is done about 20 selected hotels considering some characteristics. Customer satisfaction in overall as
well as each characteristic has been gathered and reported in Table 1.
Table 1- Customer satisfaction rate of twenty hotels
a. Determine and interpret that which variable is more correlated to the overall satisfaction. Is it highly or
lowly correlated? What do you conclude? [5 marks].
b. Plot the data and find the simple regression model for Overall and Comfort. Interpret it clearly [5
marks].
c. Identify the slope, the intercept in (b), then interpret the values [5 marks].
d. How much is the R-square value? Properly interpret its value. [5 marks].
e. What will be happened if we only consider one independent variable in the regression analysis. Discuss
on the results of simple regression comparing with the result of multiple regression. [5 marks].
Task Three- Forecasting [50 marks]
Suppose that you have gathered sales data of a company from 2013-2019 in different quarters. You are going to
to consider the company sales value and to forecast the company amount of sales in 2020 in different quarters.
Look at the gathered data of previous years related to the amount of sales in each quarter which have been reported
in Table 2.
Table 2- Data of amount of sales among previous years
Hotel Overall Comfort Amenities In-House
Dining
H1 92.68 91.50 87.80 95.70
H2 94.73 92.60 85.10 98.60
H3 92.93 97.90 97.00 90.40
H4 93.05 90.50 93.70 94.00
H5 90.00 92.00 83.80 92.10
H6 90.20 90.40 83.00 95.70
H7 89.73 95.90 87.20 87.90
H8 91.90 91.50 94.50 88.80
H9 86.70 93.60 81.80 87.70
H10 89.63 92.50 85.20 88.40
H11 86.18 87.80 81.90 85.50
H12 90.55 92.00 95.00 87.60
H13 84.28 88.50 74.20 89.20
H14 81.90 91.00 89.60 71.50
H15 85.50 91.90 72.90 90.60
H16 86.33 95.30 77.00 88.50
H17 88.08 91.40 79.30 90.80
H18 88.25 95.80 76.40 88.40
H19 84.15 94.00 68.20 89.20
H20 86.08 94.40 76.30 88.80
Assignment Brief Template
Page 3 of 10
Year Q Revenue
Four
Moving
average
Baseline
(CMA)
Seasonalit
y
Deseasonality Trend Forecast Error MAD
Error MSE MA
PE
2013 1 480
2013 2 650
2013 3 780
2013 4 504
2014 1 537
2014 2 645
2014 3 800
2014 4 526
2015 1 575
2015 2 655
2015 3 826
2015 4 548
2016 1 592
2016 2 702
2016 3 884
2016 4 582
2017 1 676
2017 2 782
2017 3 945
2017 4 681
2018 1 730
2018 2 805
2018 3 1010
2018 4 710
2019 1 775
2019 2 840
2019 3 1060
2019 4 752
a. Use the data of mentioned table to compute the four-period moving average and enter your values in the
appropriate columns. [5 marks]
b. Plot the data and describe the main features of the series. [5 marks]
c. Calculate the Centered Moving Average (CMA)/Baseline. Interpret it. [5 marks].
d. Calculate the Trend and interpret the trend. [5 marks].
e. Determine the Seasonality (St) and interpret it properly [5 Marks].
f. Forecast the revenue for 8th year [10 Mark].
g. Calculate the Error, Mean absolute deviation (MAD) error, Mean Square Error (MSE) and Mean Absolute
Assignment Brief Template
Page 4 of 10
percentage error (MAPE). [10 marks]
h. Write a brief report to explain and evaluate and make comments on the error variables, the forecasted and actual
revenues [5 marks].
Type of service: Academic paper writing
Type of assignment: Report
Subject: Business
Pages/words: 10/2500
Number of sources: 6
Academic level: Undergraduate
Paper format: APA
Line spacing: Double
Language style: UK English
