Topic: Business Individual report

Assessment Information
This assignment is designed to assess learning outcomes 1, 2, 3, 4 and 5.
Learning outcomes

  1. Define and evaluate key concepts of business analytics.
  2. Critically apply business analytics skills for decision making.
  3. Critically analyse and interpret the outputs of data mining models and forecasting results for end-users.
  4. Solve managerial problems and make systematic decisions by applying business data analysis techniques.
  5. 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

get a custom essay

Check our prices