Essay Available:
Pages:
4 pages/≈1100 words
Sources:
2
Style:
APA
Subject:
Mathematics & Economics
Type:
Statistics Project
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 20.74
Topic:
Rent-A-Car: Demand For “Economy” Vehicles
Statistics Project Instructions:
Datasets and description for the case assignments:
- Estimate the demand for “economy” vehicles using variables provided, you might also derive data from other resources and combine with the dataset. Choose the best model.
- Forecast the demand for the “economy” vehicles in Week 30.
- Our customers who choose to keep a car for an extra day are currently paying the same base daily rate. Do you see any potential in exploring alternative schemes? If so, what changes should we implement-shall we change the price for extra days? What considerations are involved in this decision? Provide your thoughts on this issue.
- What other issues or news you would pay attention to adjust your price and managerial strategies?
Demand estimation model selection guidelines
- Find a model with adjusted R-squared above 0.7
- Coefficient for PownE should be negative and significant (|t|>2)
- At least half of the coefficients should bear the correct signs (you should be able to explain the signs) and be statistically significant (|t|>2)
Statistics Project Sample Content Preview:
Project Rent a Car
Name
Institution
Date
Part 1
Using the bed tax independent variable in excel results in incorrect values indicated as “LINEST function returns error. Please check input ranges again” and was excluded from the analysis. QE is a proxy for the quantity demanded and is assumed to be the dependent variable in the model (Chulkov & Nizovtsev, 2012). UI estimated the demand using QE as the dependent variable and in the 52nd week this was 81.86609, which is approximately 82.
- 1. Estimate the demand for “economy” vehicles using variables provided, you might also derive data from other resources and combine with the dataset. Choose the best model.
Coefficients | |
Intercept | 66.57193606 |
PownE | -0.127770438 |
Pcomp | 0.019747865 |
TotlAD | -0.000271007 |
unempl | 0.000227238 |
flights/wk | 0.168145206 |
wrecks | 0.141128711 |
Q_length | 0.233578764 |
E_days | -18.01469278 |
age/weeks | 0.07495796 |
- 2. Forecast the demand for the “economy” vehicles in Week 30.
- Our customers who choose to keep a car for an extra day are currently paying the same base daily rate. Do you see any potential in exploring alternative schemes? If so, what changes should we implement-shall we change the price for extra days? What considerations are involved in this decision? Provide your thoughts on this issue.
- 4. What other issues or news you would pay attention to adjust your price and managerial strategies?
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.99274846 | |||||||
R Square | 0.985549505 | |||||||
Adjusted R Square | 0.982452971 | |||||||
Standard Error | 1.387331294 | |||||||
Observations | 52 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||