how to insert a trendline equation in excel for mac

Insert A Trendline Equation In Excel Series Makes Your
Insert A Trendline Equation In Excel Mac Offers Real

Insert A Trendline Equation In Excel Mac Offers Real

Excel 2011 for Mac offers real power in its chart-analysis tools, but using them requires some knowledge of the math behind the features.

Insert A Trendline Equation In Excel Series Makes Your

Using a single data series makes your chart much easier to understand.

To add a trendline, choose the Trendline option from the Chart Layout tab of the Ribbon.

This brings up the Trendline gallery with options to choose from.

In the Chart Layout tabs Analysis group, choose LinesHigh-Low Lines to add these.

On the Ribbons Chart Layout tab, go to the Analysis group and click UpDown Bars to turn these on or off.

Double-click one of the bars to display the Format Up Bars dialog, where you can customize these bars.

You can specify custom error values by clicking the Specify Value button and choosing cells.

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

With thorough knowledge and experience in technological fields such as computer software, hardware, the internet and programming, he creates online content for various websites.

The slope of the tangent line reveals how steep the graph is rising or falling at that point.

This type of information can be utilized on a business graph to highlight the rate at which important data, such as profits, are rising during a certain period.

You can approximate a tangent line in Microsoft Excel 2010 by adding a trendline to your graph.

Step 2 Create a column containing the X values for your graph.

Its helpful to include multiple X values close to the point for which youre calculating the tangent line.

For example, enter values of 0, 0.999, 1, 1.001, 2, 3, 4 and 5 in the cells A1 through A8.

The X values of 0.999 and 1.001 will assist in calculating the tangent line for an X value of 1.

Step 3 Create a column containing the Y values for your graph.

If youre using a formula, such as y 5 sqrt(x), enter 5sqrt(A1) into cell B1, then copy and paste cell B1 to cells B2 through B8.

Copying is done by clicking cell B1, pressing the CtrlC keys to copy, click and dragging cells B2 through B8, then pressing CtrlV to paste.

Step 4 Draw a graph for your data by click and dragging the cells containing the X and Y values closest to the point for which you want to calculate the tangent.

Click the Insert tab on the Excel ribbon, click the Scatter drop-down menu from the Charts group and select the Scatter with only Markers option.

Step 5 Draw a trend line for your graph by right-clicking a point on the graph and selecting Add Trendline.

Select Linear, click the box for Display Equation on chart and click Close.

This trend line is an approximation for the actual tangent line.

The equation for the trendline is displayed on the graph using the y mx b format.

Using the previous example, this gives the approximate equation for the tangent line as y 0.5x 2.5.

References Microsoft: Add, Change or Remove a Trendline in a Chart Microsoft: Excel Statistical Functions - SLOPE Microsoft: Create a Chart Tips Mathematically calculate the tangent line with Excels SLOPE(knownys,knownxs) function.

The knownys and knownxs should be the range of cells with Y and X values closest to the point for which youre calculating the tangent line.

The equation for the tangent line is y - Y dydx (X) (x - X).

The variable dydx is the result of the SLOPE function, representing the slope of the tangent line.

Using the previous example at the point (1,3), this gives an equation for the tangent line of y - 3 0.5 1 (x - 1), which simplifies to y 0.5x 2.5.

Warnings Information in this article applies to Microsoft Excel 2010.

It may vary slightly or significantly with other versions or products.

How To Insert A Trendline Equation In Excel For Mac