Assignment Brief As part of the formal assessment for the programme you are required to submit a Using Information assessment. Please refer to your Student Handbook for full details of the programme...

1 answer below »

View more »
Answered Same DayMay 07, 2020

Answer To: Assignment Brief As part of the formal assessment for the programme you are required to submit a...

Pooja answered on May 10 2020
145 Votes
Analysis
1)
There are seasonal variations observed in the demand and sales in the past 17 years. The demand increases in the month of May-June and sales is observed to increase in the month of August-October every year.  The demand is at its low around the month of January every year. The sale is observed to be lowest in the month of March for the past 17 years
2)
     
     average
     market share
    0.48163905
The average monthly market share is calculated to be £0.48163905
3)
For correcting the data regarding currently promotions started
two months late, lag(2) is taken. The data is given below.
    Date
     lag_market_share_(2)
    
     Date
     lag_market_share_(2)
    
     Date
     lag_market_share_(2)
    
     Date
     lag_market_share_(2)
    Mar-01
    0.5124
    
    Apr-05
    0.3181
    
    Jun-09
    0.2221
    
    Aug-13
    0.3359
    Apr-01
    0.3148
    
    May-05
    0.2679
    
    Jul-09
    0.3121
    
    Sep-13
    0.4711
    May-01
    0.1848
    
    Jun-05
    0.2183
    
    Aug-09
    0.3781
    
    Oct-13
    0.5454
    Jun-01
    0.1672
    
    Jul-05
    0.2735
    
    Sep-09
    0.4337
    
    Nov-13
    0.6550
    Jul-01
    0.2254
    
    Aug-05
    0.3569
    
    Oct-09
    0.5972
    
    Dec-13
    0.7936
    Aug-01
    0.3094
    
    Sep-05
    0.3948
    
    Nov-09
    0.6513
    
    Jan-14
    0.7652
    Sep-01
    0.4703
    
    Oct-05
    0.5850
    
    Dec-09
    0.7405
    
    Feb-14
    0.6523
    Oct-01
    0.5599
    
    Nov-05
    0.6560
    
    Jan-10
    0.7748
    
    Mar-14
    0.4504
    Nov-01
    0.7076
    
    Dec-05
    0.7027
    
    Feb-10
    0.6719
    
    Apr-14
    0.3692
    Dec-01
    0.7875
    
    Jan-06
    0.9049
    
    Mar-10
    0.4863
    
    May-14
    0.2918
    Jan-02
    0.8290
    
    Feb-06
    0.6322
    
    Apr-10
    0.3756
    
    Jun-14
    0.2743
    Feb-02
    0.6969
    
    Mar-06
    0.4571
    
    May-10
    0.2575
    
    Jul-14
    0.3041
    Mar-02
    0.4260
    
    Apr-06
    0.3871
    
    Jun-10
    0.2459
    
    Aug-14
    0.3889
    Apr-02
    0.2853
    
    May-06
    0.2301
    
    Jul-10
    0.2412
    
    Sep-14
    0.4517
    May-02
    0.2862
    
    Jun-06
    0.2464
    
    Aug-10
    0.3087
    
    Oct-14
    0.5425
    Jun-02
    0.2333
    
    Jul-06
    0.2320
    
    Sep-10
    0.4327
    
    Nov-14
    0.6885
    Jul-02
    0.2579
    
    Aug-06
    0.3538
    
    Oct-10
    0.5220
    
    Dec-14
    0.8123
    Aug-02
    0.3069
    
    Sep-06
    0.4889
    
    Nov-10
    0.6884
    
    Jan-15
    0.7177
    Sep-02
    0.4376
    
    Oct-06
    0.5449
    
    Dec-10
    0.7393
    
    Feb-15
    0.7445
    Oct-02
    0.5174
    
    Nov-06
    0.6164
    
    Jan-11
    0.7432
    
    Mar-15
    0.4935
    Nov-02
    0.6477
    
    Dec-06
    0.8082
    
    Feb-11
    0.6109
    
    Apr-15
    0.3008
    Dec-02
    0.8507
    
    Jan-07
    0.8088
    
    Mar-11
    0.4239
    
    May-15
    0.2276
    Jan-03
    0.7418
    
    Feb-07
    0.5807
    
    Apr-11
    0.3586
    
    Jun-15
    0.2921
    Feb-03
    0.6313
    
    Mar-07
    0.4532
    
    May-11
    0.2339
    
    Jul-15
    0.2820
    Mar-03
    0.5050
    
    Apr-07
    0.3028
    
    Jun-11
    0.2703
    
    Aug-15
    0.3518
    Apr-03
    0.3278
    
    May-07
    0.2034
    
    Jul-11
    0.3185
    
    Sep-15
    0.4759
    May-03
    0.2405
    
    Jun-07
    0.2686
    
    Aug-11
    0.3137
    
    Oct-15
    0.5181
    Jun-03
    0.2434
    
    Jul-07
    0.3024
    
    Sep-11
    0.4397
    
    Nov-15
    0.5835
    Jul-03
    0.2824
    
    Aug-07
    0.3473
    
    Oct-11
    0.5156
    
    Dec-15
    0.6538
    Aug-03
    0.2922
    
    Sep-07
    0.4865
    
    Nov-11
    0.6207
    
    Jan-16
    0.7569
    Sep-03
    0.4310
    
    Oct-07
    0.6115
    
    Dec-11
    0.6826
    
    Feb-16
    0.6183
    Oct-03
    0.5197
    
    Nov-07
    0.6808
    
    Jan-12
    0.7258
    
    Mar-16
    0.4228
    Nov-03
    0.7373
    
    Dec-07
    0.8771
    
    Feb-12
    0.6914
    
    Apr-16
    0.3685
    Dec-03
    0.7665
    
    Jan-08
    0.7543
    
    Mar-12
    0.4331
    
    May-16
    0.2811
    Jan-04
    0.8874
    
    Feb-08
    0.6395
    
    Apr-12
    0.3883
    
    Jun-16
    0.2713
    Feb-04
    0.6821
    
    Mar-08
    0.4176
    
    May-12
    0.2649
    
    Jul-16
    0.2829
    Mar-04
    0.5837
    
    Apr-08
    0.2775
    
    Jun-12
    0.2041
    
    Aug-16
    0.3279
    Apr-04
    0.2374
    
    May-08
    0.2339
    
    Jul-12
    0.2594
    
    Sep-16
    0.4224
    May-04
    0.2015
    
    Jun-08
    0.2412
    
    Aug-12
    0.3504
    
    Oct-16
    0.5720
    Jun-04
    0.1840
    
    Jul-08
    0.2725
    
    Sep-12
    0.4017
    
    Nov-16
    0.6090
    Jul-04
    0.2713
    
    Aug-08
    0.3635
    
    Oct-12
    0.5639
    
    Dec-16
    0.7548
    Aug-04
    0.3510
    
    Sep-08
    0.4671
    
    Nov-12
    0.6442
    
    Jan-17
    0.8041
    Sep-04
    0.4457
    
    Oct-08
    0.5284
    
    Dec-12
    0.6839
    
    Feb-17
    0.7292
    Oct-04
    0.6037
    
    Nov-08
    0.6500
    
    Jan-13
    0.7583
    
    Mar-17
    0.4714
    Nov-04
    0.6138
    
    Dec-08
    0.8087
    
    Feb-13
    0.6289
    
    Apr-17
    0.3640
    Dec-04
    0.8053
    
    Jan-09
    0.8310
    
    Mar-13
    0.5186
    
    May-17
    0.3069
    Jan-05
    0.8157
    
    Feb-09
    0.7185
    
    Apr-13
    0.3302
    
    Jun-17
    0.2895
    Feb-05
    0.6428
    
    Mar-09
    0.4470
    
    May-13
    0.2612
    
    Jul-17
    0.3089
    Mar-05
    0.5469
    
    Apr-09
    0.3324
    
    Jun-13
    0.2244
    
    Aug-17
    0.3816
    
    
    
    May-09
    0.2949
    
    Jul-13
    0.3056
    
    Sep-17
    0.4498
    
    
    
    
    
    
    
    
    
    Oct-17
    0.5583
    
    
    
    
    
    
    
    
    
    Nov-17
    0.6606
    
    
    
    
    
    
    
    
    
    Dec-17
    0.7895
    
    
    
    
    
    
    
    
    
    Jan-18
    0.6662
Null hypothesis, Ho: the average market share would be equal to 0.48 if the sales from each month happened two months earlier. u = 0.48
Alternative Hypothesis, H1: the average market share would increase if the sales from each month happened two months earlier. u > 0.48
    Null Hypothesis =
    0.48
    Level of Significance
    0.05
    Population Standard Deviation
    0.195072288
    Sample Size
    203
    Sample Mean
    0.480947108
    Standard Error of the Mean
    0.0137
    Z Test Statistic
    0.0692
    Upper Critical...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30