During the past ten weeks, sales of cases of Comfort brand headache medicine have been as follows: Week 1 2 3 4 5 6 7 8 9 10 Sales 110 115 125 120 125 120 130 115 110 130 Plot these data. Calculate the three-period moving average and forecast the sales for week 11. Plot the new moving average data.

During the past ten weeks, sales of cases of Comfort brand headache medicine have been as follows: Week 1 2 3 4 5 6 7 8 9 10 Sales 110 115 125 120 125 120 130 115 110 130 Plot these data. Calculate the three-period moving average and forecast the sales for week 11. Plot the new moving average data.

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: At Center Hospital there is some concern about the high turnover of nurses. A survey was done to…

A: Given Box and whisker plot is IQR=?

Q: Answer parts (a) through (c). 2000 2010 2020 2030 2040 2050 (millions) 275.8 C 307.9 326.6 355.3…

A: Given: Year Population (millions) 2000 275.8 2010 307.9 2020 326.6 2030 355.3 2040…

Q: The following data are the last three years of quarterly sales ($ thousands) for AmeriWeld. They are…

A: Given that -

Q: 2001 246.4 155.4 (A) Create a scatter plot for each set of data: NORTHEAST SOUTH

A: Year South 1995 124.5 1996 126.2 1997 129.6 1998 135.8 1999 145.9 2000 148 2001 155.4…

Q: Create a 2-D line chart of Cash Sales for months 1-18. Add a trend line with a forward forecast of 3…

A: Given Information: Consider the given data: Months Cash Sales 1 2145600 2 2175200 3 2255200…

Q: Can someone please help with D and E? Thank you very much.

A: One of the ways to compare the fit of the model is to compare the coefficient of determination.

Q: The global mean sea level variations taken from satellite observations in the month of May are given…

A: Given: Data for Year:1997, 1999, 2001, 2005, 2008, 2012, 2014Data for Sea level change: 0, 4.77,…

Q: 30 40 50 60 70 80 90 100 110 120 130 salaries at company 1 in thousands of dollars ..

Q: We are interested in studying the linear relationship between someone's age and how much they spend…

A: Supposey is the amount spend on travelx represents the age AgeAccording to question, we have to find…

Q: ases of Wine Sold at Five Price Levels ses Sold per 10,000 pulation Price per Bottle 23, 21 $10 19,…

A: The given data is Cases Sold per 10,000 Population Price per Bottle 23, 21 $10 19, 18 11…

Q: describe the graphs the data and trends

A: Given information: Bar graph for the Male and female for the head, elbow, shoulder and wrist.…

Q: Consider the following from an estate agent’s business nationally: Month Houses Sold Jan 380…

A: The moving average are used to estimate the average changes that happen over a period of time. There…

Q: 1. Perform a Trend and Seasonal analysis with the following data. Include the trend formula and the…

A: The provided data table:A trend and seasonal analysis must be performed the forecast sales for the…

Q: An analyst must decide between two different forecasting techniques for weekly sales of roller…

A: The data shows the weekly sales of roller blades.

Q: Weekly sales of bread at a local Foods Market are given in the table below. Forecast sales for week…

A: Given the weekly sales of bread at a local Foods Market asWeekSales14022385342043825410643273858411

Q: Food trucks have become a common sight on American campuses. They serve scores of hungry students…

A: The time series analysis is the method to model data which is time dependent. The observation which…

Q: pllowing are the data on demand for white bread loave Day 2 3 4 5 6 7 8 9 10 11 12 Loaves 199 209…

A: day loaves 1 199 2 209 3 215 4 226 5 233 6 237 7 252 8 257 9 253 10 265 11…

Q: You are given the following quarterly sales information for ASTRA Company over the last 3 years.…

A: 1. Centered moving average To compute the central moving average, take the average to two…

Question

During the past ten weeks, sales of cases of Comfort brand headache medicine have been as follows:

Week	1	2	3	4	5	6	7	8	9	10
Sales	110	115	125	120	125	120	130	115	110	130

Plot these data.
Calculate the three-period moving average and forecast the sales for week 11.
Plot the new moving average data.

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

Moving average method :

VIEW

Plot these data.

VIEW

Calculate the three-period moving average and forecast the sales for week 11.

VIEW

Plot the new moving average data

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

The following data contain the quantity (millions pounds) of U.S. domestic fish caught annually over a 7 years period as published by the National Oceanic and Atmospheric Administration. Year Quantity2010 90692011 94892012 93972013 95072014 96832015 97072016 9489 a. Use a 3-year weighted moving average to forecast the quantity of fish for the years 2010 through 2016 for these data by using weightage of 0.45, 0.3 and 0.25 accordingly. Compute the error of each forecast and then determine the Mean Absolute Deviation (MAD) of error for the forecast.
Use the following sales data: Week Sales 1 30 2 35 3 56 4 85 5 95 6 45 7 65 8 74 9 73 10 39 Use naive method, a three-period moving average and exponential smoothing with an a=0.35 for forecast sales Compare the forecasts using MSE and MAD. Explain which one is the best. Make a forecast for weeks 11 and week 12 by using the optimal method.
Illustration 15.32. Calculate the rank correlation from the data given below: Sales (in lacs): Advertising cost. (Rs. 000): 45 56 39 54 45 40 56 60 30 36 40 36 30 44 36 32 45 42 20 36
Try to fit any two moving averages models to the following data and discuss its performance. YEAR 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 QUANTITY 21 22 23 25 24 22 25 26 27 26
Can someone please answer this and tell me how to create a scatter plot in MS excel
A company has the following monthly sales for the past year. Plot the data points on a line graph and describe the results. Month Sales 1 145 2 146 3 145 4 150 5 148 6 150 7 156 8 160 9 158 10 153 11 152 12 154
Example 3: Using three-year moving averages, determine the trend. Production Production Year Year (1000 tonnes) (1000 tonnes) 1990 21 1995 22 1991 22 1996 25 1992 23 1997 26 1993 25 1998 27 1994 24 1999 26
Monday Tuesday Wednesday Thursday Friday Week 1 55 40 33 20 70 Week 2 60 48 50 36 63 Week 3 58 44 38 50 72 Week 4 80 40 40 30 64 Instructions: The table above, which shows income (in thousands of dollars) from sales of a particular product over a four week period. Determine the seasonal variation each of the week Hence calculate the average seasonal variation for each day of the week Plot the graph of the original data and then add the trend line obtained using the moving averages Comment briefly on the trend observed on the graph and calculate the sales figure that is likely to be achieved for the next Monday using the trend line
At one hospital there is some concern about the high turnover of nurses. A survey was done to determine how long (in months) nurses had been in their current positions. The responses (in months) of 20 nurses were as follows.25 4 7 16 27 38 29 44 14 109 25 31 28 30 13 22 33 10 38 (a). Select one of the box-and-whisker plot of the data (look at the screenshot). (b). Find the interquartile range.
The following data show the quarterly sales of a major auto manufacturer for the years 1 through 3. Use multiplicative method to answer the following questions. Year Quarter Sales 160 2 180 3 190 4 170 1 200 2 210 3 260 4 230 3 1 210 2 240 290 260 3 4 26. The equation for the trend line of yearly sales is F, = 567 + 150t. What is the prediction for the sales in year 4? 1200 с. 27. What is the seasonal index for quarter 4 in year 1? a. 1.0 28. What is the average seasonal index for quarter 1? 1.0 29. What is the sales forecast for quarter 1 in Year 4? a. 250 30. What is the sales forecast for quarter 3 in Year 4? a. 340 с. 2.
Give typed full explanation
A small detergent company in Karachi is confident that their sales are growing significantly week by week. Treating sales for the previous eight weeks as a typical example of this increasing trend, they recorded them in PKR 1000's and examined the results. Week 1 2 3 4 5 6 Sales (in PKR) 2.59 2.55 2.63 2.68 2.74 2.83 2.86 2.99 a) Plot a scatter diagram between week and sales. b) Find the equation of regression line. c) Find the expected sales for 12 week d) Find the correlation coefficient between the two variables.