Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

FORECASTING WITH TIME SERIES DATA SET–Quarterly Sales of BMW CARS in MILLIONS Ye

ID: 384539 • Letter: F

Question

FORECASTING WITH TIME SERIES

DATA SET–Quarterly Sales of BMW CARS in MILLIONS

Year                Quarter          Sales (1,000,000)

2012                1                      7.0

2                      6.4

                        3                      8.2

                        4                      8.8

2013                1                      8.0

                        2                      7.5

                        3                      9.0

                        4                      9.7

2014                1                      8.5

                        2                      8.0

                        3                      9.8

                        4                      9.9

2015                1                      8.5

                        2                      8.2

                        3                      9.5

4                                            9.9

2016                1    ? (forecast)

   2    ? (forecast)

   3 ? (forecast)

   4    ? (forecast)

Explanation / Answer

for series 1= (7+7.5+8.5+8.5)/4= 7.875

series 2= (6.4+7.5+8+8.2)/4= 30.1/4= 7.525

series 3= (8.2+9+9.8+9.5)/4= 36.5/4= 9.125

series 4= (8.8+9.7+9.9+9.9)/4= 38.3/4= 9.575