Question
Question 2: The sales data of a company’s sales records is provided in the attached dataset....
Question 2: The sales data of a company’s sales records is provided in the attached dataset. (10 marks – 2 for each part) a) Plot a time-series plot of these data b) Fit a linear trend line to these data. c) Conduct a hypothesis test of the linear trend model developed in part b. Use a level of significance of 0.05 d) State the predicted value of sales from 2005 to 2021 e) Calculate MAD and MSE for the linear trend forecasts developed.
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
Please use SPSS for analysis if available Will give positive feedback for answering all questions! Question:...
Please use SPSS for analysis if available
Will give positive feedback for answering all
questions!
Question:
The sales data of a company's sales records is
provided.
a. Plot a time-series plot of the data
b. Fit a Linear trend line to these data
c. Conduct a hypothesis test of the linear trend model developed
in part b. Use significance level of 0.05
d. State the predicted value of sales from 2005 to 2020
e. Calculate MAD and MSE for the...
Crossland Construction’s design/build department allows their clients (owners) to select the design and construction team based...
Crossland Construction’s design/build department allows their
clients (owners) to select the design and construction team based
on their combined experience and track-record. Design/build firms
typically have a cash flow problem since they tend to be paid in
lump sums when projects are completed or hit milestones. However,
their expenses, such as payroll, must be paid regularly. So, such
firms need bank lines of credit to finance their initial costs, but
in the past year, lines of credit were difficult to...
Crossland Construction’s design/build department allows their clients (owners) to select the design and construction team based...
Crossland Construction’s design/build department allows their
clients (owners) to select the design and construction team based
on their combined experience and track-record. Design/build firms
typically have a cash flow problem since they tend to be paid in
lump sums when projects are completed or hit milestones. However,
their expenses, such as payroll, must be paid regularly. So, such
firms need bank lines of credit to finance their initial costs, but
in the past year, lines of credit were difficult to...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4...
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
2
4
5
2
4
5
8
3
1
3
4
4
7
9
10
(a)
Choose the correct time series plot.
(i)
(ii)
(iii)
(iv)
- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item
1
What type of pattern exists in the data?
- Select your answer -Positive trend pattern, no
seasonalityHorizontal pattern, no seasonalityNegative trend
pattern, no seasonalityPositive trend pattern, with
seasonalityHorizontal pattern, with...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5...
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
2
5
7
2
0
2
6
3
5
8
10
4
5
8
10
(a)
Choose the correct time series plot.
(i)
(ii)
(iii)
(iv)
Plot (iii)- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot
(iv)Item 1
What type of pattern exists in the data?
Positive trend pattern, no seasonality- Select your answer
-Positive trend pattern, no seasonalityHorizontal pattern, no
seasonalityNegative trend pattern, no seasonalityPositive trend...
A small business has recorded sales over the last 20 years. The data is provided in accompanying...
A small business has recorded sales
over the last 20 years. The data is provided in
accompanying workbook, tab “Small Business”. The business would
like to use this data to provide a sales forecast for the future,
specifically, the next two years. Build a spreadsheet that shows
all the forecasts on a side-by-side basis so they can be compared
for effectiveness using an error measure.
Create a chart showing the data in time. Discuss any
patterns in the dat
Create moving average...
Question 1: Wendy's Happy Homes Inc. manufactures Home Appliances. Monthly sales of Wendy's Washers and Dryer...
Question 1:
Wendy's Happy Homes Inc. manufactures Home Appliances. Monthly
sales of Wendy's Washers and Dryer Sets for a nine-month period
were as follows:
MONTH
Washer and Dryer Sales
January
490
February
480
March
450
April
500
May
480
June
470
July
490
August
520
September
530
Forecast October sales
using:
1) A four-month moving average
2) a six-month moving average
3. Compute the MAD for each forecast
method you used.
Actual October sales were 520 units.
4) Which method...
Please answer the following questions with actual average sales prices of existing single family homes in...
Please answer the following questions with actual average sales
prices of existing single family homes in the United States over a
number of years. (10pts)
Year
Avg Price
1
$114,400
2
$115,300
3
$124,700
4
$126,600
5
$129,300
6
$133,500
7
$135,800
8
$141,800
9
$150,500
10
$159,100
11
$168,300
12
$176,200
13
$185,300
Prepare a line graph of these data. Do the data appear to be
stationary or non-stationary?
Create a (double) moving average model (with k=2) for the...
1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply...
1) Data collected on the yearly demand for 50-pound bags of
fertilizer at Wallace Garden Supply are shown in the following
table
. YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS)
1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15
a) Develop a 3-year moving averages model to forecast sales.
b) Develop a 3-year weighted moving averages model in which
sales in the most recent year are given...
Consider the following time series data (Insert the data in an Excel file): Quarter Year 1...
Consider the following time series data (Insert the data in an
Excel file):
Quarter Year 1 Year 2 Year 3
1 8 9 12
2 5 6 9
3 7 8 10
4 8 11 11
2.1. Construct a time series plot. What type of pattern exists
in the data?
2.2. Use a multiple regression model with dummy variables as
follows to develop an equation to account for seasonal effects in
the data. Qtr1=1 if quarter 1, 0 otherwise; Qtr2=1...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 23 minutes ago
asked 35 minutes ago
asked 40 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago