Like Day Regression Model

**Alexmedft** · 08-02-2023, 09:52 AM

I have a small set of data points and I am trying to find the top 3 days in history that are the closest to the forecast. My two data points are load and wind. Either return the days that best match the hourly pattern or use the average in AD7 and AD8 to find the best matches. I am using Microsoft 365.

Thank you

**HansDouwe** · 08-02-2023, 10:48 AM

Assuming the best match is when the sum of the percent deviations squared is as small as possible try this formula and copy to the right

Formula:

Please Login or Register  to view this content.

**Alexmedft** · 08-02-2023, 12:18 PM

This formula works perfect thank you. How would I incorporate this formula to find the 2nd and 3rd best like days?

**HansDouwe** · 08-02-2023, 12:25 PM

Thanks for the feedback and rep

, Glad to have helped.

For three days, please try in C9 and copy to right (not down!):

Formula:

Please Login or Register  to view this content.

**Alexmedft** · 08-02-2023, 12:30 PM

Thank you, you have helped me.

Like Day Regression Model

LinkBack

Thread Tools

Rate This Thread

Display

Like Day Regression Model

Re: Like Day Regression Model

Re: Like Day Regression Model

Re: Like Day Regression Model

Re: Like Day Regression Model

Thread Information

Users Browsing this Thread

Similar Threads

Multi Regression Model

Macro for VBA button that refreshes a regression model

Help building a regression model

Help building a regression model

Help building a regression model

Regression Forecasting Model

Regression Model in Excel.

Bookmarks

Bookmarks

Posting Permissions