Only need help with the second part. Moving averages and the MAD The manager of the Carpet City outlet needs to make an accurate forecast of thedemand for Soft Shag carpet (its biggest seller). If the manager does not order enoughcarpet from the carpet mill, customers will buy their carpet from one of Carpet City'smany competitors. The manager has collected the following demand data for the past8 months. Compute a 3-month moving average forecast for month 4 through month9. According to the result from Excel and/or POM-QM, the forecast for month 4 is(type number only, two decimals)Month1234568879Demand for Soft ShagCarpet (1,000 yd.)8127915111012 For the carpet city problem, what would the Excel file that shows 3-month moving average andthe weighted 3-month moving average forecasts with weights of .55, .33 and .12 look like. Themean absolute deviation (MAD) computations of the two forecasts should also be included in theexcel.

The given information isw1=0.55w2=0.33w3=0.12Sum of wi=1Mean Absolute Deviation (MAD)=|Actual value…

Answered: For the carpet city problem, what would…

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

Perform a complete analysis of this data using the plots and descriptive statistics you generated. You should write your analysis as though it is intended for someone who knows absolutely nothing about this data. You may use the following questions as a starting point to help guide your analysis: What do the data points in both columns represent? Are the data skewed? How do the data compare to one another? (Variation, median, etc.)
Dataset physical is available here. The figure for this exercise is a scatterplot of y 61 60 Head circumference (cm) gཆ ཆུ 56 55 54 59- 58 57 = head circumference (centimeters) versus x = height (inches) for 30 females. 53 60 62 64 66 Height (in.) 68 70 72 (a) Which association does the plot show between the two variables? Explain. There is a positive association since the average head circumference seems to decrease as height increases. There is a negative association since the average head circumference seems to increase as height increases. There is a negative association since the average head circumference seems to decrease as height increases. There is a positive association since the average head circumference seems to increase as height increases. There is no association since the average head circumference is approximately the same across heights. (b) One data point appears to be an outlier. What are the approximate values of height and head circumference for that point?…
Duration is what typye of data?
Determine the type of direction of correlation that you would expect of the given case / situation. Speed of wind turbines and amount of electricity generated. no correlation positive correlation zero correlation negative correlation
PLEASE SHOW AN EXPLANATION FOR EACH PART
I collected data on levels of anxiety after receiving three types of therapies (CBT, psycho education, and psycho analysis). Below are the anxiety scores for 9 patients. Is there a difference in anxiety based on treatment type ? CBT: 3, 2, 0 Psycho Education: 8, 8, 9 Psycho Analysis: 10, 12, 12 (Look at the table)
A correlation of 0.5. The community of having a cat and dog average is 60% and SD = 15. find the score of people having cats that show 75%.
The mall has a set of data with employee age (X) and the corresponding number of annual on-the-job-accidents(Y). Analysis on the set finds that the regression equation is Y=100-3X. What is the likely number of accidents for someone aged 30? 97 100 10 none of the above
Letter (d) Would i be wrong if i said yes the data set consisting of the annual salary for each employee at the MNM company is a population since no employee salary is excluded from the data
The more serving of fruits and vegetables that people tend to eat during the week, the lower their levels of cholesterol. What type of correlation vegetables eaten and cholesterol levels? A positive B negative
Fill in the blank. A A Jhy trial exists between two variables when the values of one variable are somehow associated with the values of the other variable. exists between two variables when the values of one variable are somehow associated with the values of the other variable. correlation inference difference
DataValues 5 9 43 75 77 78 96 98 100 What is the 5th decile?

SEE MORE QUESTIONS

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS

For the carpet city problem, what would the Excel file that shows 3-month moving average and the weighted 3-month moving average forecasts with weights of .55, .33 and .12 look like. The mean absolute deviation (MAD) computations of the two forecasts should also be included in the excel.