Scribd
Upload
59 views6 pages

January Sale Forecast Soln Year X y Xy X 2 X X/N y X/N B1 Xy-Nxy / X 2-nx 2

The document contains sales forecasts for January, February, and March using a linear regression model. For each month, it lists the year, sales amount, calculates the slope and y-intercept of the linear regression line, and uses that to forecast future year's sales.

Uploaded by

Jodette Karyl Nuyad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
59 views6 pages

January Sale Forecast Soln Year X y Xy X 2 X X/N y X/N B1 Xy-Nxy / X 2-nx 2

The document contains sales forecasts for January, February, and March using a linear regression model. For each month, it lists the year, sales amount, calculates the slope and y-intercept of the linear regression line, and uses that to forecast future year's sales.

Uploaded by

Jodette Karyl Nuyad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

JANUARY SALE FORECAST SOLN x=∑x/n 21/6 3.

5
y=∑x/n 210,000/6 35,133.33
YEAR x y xy x^2
2015 1 30,000 30,000 1 B1= ∑xy-nxy / ∑x^2-nx^2
2016 2 35,000 70,000 4 767,000-(6)(3.5)(35,133.33) / 91-(6)(3.5)^2
2017 3 32,000 96,000 9 767,000-737,799.93 / 91-73.5
2018 4 37,000 148,000 16 29,200.07 / 17.5 = 1,668.58
2019 5 37,800 189,000 25
2020 6 39,000 234,000 36 Bo= y-B1x
∑ 21 210,000 767,000 91 35,133.33-(1,668.58)(3.5)
35,133.33-5,840.03 = 29,293.3

y= Bo+B1x
29,293.3+(1,668.58)(7)
29,293.3+11,680.06 = 40,973.36
133.33) / 91-(6)(3.5)^2

-(1,668.58)(3.5)
-5,840.03 = 29,293.3

(1,668.58)(7)
11,680.06 = 40,973.36
FEBRUARY SALE FORECAST SOLN x=∑x/n 21/6 3.5
y=∑x/n 148,000/6 24,666.67
YEAR x y xy x^2
2015 1 22,500 22,500 1 B1= ∑xy-nxy / ∑x^2-nx^2
2016 2 23,000 46,000 4 533,500-(6)(3.5)(24,666.67) / 91-(6)(3.5)^2
2017 3 25,000 75,000 9 533,500-518,000.07 / 91-73.5
2018 4 24,500 98,000 16 15,499.93 / 17.5 = 885.71
2019 5 26,000 130,000 25
2020 6 27,000 162,000 36 Bo= y-B1x
∑ 21 148,000 533,500 91 24,666.67-(885.71)(3.5)
24,666.67-3,099.99 = 21,566.68

y= Bo+B1x
21,566.68+(885.71)(7)
21,566.68+6,199.97 = 27,766.65
666.67) / 91-(6)(3.5)^2

-(885.71)(3.5)
-3,099.99 = 21,566.68

+(885.71)(7)
+6,199.97 = 27,766.65
MARCH SALE FORECAST SOLN x=∑x/n 21/6 3.5
y=∑x/n 169,400/6 28,233.33
YEAR x y xy x^2
2015 1 27,000 27,000 1 B1= ∑xy-nxy / ∑x^2-nx^2
2016 2 26,400 52,800 4 605,000-(6)(3.5)(28,233.33) / 91-(6)(3.5)^2
2017 3 28,000 84,000 9 605,000-592,899.93 / 91-73.5
2018 4 28,800 115,200 16 12,100.07 / 17.5 = 691.43
2019 5 29,200 146,000 25
2020 6 30,000 180,000 36 Bo= y-B1x
∑ 21 169,400 605,000 91 28,233.33-(691.43)(3.5)
28,233.33-2,420.01= 25,813.32

y= Bo+B1x
25,813.32+(691.43)(7)
25,813.32+4,840.01 = 30,653.33
233.33) / 91-(6)(3.5)^2

-(691.43)(3.5)
-2,420.01= 25,813.32

+(691.43)(7)
+4,840.01 = 30,653.33

You might also like