Share
Explore BrainMass

Central Tendency

Moving Average Forecast for Closing Value of Stock

The closing value of the AMEX Airline Index for each trading day during a 1-year period is given in the file P13_17.xlsx. a. How well does the moving average method track this series when the span is 4 days; when the span is 12 days? b. Using the more appropriate span, forecast the closing value of this index on the next

Moving Average Forecast, Exponentially Smoothing and MSE

- Calculate the 3-month moving average and MSE a. Exponentially smooth the data and MSE b. Explain which method produces better results and why c. Forecast the value for period 13 using the better method Month Yt 1 80 2 82 3 84 4 83 5 83 6 84 7 85 8 84 9 82 10 83 11 84 12 83

Statistical Analysis of Job Satisfaction

The data set for this post is a sample of a survey conducted on the population of the American Intellectual Union (AIU). It is available via the following link: DataSet with DataSet Key: NEW SET OF DATA IS USED EACH SESSION different set of numbers. Must complete using the current dataset which contains the following nine sect

Expected Frequency

1) Determine the expected frequencies for each of the cells in the following contingency tables. For each problem, state how many of the expected values actually had to be computed and how many could be found by subtraction. Problem 1c 21 25 15 10 13 10 11 45 27

Quantitative Analysis for Management

Chapter 15 Dr. Mark Greenberg practices dentistry in Topeka, Kansas. Greenberg tries hard to schedule appointments so that patients do not have to wait beyond their appointment time. His October 20 schedule is shown in the following table. Unfortunately, not every patient arrives exactly on schedule, and expected times to

Drawing a Decision Tree: Expected Value of Chance Node

I am trying to figure this out a chance node on a decision tree has four possible outcomes worth $10,000, $20,000, $30, 000 and minus $100,000 respectively. The probabilities of these outcomes occurring are assessed as 10%, 25%, 50%, and 15% correspondingly. Draw the decision tree. What is the expected value of this chance node?

risk averse investor

# 12 You are a risk-averse investor who is considering investing in one of two economies. The expected return and volatility of all stock in both economies is the same. In the first economy, all stock move together—in good time all prices rise together and in bad times they all fall together. In the second economy, stock retur

Forecast for demand based on moving average

Recent past demand for product ZXT is given in the following table. Month Actual Demand February 20 March 22 April 33 May 35 June 31 July 48 August 41 Determine the forecasted demand for May, June, July August and Septemb

Moving Average and Exponential Smoothing

____________ moving averages react more slowly to recent demand changes than do ____________ moving averages. Longer-period / shorter-period Shorter-period / longer-period Longer-period / longer-period Shorter-period / shorter-period In exponential smoothing, the closer alpha

Forecast Accuracy Measure

RAP Computer assembles personal computers from generic parts it purchases at a discount, and it sells the units via phone orders it receive from customers responding to the company's ad in trade journal. The business has developed an exponential smoothing forecast model to forecast future computer demand. Actual demand for th co

Weighted Moving Average Forecast and MAD in EXCEL

The problem states that the manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (it biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City many competitors. The manager has collected the followi

Naive Exponential Forecasts

Sales of a reversible electric drill over the last eight months are given in the following table: Month 1 2 3 4 5 6 7 8 Sales (units) 42 43 40 44 50 47 53 49 Forecast sales of the drill in month 9 using the following methods: a. A naive forecast. b. A five-period simple moving average. c. A three-period weig

Ratio to moving average method

Ratio to moving average method An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few quarters. Beginning in Quarter 4 of 2006 , the analyst collects the following sales data (in millions of dollars). Estimate the seasonal index associated with Quarter 1 . Round your answe

Expected dividend per shares

Company x just paid a dividend of $1.50 a share. the dividend was expected to grow 7% for the next 3 years and then 5% a year thereafter. What is the expected dividend per share for each of the next 5 years?

Distributions/Quartiles : Assume that you work in the Planning D partment of the Century National Bank and report to Ms. Lamberg. You will need to do some data analysis and prepare a short written report. Remember, Mr. Selig is the president of the bank, so you will want to ensure that your report is complete and accurate. A copy of the data appears in Table 1 ... (Please see attachment)

Assume that you work in the Planning D partment of the Century National Bank and report to Ms. Lamberg. You will need to do some data analysis and prepare a short written report. Remember, Mr. Selig is the president of the bank, so you will want to ensure that your report is complete and accurate. A copy of the data appears in T

calculate the expected net profit

Information I have gathered from the problem. I have a new product that has a probability .5 of being a success and probability .5 of being unsuccessful. Sucessful products pass quality control 80% of the time. Unsuccessful products pass quality control 25% of the time. If the product is successful the net profit for the

Moving Average Forecast: Example Problem

The closing value of the AMEX Airline Index for each trading day during a 1 year period is given in the attached file. 1) How well does the moving average method track this series when we span in 4 days; when we span in 12 days? 2) Using the more appropriate span, forecast the closing value of this index on the next

Job Satisfaction Data Set

Please advise what would be the most suitable format for the following: QMB350-0903B-09 Statistical Analysis Assignment Name: Unit 1 Individual Project Deliverable Length: 3 pages Details: The data set for our course is a sample of a survey conducted on the population of the school. It is available via the following lin

Expected Returns on the Stock Market

C1. (Beta and required return) The riskless return is currently 6%, and Chicago Gear has estimated the contingent returns given here. a. Calculate the expected returns on the stock market and on Chicago Gear stock. b. What is Chicago Gear's beta? c. What is Chicago Gear's required return according to

Observed and Expected Values

A research firm reported that 15% of those surveyed described their health as poor, 26% as good, 40% as very good, and 19% as excellent. A health professional in Chicago wanted to determine if people in Chicago had similar feelings toward their health. In a sample of 610 people, 70 described their health as poor, 180 as good, 22

Finding the Expected Value: Example Problem

Dan Woodward is the owner and manager of Dan's Truck Stop. Dan offers free refills on all coffee orders. He gathered the following information on coffee refills: there is a 30% chance that a customer will not get a refill, a 40% chance that a customer will get one refill, a 20% chance that a customer will get two refills, and a

If he uses minimax regret criterion, how many new workers will he hire? If the manager thinks the chances of low, medium and high compliances are 20%, 30%, and 50% respectively. Find the best expected net revenues for the number of worker he will decide to hire. Find the expected value of the perfect information.

The local operations manager for the IRS must decide whether to hire 1, 2, or 3 temporary workers. He estimates that net revenues will vary with how well taxpayers comply with the new tax code. # of workers Low Compliance Medium Compliance High Compliance 1 $50 $50 $50 2

Expected completion time and variance for the overall project completion time

Determine the expected completion time and variance for each activity, the expected completion time and variance for the overall project completion time, and answer questions a, b, and c below. 2. Determine the expected completion time and variance for each activity, the expected completion time and variance for the overall p

Capital Asset Pricing

Capital Asset Pricing Model 6.10 Suppose you invest $27,000 in King Company Stock, which has a beta of 1.33 and in 1000 shares of Ace company stock at $23 a share. Ace has long term growth of 4% annually. The riskless rate is 9% and the expected return rate on the market is 17%. Next year the dividend of Ace will be $2.30 a