trend

Hi, I have a list of film titles with position rankings. A simplified example is shown below. I would like to work out what the "general trend" (sorry to be vague) is for a given title's position rankings, i.e. whether a film generally "improves" (or "worsens") over time. Just to get an idea of...

I have numerous x/y series that aren't regularly sampled, I need to create an average of these series on a regularly sampled output. Here's the beginning of 3 example series: x1 y1 x2 y2 x3 y3 2.055 1542.36 1.013 1540.924 1.185 1541.119 3.077 1542.382 2.028 1540.778 2.002 1541.082 4...

Help me please. I would like to know the possible probability, forecast, and trend. If you are given 2 possible outcome with atleast 1-60 given outcomes. For insctance, if you have 100 ballpens, and the only colors are BLUE and RED. then you want to know the possible color you would pick next...

Hi All, could someone please help me figure out how to make a dynamic trend formula in a following way: I calculated YTD trend as but would like the Trend formula to automatically take into account the following month once I update the source table with September Actuals so that the trend for...

Hi folks, I am trying to do a calibration curve and have strange results from the trendline. It appears to be giving me a trend that beggars belief! Just looking at the X and Y axes, it seems apparent that the relationship given is not likely at all. Can you advise on where I'm going wrong...

I have 3 charts in a worksheet. All of the charts share the same x axis. I would like to a trend cursor to each of the charts to clearing indicate the y value for each of the charts at the x-value the mouse pointer is located at. There are probably several parts to this question. but looking...

Please bear with this explanation as it may be lengthy but I want to be as clear as possible with my problem.. I am trying to detect with a formula the trend over the past 6 months of my data. I do not simply want to see if the data has increased from one month to the next month; rather I want...

When I enter the following data into Excel and generates af Forecast Analysis with a Polynomial Trendline (Order 2) Excel shows an almost perfect trendline in the diagram. But when I choose Display equation on chart, it comes up with a Trend formula that has nothing to do with reality. This is...

Hi, I am wanting to be able o se the values behind a trend line I am using on one of my graphs I can get this to work for order #3 using a formula I found on one of these forums, however when I try and adapt it to work for order #4 the results it give me are different to the trend line

Hi - I want to be able to describe the trend (+, - or flat) of a series of %'s over time, but the =slope function returns very large numbers (e.g. 72,932) - what is the best way to interpret? Dataset: Known Ys: Jan 18 - Apr 19 dates Example Known Xs: <tbody> 8.17% 8.26% 8.33% 8.45%...

Hello, I have the attached image (left) of more than 45k data points and I want to delete all the points within a range from the trend line to have it like the one on the right side (only the points between the two red lines, deleting all other points that fall out). I can't think of a...

Hello everyone, I'm trying to calculate the "trend" in student GPAs as a value of some sort, indicating if the overall trend is negative, positive, or flat. I've done some digging but can seem to figure out what this value would even be called. Possibly r-squared when you add a trendline to a...

I have a spreadsheet which is used to add in the vacancies which are closed. As you can see there is a reference number, a date and the title of the vacancy. I want to highlight every 6th occurence of the Administrator vacancy for the records to be audited. I want all fields in the record to...

This probably sounds familiar, but I have been rifling through google and herd all day to find a solution. Here is some background information: The spreadsheet is for trend analysis on tests. You put in the class number, number of students, and what version of the test they are on(there are 3...

Hi I am trying to display trend equation on my line chart but the option is grayed out in the format trend window. Why is that? Thank you so much.

Hi folks, I have a new file a friend has been helping me with, but we are stuck on a couple parts, so I am looking for someone who can help me finish this up. Here is the file: https://drive.google.com/open?id=1OcgTWLxrenff7czHy1V3YiT_O878YTCV The "SELECT DATA RANGE" tab is a summary based...

Hi, I am looking to create some sort of formula that can throw an alert for the user if the upward trend is increasing. I need help with the algorithm For example, Months Jan, Feb, Mar, Apr, May, Jun Values 1024, 1130, 1250, 1375, 1425, 1250 Displaying this in a chart you could say the cost...

I currently have a trend line with the following trend line equation, y=-0.0131x+580.53. I am trying to determine the start and end points of the trend line. I have 19 data points please let me know if sharing the data points would be helpful or are they relevant considering I am addressing the...

I have a graph with a trend line and am wondering how can I determine what the start and end points of the trend line are?

Hello folks, I was wondering if someone is able to help me with code for identifying and summarizing trends based on frequency data. I have been working on this file for a while with the help of somebody else, but he is stuck with regards to reporting the Trend based on data selected. In the...