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

Find out that sets of functions are linearly dependent, Find out if the fol...

Find out if the following sets of functions are linearly dependent or independent. (a) f ( x ) = 9 cos ( 2 x ) g ( x ) = 2 cos2 ( x ) - 2 sin 2 ( x ) (b) f

Integers, -2-1

-2-1

Solving rational equations, 7=1w-4 answer is 1/11 need help doing the math

7=1w-4 answer is 1/11 need help doing the math

Determine the other two sides of the triangle, The radius of the in circle ...

The radius of the in circle of a triangle is 4cm and the segments into which one side is divided by the point of contact are 6cm and 8cm. Determine the other two sides of the tria

Maths Assignment, Hi, I really need an idea and a layout on where i should ...

Hi, I really need an idea and a layout on where i should take my Maths assignment. This is for Year 12, and i want to focus on Maths in Music. It has to be at least 6 to 12 pages l

Quantitative, A lobster catcher spends $12 500 per month to maintain a lobs...

A lobster catcher spends $12 500 per month to maintain a lobster boat. He plans to catch an average of 20 days per month during lobster season. For each day, he must allow approx

Evaluate the area of the shaded region, Evaluate the area of the shaded reg...

Evaluate the area of the shaded region in terms of π. a. 8 - 4π b. 16 - 4π c. 16 - 2π d. 2π- 16 b. The area of the shaded region is same to the area of the squa

Perimeter of trinagle, what is the perimeter of a triangele with the sides ...

what is the perimeter of a triangele with the sides of 32 in /22 in/20 in/

Power series - sequences and series, Power Series We have spent quite...

Power Series We have spent quite a bit of time talking about series now and along with just only a couple of exceptions we've spent most of that time talking about how to fin

Ratio, find the ratio of 1:4

find the ratio of 1:4

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages