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 8^th year

Solution

Years (x)	Sales (y)	xy	x²
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	Σx²= 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 8^th 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

Equations, calculate x+2+y=4

calculate x+2+y=4

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

Lcm method, lcm method of 648

lcm method of 648

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!

Name

Email id

Message

Verfication Code

User Account

All Pages