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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
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...