Hi,
I have been asked to find trends amongst the data in the excel spreadsheet that i have attached. does anybody have an idea about the best way to find trends or which graphs would be best to use here?
The product allowance is the number of products allowed per month.
many thanks
g
Excel offers a couple of ways to find trends. But you need to have some idea what are the independent variables and what is the dependent variable.
Often trends are values over time, like weekly sales revenue. You can test for trends over time, and even things like seasonal variation. Even a rolling average is a simple kind of trending tool. But you do not have any date information. I don't know what you are trying to correlate. Are you trying to establish a relationship between billing amount and contract duration? (I'm afraid that despite your description I still don't understand what "product allowance" is.)
Maybe if you explain your business situation a little more someone can offer more specific advice.
A simple linear regression is very straightforward to do by the Data Analysis Toolpak linear regression, or with the TREND or LINEST functions. First you have to establish what data you want to trend, though.
This will give you an idea that each year the start and end of the ocntract yeilds the most income but i think as the last poster said you need a lot more infoo to make a better presentation
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
thank you for your replies.
i think the reason i am struggling with this is due to the lack of information here. to clarify, the product allowance is the amount of products that the customer (which is referred to by the contract ID number) takes per month. i think i need to show something that shows a correlation between customers who take large amounts of products a month and those who just take 1 or 2.
any ideas?!
thank you
There is still not enough information here. For example, you have 36 customers with a billing amount of 590 but those customers have a huge range of product allowance. How can the billing amount be the same if they are buying 1 product or 50 products?
To get you started, here is a chart that does a linear regression correlating product allowance to billing amount. The regression is shown on a scatter graph. The R squared value is 0.3297. This value tells you the strength of the correlation. It is 0 for no correlation and 1.0 for absolute correlation, so the correlation in your case is on the weak side.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks