Sentences with phrase «calculate the moving trends»

Excel's slope function was used to calculate the moving trends for each time span (by month) and to plot them.

Not exact matches

A worksheet on moving averages allowing pupils to calculate moving averages and to plot them to enable trends to be discovered.

This activity explores time - series data and shows how calculating and plotting moving averages can help to iron out fluctuations and spot trends.

A powerpoint and worksheet to revise seasonal products and averages, then learn how to calculate 4 - point moving averages, use them to plot a trend line and predict future values.

Note: Excel used to calculate the 3 - year absolute temperature and CO2 level averages; also used to calculate the moving 36 - month and 360 - month per century acceleration / deceleration trends (Excel slope function) as depicted on chart; the absolute temps calculated using the HadCRUT4 month anomalies and NOAA's monthly global mean temperature estimates; and, the 3 - year average beginning value for CO2 was offset to a zero starting place.

Dataset used in Excel to calculate moving 5 - year, 8 - year, 10 - year and 15 - year per century trends (ie, slopes), chart column bars and line curve.

For example, changes in time of observation, adjustment for a move of a station that was previously sited next to a heat source to a better location (that now allows the station to be classed as Class 1 or 2), switch to a different temperature measurement device or system, etcetera, could explain why smaller classes of raw data don't track well with the overall trend calculated from homogenized station trend data.

Notes: Excel was used to calculate and plot the moving sea level per century curves and fitted trends (Excel slope function produced trends based on moving 360 - month periods for each month in the dataset; then converted to per century trends (inches) for each month).

Excel was used to plot chart and calculate all figures, including the linear trends and 3 - year moving averages.

Excel was used to calculate and plot the multiple rolling / moving LT temperature trends and monthly CO2 cumulative totals.