Three horrible guys Project Report
Network Analysis (Shortest Path)
We realized that for every map IFC provided in PowerPoint they have a node which indicated the travel time to each region. However, we realized that this time is only calculated with the main external road without taking into consideration that there were other roads within each Trade Area that can be utilized for travel time. We created centroids for each subzone that would provide a more accurate estimation of Travel Time for IFC.
Multivariate Regression Analysis
We performed Regression Analysis using the Ordinary Least Squares (OLS) method to identify any predictor factors that could be used to predict what point of interest can make an impact on the sales in the region.
There are 5 significant points,
- Hotel
- Medical Service
- School
- Commuter Rail Station
- Grocery Stores
Hotel, Medical Service and School points are common places one might order a food delivery service to. Hotels have guest who would like to order food in the comfort of their room. Medical Service points might have staff who are too busy to eat their meals, and thus order delivery in order to get food. Schools are full of students who snack and order pizza regularly. All these thus affecting overall sales of the store. However, Commuter Rail Station and Grocery Stores do not make much sense in the context of our model and require further analysis
