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 Taskone (a) with proper explanation. The technique, its application and the results need to be interpretedproperly [17 marks]
Assignment Brief Template
Page2 of 10Task 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 hotelsa.Determine and interpret that which variable is more correlated to the overall satisfaction. Is it highly orlowly correlated? What do you conclude? [5 marks].
b.Plot the data and find the simple regression model for Overall and Comfort. Interpret it clearly [5marks].
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. Discusson 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 reportedin Table 2. Table 2- Data of amount of sales among previous yearsHotelOverallComfortAmenitiesIn-House DiningH192.6891.5087.8095.70H294.7392.6085.1098.60H392.9397.9097.0090.40H493.0590.5093.7094.00H590.0092.0083.8092.10H690.2090.4083.0095.70H789.7395.9087.2087.90H891.9091.5094.5088.80H986.7093.6081.8087.70H1089.6392.5085.2088.40H1186.1887.8081.9085.50H1290.5592.0095.0087.60H1384.2888.5074.2089.20H1481.9091.0089.6071.50H1585.5091.9072.9090.60H1686.3395.3077.0088.50H1788.0891.4079.3090.80H1888.2595.8076.4088.40H1984.1594.0068.2089.20H2086.0894.4076.3088.80
Assignment Brief TemplatePage3 of 10YearQ RevenueFour Moving averageBaseline(CMA)Seasonality DeseasonalityTrendForecastErrorMAD ErrorMSEMAPE20131 48020132 65020133 78020134 50420141 53720142 64520143 80020144 52620151 57520152 65520153 82620154 54820161 59220162 70220163 88420164 58220171 67620172 78220173 94520174 68120181 73020182 80520183 101020184 71020191 77520192 84020193 106020194 752a.Use the data of mentioned table to compute the four-period moving average and enter your values in theappropriate 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 TemplatePage4 of 10percentage 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 mark
