Discussion


Note: Images may be inserted into your messages by uploading a file attachment (see "Manage Attachments"). Even though it doesn't appear when previewed, the image will appear at the end of your message once it is posted.
Register Latest Topics
 
 
 


Reply
  Author   Comment   Page 2 of 2      Prev   1   2
sfew

Moderator
Registered:
Posts: 823
Reply with quote  #16 
Aruns,

In response to your final question #3 above, what I mean is that "spend" can be displayed as negative values, which is what jbriggs did in his example. This is appropriate because you can think of "spend" as a reduction in funds, thus as negative values.

__________________
Stephen Few
aruns

Registered:
Posts: 22
Reply with quote  #17 
Hi all,

Following jbriggs' suggestion, I tried plotting a couple of data sets on his area graph. I found that we have certain outliers in the data and they blow up the axis range to overshadow the variation in the observations. Adding an example with real data:

Screen Shot 2016-01-20 at 5.07.05 pm.png 


DatehourCTRSpend
03/01/1600.8%164.88
03/01/1611.0%167.88
03/01/1621.1%167.7
03/01/1630.9%163.28
03/01/1641.1%161.21
03/01/1650.9%152.33
03/01/1660.8%141.41
03/01/1671.2%136.37
03/01/1681.1%134.5
03/01/1691.1%145.39
03/01/16101.0%133.08
03/01/16111.5%66.06
03/01/1612144%0.06
03/01/16134.6%22.64
03/01/16141.2%55.61
03/01/16151.1%62
03/01/16160.9%58.34
03/01/16171.0%69.19
03/01/16180.9%102.5
03/01/16191.0%133.86
03/01/16201.0%170.05
03/01/16211.0%185.39
03/01/16220.8%193.58
03/01/16231.0%190.22
04/01/1600.9%166.68
04/01/1610.9%153.74
04/01/1620.8%152.34
04/01/1630.9%158.73
04/01/1641.0%169.87
04/01/1651.0%154.76
04/01/1661.1%152.36
04/01/1671.0%139.23
04/01/1681.0%151.97
04/01/1691.0%165.02
04/01/16101.0%131.72
04/01/16111.1%59.78
04/01/161218.8%0.42
04/01/16133.4%23.37
04/01/16141.0%61.58
04/01/16151.0%71.84
04/01/16161.0%83.87
04/01/16170.9%116.89
04/01/16180.8%112.88
04/01/16190.7%117.53
04/01/16200.7%115.8
04/01/16210.6%129.17
04/01/16220.8%160.44
04/01/16230.5%173.29
05/01/1600.7%190.9
05/01/1610.7%164.11
05/01/1620.7%176.57
05/01/1630.9%203.16
05/01/1641.1%177.75
05/01/1651.0%180.19
05/01/1661.1%171.93
05/01/1671.1%154.41
05/01/1681.2%144.06
05/01/1691.7%8.87
05/01/16107.6%1.65
05/01/16117.3%0.35
05/01/161213.6%0.41
05/01/161388.9%0.05
06/01/1610.8%36.39
06/01/1620.7%121.49
06/01/1630.8%87.83
06/01/1640.6%83.26
06/01/1650.6%70.6
06/01/1660.8%103.29
06/01/1671.0%104.12
06/01/1680.9%97.74
06/01/1690.8%73.32
06/01/16101.3%46.76
06/01/16111.1%44.58
06/01/16121.4%12.67
06/01/16132.4%29.24
06/01/16141.1%15.59
06/01/16150.7%16.25
06/01/16161.1%15.65
06/01/16170.9%27.34
06/01/16181.0%44.02
06/01/16191.0%66.04
06/01/16200.8%84.45
06/01/16210.8%103.45
06/01/16220.9%99.24
06/01/16230.6%95.17
07/01/1600.8%127.8
07/01/1610.9%94.27
07/01/1620.8%89.7
07/01/1630.8%102.61
07/01/1640.7%90.29
07/01/1650.8%96.06
07/01/1660.7%116.67
07/01/1670.6%114.5
07/01/1680.9%109.29
07/01/1690.8%87.28
07/01/16100.7%75.27
07/01/16110.8%83.36
07/01/16120.7%16.46
07/01/16134.9%5.35
07/01/16140.6%20.58
07/01/16150.8%17.69
07/01/16160.6%19.33
07/01/16170.6%30.34
07/01/16180.5%73.43
07/01/16190.6%113.42
07/01/16200.6%133.1
07/01/16210.7%121.67
07/01/16220.8%112.82
07/01/16230.7%103.09
08/01/1600.8%154.63
08/01/1610.8%147.79
08/01/1620.9%91.09
08/01/1630.9%58.81
08/01/1640.7%64.5
08/01/1650.8%73.58
08/01/1660.7%79.41
08/01/1670.6%89.85
08/01/1680.6%89.53
08/01/1690.7%80.65
08/01/16100.6%69.19
08/01/16110.8%48.1
08/01/16124.4%2.05
08/01/16130.0%0
08/01/16141.1%25.59
08/01/16151.8%14.98
08/01/16161.0%14.94
08/01/16171.0%24.06
08/01/16180.7%58.82
08/01/16190.7%83.52
08/01/16200.5%101.27
08/01/16210.6%99.31
08/01/16220.6%99.93
08/01/16230.5%83.87
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.