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 8th year

Solution

Years (x)

Sales (y)

xy

x2

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

    Σx2= 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 8th year sales = 12 + 1.86 (8)

=26.88 that is 26,888 units.


Related Discussions:- Forecasting by using least squares

Differential calculus, lim n tends to infintiy ( {x} + {2x} + {3x}..... +{n...

lim n tends to infintiy ( {x} + {2x} + {3x}..... +{nx}/ n2(to the square) )where {X} denotes the fractional part of x? Ans) all no.s are positive or 0. so limit is either positive

Determine the probability - probability example, Consider two bags, A and B...

Consider two bags, A and B, with the following contents Bag A Bag B 3 white marbles 4 white marbles 2 red marbles

Relationship between the shortest path distances - tree, 1. a)  Given a dig...

1. a)  Given a digraph G = (V,E), prove that if we add a constant k to the length of every arc coming out from the root node r, the shortest path tree remains the same.  Do this by

Curve tracing, how to curve trace? and how to know whether the equation is ...

how to curve trace? and how to know whether the equation is a circle or parabola, hyperbola ellipse?

Probability of tossing a head with the dime, Q. Find Probability of tossing...

Q. Find Probability of tossing a head with the dime? List the sample space, and find n(S), for the outcomes of tossing a nickel followed by a dime. What is the probability of t

System of first order equations, Consider the Van der Pol oscillator x′′...

Consider the Van der Pol oscillator x′′- µ(1 - x 2 )x′ + x = 0 (a) Write this equation as a system of first order equations (b) Taking µ = 2, use MatLab's routine ode45 to

What were her sales for the month of may of medical supplies, Kim is a medi...

Kim is a medical supplies salesperson. Each month she receives a 5% commission on all her sales of medical supplies up to $20,000 and 8.5% on her total sales over $20,000. Her tota

Determine the length of the longer base, The longer base of a trapezoid is ...

The longer base of a trapezoid is 3 times the shorter base. The nonparallel sides are congruent. The nonparallel side is 5 cm more that the shorter base. The perimeter of the trape

What is the total number of pounds they bought if the total, The student co...

The student council bought two various kinds of candy for the school fair. They purchased 40 pounds of candy at $2.15 per pound and x pounds at $1.90 per pound. What is the total n

Trigonometry.., if b+c=3a then the value of cotB/2.cotC/2 is equal to

if b+c=3a then the value of cotB/2.cotC/2 is equal to

Write Your Message!

Captcha
Free Assignment Quote

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd