A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days wereDay:1Number sold: 36238Day:1011Number sold: 48 523 2 12 55MSE42Click here for the Excel Data File4441354548145664915577950849952a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 50 forDay 8, an initial trend estimate of 2, and a = B = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSEusing the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimalplaces. Round your final MSE answer to 3 decimal places.)

Using trend-adjusted exponential smoothing, we can solve this problem. Trend-adjusted exponential…

Answered: A pharmacist has been monitoring sales…

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

Technicians use moving-average lines to detect changes in trends by observing the interaction between the price of an asset and its moving average over a specific period. Consider a stock whose price data over the past 10 days are as follows: Day 1 2 3 4 5 6 7 8 9 10 Stock Price ($) 54.50 54.25 55.75 56.50 57.25 56.00 54.75 53.25 52.50 53.00 5-Day Simple Moving Average ($) Trend Assume a simple moving average (SMA) is calculated over a 5-day period. Calculate the SMA for each day, and based on the SMA, identify any potential changes in the trend during the 10-day period.
The below data represent the advertising expenditure and sales of Liu Liu Ltd from year 2010 to 2019. Table: Advertising Expenditure vs. Sales from 2010 to 2019 Year Advert. Expenditure Sales Growth rate of Ad. Expenditure Growth rate of Sales (x, £000) (y, £000) 2010 19 84 2011 22 108 18% 29% 2012 32 82 46% -24% 2013 42 86 32% 6% 2014 47 84 11% -3% 2015 46 94 -2% 11% 2016 58 103 27% 10% 2017 63 115 8% 12% 2018 70 106 11% -8% 2019 80 142 15% 34% Total 479 1004 a. What is the statistical relationship shown in the table and list out 3 characteristics of this relationship?
the table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.
Given the number of calls per week received by a dental clinic, what is the forecasted number of calls for week 12 considering that the forecast for week 1 was 47 and a smoothing constant a -0.2? CALLS 52 35 25 36 45 35 44 WEEK 1 2 3 4 5 6 7 869 10 34 calls 35 calls 33 calls 38 calls 30 35 25
Please solve with accurate steps.
A hotel is monitoring how the number of increases in price affects the weekly profit. The table models the weekly profit, y, after a given number of price increases, x. Which type of models would best fit the data?
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $2,570,000 $3,750,000 $4,380,000 $5,010,000 $5,520,000 What would be the forecast for next year’s sales using regression to estimate a trend?
Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yes
Below is a table containing data on product demand for the most recent three months along with the forecasts that had been made for those three previous months. Calculate the MAPE. Month Demand Forecast 1 308 310 388 390 344 342 2.
This is an MCQ kindly answer with proper explanation
The following are historical demand data: ACTUAL YEAR 2011 SEASON DEMAND Spring 201 Summer 142 Fall 380 Winter 578 2012 Spring 469 Summer 273 Fall Winter 683 963 Use regression analysis on deseasonalized demand to forecast demand in summer 2013. (Do not round intermediate calculations. Round your answer to the nearest whole number.) Forecast for summer 2013
The below data represent the advertising expenditure and sales of Little Liu Ltd from year 2008 to 2017. Table: Advertising Expenditure vs. Sales from 2008 to 2017 Year Advert. Expenditure Sales (x, £000) (y, £000) 2008 8 30 2009 12 40 2010 11 29 2011 5 29 2012 14 43 2013 3 17 2014 6 20 2015 8 30 2016 4 22 2017 9 40 Total 80 300 Figure: Scatter Diagram of Advertising Expenditure and Sales with Trend line ( See picture) What is the statistical relationship shown in the Figure and list out 3 characteristics of this relationship? 2. Work out the values of parameters of the relationship shown in the Figure (i.e. work out the equation of the relationship). 3.Explain the relationship and make recommendations to Little Liu Ltd based on the information given.

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