'How can I set up a database with one annual dependent variable (Y) and many daily independent variables?
The dependent variable can only be measured once a year, so I have a value over 365 days. The independent variables are daily or weekly (I have data for about 10 years). My goal is to predict the value of Y (one value per year) using daily data.
I tried to do a regression with R, but did not get any significant results. For each year in the column "dependent variable" I have only one value and 364 empty cells. It is not possible to replace the 365 independent variable data with an average because each day influenced the result differently and I would not know how to assign such weights.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|