4. Using the actual Year-3 numbers check your forecast accuracy, by calculating CFE, MSE, MAD, MAPE, and the tracking signal on microsoft Excel ### Dress Sales Data AnalysisPricilla Phranklin opened her clothing store, Pricilla Phashions, in Downtown Dover a little over three years ago. The sales of pants, skirts, blouses, and shirts are fairly consistent, while items like shorts, sweaters, and outerwear show a high degree of seasonality. However, the sales of dresses are more challenging to predict. Pricilla is hiring you to determine the best forecasting method for dress sales.Below is a table containing three years of dress sales data:| Month | Year 1 Demand | Year 2 Demand | Year 3 Demand ||-------|---------------|---------------|---------------|| Jan | 186 | 217 | 212 || Feb | 222 | 220 | 245 || Mar | 220 | 239 | 252 || Apr | 356 | 362 | 376 || May | 720 | 727 | 757 || Jun | 367 | 376 | 404 || Jul | 340 | 341 | 354 || Aug | 293 | 290 | 324 || Sep | 305 | 296 | 338 || Oct | 600 | 600 | 618 || Nov | 325 | 318 | 356 || Dec | 679 | 708 | 713 || **Total** | **4613** | **4694** | **4949** |This data will help in analyzing the patterns and trends in dress sales over a three-year period, which is essential for developing a robust forecasting model. The data shows variability across months, indicating potential seasonality, and an overall increasing trend.

Given information: Month Year 1 Demand Year 2 Demand Year 3 Demand January 186 217 212…

Pricilla Phranklin opened her clothing store, Pricilla Phashions, in Downtown Dover a little over three years ago. Pants, skirts, blouses, and shirts have fairly consistent sales, while things like shorts, sweater and outerwear are highly seasonal. On the other hand, dresses are a little harder to predict. Pricilla is hiring you to arrive at the best forecasting method for dresses. The following table contains three years of dress sales data Year 1 Month Demand Jan Feb Mar Apr Ap May Jun ww Jul . Aug Sep Oct Nov Dec Total 186 222 *********** Year 2 Demand 217 220 239 2.99 362 www 727 *** 376 www 341 290 296 600 318 708 4694 Year 3 Deman d 212 245 252 376 919 757 10 404 354 324 338 618 356 713 4949

Pricilla Phranklin opened her clothing store, Pricilla Phashions, in Downtown Dover a little over three years ago. Pants, skirts, blouses, and shirts have fairly consistent sales, while things like shorts, sweater and outerwear are highly seasonal. On the other hand, dresses are a little harder to predict. Pricilla is hiring you to arrive at the best forecasting method for dresses. The following table contains three years of dress sales data Year 1 Month Demand Jan Feb Mar Apr Ap May Jun ww Jul . Aug Sep Oct Nov Dec Total 186 222 ********* Year 2 Demand 217 220 239 2.99 362 www 727 * 376 www 341 290 296 600 318 708 4694 Year 3 Deman d 212 245 252 376 919 757 10 404 354 324 338 618 356 713 4949

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: Define Panel Data with Two Time Periods? can it be used for comparison?

A: Panel Data with Two Time Periods: “Before and After”: Panel data can be used to control for…

Q: You are interested in studying the relationship between dietary fat intake and pubertal onset. a.…

A: Dietary fat intake and Pubertal onset variable is given to model the data

Q: years are as follows: Year Mileage a) Using a 2-year moving average, the forecast for year 6 = 3775…

A: Given information isThe Carbondale Hospital is considering the purchase of a new ambulance. The…

Q: please answer in text form and in proper format answer with must explanation , calculation for each…

Q: A production process is currently operating at + 4.5 a level. a. Calculate the nonconforming ratio…

A: Answer: Part A: --------------------------- Here, For a ± 4.5σ level, the 'z' score is 4.5.…

Q: b) Given the following data: Month Sales Month Sales July August September 38.0 October 35.0 January…

A: “Since you have posted multiple questions with multiple sub-parts, we will solve the first three…

Q: Scatterplot of Height va Gest Gest

A: We have to comment on the relationship between two variables based on scatter plot.

Q: A company cl mean monthl E. Ho: H Ha

A: Given, a). The hypothesis to be tested: This is a right tailed test. b). The excel syntax to…

Q: 5-Find best predicted repair cost for full-rear crash for Nissan Altima, given that its repair cost…

A: The general form of the linear regression model is, y=a+bx Where, 'y' is the dependent variable, 'a'…

Q: 16. Results for Chess Club attendance are shown in the box plots. Part A: Which month has the…

A: The box plot contains two whiskers which give the range of the box plot. The range is from the…

Q: The table below is the total assets owned by Sharia Commercial Banks (BUS) in 2011 - 2020 obtained…

A: Given: Year Total Assets (in billion rupiahs) 2011 148984 2012 149321 2013 161932 2014…

Q: Given the following actual and forecast data: Month January February March Actual 1250 1200 Forecast…

A: The formula of the forecast error is,where,At denotes the actual value in the time period of t.Ft…

Q: Number of Month Tables Produced EA 10. LO 2.3 This cost data from Hickory Furniture is for the year…

A: The question is about correlation and regression.Given :

Q: Your new store opened for business on September 1. Assuming you plan to forecast sales using a 6-…

Q: The population of a certain region grew from 17 million in 2005 to 21.7 million in 2012 a. Find a…

A: Given, the population P is 17 million in 2005 and has grown to 21.7 million in 2012, let us find the…

Q: State the Five Number Summary for the following dataset. 0.03 0.04 0.05 0.07 0.08 0.09…

A: given data in ascending order; number of…

Q: The following statement refers to which aspect of a statistical study: "A meteorologist constructs a…

A: The statement "A meteorologist constructs a graph showing the total precipitation in Phoenix,…

Q: Given the following forecast errors, calculate the MSE: 15.53 81.22 4.09 5.00 11.34 (Keep one…

A: It is given that the forecast errors are 15.53, 81.22, 4.09, 5.00, 11.34.

Q: The accompanying data table shows the average number of viewers, in millions, for each season of a…

A: We have given average viewers data from year 2000 to 2009. We have to forcast the average no. Of…

Q: The accompanying data table shows the average number of viewers, in millions, for each season of a…

A: The data shows the average number of viewers in millions.

Q: 3. Consumer Reports recently followed up with a survey to its readers asking about political…

A: Hi! Thank you for the question, As per the honor code, we are allowed to answer three sub-parts at a…

Q: The following data report total, monthly U.S. book-store sales in millions of dollars from January…

A: Month number…

Q: The following data report total, monthly U.S. book-store sales in millions of dollars from January…

A: “Since you have posted a question with multiple sub-parts, we will solve three sub-parts for you. To…

Question

4. Using the actual Year-3 numbers check your forecast accuracy, by calculating CFE, MSE, MAD, MAPE, and the tracking signal on microsoft Excel

### Dress Sales Data Analysis

Pricilla Phranklin opened her clothing store, Pricilla Phashions, in Downtown Dover a little over three years ago. The sales of pants, skirts, blouses, and shirts are fairly consistent, while items like shorts, sweaters, and outerwear show a high degree of seasonality. However, the sales of dresses are more challenging to predict. Pricilla is hiring you to determine the best forecasting method for dress sales.

Below is a table containing three years of dress sales data:

| Month | Year 1 Demand | Year 2 Demand | Year 3 Demand |
|-------|---------------|---------------|---------------|
| Jan | 186 | 217 | 212 |
| Feb | 222 | 220 | 245 |
| Mar | 220 | 239 | 252 |
| Apr | 356 | 362 | 376 |
| May | 720 | 727 | 757 |
| Jun | 367 | 376 | 404 |
| Jul | 340 | 341 | 354 |
| Aug | 293 | 290 | 324 |
| Sep | 305 | 296 | 338 |
| Oct | 600 | 600 | 618 |
| Nov | 325 | 318 | 356 |
| Dec | 679 | 708 | 713 |
| **Total** | **4613** | **4694** | **4949** |

This data will help in analyzing the patterns and trends in dress sales over a three-year period, which is essential for developing a robust forecasting model. The data shows variability across months, indicating potential seasonality, and an overall increasing trend.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Need help with the last one please!
The Consumer Price Index is reported monthly by the U.S. Bureau of Labor Statistics. It reports the charge in prices for a market basket of goods from one period to another. The index for 2010 was 213.967. BY 2017, it increased to 239.051 What was the geometric mean annual increase for the period? ( Round your answer to 1 decimal)
An important characteristic on Google Trends is the use of A. Annotations B. cross section data С. Кеywords D. none of these
The forecasts generated by two forecasting methods and actual sales have been collected in the Microsoft Excel Online file attached. Use the Microsoft Excel Online file attached to develop forecast accuracy and answer the following questions. 1. What is the MAD, the MSE, the MAPE, the RSFE, and the tracking signal for each forecasting method? Do not round intermediate calculations. Round your answers to two decimal places. Use the minus sign to enter negative values, if any. 2. What can be concluded about the quality of the forecasts 2? Assume that the control limit for the tracking signal is ±3. The results indicate (bias or no bias) in the forecasts 2, and that the tracking signal (is not or is) within the control limits of ±3.
7.8km 16km SA=
Q. 8 What type of Index numbers are usually calculated?
Name the forecasting methods
Read the following prompt and complete 3.a and 3.b
Answer the following questions regarding the population of Hamilton County in 2016. a. If you predict the population of Hamilton County in 2016, should you use the average growth rate of 2000-2009 or the average growth rate of 2009-2015? Explain your choice in a complete sentence. b. Predict the population of Hamilton Country in 2016. Show your work. Express your answer in “thousand people” rounded to the nearest whole number.
Use the most accurate method to forecast the revenues of licenses, permits, and fees in Years 9, 10, and 11. Use the Year 8 actual figure instead of the forecast figure (Year 8 was $23,210,218). Also, consider three incremental changes in forecasting.
Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Using the most recent value as the forecast for the next month, compute the following measures of forecast accuracy: a) Mean Absolute Error (MAE) b) Mean Squared Error (MSE) c) Mean Absolute Percentage Error (MAPE) d) What is the forecast for Month 8?
Determine which of the four levels of measurement ( norminal, ordinal, interval, ratio) is most appropriate for the data below. Years in which U.S. presidents were inaugurated