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

Product of complex number., multiply (1/2+1/2i) ten times

multiply (1/2+1/2i) ten times

Simplify, X^2 – y^2 – 2y - 1

X^2 – y^2 – 2y - 1

Recognize the importance of famous numbers, Activity This activity will ...

Activity This activity will help you recognize the importance of some very famous numbers, as well as learn more about approximations. Directions Using the Internet, provi

Operation research, sequencing problem

sequencing problem

Reduce the rational expression to lowest terms, Reduce the following ration...

Reduce the following rational expression to lowest terms. x 2 - 2 x - 8/ x 2 - 9 x + 20 Solution When reducing a rational expressio

Physical fitness association, Physical fitness association 1 mile run. It i...

Physical fitness association 1 mile run. It is known to have a normal distribution, mean 450 sec. SD 50 sec. How many in the top 10% fastest runners? Need to know what time they ha

Trig identities, What is the exact vale of sin(theta/2) when sintheta=3/5, ...

What is the exact vale of sin(theta/2) when sintheta=3/5, pi/2

Rounding off the numbers to the given degree of accuracy, 6 412.56356

6 412.56356

Life mathametics, 20% of the total quantity of oil is 40 litres find the to...

20% of the total quantity of oil is 40 litres find the total quantity of oil in litres

The fisher’s index, The Fisher's index The index of Fisher acts as a c...

The Fisher's index The index of Fisher acts as a compromise between Paasche' index and Laspeyre's index. This is calculated as a geometric mean of the two indexes.

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