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

Tagent, what is tangent

what is tangent

Differential equation, i need help for DIFFERENTIAL EQUATION PROJECT

i need help for DIFFERENTIAL EQUATION PROJECT

Trignometry, sin 30

sin 30

Indices, what are the advantages and disadvantages of both Laspeyres and Pa...

what are the advantages and disadvantages of both Laspeyres and Paasche index

Properties of radicals, If n is positive integer greater than 1 and a & b b...

If n is positive integer greater than 1 and a & b both are positive real numbers then, Consider that on occasion we can let a or b to be negative and yet have these propert

Holistic Marketing, Do you believe the holistic marketing concept is the mo...

Do you believe the holistic marketing concept is the most effective way to conduct marketing activities? Why? (Why not?)

Subjective probability, Subjective Probability Probability may be de...

Subjective Probability Probability may be determined by a personal statement of how likely an outcome is in a single trial or repetition of the same experiment. Since sub

Shares and devidends, report of shares and devidends

report of shares and devidends

#tnumarancyitle.., what is classification and how can you teach it?

what is classification and how can you teach it?

Find the probability, A bag contains 19 tickets, numbered from 1 to 19. A t...

A bag contains 19 tickets, numbered from 1 to 19. A ticket is drawn and then another ticket is drawn without replacement .Find the probability that both tickets will show even numb

Write Your Message!

Name

Email id

Message

Verfication Code

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!

Submit Assignment

User Account

All Pages