Used as a real-time and time-based data analysis.Trend analysis helps determine that the company is achieving their planned goals, so that management can compare that margin wise sales have reached up or down by performing this trend analysis.In project management, trend analysis is a mathematical technique that uses present data to predict future outcome.It is also used in Investment concern to predict the future shares.Trend analysis is mainly important in the business, financial, FMCG and other companies to predict future trending sales.FMCG Company can create a trend line of historical sales, and this information can be used to predict the future changes that will be happening in the sales.In a Business analysis, trend function can be used to analyze revenue, cost, and investment.
Use the growth function as explained above using CTRL+SHIFT+ENTER we will get a growth value figure with another line chart which is shown below in grey color. Now, this sales data shows only the trend figure with orange line show linear values, and the graph will be more dynamic if we put the month-wise growth value. So we get the line chart graph as given below where it shows very clearly sales data month wise. To view in graphical chart format, choose insert and select the line chart format. We are going to using the trend function here to get the result, select the column D41 to D56 and use the trend function as per below.Īfter selection, we use the Trend function by selecting C41: C56 and then we have to use CTRL+SHIFT ENTER to get the entire trend value shown below.
0 kommentar(er)
