trend analysis

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...

Hello Everyone, Can you please help me make a trend chart to determine if our sales of units in this time span is trending up or down. Thank you.

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 am attempting to trend data without using a graph. The data would look something like this: Week Revenue 1 $90,934.15 2 $143,314.75 3 $134,522.00 4 $202,343.00 5 $177,218.00 6 $132,985.75 7 $113,291.00 8 $62,821.00 9 $151,983.00 10 $161,214.80 11 $142,278.45 12...

Hello everyone, hope you'll be able to help me I have everyday sales data of this month and I need to forecast daily sales till the end of this month. I have to take into consideration the ongoing trend and also the history sales of the same month of previous year. The solution has to be...

Hello Everybody, I need to format some raw data for a trend report as following: The raw data is extracted from a ticketing system and I need to assign a Category/Topic and a Subcategory to each ticket by using the text present in the "Short description" tab. I defined two names as "keywords"...

My sheet is simple: A1: data volumn, a big int like: 19981573933 B1: partition day, a small int like 365, every day has certain amount of data to be processed, total add up to A1 A2: starting date time (could be only time part, like 16:05) B2: 0 (meaning at the starting point processed days is...

Hi :) I am working on a project to forecast monthly change of inflation rate. I used SLR but the forecast doesnt seem to be correct. Could someone take a look please? :confused: I am also not sure how to diagnose time series (stationarity, trend, ARMA..) in Excel( is this even possible?) I...

I have a data set that includes Column1 (Dates, week-to-week starting on Mondays), Column2 (product by SKU), Columns3 (product status, active... this will eventually be left out as soon as I finish the VBA to permit a list to be built allowing only active products to be selected in the data...

I'm trying to trend out some numbers. I have two sets of numbers: The first we can call a "local" projection and the second we can call a "national" projection. For the national projection I know all 3 numbers: Low, Medium, High For the local projection I know only 1 number: Low I would...

Hi there - Haven't been able to find an answer to this exact question, and am not able to get nestedIFs to work. In short, I'm doing a trend analysis based on ranks that looks like the below: Jan | Feb | Mar | Apr | TREND 2 | 5 | 6 | 8 | GROWING 3 | 1 | 7 | 3 | NO TREND 4 | 2 | 8 | 7 | NO...

Hi, I'm new to the board hoping for some friendly insight.. I'm trying to find a means to calculate a probability of default trend line over a certain period using the TREND function in Excel 10. My issue is the probability figure cannot be less than zero, however I'm not sure how to configure...

Hi, I'm looking to apply conditional formatting based on the value of the adjacent cells. So using the example below, I want to highlight the figure showing for Q4 if it is 10% greater than the value in Q3. (However that figure in Q4 is a forecast in which I will be using trend function - not...

I have a small data set with Fiscal years and Sales. One of the data points is an outlier so in order to get an accurate trend line I have omitted the outlier data point. I have already created a trend line omitting the outlier. What I want to do: 1) Lock the trend line and re-plot the...

Hi Folks, Uust wonderin if anyone has come up with a way to perform trend analysis againt Nessus scan results using Excel. Thanks, Fergie

I am trying to update my Quality control charts with some basic trend analysis. I need to be able to easily track trends in Spike, blank and standard results using excel 2010. Using conditional formatting I have been able to track 7 consectutive increasing or decreasing points: =AND(O4:O9>O3:O8)...

I was given a spreadsheet that has over 50 control charts -- 1 control chart on each tab. The control charts are run against 1 set of data (on a tab called "data"). My job is to review every control chart every day to look for data points that are above or below control limits or that seem to...

Hi Hope it's OK to ask an open question, but I have problem deciding the best way to "graph" my Trends. I have Students entering the company, on different student schemes (12 in total), with Years of entry over the past 15 years. I want to be able to compare trends, which looks at pay...