I am trying to find any correlation between Day Ahead prices and real time prices. I tried the pearson formula but do not think I applied it correctly. For example I want a formula that looks at each day ahead hour and finds a correlation with real time outcome. IF Day Ahead Hour1 (cells b3;b61) clears over real time Hour 1 (cells h3;h61) what is the correlation. What does Hour 1 in day ahead need to be for it to clear over hour 1 in real time. I am using microsoft 365. Please see the tab labeled Sheet1.
Thnk you.
Bookmarks