I need an eqn for a graph. I think the linest eqn might help. How does one do this. thanks
2007-03-11 07:33:28 · 2 answers · asked by The Ghetto David Hume 3 in Computers & Internet ➔ Software
not sure what you mean but if you create a line graph in excel
right click on the line in the graph
select trendline
select options
select the radio button that says show formula
The formula for the trendline is shown
2007-03-11 07:44:02 · answer #1 · answered by cool_clearwater 6 · 0⤊ 0⤋
hi i'm sorry, for this reason of actuality i'm undesirable in English language. you ought to apply a formulation with SUM, MIN & COUNTA as an social amassing: in case you place the grades interior the cells A2:E2 (for 5 assessments) and the prevalent interior the cellular F2 using this formulation =(SUM(A2:E2)-MIN(A2:E2))/(COUNTA(A2:E2..... I surpassed over the minimum attempt fee from the sum and surpassed over its cellular from the selection of the cells. Now in case you duplicate the cellular F2 to the cellular G2, Excel will regulate it to the recent concern. After so you might apply the cellular F2 for 6th attempt. in case you pick you are able to placed the astounding steps in a macro. good fulfillment
2016-12-18 10:54:24 · answer #2 · answered by ? 4 · 0⤊ 0⤋