1 / 7

ESTIMATING & FORECASTING DEMAND

Best-fit Line. Average Fare. # Seats sold per flight. ESTIMATING & FORECASTING DEMAND. Chapter 4 slide 1. An airline seeks to estimate the demand relationship between seats sold (Q) and average fare (P): Q = a + bP, based on 16 past observations of P & Q.

vina
Download Presentation

ESTIMATING & FORECASTING DEMAND

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Best-fit Line Average Fare # Seats sold per flight ESTIMATING & FORECASTING DEMAND Chapter 4 slide 1 An airline seeks to estimate the demand relationship between seats sold (Q) and average fare (P): Q = a + bP, based on 16 past observations of P & Q. Here, the best linear equation turns out to be: Q = 479 – 1.63P. Regression Analysis estimates the equation that best fits the data and measures whether the relationship is statistically significant.

  2. R2/(k - 1) 2. F = (1 - R2)/(N - k) REGRESSION ANALYSIS 4.2 More generally, Multiple Regression allows for multiple explanatory variables: Q = a + bP + cP + dY. The power of Multiple Regression: Even with multiple variables that simultaneously influence sales, it’s able to estimate the separate variable influences (i.e. coefficients). Important Regression Statistics 1. R2(ranging between 0 and 1) measures the proportion of variation in Q explained by the right-hand side variables. The F stat (larger F better) indicates the statistical significance (or lack thereof) of the relationship.

  3. REGRESSION STATISTICS 4.3 For the estimated OLS equation: Q = 28.8 - 2.12P + 1.03P+ 3.09Y, (.34) (.47) (1.00) R2 = .78 (78% of Q’s variation explained) and F = 13.86 (well above 95% significance threshold). Standard Errors and t-stats Here, the t-stats are -6.24, 2.20, and 3.09, indicating that all coefficients are statistically significant. Each coefficient’s standard error (its standard deviation) measures the uncertainty around its estimate. The coefficient’s t-stat = coefficient/SE, tests whether the coefficient is statistically significantly different t 0.

  4. REGRESSION ISSUES 4.4 The standard error of the regression measures the uncertainty around the forecast of Q. A 95% confidence interval around the forecast is: ± 2 standard errors. 1. Which equation form? Linear? Polynomial, Multiplicative? 2. Have explanatory variables been omitted? 3. Are the explanatory variables multicolinear? 4. Are the equation errors serially correlated?

  5. CHOOSING A REGRESSION EQUATION 4.5 1. Does the equation make economic sense? Are the “right” explanatory variables included? 2. Are the signs and the magnitudes of the estimated coefficients reasonable? Do they make economic sense? 3. Based on the regression statistics, does the equation have explanatory power? How well did it track the past data?

  6. FORECASTING DEMAND 4.6 Time-Series Models indentify patterns in a single variable over time. Three equations for estimating a time trend: 1. Linear, Qt = a + bt A Time Series can be decomposed into: 1. Trends 2. Business Cycles 2. Quadratic, Qt = a + bt + ct2 3. Seasonal Variation, and 4. Random Fluctuations. 3. Exponential, Qt = brt, estimated as log(Qt) = log(b) + log(r)t

  7. FORECASTING DEMAND 4.7 Barometric Models indentify patterns among different variables over time. Movements in “Leading Indicators” predict future changes in economic activity. • The Index of Leading Indicators • Weekly manufacturing hours • Manufacturer’s New Orders • Changes in Unfilled Orders • Plant and Equipment Orders • Number of Housing Building • Permits • 6. Changes in Sensitive • Materials Prices 7. Percentage of firms receiving Slower Deliveries 8. Growth in the Money Supply 9. Index of Consumer Confidence 10. The S&P 500 Index 11. Weekly Claims for Unemployment Insurance

More Related