how to get equation of trendline in excel

In this case, the seasonal fluctuation is about 30 cm (300 mm). You could even calculate the average seasonal range of sea level from your dataset because you now have the data.This suggests Panama experiences a persistent seasonal sea level change. Looking at our dataset (Figure 4.51 above), it looks like there are annual highs and lows where tides are high for about 8 months (May-December) every year, and are relatively low for 4 months (January-April).In the dataset example used here, remember, we are looking at monthly averages, so the data we downloaded is the 30-day average for each month therefore all tides in a given month are averaged to a single value.In fact you may see trends and patterns that we discussed throughout the module. You will begin to see patterns or trends in the data. At this point, it is a good idea to look at the data and see what is going on with tides.Still need help? Go to Microsoft Community. In the Decimal places box, increase the number of decimal places to 30 so that you can see all the decimal places.Select the Number tab, and then select Number in the Category list.

On the Format menu, click Selected Data Labels.In the chart, select the trendline equation.To work around this behavior, increase the digits in the trendline equation by increasing the number of decimal places that are displayed. This can cause a trend to appear to be incorrect. However, the accuracy of the chart is significantly reduced. This behavior allows the equation to occupy less space in the chart area. For appearance, each X value is rounded off to the number of significant digits that are displayed in the chart. Microsoft Excel plots trendlines incorrectly because the displayed equation may provide inaccurate results when you manually enter X values. Therefore, the trendline will be inaccurate if it is displayed on these types of charts. In these chart types, the X axis is plotted as only a linear series, regardless of what the labels actually are. Line, Column, and Bar charts plot only the Y axis as values. This chart plots both the X axis and Y axis as values. The trendline formula is used for an XY Scatter chart.

How to get equation of trendline in excel