trend

Hi all! I would like to know if there is a way to set a coefficient in the trendline equation to zero. For example: The equation of the second order trendline is Ax^2 + Bx + C I want to find a way to set B = 0 I know it's possible to set C = 0 by setting the intercept, so I was wondering if...

Hello, I have my forecast for each month in 2014 of my budget. I want to forecast how many tickets I will be able to produce with that budget amount. I have the historical data from 2013 to use. I want to forecast how many tickets I will have February 2014 - December 2014. Is there any way to...

Hi all, =TREND(known_y's,known_x's,new_x's,const) I am trying to use the TREND function to return a value for a certain x (in this case 10). The known y's come from column A and known_x's from column B. However, I only want to get the trend for functions for values greater than 0 in row C. I...

Hello, I'm dealing with the following problem. Say I have a set af values: A B 1 567 2 546 3 567 4 554 5 572 6 543 I can easily determine the average of the values in column B (=AVERAGE(B1:B6)) But I also want to know if the average is increasing or decreasing without making a chart and...

Hi I need to create a metric which compares Courses run, and the impact of changing the Course duration, or the Maximum number of students allowed on each course.... In some cases the Duration or Max number changes... In other cases both could change.... I just can't think of the most suitable...

I want to develop a formula that will either predict, forecast, trend, etc. that will provide me with the mostly likely number that will be next in the sequence below (from bottom up) and will display in A1. For example, <tbody> A B 1 2 6 3 3 4 14 5 15 6 1 7 2 8 5...

I have a table of numbers with totals and am currently trying to graph them with a trendline. The table is for totals at the end of each month plus the last 2 months of the prior year. My trendline picks up the zero values that are currently being summed for the months that have yet to be...

HI, I am trying to create a formula or a way to evaluate two curves, say curve1 and curve 2. These two curves are on different scales. They tend to follow each other. However they "cross over" each other at certain intervals. Question: Is there a way(formula) to flag the "belly" going to...

Hi All I have the following data from a worksheet detailing an individuals performance over time. 23MAY 30MAY 6JUN 13JUN 20JUN 27JUN 4JUL 11JUL 18JUL 25JUL 01AUG 86.25 67.05 85.53 57.87 83.67 64.94 92.84 117.71 - 70.25 90.31 08AUG 15AUG 84.84 88.05 I know how to use a chart...

Hello, I'm trying to predict the dollar amount of new loans that my office will book over the next year. I have 10 years of historical data to build from. I started with a trendline forecast which shows what I already know, we're growing positively. Unfortunately, it doesn't accurately...

Hello experts! I need your help with calculating the parameters of biexponential (two term exponent) fit of my data. Or in other words, getting the parameters of a biexponential trendline of my data, known to be following this equation: y= A1*e^(b1*x) + A2*e^(b2*x) I am more interested in...

Hi everyone, It's been a while since I was last on this form, the last time someone helped me pretty quickly so I thought that I'd give it another try. What am I trying to do? I run a Fantasy Football competition I using Excel to collate all of the stats and results. I'm wanting to create a...

i have a couple columns and want to use the Trend Function in excel but that data contains the error #Div/0. is there an easy way to get around this error. =TREND($A$1:$A$10,$B$1:$C$10,B1:C1,TRUE) in column B there is an error div/0 any help is greatly appreciated. Thank you

Hi Everyone, I have tried to recreate a graph given to me on paper by taking a few points and ploting them in excel. I now want to find a function to return the Y value for a given X in the range of the graph. I have tried using the trend function but the regression line does not come close...

I have 3 columns of data Month Sales YTD Jan08 $135500 135500 Feb08 $144999 280499 Mar08 $186700 467199 Apr08 $176000 643199 May08 ... . . . Dec 09 ?? I using Trend function to show a trend for YTD dollars and I know how to do that. My issue is for all of 2009 is my...

Hey, I have a chart with two sets of values: one in stacked column, the other a trend line that displays values over time. The date on horizontal (x) axis goes beyond the most recent data point I have for the trend line but I wish to include it in the chart anyway. The problem is that...

I have a question regarding the excel trend line and he equation it provides. I have a temperature vs viscosity graph and I have added a eponential trend loine and displayed the equation. I have used that equation to calculate actual readings vs where they should fall on my graph. The...

Hi all, If a formula requires contiguous cells as part of the argument is there some way of creating a contiguous range from non-contiguous cells without moving data? For example, if I have data in A1, C1 and E1 and would like to use the values to calculate the trend going forward how can I...