trendline

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

Hello all, Iam student and for a lab test I need to solve about 450 excel sheets for my project. The spreadsheet has X and Y data and curve is plotted. I need to split the curves into 3 parts based on major slope change and fit a trendline. I can do it manually but I need an excel Macro which...

How do i find trend lines using two year moving when two sets of arrays are given

I have this formula: =EXP(INDEX(LINEST(LN($P$9:$P$14),$C$9:$C$14),1,2))*EXP(1)^(INDEX(LINEST(LN($P$9:$P$14),$C$9:$C$14),1)*C9) I am essentially calculating the value at specific points on an exponential trendline. I want it to ONLY calculate this equation when there are values in cells P9:P14...

I have managed to extract the trendline from a graph to a cell and now wish to input different values of x so I am able to plot more points. The values of x are already in a range of cells. I have managed to reduce the formula down to: 1.81ln*(x)+1.6161 to hopefully make it easier. I have...

Hello, I have a column graph with two data sets. Let's say Row 1 represent a month value JAN-JUN. Row two has columns A:F populated with values ranging from 1-10. Row three only has values in columns D:F. When the select data I must include columns A:F for row three or the graph will left...

Ok so I have this problem and its doing my head in. Basic set up: One one sheet I have a pivot table with bulk data, on another sheet I have 3 XY charts that run off the pivot table. I have one subroutine that manipulates a pivot table based on a comboBox selection. It basically turns on/off...

Hoping someone can help. I am using line graphs and trend lines to understand some performance targets of staff in my call centres. I am able to format a trendline to show the formula of the trendline. However I am looking to state this in a cell, so I can then state Agent A scores X, therefore...

I use trend function just write =trend(A1:A20) enter and I got the linear trend, my question, if I want the polynomial trend, what I have to write? =what?.

I have a scatter plot of X and Y data points. Each point is made up of some number of items. How can I weight the points so that the trendline doesn't count a point that is made up of 10 items the same as it counts a point that is made up of 100 items? An example of my data: X .... Y ...

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

I have some data sets I wish to create equations based on (3rd and 4th degree poly for good fit) but can't figure out how. I've tried the solutions suggested here: http://www.mrexcel.com/forum/showthread.php?t=396162&highlight=trendline+coefficients...

Hello, This is my first post. I found an article on Microsoft Office Online from MrExcel about calculating a forecast for Sales based on historical data. I tried this LINEST formula by selecting two cells side by side and entering the =linest(c2:c35) etc. This formula does not seem to work for...

Does anybody know if it is possible to get Excel to calculate a logarithmic trendline in a chart using base 10 and not base e?

Hi all-- I have multiple data sets, each which fit a power curve very well. Each dataset has 30 days worth of data If I graph the data and add a power trendline, I'm able to see an equation on the chart and get a sense for where the data will be at 100 days. How can I accomplish the same...

For a data correlation, I have added a trendline to the plotted data with R2, and also used the linest function on the same data. The two R2 values match when there is an intercept, but when the correlation is forced through the origin the R2 values differ by up to 2%. Any ideas why this is...

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...

Hi, all I'm trying to use Excel to create a trendline for data that approximates a shifted-power law equation, of the form y=a*(x-b)^c. The built-in formulae in Excel 2007 aren't able to give adequate results, so I would really like to find a method within Excel of obtaining the coefficients...

I have a table with 4 consecutive years and corresponding values for expenses - it does not get simpler than that.... When I ask for a trendline, the line shows up in the legend, but not on the chart. Selecting the markers does not enable 'clear trendline'. In a 'select all', it does not show...

Hey all, I'm a newbie here, desparately looking for some help. My boss at work wants me to use the chart function on some excel files to make line charts in Excel 2000. My problems begin with the format of the information, and don't end there. The information is spread out among this little...