Forecasting by using least squares, Mathematics

Assignment Help:

Forecasting By Using Least Squares

Data have been kept of sales over the last seven years

Year

1

2

3

4

5

6

7

Sales (in '000 units

14

17

15

23

18

22

27

It is required to forecast the sales for the 8th year

Solution

Years (x)

Sales (y)

xy

x2

1

14

14

1

2

17

34

4

3

15

45

9

4

23

92

16

5

18

90

25

6

22

132

36

7

27

189

49

       Σx=28

     Σy = 136

       Σxy=596

    Σx2= 140

136 = 7a + 28b

596 = 28a + 140b

∴b = 1.86

And substituting in one of the equations we acquire

a = 12

∴ Regression line = y = 12 + 1.86x

Or, Sales in ('000s of units) = 12.00 + 1.86 (no of years)

We utilize this expression for forecasting, for 8th year sales = 12 + 1.86 (8)

=26.88 that is 26,888 units.


Related Discussions:- Forecasting by using least squares

Math, how do you do algebra in 4th grade

how do you do algebra in 4th grade

Bar charts, I''m supposed to be writing a critique for my maths project whe...

I''m supposed to be writing a critique for my maths project where i compare the prices for different holidays. i don''t know what to write for a critique though, any tips on what w

Advantages of peer interaction in learning maths, Can you think of some mor...

Can you think of some more advantages of peer interaction and child-to child learning? If you agree that children learn a lot from each other, then how can we maximise such oppo

Pair of straight lines, the adjacent sides of a parallelogram are 2x2-5xy+3...

the adjacent sides of a parallelogram are 2x2-5xy+3y2=0 and one diagonal is x+y+2=0 find the vertices and the other diagonal

Types of sets, NULL/ VOID/ EMPTY SET A set which has no element is know...

NULL/ VOID/ EMPTY SET A set which has no element is known as the null set or empty set and is indicated by f (phi). The number of elements of a set A is indicated as n (A) and

Describe adding and subtracting fractions in details, Describe Adding and S...

Describe Adding and Subtracting Fractions in details? To add or subtract fractions, here are some steps: 1. Find the lowest common denominator (LCD) or any common denominato

Write down the equation of the line, Write down the equation of the line wh...

Write down the equation of the line which passes through the points (2, -1, 3) and (1, 4, -3).  Write all three forms of the equation of the line. Solution To do the above

Maths Assessment, Assessment task This Term Assessment will require you ass...

Assessment task This Term Assessment will require you assess the effectiveness of your current lunch budget and prepare a proposal to your caregiver to seek permission to be given

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd