The file P12_29.xlsx contains monthly revenues for a company over a four-year period. Use the moving average

Question:

The file P12_29.xlsx contains monthly revenues for a company over a four-year period. Use the moving average method to forecast this company's revenues for the 12 months. What span seems to work best?

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

Step by Step Answer:

Related Book For book-img-for-question

Business Analytics Data Analysis and Decision Making

ISBN: 978-1305947542

6th edition

Authors: S. Christian Albright, Wayne L. Winston

See More Books

Question Posted: Apr 06, 2017 11:37 AM

See More Questions

The file S02_41.xlsx contains monthly returns on Barnes and Noble stock for several years. As the formulas in the file indicate, each return is the percentage change in the adjusted closing price...
The file P09_42.xlsx contains many years of monthly percentage changes in the Dow Jones Industrial Average (DJIA). a. Create a histogram of the percentage changes in the DJIA. Is there any visual...
The file S02_27.xlsx contains monthly data for total U.S. retail sales of building materials. There are really two series, one of actual values and one of seasonally adjusted values. The latter...
1. You are required to compare the results of your printed reports and the results of reports of the MYOB assignment book in your MYOB assignment. If it is assumed that two results of the reports are...
Preparing journal entry for pension plan. A consumer foods company reports the following information related to its only pension plan for 2008 (amount in millions) Give a single journal entry for the...
Being a prudent investor, Sally Perkins always investigates a company thoroughly before purchasing shares of its stock for investment. Ms. Perkins is interested in the common stock of Plunge...
A cylinder of diameter $1.2 \mathrm{~m}$ and length $7.5 \mathrm{~m}$ rotates at $90 \mathrm{r}$.p.m. with its axis perpendicular to an air stream with an approach velocity of \(3.6 \mathrm{~m}...
HHG Consultants has been asked to analyze Carol & Carroll Co. (C&C), which has one retail division. C&C is concerned that it is not focused on its core mission of sales despite only having one...
Health care administrationoffers many opportunities to work on committees, teams, or special projects in an HCO. Discuss one such environment and what regulatory entity may have jurisdiction over the...
For R, partition the data sets into 60% training and 40% validation and implement the 10-fold cross-validation. Use the statement set. seed(1) to specify the random seed for data partitioning and...
The file P12_10.xlsx contains annual revenues for a convenience store. If you want to forecast revenue for the next few years with the moving averages method, what span should you use? Will any span...
Suppose that a time series consisting of six years (20112016) of quarterly data exhibits obvious seasonality. In fact, assume that the seasonal indexes turn out to be 0.75, 1.45, 1.25, and 0.55. a....
Project 1 requires an original investment of $125,000. The project will yield cash flows of $50,000 per year for 10 years. Project 2 has a computed net present value of $135,000 over an eight-year...
How security is maintained within the RSA encryption method. Is it possible to crack RSA encryption and if so how? What precautions can be taken to ensure the security of RSA encryption.?
A tile is initially lying on a roof at a height of 20 m above the ground. A bird lands on the roof, pushing the tile off the roof, which then falls onto the ground. If the tile has a mass of 2 kg,...
The top of a ramp is 5 meters above ground level. The distance a person must travel to get to the bottom of the ramp is 13 meters. What is the horizontal length of the base of the ramp?
In a geometric series, the sum of the second and fourth term is 156. Meanwhile, the sum of the third and fifth term is 235. Find the first term and the common ratio of the series
Suppose four players play 12 games of cards. If the players are all equally likely to win each game, what is the probability that each player will win exactly three games?
Included in Marys gross estate are the following assets: a. How much is included in her gross estate if the alternate valuation date is elected? b. Instead, what if all of Marys assets pass to her...
The polar coordinates of a point are given. Find the rectangular coordinates of the point. (-1, - /3)
A real estate agent has received data on 150 houses that were recently sold in a suburban community. Included in this data set are observations for each 6f the following variables: the appraised...
Given data in the file P2_13.XLS from a recent survey of chief executive officers from 350 of the nations biggest businesses (The Wall Street Journal, April 9, 1998), choose a sample of 25 executives...
A manufacturing companys quality control personnel have recorded the proportion of defective items for each of 500 monthly shipments of one of the computer components that the company produces. The...
First, technology has a major impact on talent shortage. With the increased use of AI, there are fewer data analysis jobs required, so technology can potentially replace some forms of supply chain...
Career pathing programs arm staff with skills and provides incentives of growth, challenge, and visibility. It presents the chance to change the way a technology team is perceived internally and...
In order to better understand what you are trying to communicate, does Christianity and the Way of Jesus fall under a honor society, justice society or both?

The file P12_29.xlsx contains monthly revenues for a company over a four-year period. Use the moving average

Question:

Step by Step Answer:

Month Revenue 1 10767 2 8908 3 8549 4 11316 5 17667 6 11998 7 10800 8 11639 9 11422 10 6755 11 8921 12 13260 13 15547 14 11433 15 13704 16 11267 17 14283 18 13345 19 14521 20 15648 21 15174 22 22889 2...View the full answer

Business Analytics Data Analysis and Decision Making

Students also viewed these Statistics questions