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 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 quit covers at at Jim's departmental store in Australia over the last 12 months...
Sales of quit covers at at Jim's departmental store in Australia
over the last 12 months 2017 are shown below
Period: Actual Demand:
Jan. -20
Feb -21
March -15
April -14
May - 13
June - 16
July - 17
August. - 18
Sep - 20
October. -20
November. - 21
December. -24
Calculate:
I. Use a 3- month and 4-month average on all the data and plot
averages and the actual demand.
II. Using MAD techniques determine which is...
. Shipments (in tons) of welded tube by an aluminum producer are shown below: Year 1...
. Shipments (in tons) of welded tube by an aluminum
producer are shown below:
Year
1
2
3
4
5
6
7
8
9
10
11
Tons
2
3
6
10
8
7
12
14
14
18
19
Required:-
Graph the data, and comment on the
relationship.
Compute a 3-year moving average, plot it as a dotted
line, and use it to forecast shipments in year 12.
Using a weight of 3 for the most recent data, 2 for the...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 5 minutes ago
asked 9 minutes ago
asked 29 minutes ago
asked 29 minutes ago
asked 30 minutes ago
asked 30 minutes ago
asked 49 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago