The Vintage Restaurant, on Captive Island near Fort Meyers, Florida, is owned and operated by Karen Payne. The restaurant just completed its second year of operation. Below are the sales for those two years (in ten thousands of dollars).MonthFirst YearSecond YearJanuary5761February5175March5854April5756May6862June7271July6059August5175September6868October5150November7164December7558 a) Construct a time-series plot in excel. (Label axes and graph) b) Develop a six month moving average. Compute MSE and forecast the amount of sales for the next month. c) Use α = 0.2 to compute the exponential smoothing values. Compute MSE and forecast for the next month. d) Compare the result for the six month average and exponential smoothing. Which appears to provide a better forecast based on MSE? Explain.

Since you have posted a question with multiple-subparts. we will be answering first three subparts…

The Vintage Restaurant, on Captive Island near Fort Meyers, Florida, is owned and operated by Karen Payne. The restaurant just completed its second year of operation. Below are the sales for those two years (in ten thousands of dollars). Month First Year Second Year January 57 61 February 51 75 March 58 54 April 57 56 May 68 62 June 72 71 July 60 59

The Vintage Restaurant, on Captive Island near Fort Meyers, Florida, is owned and operated by Karen Payne. The restaurant just completed its second year of operation. Below are the sales for those two years (in ten thousands of dollars). Month First Year Second Year January 57 61 February 51 75 March 58 54 April 57 56 May 68 62 June 72 71 July 60 59

Algebra: Structure And Method, Book 1

(REV)00th Edition

ISBN:9780395977224

Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole

Publisher:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole

Chapter8: Introduction To Functions

Section8.6: Functions Defined By Tables And Graphs

Problem 8WE

See similar textbooks

Similar questions

the values of alabama building contracts (in $ millions) for a 12-month period follow.240 350 230 260 280 320 220 310 240 310 240 230a. construct a time series plot. What type of pattern exists in the data?
For the hawkins company, the monthly percentages of all shipments received on timeover the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.a. construct a time series plot. What type of pattern exists in the data?
The daily sales figures shown below have been recorded in a medium size insurance company
ten weeks of data on the commodity Futures index are 7.35, 7.40, 7.55, 7.56, 7.60, 7.52,7.52, 7.70, 7.62, and 7.55.a. construct a time series plot. What type of pattern exists in the data?
a) If 30 % of the hack times are greater than A microseconds, what is A to one decimal place? b) What percent of the times are predicted to be between 18 and 20 microseconds? Report the percentage to two decimal places. c) What percent of the times are predicted to be between 18 and 20 microseconds? Report the percentage to two decimal places. d) If 60 % of the hack times are predicted to be between 17 and B microseconds, what is B to one decimal place? Note: Avoid rounding until the very end. Store intermediary numbers as a variable to use in your calculator. e) What is the probability that the hack times are typical? Round your answer to two decimal places.
Kaitlyn measures the upload speed in megabits per second of her home broadband internet connection during peak hours and off-peak hours. The results are provided in the accompanying table. Peak Off-Peak 5.83 5.14 6.05 6.80 7.14 6.98 3.54 5.77 5.45 7.27 5.90 6.62 5.81 6.19 4.82 6.08 6.37 6.59 4.65 5.58 5.30 7.41 6.48 6.26 5.96 6.37 5.79 6.31 6.84 6.55 5.06 4.95 5.61 7.03 6.45 6.77 Examine the results of Kaitlyn's test to determine the statements that compare the medians and interquartile ranges of the data sets to each other in terms of this situation. Select the two correct answers. The median upload speed during peak hours is 5.905 megabits per second, which is less than the median upload speed during off-peak hours, 7.005 megabits per second. The upload speeds during peak hours are slower on average compared to off-peak times. The median upload speed during peak hours is 6.37 megabits per second, which is greater than the median upload speed during…
The following table represents the MPY closing sock price over a period of 9 trading days. In the image. What is the 2nd 6-day simple moving average? Round your answer to nearest penny.
John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)
Use MINITAB or some other computer software toconstruct a stem-and-leaf display for the following data representing the time to make coke (in hours) in succes-sive runs of a coking oven. 7.8 9.2 6.4 8.2 7.6 5.9 7.4 7.1 6.7 8.510.1 8.6 7.7 5.9 9.3 6.4 6.8 7.9 7.2 10.26.9 7.4 7.8 6.6 8.1 9.5 6.4 7.6 8.4 9.2
The following data set provides the total number of shipments of core major household appliances in the U.S. from 2000 to 2016 (in millions): Year Shipments (millions) 2000 38.4 2001 38.2 2002 40.8 2003 42.5 2004 46.1 2005 47.0 2006 46.7 2007 44.1 2008 39.8 2009 36.5 2010 38.2 2011 36.0 2012 35.8 2013 39.2 2014 41.5 2015 42.9 2016 44.7 a. Plot the time series. b. Fit a three-year moving average to the data and plot the results. c. Fit a five-year moving average to the data and plot the results. d. Compute a linear trend forecasting equation and plot the trend line. e. Compute a quadratic trend forecasting equation and plot the results.
The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.350.35 and 0.650.65 is what?
(B) Predict the company's annual revenue for the period ending 1/31/10. Screenshot attached below