• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Quick excel/math question

F

Fiveohhh

Diamond Member
I'm trying to figure out the formula for a project at work. I have about 100 poins in excel with a graph of those points and I'm wondering if there is a way to get the formula to have 2 variables so I can find the slope of the line. Basically the line risessharply and the falls very lightly for a few points, and than raises gradually consistantly and I wnat to be able to find the slope for the gradual rise. is there a way to setup excel so that the user can just look at the graph, Get a point, enter the row where the line starts its consistant rise, and where it ends, and enter them and a cell and apply the slope formula to whichever points those may be? Thanks, and sorry if its hard to understand, but its kinda tricky to explain.

Ideally it would be awesome if I could click two points on the graph and have it tell me the slope of those two points...
 
Sure. Right click the line graph in Excel, click add trendline. Then you can click various tabs to make it display the equation in a linear, quadratic or expn form among others.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top