For the data in the Excel file Gasoline Prices do the following: a. Develop spreadsheet models for

Question:

"For the data in the Excel file Gasoline Prices do the following:

a. Develop spreadsheet models for forecasting prices using simple moving average and simple exponential smoothing.

b. Compare your results to the outputs from Excel’s Data Analysis tools.

c. Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing.

d. Use XL Miner to find the best number of periods for the moving average forecast and optimal exponential smoothing constant.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Business Analytics Methods Models and Decisions

ISBN: 978-0321997821

2nd edition

Authors: James R. Evans

See More Books

Question Posted: Dec 09, 2015 02:06 AM

See More Questions

For the data in the Excel file Graduate School Survey, perform a chi square test for independence to determine if plans to attend graduate school are independent of gender.
Create a PivotTable for the data in the Excel file Weddings to analyze the wedding cost by type of payor and value rating. What conclusions do you reach?
Construct a column chart for the data in the Excel file State Unemployment Rates to allow comparison of the June rate with the historical highs and lows. Would any other charts be better to visually...
For the non-seasonal frequencies, use $g \operatorname{lm}()$ to fit the additive exponential model \[ E\left(|\hat{Y}(\omega)|^{2}ight)=\beta_{0}+\beta_{1} \exp \left(-|2 \pi \lambda \omega|^{1 /...
Give an example of how environmental genomics has discovered a known metabolism in a new organism.
Nadia consumes two goods, food and clothing. The price of food is $2, the price of clothing is $5, and her income is $1,000. Nadia always spends 40 percent of her income on food regardless of the...
In a group of 160 graduate engineering students, 92 are enrolled in an advanced course in statistics, 63 are enrolled in a course in operations research, and 40 are enrolled in both. How many of...
Saddle Inc. has two types of handbags: standard and custom. The controller has decided to use a plant-wide overhead rate based on direct labor costs. The president has heard of activity-based costing...
Suppose the real risk - free rate is 3 . 5 0 % , the average future inflation rate is 2 . 5 0 % , a maturity premium of 0 . 2 0 % per year to maturity applies, i . e . , MRP = 0 . 2 0 % ( t ) , where...
Suppose that you are the new CEO at Memorial Hospital. Me- morial is a nonprofit hospital with 300 beds and is located in a busy metropolitan area directly adjacent to a large university. Memorial is...
The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrials Index over a 1 month period. a. Develop spreadsheet models for forecasting each of the stock prices...
Consider the prices for the DJ Industrials in the Excel file Closing Stock Prices. The data appear to have a linear trend over the time period provided. a. Use simple linear regression to forecast...
Consider the following sample data, consisting of 20 observations. a. Construct a 5-period moving average and plot it along with the actual series. Comment on smoothing. b. Use the 5-period moving...
Why can the Z-distribution be used in the event of large samples?
List some guidelines for successful service design.
Outline the relative advantages of action research and more typical approaches to evaluation from the perspective of the HR manager sponsoring an evaluation.
Describe and analyse conceptual approaches to the design of organisational structures and discuss their strategic implications;
List the characteristics of well-designed service systems.
Find polar equations for the circles. Sketch each circle in the coordinate plane and label it with both its Cartesian and polar equations. x 2 + (y - 5) 2 = 25
The Smiths buy a house. They borrow 80 percent of the purchase price from the local ABC Savings and Loan. Before they make their first payment, ABC transfers the right to receive mortgage payments to...
A warehouse double-checks the accuracy of its order fulfillment process each day. The data in the worksheet Problem 12 shows the number of orders processed each day and the number of inaccurate...
Refer to the data in the worksheet Problem 8. Suppose that the specification limits for the process are 90 (lower) and 110 (upper). Compute the process capability index and interpret. Eliminate any...
Refer to the data in the worksheet Problem 9. Suppose that the specification limits for the process are 25 (lower) and 40 (upper). Compute the process capability index and interpret. Eliminate any...
How many stars will be printed on the screen when the following piece of code runs? for (int i = 1; i
Create Unified Modeling Language (UML) diagrams for the following classes. Cellphone : It carries manufacturer, modelNumber and Price info.
please explain from your perspective what are the benefits of using a data dictionary? List the three elements Unified Modeling Language understanding and practical example.

For the data in the Excel file Gasoline Prices do the following: a. Develop spreadsheet models for

Question:

Step by Step Answer:

Gasoline Prices Average US Prices for Regular Gasoline Alpha Alpha Alpha MANUAL Data Analysis 3Period 02 3Period 02 3Period 02 Alpha Alpha MA ES MA ES MA ES 3Period 02 3Period 02 MAD MSE MAPE Date Pri...View the full answer

Business Analytics Methods Models and Decisions

Students also viewed these Business Communication questions