## Just do my homework!

• HTML tags will be transformed to conform to HTML standards.
Question
Submitted by shahimermaid on Tue, 2012-03-06 05:30
due on Sat, 2012-03-10 05:28
shahimermaid bought 77 out of 250 answered question(s)

other students are interested:
tifjones334 on Tue, 20 Mar 2012
lateasa on Sun, 25 Mar 2012
pejones10 on Sun, 25 Mar 2012
aarn.z on Sun, 05 Aug 2012
5 anonymous students showed interest
More questions like this
 Use the table “Food and...

# Use the table “Food and Beverage Sales for Paul’s Pizzeria” to answer the questions below.

Food and Beverage Sales for Paul’s Pizzeria Restaurant

(\$000s)

Month

First Year

Second Year

January

55

60

February

53

54

March

53

56

April

63

44

May

64

44

June

54

34

July

33

36

August

35

37

September

25

28

October

30

30

November

35

38

December

54

52

Part (a) Calculate the regression line and forecast sales for March of Year 3.

Part (b) Calculate the seasonal forecast of sales for March of Year 3.

Part (c) Which forecast do you think is most accurate and why?

Submitted by shahimermaid on Tue, 2012-03-06 05:31
teacher rated 387 times
4.322995
purchased 14 times
price: \$10.00

1

## the answer is in attached file

body preview (0 words)

file1.docx preview (543 words)

xxxx (a) Calculate the xxxxxxxxxx xxxx and xxxxxxxx xxxxx xxx xxxxx of xxxx 3.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 Food xxx Beverage xxxxx xxx xxxx’x Pizzeria Restaurant (\$000s) Month First xxxx xxxxxx xxxx January xx xx xxxx xxxxxxxx xx xx xxxx xxxxx xx 56 54.5 April 63 xx xxxx May 64 44 xx xxxx xx xx xx July 33 xx xxxx xxxxxx xx 37 xx September xx xx 26.5 xxxxxxx 30 xx xx xxxxxxxx xx xx 36.5 December 54 xx xx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxxxx xxxx xxxxx (X) x= (X-mean X) xxx Sales (Y) xx (Y-mean xx y^2 xx x xxxx xxxxx 57.5 xx xxx xxxxx 2 -4.5 xxxxx xxxx 9 81 xxxxx x xxxx 12.25 xxxx 10 xxx xxx x xxxx xxxx 53.5 x xx xxxxx 5 -1.5 xxxx 54 xxx xxxxx xxxxxx 6 -0.5 0.25 44 xxxx xxxx xxxx x xxx 0.25 34.5 xxx 100 xx x 1.5 2.25 xx xxxx xxxxx xxxxxx x xxx 6.25 26.5 -18 xxx -45 10 xxx xxxxx 30 xxxxx 210.25 xxxxxx 11 xxx xxxxx 36.5 -8 xx -36 xx xxx xxxxx 53 xxx 72.25 xxxxx Total 78 x 143 533.5 xxxx xxxxxxx -286.25 X xxxx x 78/12 x 6.5 x mean x 533.5/12 =44.5 xxxxx xxx x ( 12 x -286.25 -78 x 533.5) x xxxxxx x xxxxxx 12 x xxxx xxxxxx xxxx xxxxx -4368 10.31 xxxxxxxxx xxx = xxxxx x xxxxx (78) xxxxx x xxxxxx x xxxxxxx xxxxxx 12 12 xx Y = 10.31 X -22.56 12 xxxxx will end in xxxxxxxx , so xxx xxxxx xx 3rd year x= xx x x xxxxxx -22.56 = 132.09
xxx
 xxxxxxxxxx xxxxxxxx xxxxxxxxxx Equation(y) = a x bx xxxxxxxx x xxxxxx x xxxxxxxxxxx x xxxxxx -

- - - more text follows - - -

file2.xlsx preview (271 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxxxx xxxx Month (X) x= (X-mean X) x^2 Sales xxx y= (Y-mean xx xxx xx xxxxxxxxxx xxxxxxxx 1 -5.5 xxxxx xxxx xx 169 xxxxx xxxxxxxxxx xxxxxxxxxxx = x + xx x -4.5 20.25 xxxx 9 81 -40.5 xxxxxxxx x xxxxxx - (ΣX)(ΣY)) x xxxxxx - (ΣX)2) 3 -3.5 12.25 xxxx xx xxx -35 Intercept(a) x xxxx x b(ΣX)) / N x -2.5 xxxx xxxx x xx -22.5 5 -1.5 2.25 xx xxx 90.25 -14.25 where 6 xxxx xxxx 44 -0.5 xxxx xxxx x and y xxx xxx variables. 7 0.5 xxxx xxxx -10 100 xx x = xxx slope of xxx xxxxxxxxxx xxxx x xxx 2.25 36 -8.5 72.25 xxxxxx x x The xxxxxxxxx point xx xxx xxxxxxxxxx xxxx xxx the x axis. 9 2.5 xxxx xxxx xxx xxx xxx x x xxxxxx of xxxxxx xx xxxxxxxx 10 3.5 12.25 xx -14.5 xxxxxx xxxxxx X x xxxxx xxxxx xx xxx 20.25 36.5 xx 64 -36 x = Second xxxxx xx xxx 30.25 53 xxx 72.25 xxxxx ΣXY = Sum of the xxxxxxx of first xxx Second Scores xxxxx xx x xxx 533.5 xxxx 1364.25 xxxxxxx

- - - more text follows - - -