uftree.blogg.se

Calculating autocorrelation in excel
Calculating autocorrelation in excel






calculating autocorrelation in excel

Sen’s slope analysis indicates the steepness and the extent of the increment and decrement in the pollutants.

calculating autocorrelation in excel

We have analyzed the data with software embedded within Excel called MAKESENS (Mann–Kendall test regarding trends with Sen’s slope estimates) and estimated the trends as positive (for PM (10) or negative (for NO2, PM (2.5), and O3).

calculating autocorrelation in excel

The Mann–Kendall method of Sen's Slope is used for predicting the trend of the recorded data and generalizing the magnitude as well as upward or downward regressions of the trend of each pollutant. The present study is, therefore, aimed at analyzing the readings of concentration of pollutants such as PM (10), CO, NO2, O3, and PM (2.5) over the span of 5 years (2017–2021) at UPPCB Reading Center Knowledge Park III, Greater Noida, Uttar Pradesh. Reducing the amount of pollutants in the air is important for human health and the environment. Today, air pollution is one of the prominent queries to deal with for any country including India.








Calculating autocorrelation in excel