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

NUMBER SYSTEMS, CONCEPT OF NUMBER LINE

CONCEPT OF NUMBER LINE

Define the correlations, A retention counselor at a state university believ...

A retention counselor at a state university believes that freshman year success is related to high school standard tests in math and reading, and in the number of credits the stude

Class 10, chapter permutation & combination ex :4.6

chapter permutation & combination ex :4.6

What is slope of a line, What is Slope of a Line ? A line can have a "...

What is Slope of a Line ? A line can have a "steep" slope or a "gradual" slope. slope = rise/run The "rise" is the distance going up or down. The "run" is the distance goin

Methods of sampling, a. Random or probability sampling methods they in...

a. Random or probability sampling methods they involve: Simple random sampling Systematic sampling Stratified sampling Multi stage sampling b.

Determine dy & dy if y = cos ( x2 + 1) - x, Determine dy & Δy if y = cos ...

Determine dy & Δy if y = cos ( x 2 + 1) - x as x changes from x = 2 to x = 2.03 . Solution Firstly let's deetrmine actual the change in y, Δy . Δy = cos (( 2.03) 2

Example of binomial distribution, Example: Joanne is given a four-question...

Example: Joanne is given a four-question multiple-choice quiz. She hasnt studied the material to be quizzed, so she decides to answer the questions by randomly guessing the answe

Functions, Question Solve the following functions for x (where x is a r...

Question Solve the following functions for x (where x is a real number). Leave your answers in exact form, that is, do not use a calculator, show all working. (a) 3 x 3 x2 3

Set theory, set theory

set theory

G .E matrix, using the g.e matrix, how can you turn an unattractive product...

using the g.e matrix, how can you turn an unattractive product to be attractive

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages