• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sales performance vs Weather (best way to analyse and display)

M

mrzoogle

Member
Hi Excel Gurus,


Hope you all are doing great. I know I haven't been very active on chandoo recently and it is due to various shifts in my occupation which required me to focus on other subjects rather than on excel and data analysis. My apologies for this :)


I was doing this analysis and came up with the idea to compare the sales data to the weather to see if it is affecting the sales performance somehow.

I did try charting the data but I am sure there are better way to display and analyse this sort of issue.

Are there anyway where we can see if there are any correlation between these two sets of data?

I have attached the spreadsheet with this post for your reference. http://www.mediafire.com/view/?47iy1gl7khk0z38

I was hoping if you could point me to the right direction, thanks for your time.


Kind Regards,

Z.
 
Hi ,


Excel is not going to show any relationships if there aren't any ; is your product such that its sales can be affected by the weather ?


Secondly , weather is a long-term phenomenon , and you need to track sales performance over at least a full year or even more before you can draw any conclusions. Within the period that you have tracked , the temperature has varied by around 20 degrees Celsius , which may or may not be sufficient to affect sales.


Narayan
 
Hi NARAYANK991,


Thanks for getting back on me this.

I have a hypothesis that if the weather is bad, people are going to buy to more of our products. We have actually seen this happening but I want to prove this by doing an analysis to see if this is really happening.

I could as for a year worth of data but I need to propose how I am going to approach with this analysis. If they think there is a strong relationship I will get more data and will be able to do year worth of analysis as you've said.

What I am bit confused is how to approach this analysis, doing just the chart ain't going to show any relationship is it not?

Hope to hear from you soon.


Kind Regards,

Z.
 
Hi ,


Can we have some kind of a quadrant chart as shown here ?


http://www.analyticshero.com/2012/09/11/how-to-use-scatterplot-quadrant-analysis-with-your-web-analytics-data/


You need to establish the thresholds :


Below Normal Sales , Normal Sales , Above Normal Sales


Below Normal Temperature , Normal Temperature , Above Normal Temperature


In a scatter chart , the dense packing of data points will establish the relationship , especially if you have one or more clusters.


Narayan
 
Hi NARAYAN,


Thanks for the link, I am going to try as you've mentioned and will let you know how it goes.

Please do let me know if you think there's any more approaches :)


Kind Regards,

Z.
 
You must log in or register to reply here.
Back
Top