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

Circumference of a circle, How far will a bowling ball goes in one rotation...

How far will a bowling ball goes in one rotation if the ball has a diameter of 10 inches? (π = 3.14) 1. 78.5 in 2. 31.4 in 3. 62.8 in 4. 15.7 in 2. The circumfere

Composition of functions, functions f&g on R to R such that f=\g but fog=go...

functions f&g on R to R such that f=\g but fog=gof

Solid mensuration, given dimensions: 130cm, 180cm, and 190cm is to be divid...

given dimensions: 130cm, 180cm, and 190cm is to be divided by a line bisecting the longest side shown from its opposite vertex. what''s the area adjacent to 180cm? ;

We know this equation a°=1.prove this?, we know that A^m/A^m=1 ...

we know that A^m/A^m=1 so A^(m-m)=1 so A^0=1.....

Example of identify the pre-requisites, Ravi is a teacher of Class 4 in a m...

Ravi is a teacher of Class 4 in a municipal school in Delhi. When the new school year started, he opened the textbook and started teaching the children how to write 4-digit numbers

Factor , #Mai iss 3 years younger than twice the age of her brother . If b ...

#Mai iss 3 years younger than twice the age of her brother . If b represents the age of Mai''s brother .which expression below represents Mai''s age 2-3b 3-2b 2b-3 3b-2 2-3b 3-2b q

Ratios, in a veggie mix the ratio of cups of carrots to cups of broccolie i...

in a veggie mix the ratio of cups of carrots to cups of broccolie is 4 to 5 if you made this party mix larger how many cups of carrots would be needed to mix with fo cups of brocco

Example of addition, Example 1 Add 4x 4 + 3x 3 - ...

Example 1 Add 4x 4 + 3x 3 - x 2 + x + 6 and -7x 4 - 3x 3 + 8x 2 + 8x - 4 We write them one below the other as shown below.

Fraction, 5645.356 turn into fraction

5645.356 turn into fraction

Function expansion, The functions {sinmx; cosmx}; m = 0,....∞ form a ...

The functions {sinmx; cosmx}; m = 0,....∞ form a complete set over the interval x ∈ [ -Π, Π]. That is, any function f(x) can be expressed as a linear superposition of these

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages