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

Progressions, * 2^(1/2)4^(1/8)8^(1/16)*16^(1/32) =

* 2^(1/2)*4^(1/8)*8^(1/16)*16^(1/32) =

Calculus, I need help with my calculus work

I need help with my calculus work

Quadratic equations, prSQUQRE=R-5

prSQUQRE=R-5

Diameter of the circle , The length of the diameter of the circle which tou...

The length of the diameter of the circle which touches the X axis at the point (1,0) and passes through the point (2,3) is ? Solution) If a circle touches the x-axis, its equatio

Prove, Let Xn be a sequence of distinct real numbers. Define E = {L : L is...

Let Xn be a sequence of distinct real numbers. Define E = {L : L is a subsequential limit of Xn}. Prove E is closed.

How much more does she required to sell to meet her goal, Hanna's sales tar...

Hanna's sales target for the week is $5,000. So far she has sold $3,574.38 worth of merchandise. How much more does she required to sell to meet her goal? You must ?nd out the

Determine the displacement, Example: A 16 lb object stretches a spring 8/9...

Example: A 16 lb object stretches a spring 8/9 ft by itself. Here is no damping as well as no external forces acting on the system. The spring is firstly displaced 6 inches upward

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

Divison., 265 divided by 7

265 divided by 7

Independent & Dependent functions, I am learning this at school today and I...

I am learning this at school today and I started getting confused which one is which, can you help me?

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