other students are interested:
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?
Answer rating (rated one time)
the answer is in attached file
body preview (0 words)
file1.docx preview (841 words)
xxxx xxx Calculate xxx regression xxxx and xxxxxxxx sales xxx xxxxx of Year 3.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxFood xxx Beverage Sales for xxxx’x xxxxxxxx xxxxxxxxxx | ||||||
xxxxxxx | ||||||
Month | First xxxx | Second xxxx | ||||
xxxxxxx | 55 | 60 | xxxx | |||
February | xx | 54 | xxxx | |||
xxxxx | xx | 56 | xxxx | |||
April | xx | xx | 53.5 | |||
xxx | xx | 44 | xx | |||
June | xx | xx | xx | |||
July | 33 | xx | 34.5 | |||
xxxxxx | xx | 37 | 36 | |||
xxxxxxxxx | 25 | 28 | xxxx | |||
xxxxxxx | 30 | xx | 30 | |||
November | 35 | 38 | 36.5 | |||
xxxxxxxx | xx | xx | 53 |
xxxxxxxxxx Line | |||||||||
xxxxx xxx | xx (X-mean xx | x^2 | xxxxx xxx | y= xxxxxxx - - - more text follows - - - |
file2.xlsx preview (352 words)
Sheet1
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxRegression xxxx | |||||||
xxxxx xxx | x= (X-mean xx | xxx | xxxxx xxx | y= (Y-mean xx | y^2 | xy | Regression xxxxxxxx |
1 | xxxx | xxxxx | 57.5 | xx | 169 | -71.5 | Regression xxxxxxxxxxx = x + bx |
2 | xxxx | 20.25 | xxxx | x | xx | xxxxx | Slope(b) x xxxxxx - (ΣX)(ΣY)) x xxxxxx - xxxxxxx |
3 | xxxx | xxxxx | xxxx | 10 | xxx | xxx | xxxxxxxxxxxx = (ΣY - xxxxxxx / x |
x | -2.5 | xxxx | 53.5 | x | xx | -22.5 | |
x | -1.5 | xxxx | xx | 9.5 | 90.25 | xxxxxx | where |
6 | xxxx | 0.25 | 44 | -0.5 | xxxx | xxxx | x xxx y xxx xxx variables. |
7 | 0.5 | xxxx | xxxx | -10 | xxx | -5 | b = xxx xxxxx xx xxx regression xxxx |
x | xxx | 2.25 | 36 | xxxx | xxxxx | xxxxxx | x x The intercept point xx the xxxxxxxxxx xxxx xxx the x axis. |
x | xxx | xxxx | xxxx | -18 | 324 | -45 | N x xxxxxx xx xxxxxx or xxxxxxxx |
xx | xxx | xxxxx | 30 | xxxxx | xxxxxx | -50.75 | X x xxxxx - - - more text follows - - - |
Buy this answer | Try it before you buy it |