I am going to do my best to explain what I need here but I am really very novice with Excel. I have hunted the internet and this fabulous forum for answers but I am just not quite getting there. You see I have been tasked with finding the delta between highs and lows in some data I have. The data represents online messages over a particular period and a sentiment assignment. I can graph the volume and positive/negative/neutral sentiment (see attached) but what I am trying to do is ascertain what the actual magnitude is between peaks and dips so I can determine what are the really important changes comparatively. Essentially I am trying to identify which are the 'big enough' jumps to be of importance. Does that make any sense? Ugh.
I have hourly totals, ratios, and change for each type of data: positive/negative/neutral.
Ok, so the only response I have received is to tell me I titled my post badly. Sorry about that but I am not totally sure how to ask the question I am trying to ask. It is so frustrating to not have community help local to me. I appreciate that forums like this exist and I will keep looking for an answer - there has to be one out there!
Bookmarks