BAD 376PROBLEM ANALYSIS: FORECASTINGQUESTION 1In order to forecast the stock price of Target, a financial analyst used two differentforecasting methods: method 1 and method 2. The results are summarized in thefollowing table:Method 1Method 2Year Actual ValueForecast Value YearActual ValueForecast Value20221009820221009920231101052023110104202411511820241151171. For each method compute the mean square error (MSE).2. Which forecasting method would you recommend? Why?QUESTION 2The following table contains yearly data on the price of beef from 2022 to 2024:Price of beefYear202220232024($/Kg)4812Forecast the price of beef for 2025 and 2026 using the simple linear trend model.

Question 1:Step 1: Calculate the difference between actual values and forecasted values for each…

Answered: BAD 376 PROBLEM ANALYSIS: FORECASTING…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Mazars is an integral player in auditing, accounting, tax and advisory services in South Africa. A seasonal analysis was done on their sales for the period between 2009 and 2014 and the Median Seasonal Index's and the Adjusted Seasonal index's was calculated for each quarter as reflected below. Median seasonal Index Adjusted seasonal index Quarter 1 79.5660 79.0886 Quarter 2 85.3333 84.8213 Quarter 3 135.9855 135.1696 Quarter 4 101.5385 100.9293 Total 400.00 Each adjusted seasonal index measures the magnitude of seasonal influence on the actual values of the time series for a given period within the year. Interpret the seasonal analysis results for Quarter 1
Cryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021. It includes the following variables: Date Day – Day of the year, used to assess trend over time Volume (US $) – Daily trading volume Opening Price (US $) – Opening price for daily trading Price Change (US $) – Daily change in price from opening to close 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)
What is the most effective method for predicting future stock prices based on historical data, and how accurate are these predictions compared to other forecasting models?
Morning House is a mail-order firm which carries a wide range of rather expensive art objects for homes and offices. It operate problems would be greatly reduced. Since it takes approximately six weeks to receive 90% of the response to a given campaign, an accurate prediction of total sales made as late as the end of the first week of receiving orders would be useful. The first week’s sales and total sales of the last 12 campaigns of the firm are shown below. Can the first week’s sales be used to predict total sales? First week’s Total Campaign Sales Sales 1 32 167 2 20 91 3 114 560 4 66 335 5 18 70 6 125 650 7 83 401 8 65 320 9 94 470 10 5 15 11 39 210 12 50 265 --------------------------------------------
Canton Supplies, Inc., is a service firm that employs approximately 100 people. Because of the necessity of meeting monthly cash obligations, the chief financial officer wants to develop a forecast of monthly cash requirements. Because of a recent change in equipment and operating policy, only the past seven months of data are considered relevant. The change in operations has had a great impact on cash flow. What forecasting model do you recommend? Use the Moving Average and Exponential Smoothing Excel templates or other Excel tools to help you answer this question. Cash Required Cash Required Month ($1,000) Month ($1,000) 1 194 5 235 2 217 6 244 3 215 7 203 4 275 Find the best number of months to use in a moving average forecast based on MSE. Do not round intermediate calculations. Round your answers to two decimal places. Number of months MSE 2 3 4 The model is the best. Find the best single exponential smoothing model by…
What do the Forecast for each year add up to?
The ABC Company is involved in the production and selling of consumer goods, particularly beauty products such as bath soap and shampoo and had registered a positive profit growth for the last 10 years. However, the current year seems to be different from those years as the company is expecting a decline in profit; which is estimated to be about 70% below the target. The manager now is in a dilemma … asking himself/herself “What happened, why this decline in profit?” The Manager then asked the company Accountant to give him/her the data on sales and advertising cost for the last 10 years – he/she wants these data to determine whether the company can live without advertising, as advertising cost happens to be substantial. Justify your answer by doing as step-by-step procedure in Correlation Analysis using a 0.05 level of significance. The data are as follows –
Discuss two extensions to the original GARCH (p,q) model and explain additional characteristics of financial data they might be able to capture.
a) Explain the key features of both discrete and continuous data. Use relevant examples to highlight your answer. Are monetary values typically treated as discrete or continuous data? b) You have been given data on real Gross Domestic Product (GDP) for the UK for each year from 2009 to 2019. What is the best way to graphically present this data in order to demonstrate the growth of UK GDP over this time period?
The National Entrepreneurship and Innovation Programme has initiated a business incubation venture ahead of schedule in the venture lifecycle. Something that must be done is to do a justification for the project. Since very little information is known about the project, the estimates are considered to be rough estimates. The accompanying table is the project manager’s gauge of the income that will occur throughout the following five years: End of Year Cash Flow In (GHC) Cash Flow Out (GHC) 1 0 500,000.00 2 300,000.00 90,000.00 3 400,000.00 100,000.00 4 100,000.00 175,000.00 5 50,000.00 35,000.00 What is the payback period for the project. show workings If the net present value (NPV) for each of the cash flows were calculated at a 10% interest rate, what would the NPV cash flow be at the end of five years? Comment on the feasibility of the project.
Below are listed several variables. Check ALL those that are QUANTITATIVE. Group of answer choices • The net profit for a company in 2000 • The dollar amounts on an accounts receivable invoice • The advertising medium (radio, tv, print) used to promote a product • The stock exchange (NASDAQ, NYSE, etc) on which a company’s stock is traded • The reason for termination for all ex-employees
Bartman Industries' and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015-2020. The Winslow 5000 data are adjusted to include dividends. Data as given in the problem are shown below: Bartman Industries Reynolds Inc. Winslow 5000 Year Stock Price Dividend Holding period return Stock Price Dividend Holding period return Includes Divs. Holding period return 2020 $17.25 $1.15 24.75% $48.75 $3.00 -1.05% 11,663.98 32.76% 2019 14.75 1.06 -4.18% 52.30 2.90 13.23% 8,785.70 1.22% 2018 16.50 1.00 62.79% 48.75 2.75 -10.04% 8,679.98 34.91% 2017 10.75 0.95 2.90% 57.25 2.50 -0.42% 6,434.03 14.85% 2016 11.37 0.90 61.02% 60.00 2.25 11.66% 5,602.28 19.05% 2015 7.62 55.75 4,705.97 Assume the risk-free rate on long-term Treasury bonds is 6.04%. Assume also that the average annual return on the Winslow 5000 is 11% as the expected return on the market. Use the SML equation (i.e., CAPM) to…

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS