Purchase Solution

quantitative forecasting

Not what you're looking for?

Ask Custom Question

"... With quantitative forecasting, historical data and math are used to predict future events" .

Questions:
A) Identify a variable that varies over time. Be sure you have a sufficiently large data set.
B) Construct a time series scatter plot. Is there an apparent trend component? (plug data into Excel, create simple scatter plot)
C) Using an appropriate forecasting tool, predict the value for the next period of time. (add trend line with forward looking attribute turned on)
D) Create a short description of your findings (tell me about some future predicted value, based on your data / trend)

Purchase this Solution
Solution Summary

This solution is comprised of a detailed explanation for time series analysis. The data analysis tool is used for the time series in excel. Scatter plot along with the interpretation is given in the solution. Full interpretation is given for analysis based on the output.

Solution Preview

Please see attachments for complete solution.

"... With quantitative forecasting, historical data and math are used to predict future events" .

Identify a variable that varies over time. Be sure you have a sufficiently large data set.

Construct a time series scatter plot. Is there an apparent trend component? (plug data into Excel, create simple scatter plot)

Using an appropriate forecasting tool, predict the value for the next period of time. (add trend line with forward looking attribute turned on)

Create a short description of your findings (tell me about some future predicted value, based on your data / trend)
Solution:
The data is sale data for ABC Company. Quarterly sales values (measuring in $1,000's) for last 20 years is given and based on these values they want to forecast budget plan for ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Quantitative Forecasting Explained

    78825 Forecasting Explain what makes quantitative forecasting methods appropriate. Quantitative forecasting methods or objective analysis are appropriate when sufficient and relevant numerical data from the past is available.

  • Planning tools for forecasting

    Forecasting Planning Tools 1. Quantitative Forecasting - This type of forecasting is a common method used in organizations. Quantitative predictions are generated by using past or historical data to forecast the future.

  • Linear Programming, Queueing Analysis, Simulations, Decision Analysis and Forecasting

    D) What is the difference between quantitative forecasting methods and qualitative forecasting methods? E) Under what circumstances would it be more appropriate to use quantitative rather than qualitative forecasting methods?

  • Forecast Technique

    However, as Iraq has gone through turbulent times and war, it is best advisable to combine such quantitative forecasting techniques with qualitative forecasting tools such as Delphi Method.

  • Forecasting Methods used by Modern Corporations

    460873 Forecasting Methods used by Modern Corporations Discuss forecasting methods used in a modern corporation. Include qualitative and quantitative methods commonly used. Forecasting utilizes past data to predict the future.

  • Appropriate quantitative forecasting methods

    The solution explains when quantitative forecasting is appropriate.

  • Forecasting Methodologies

    In project management forecasting refers to the forecasting of discrete events, forecasting of a large group of activities, or the technology used for forecasting. The methodologies include qualitative and quantitative.

  • Technology Forecasting

    Quantitative or numerical techniques such as Trend Exploration are useful when reliable quantitative data are available for forecasting. Such forecasting techniques are mostly used for short to medium term forecasting.

  • Forecasting in a Health Care Center

    Forecasting is an uncertain science since it calls for predictions but current theoretical and mathematical models (quantitative and qualitative) make it possible for organizations to predict with an acceptable margin of error.

  • Two Forecasting Approaches

    The two approached to forecasting are qualitative methods and quantitative methods. Quantitative methods are most frequently used when existing data is available surrounding sales of a product or service and that data can be measured.

View More Related Solutions