<div>
Thank you all! I will be using Tommy's suggestion of fiscal quaters if not normalizing weekly data!
</div>


Thank you all! I will be using Tommy's suggestion of fiscal quaters if not normalizing weekly data!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a set of financial data for a company for the past 3 years. The company's most profitable days in a 5-business-day week is Monday (most), Tuesday (next most)....and the Friday being the least profitable day.<br />
<br />
However, overall, this balances out (as nearly 70% of the revenues and costs get registered on Monday)<br />
<br />
Now the problem is, if a Month ends on a Friday, some of its revenues goes to Mondays and bloats next month's revenues or vice-versa.<br />
<br />
How can I create a forecasting model using historic data to see the 'true' revenue vs costs?(calculated of course)
</div>
</div>


Hi,

I have a set of financial data for a company for the past 3 years. The company's most profitable days in a 5-business-day week is Monday (most), Tuesday (next most)....and the Friday being the least profitable day.

However, overall, this balances out (as nearly 70% of the revenues and costs get registered on Monday)

Now the problem is, if a Month ends on a Friday, some of its revenues goes to Mondays and bloats next month's revenues or vice-versa.

How can I create a forecasting model using historic data to see the 'true' revenue vs costs?(calculated of course)

Data Forecasting

The Math / Science topic primarily includes discussions of mathematics, physics, statistics and economic analysis, but also biology, chemistry and other sciences.