I'm looking for someone who is FAMILIAR WITH STATA to run my business data through the program and create a model for me.
I have Stata on my computer and while I am not very well versed, I can find my way around for the most part but I'm not great at econometrics so I am not sure what I'm looking for which is a huge disadvantage obviously which is the reason I'm reaching out to you.
I have sets of data I am trying to compile some reports from. I detail cars and have kept reports of everything I've done and which buildings I've gone to in order to service vehicles.
I have css sheets with the following data:
Customer Vehicle Type
Customer Service Purchased
Date Customer Requested Service
Size of the buildings of my customers (sq. ft.)
Vacancy Rate of the aforementioned builds (sq. ft)
Average Salary of workers in each building
Weather csv sheet for the area I work in for each day I've been working
Each Supply Used
How much of each supply is used per vehicle (on average)
What I'm trying to do is take the above csv sheets, upload them into Stata and create a .Do file that will analyze:
1. Qty of sales per day for product
2. Building Size correlation to services rendered
3. Correlation between Weather and services rendered
4. Salary of building occupants and services rendered
I would like to be able to build a model where I can input:
1. Building Size
2. Building Avg. Salary
3. Building Vacancy
and get an output of:
1. Expected Revenue
2. Expected amount of services to be rendered
3. Expected amount of supplies to be used
If you could create a .do file (and comment out between regressions, etc. what it is you were looking for) and a .dta file so I can run different variables in it in the future, etc. I would appreciate it.
Let me know a time you are free to discuss.