how to get an equation from trendline excel

Select an appropriate weight variable (GNI, population, GDP, exports, imports, labor force or land area) from the Weight Indicator box, as shown above. No aggregate is shown if countries with missing data represent more than one third of the total population of your custom group. Weighted Mean 66POP: Aggregates are calculated as weighted averages of available data for each time period. Select an appropriate weight variable (GNI, population, GDP, exports, imports, labor force or land area) from the Weight Indicator box, as shown above.ġ1. No aggregate is shown if missing data account for more than one third of the observations in the series. Weighted Mean 66: Aggregates are calculated as weighted averages of available data for each time period. Select an appropriate weight variable (GNI, population, GDP, exports, imports, labor force or land area) from the Weight Indicator box, as shown above.ġ0. Weighted Mean: Aggregates are calculated as weighted averages of available data for each time period. Sums are not shown if more than one third of the observations in the series are missing.ĩ. Sum 66: Aggregates are calculated as the sum of available data for each time period.

Sum: Aggregates are calculated as the sum of available data for each time period.Ĩ. Min: Aggregates are set to the lowest available value for each time period.ħ. Values are not computed if more than a third of the observations in the series are missing.Ħ.

Median 66: Aggregates are calculated as the median of available data for each time period. Median: Aggregates are calculated as the median of available data for each time period.ĥ. Values are not shown if more than one third of the observations in the series are missing.Ĥ. Mean 66: Aggregates are calculated as the average of available data for each time period. Mean: Aggregates are calculated as the average of available data for each time period.ģ. Max: Aggregates are set to the highest available value for each time period.Ģ.

How to get an equation from trendline excel