Scribd
Upload
310 views4 pages

Student Demand Forecasting Exercise

This document contains a table with historical demand data from 2008-2020, including a year, time period (t), demand (D), and demand times time period (tD). It also contains a linear regression with R^2 of 0.89201201695543 predicting future demand from 2021-2030 based on the historical data. A separate chart shows the forecasted demand values.

Uploaded by

Test Mock
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
310 views4 pages

Student Demand Forecasting Exercise

This document contains a table with historical demand data from 2008-2020, including a year, time period (t), demand (D), and demand times time period (tD). It also contains a linear regression with R^2 of 0.89201201695543 predicting future demand from 2021-2030 based on the historical data. A separate chart shows the forecasted demand values.

Uploaded by

Test Mock
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

EXERCISE: DEMAND FORECASTING

Date: NOV 2020

Name of the student……………………..


Roll ………..

year ti ti Di tiDi t2i


2008 1 3 3 1
2009 2 5 10 4
2010 3 6 18 9 f
2011 4 9 36 16 40
2012 5 11 55 25
2013 6 10 60 36 35
2014 7 10 70 49
2015 8 12 96 64 30
2016 9 15 135 81
2017 10 20 200 100 25
2018 11 19 205 121
2019 12 20 242 144 20
2020 13 22 282 169
2021 14 23 325 196 15
12
11
2022 15 25 372 225 9
10 10
10
2023 16 26 421 256
6
2024 17 28 474 289 5
53
2025 18 29 530 324
2026 19 31 588 361
0
2027 20 33 650 400 08 009 010 011 012 013 014 015
0
2028 21 34 715 441 2 2 2 2 2 2 2 2
2029 22 36 783 484
2030 23 37 854 529

Chart Title
25

20

f(x) = 1.54545454545455 x + 1.6


15 R² = 0.89201201695543

10

5
f(x) = 1.54545454545455 x + 1.6
15 R² = 0.89201201695543

10

0
2008 2009 2010 2011 2012 2013
1.6+

forecast of the demand


40
37
36
35 34
33
31
29
30 28
26
25
25 23
22
20 20
20 19
15
15
12
11
10 10
10 9
6
5
53

0
0 08 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2

x y
11 23.03274
12 27.36642
13 32.5155
Chart Title 14 38.63339
15 45.90238

16 54.53904

17 64.80073
18 76.99318
19 91.47968
20 108.6919
21 129.1426
22 153.4411
23 182.3115

2012 2013 2014 2015 2016 2017

You might also like