What is the approach to solve such a question, given that I need to simply analyze a dataset and express findings I find?
Problem:
I am given a dataset of everyday revenue for three children companies of ABC for the period of January 1, 2014 to March 31, 2014.
I am also given revenue and profit for the three children companies for last five quarters of the above period, i.e Q4 2012, Q1 2013, Q2 2013, Q3 2013, and Q4 2013.
My aim is: Based on the everyday revenue data for the period of January 1, 2014 to March 31, 2014 (Q1 2014) and the historical data (revenue and profit) to come up with an estimate for the profit that ABC will report as their Q1 2014 profit.
How should I approach this problem?