slope

Hi, I'm using linest to obtain the slope of a series of data. My data is three colums of X, Y and 'category'. e.g. X Y 'category 1' X Y 'category 1' X Y 'category 2' X Y 'category 3' X Y 'category 3' X Y 'category 2' ect. ect. What I'm trying to do is look up the specific categories X...

Hi, How can we make Excel automatically calculate the maximum slope in the following type of data, please? For example, the max earning per hour (or the Max slope) in the following data is $20/hour. Note: the earnings per hour change every day. <tbody> Time (h) Total Earning ($) 0 0 1 10...

Hi All, Need your kind support, KPI Weight = 15% Measure = <95% = 0% | = 98% = 12% | >99% = 15% Score = 96% = ?? Thanks in advance.

I have a set of data to which I've fit a trendline on my chart. I'm currently using the option to calculate the line with a custom intercept (0), and for the graphing tool this works fine. However, I need to report that slope for some other calculations in my spreadsheet and I would a way to...

Hi, i would like to calculate a slope, being the x values in Column A and y values in Columns B,C,D.. below is an example with only columns A and B. I would like the function SLOPE to pick up the y values in columns B,C,D.. (which means to pick up the range of cells that is not blank) and to...

Hello, I am trying to use one array formula to recreate the following linear regression formula: Y = (SalesRatio-MedianSalesRatio)/MedianSalesRatio X = LN(((EMV/MedianSalesRatio)⁄(2))+ (SalePrice⁄(2)))/LN(2) Here is my data: <tbody> <tbody> SalePrice </tbody> <tbody>...

Dear everyone, I'm happy to find this forum, this is my first posting. (1) I would like to calculate the slope from multiple sets of data. Since the curves are rather complex, I'd like to be able to easily define the start and end of the "linear region" for which the slopes will be calculated...

Hey guys, This is my first post on the forum and I'm hoping to get some of the same help others have received. I am running a spreadsheet on excel for a daily fantasy basketball algorithm and so far I have succeeded in developing efficient macros to grab particular player data from a number of...

Hi there I have a huge number of rows with sales data. I want to use the slope formula to determine the trend. However the sales data is full of gaps like this example. <tbody> 3 4 5 8 0 2 8 N/A 5 8 1 9 7 1 5 N/A 8 7 3 8 9 3 8 9 5 3 1 N/A N/A 3 1 6 9 2 N/A </tbody> Since the data...

I have a large time-series array, say, Array (1 to 5000, 1 to 20). Column 1 has an index number starting at 1, column 2 has the incrementing date. Column 10 has a data series and Column 11 has the natural log LN() of Column 10. For each row (ignoring the first few rows where I test for...

I need to identify the beginning of a period of constant slope in a set of data - Any general suggestions for where to start or any specific ideas are welcome. Thanks everyone. I have a set of data that can be represented as a curve. The X axis is time and The Y axis is weight. What always...

I am using Excel to calculate thresholds for slope. X's are the number of a day. Y's are the price of a stock at the close of the day. Here is my Array: X's Y's 3 68.82 2 70.12 1 69.40 The 3 day Slope of this array is -0.29 using the SLOPE function. Now I want to...

I hope that you will be able to help me with this, I'm unable to get the HTML maker past the company firewall so I'll try to describe my problem as simply as I can. I have two column of data that I have charted. Column A contains the x axis values from 1 to 100, Column B contains the vaules for...

Hello fellow Excel users (especially engineer or scientist types), I've been asked to have MS Excel do calculations done manually so far. An instrument takes readings (absorbance) over time. Typically, for a sample, the absorbance goes up, peaks after about 3 minutes and then comes down, then...

I am trying to modify a spreadsheet so that we can plug the slope off of a log regression equation into a formula, however, I cannot figure out how excel is calculating slope. The given formula is y=-0.098ln(x)-0.3401. My max and min data points are (69,0.375758) and (585,0.157576) and the...

I am trying to calculate slope manually and match the number that is being output using Excel's Slope Formula. I cannot get them to match. Check out the sheet below. Any ideas? <TABLE style="WIDTH: 814pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1086><COLGROUP><COL...

Hey all Excel geniuses, This is actually my FIRST forum post ever ! yep yep gety yep... I'm officially a web geek ! yeee haaww...:eeek: let's imagine I have : 1) average price per year:2006=$200; 2007=$210; 2008=$215;2009=$210 2) # of units sold per year...