Formatting Excel Data for Panel Data Regressions
- or -
Post a project like this1784
$27/hr
- Posted:
- Proposals: 16
- Remote
- #2401606
- PRE-FUNDED
- Completed
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing
Islamabad
IT Consultant |Virtual Assistant| graphics| | Website design | social media management .
Nairobi
19919998838331114128141971120989662400510251083325224802589170271293227270022731208
Description
Experience Level: Expert
I am working on a project and need to stitch together and format data for panel data regression analysis. I am currently unsure whether I'll use this as an attempt to learn R, but otherwise plan to use SPSS or Stata. The data is currently a bit of a mess with some being monthly and other data being annually for approximately 122 entities. Additionally, one or two new variables will need to be created. Most of the data has been pulled from SNL, but some is my own data.
I need someone to create new variables and aggregate the data into an annual format that will allow for an unbalanced panel data regression analysis. Based on my understanding, the following tasks would need to be completed:
1. Convert monthly data into annual data (the "New Data")
2. Convert existing variables into new variables (e.g., annual NOI into annual NOI growth)
3. Match existing annual data to the New Data
4. Format so that panel data regression analysis can be conducted
If you are interested, please provide an estimated turnaround time and cost. Thank you for your time.
I need someone to create new variables and aggregate the data into an annual format that will allow for an unbalanced panel data regression analysis. Based on my understanding, the following tasks would need to be completed:
1. Convert monthly data into annual data (the "New Data")
2. Convert existing variables into new variables (e.g., annual NOI into annual NOI growth)
3. Match existing annual data to the New Data
4. Format so that panel data regression analysis can be conducted
If you are interested, please provide an estimated turnaround time and cost. Thank you for your time.
Marc J.
100% (4)Projects Completed
3
Freelancers worked with
3
Projects awarded
43%
Last project
3 Jun 2019
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hey Marc, can you share your file? It would help us help you better.
807245
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies