Question
The sales records of a company over a period of seven years are shown below. Year...
The sales records of a company over a period of seven years are shown below.
|
Year (t) |
Sales (In Millions of Dollars) |
||
|
1 |
12 |
||
|
2 |
16 |
||
|
3 |
17 |
||
|
4 |
19 |
||
|
5 |
18 |
||
|
6 |
21 |
||
|
Required: |
|||
|
Required ( Use a Mathematical Computerized Program for solving the question) |
|||
|
Forecast sales for period 10. |
|||
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
The daily maximum temperature in Beijing is F over a seven day period is recorded below...
The daily maximum temperature in Beijing is F over a seven day
period is recorded below
Day
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
F
18
17
25
23
27
21
19
The five median smoothed daily temperatures in F for Wednesday
is:
21
22
24
23
25
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and
its advertising expenditure over a period of 8 years.
(Y) Sales in Millions of Dollars (X) Advertising in
($10,000)
15 32
16 33
18 35
17 34
16 36
19 37
19 39
24 42
Develop a 95% confidence interval for predicting the average
sales for the years when $400,000 was spent on advertising.
i. Compute the correlation coefficient. alpha=5
urgently need detailed solution please
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and
its advertising expenditure over a period of 5 years.
(y) sales in millions of dollars (x) advertising in
($10,000)
15 32
16 33
18 35
17 34
16 36
Use the method of least squares to compute an estimated
regression line between sales and advertising by computing b0 and
b1.
If the company's advertising expenditure is $400,000, what are
the predicted sales? Give the answer in dollars.
What does the...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a company's yearly sales volume and
its advertising expenditure over a period of 5 years.
(Y) Sales in Advertising (X) Millions of Dollars in
($10,000)
15 32
16 33
18 35
17 34
16 36
(a) Compute the coefficient of determination for the estimated
regression equation you got in the previous in-class problem.
(b) Interpret the meaning of the value of the coefficient of
determination that you found in (a). Be very specific.
(c) Perform a...
The following data represent a company's yearly sales volume and its advertising expenditure over a period...
The following data represent a
company's yearly sales volume and its advertising expenditure over
a period of 8 years.
Sales (Millions)
Advertising ($10,000)
15
32
16
33
18
35
17
34
16
36
19
37
19
39
24
42
To make sure the Excel regression package is
installed.
Click “Tools”,
à“Add-Ins”
àchoose “Analysis Toolpak” and click
“OK”.
To use the Excel regression
package,
Click “Tools”, à“Data
Analysis” and click “Regression”.
f. Use the F test to
determine whether or not...
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales...
Actual sales for January through April are shown below:
Observation
Month
Actual Sales (A)
Forecasted Sales (F)
1
January
18
2
February
23
3
March
20
4
April
16
5
May
a. Use exponential smoothing with α = 0.2 to calculate
smoothed averages and forecast sales for May from the above data.
Assume the forecast for the initial period (January) is 18.
b. Calculate MSE, and MAPE.
Hudson Marine has been an authorized dealer for C&D marine radios for the past seven years....
Hudson Marine has been an authorized dealer for C&D marine
radios for the past seven years. Suppose the quarterly sales values
for the seven years of historical data are as follows.
Year
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Total Yearly
Sales
1
7
13
9
4
33
2
11
20
16
6
53
3
12
25
25
11
73
4
18
28
26
16
88
5
23
35
27
21
106
6
24
37
31
18
110
7...
The table below shows the monthly sales of a motorcycle store during the last two years....
The table below shows the monthly sales of a motorcycle store
during the last two years. The commission for each motorcycle sale
is $1,000. The manager wants to estimate how much money he will
need for month 25.
Month
Sales
Month
Sales
1
195
13
155
2
210
14
120
3
190
15
135
4
170
16
110
5
180
17
122
6
156
18
97
7
134
19
85
8
155
20
110
9
145
21
85
10
165...
Below is the number of times a commercial was shown displaying high fat, high sugar foods...
Below is the number of times a commercial was shown displaying
high fat, high sugar foods during children’s programming over each
of 20 days.
21, 8, 11, 9, 12, 10, 10, 5, 9, 18, 17, 3, 6, 14, 18, 16, 19, 3,
22, 7
(a) Create a simple frequency distribution for these grouped
data with four intervals.
(b) Which interval had the largest frequency?
Additional requirements for question:
1. The frequency table must include the following columns:
Values
Frequencies
Relative...
Sales of paint at Eddie's hardware store over the past 10 weeks are shown below: Week...
Sales of paint at Eddie's hardware store over the past 10 weeks
are shown below:
Week 1 - 20 Week 2- 21 Week 3- 29 Week 4- 36 Week 5- 24 Week 6-
29 Week 7-37 Week 8- 24 Week 9- 26 Week 10- 29
A. The forecast for week 3 using exponential smoothing with
alpha=0.6 and a week 1 initial forecast of 20 is _____ B. For the
forecast developed using exponential smoothing with alpha=0.6 and a
week 1...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 3 minutes ago
asked 23 minutes ago
asked 36 minutes ago
asked 43 minutes ago
asked 45 minutes ago
asked 49 minutes ago
asked 50 minutes ago
asked 55 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago