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
- 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
Provide answers and calculations. An insurer sells a very large number of policies to people who each have the following identical loss (claims) distribution Loss/claim Probability 100,000 .005 60,000 .010 20,000 .020 10,000 .050 0 .915 1 A. Calculate the Expected claim cost p
See attached file. What is the moving average forecast prediction for a 3 day span for American Express stock? Repeat with a span of 10 days Which of these two spans appears to be more appropriate? Explain your choice.
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
Aztec Industries has developed a forecasting model that was used to forecast during a 10-month period. The forecasts and actual demand were as follows: (see attached file for data) Measure the accuracy of the forecast by using MAD, MAPD, and cumulative error. Does the forecast method appear to be accurate?
17 students + 1 teacher with the following ages: 28 37 42 44 40 36 46 38 42 50 35 47 39 25 33 30 30 30 Compute the Mean, Medium and Mode. Please include spreadsheet and a graph.
Unit 8 Project Quantitative methods 16.12. In testing 9 sedans, Cars and Driver magazine rated each on 13 different characteristics, including ride, handling, and driver comfort. Each vehicle also received ... 18.5. Fit a linear trend equation to the following data describing average hourly earnings of U.S. production work
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
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
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?
# 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
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 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
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
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
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 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
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
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
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
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
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
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
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
Moving Average Forecast, Exponential Smoothing Forecast, Adjusted Exponential Smoothing Forecast, Mean Absolute Deviation (MAD) and Mean Square Error (MSE)
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 a) Determine the forecasted demand for May, June, July and August based on a three month moving average. b) Determine the forecasted demand for May, June, July and A
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 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