Purchase Solution

Quantitative Methods : Linear Trends, Regression and Forecasting

Not what you're looking for?

Ask Custom Question

1. The CEO of a small company is concerned about the continual growth in manufacturing costs over the past few years. The following is a time series of the cost per unit (in dollars) for the companys leading product over the past 8 years.

A. graphic this time series. Does a linear trend appear?
B. Develop the equation for the linear trend component for the time series. What is the average cost increase per year?
(see attached file label "costperunit.doc")

2. The ownership of a fast food chain wants to investigate the relationship between the daily sales volume in dollars of a company restaurant against the number of competitors within a 1 mile radius... (see attached file labeled "competitors.doc")

A. Develop a least squares estimated-regression-equation that relates dailysales volume to the number of competitor restaurants in the 1 mile radius.
B. Use the estimated regression equation developed in part A to forecast the daily sales volume for a particular company restaurant that has for competitors within a 1 mile radius.

Attachments
Purchase this Solution
Solution Summary

Linear Trends, Regression and Forecasting are investigated.

Solution Preview

Please see attached.

I have used Excel to perform the ...

Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Probability Quiz

Some questions on probability

View More Free Quizzes
Related BrainMass Solutions

  • Appropriate quantitative forecasting methods

    Mathematical models (trend lines, log-linear models, Fourier series, etc.): linear or non-linear models fitted to time-series data, usually by regression methods. 4.

  • Quantitative Forecasting Explained

    Types of time series forecasting methods are moving averages (forecast based on arithmetic average of past data points), exponential smoothing (a weighted moving average that includes trends), mathematical models (linear or non-linear best fit models

  • Forecasting

    These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regression 5)Seasonal Forecasting via Regression, if we determine it is subject to seasonality (i.e., linear trends with multiplicative seasonality or nonlinear

  • quantitative methods

    Another example of quantitative methods used in business is regression and time series analysis. These are basically forecasting methods. Consider you have a business which sells seasonal goods.

  • Quantitative analysis questions

    100077 Quantitative Methods Questions I What do you know about regression analysis? What is regression analysis good for?

  • Understanding Forecasting models as they apply to products

    houses can be forecasted by using linear regression model of forecasting-a quantitative method of demand forecasting.

  • Mean Absolute Deviation

    These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regression 5)Seasonal Forecasting via Regression (i.e., linear trends with multiplicative seasonality or nonlinear trends with multiplicative

  • Time Series Analysis

    These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regression 5)Seasonal Forecasting via Regression, if we determine it is subject to seasonality (i.e., linear trends with multiplicative seasonality

  • Comparing and Contrasting of various forecasting methods

    Different methods of quantitative techniques I Regression analysis is used to forecast demand and expenses: Regression analysis is any statistical method where the mean of one or more random variables is predicted conditioned on other (measured) random

View More Related Solutions