Please assist with this Forecasting question. Show all workings and provide explanations. Also, show all input in the table please Question 1The table below shows the number of CD sales recorded at a certain store.Week12346.78910CD Sales110130120140170150160190200190a) Calculate a two-month weighted moving average. Weights applied to oldestin order 0.4, 0.6. What would be your forecast for the demand in month 111?b) What are the MAD, MSE and MAPE for this method?c) If the store decided to forecast using exponential smoothing with value ofalpha = 0.7, what would the forecasts be for the CDs? (Use 2 decimal places)d) Is this an improvement over the previous method – use MAD alone? Explain.-

Question 1 The table below shows the number of CD sales recorded at a certain store. Week 1 2 4 5 7 8. 9 CD Sales 110 130 120 140 | 170 150 160 190 200 a) Calculate a two-month weighted moving average. Weights applied t in order 0.4, 0.6. What would be your forecast for the demand in mo b) What are the MAD, MSE and MAPE for this method? c) If the store decided to forecast using exponential smoothing with va alpha = 0.7, what would the forecasts be for the CDs? (Use 2 decima d) Is this an improvement over the previous method – use MAD alone?

Question 1 The table below shows the number of CD sales recorded at a certain store. Week 1 2 4 5 7 8. 9 CD Sales 110 130 120 140 | 170 150 160 190 200 a) Calculate a two-month weighted moving average. Weights applied t in order 0.4, 0.6. What would be your forecast for the demand in mo b) What are the MAD, MSE and MAPE for this method? c) If the store decided to forecast using exponential smoothing with va alpha = 0.7, what would the forecasts be for the CDs? (Use 2 decima d) Is this an improvement over the previous method – use MAD alone?

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

Similar questions

Hi i’m in grade 12 Data Management and i need help with this practice question
Draw a scatter diagram with square feet of living space as the independent variable and selling price as the dependent variable and describe variable and describe the relationship between the size of a house and the selling price.
Please complete the rest of these questions thank you! The given scatter plot shows age versus test score data for a testof video game skills: d) Use your equation to predict the test score for a60 year-old test-taker.e) Estimate the value of the linear correlationcoefficient for your line. Explain your reasoning.
The basketball coach at a local college believes that his team scores more points at home games when more people show up. Below is a list of all home games last year with scores and corresponding attendance. Use Excel, SPSS, or work by hand to show your work finding r. Show your work on the attached pages. Score Attendance Score Attendance 54 380 67 410 57 350 78 215 59 320 67 113 80 478 56 250 82 451 85 450 75 250 101 489 73 489 99 472 53 451 What is the obtained t-score for this correlation? What is the critical t-score for a two-tailed test with a = 0.05? Is this correlation significant based on the t-scores?
please answer in text form and in proper format answer with must explanation , calculation for each part and steps clearly
The statistics prompt states "The average amount of sleep people get throughout the week in hours. You’ve collected data from 6 people." I need to know how I would input this data into SPSS, or at least what kind of graph it would be so I can try to break it down. Thank you.
dear sir mam how do u create a steam and leaf data plot
For some data, we know the range R of the data is 12 and its median is 6. Find Estimated Lowest Number, and Estimated Highest Number for this data. Give you answers in the same order asked.
CHART ATTACHED. PLEASE USE EXCEL FORMULAS FOR ME TO FOLLOW WHEN APPLICABLE The Standard Issue Test Prep company offers an ACT prep course designed to help students improve their scores on the ACT exam. A mock exam is given at the beginning of the course to see where students are starting from. A sample of 27 students' scores are taken and given below: Using this data, answer questions below. CAUTION! If you are using your calculator for Parts A and B, double-check that you entered the data in your calculator correctly. One minor mistake in data entry can lead to a drastically different answer! Find the mean: ___________________. Round your answer appropriately. Find the standard deviation: ___________________. Round your answer appropriately. Assuming the population is normally distributed, construct a 95% confidence interval for the mean mock exam. Show all relevant work and follow these expectations: Your work should be easy to read and follow. Use…
Provide an appropriate response using correct mathematical notation and vocabulary in the space below. Use the equation editor as needed for mathematical notation.On a recent Statistics test, the scores were 15, 66, 66, 81, 82, 83, 85, 88, 90, 92, 93, and 95. Is the mean a good representation of the center of data? If not, explain why not and identify a better representation of the center of data.
Steve, who has been working hard to improve his golf game, has seen some improvement in his scores over the summer. He would like to use forecasting to set a goal fo accompanying data show the scores from his last nine rounds of golf at the course he plays most often. Use these data to complete parts a through c below. Click here to view the golf score data. a. Construct a graph showing Steve's golf scores over time. Choose the correct graph below. Score A. 100- 96- 92+ 88- 84- 80- Mon 02 4 6 8 10 Round Score The MAD for this forecast is. (Round to two decimal places as needed.) B. 100+ 96- 92- 88- 84- 80- foo 0 24 6 8 10 Round b. Forecast Steve's golf score for his next round using a trend projection. Steve's forecasted golf score for his next round is (Round to the nearest whole number as needed.) c. Calculate the MAD for this forecast. O C. Score 100- 96- 92- 88- 84- 80- 0 2 4 6 8 10 Round Golf Score Data Round 1 2 3 4 56789 Score 94 92 90 88 93 90 86 88 89 0 Score D. 100- 96- 92-…
Please help with both the questions