Linear TrendAnalysisTool_temp Law Enforcement Attachment.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- Indian Highway Safety Law Enforcement Grants
- Opportunity number
- BIA-IHSP-2021-0003
About this file
Linear Trend Analysis
View the file
Other files
| File | Type | Posted |
|---|---|---|
| FY21 Grant Announcement.pdf | ||
| Law Enforcement Grant Application with Instructions OMB Approved.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Data Entry Sheet
Year Annual Count 3-Yr Moving Avg 5-Yr Moving Avg
| 2010 | ||
| 2011 | ||
| 2012 | ||
| 2013 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2014 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2015 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2016 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2017 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2018 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2019 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2020 | ||
| 2021 | ||
| 2022 | ||
| 2023 |
Update years and event counts by replacing existing data to maintain a ten-year span. Udate the title
| **Be sure to replace existing data. Do not move cells; this will cause errors in calculations! | |
| Click on the tabs below to see your new charts and calculations |
Annual and Moving Avg Chart
Annual Count 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 3-Yr Moving Avg 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 0 0 0 0 0 0 0 5-Yr Moving Avg 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 0 0 0 0 0 0 0
ChartSheet
| 5- yr | ||
| FATALITY SLOPE | FATALITY TRENDLINE | |
| ERROR:#VALUE! | 2015 | ERROR:#VALUE! |
| FATALITY INTERCEPT | 2016 | ERROR:#VALUE! |
| ERROR:#DIV/0! | 2017 | ERROR:#VALUE! |
| 2018 | ERROR:#VALUE! | |
| 2019 | ERROR:#VALUE! | |
| 2020 | ERROR:#VALUE! | |
| 2021 | ERROR:#VALUE! | |
| 2022 | ERROR:#VALUE! |
| 4-year | 0.83 | ||
| FATALITY SLOPE | FATALITY TRENDLINE | ||
| ERROR:#VALUE! | 2016 | ERROR:#VALUE! | |
| FATALITY INTERCEPT | 2017 | ERROR:#VALUE! | |
| ERROR:#DIV/0! | 2018 | ERROR:#VALUE! | |
| 2019 | ERROR:#VALUE! | ||
| 2020 | ERROR:#VALUE! | ||
| 2021 | ERROR:#VALUE! | ||
| 2022 | ERROR:#VALUE! |
5-Yr Linear Trend Chart
Linear Trend Analysis 5 Most Recent Years Annual Count 2015 2016 2017 2018 2019 2020 2021 2022 Trend
0 0 0 0 0 0 0 0 Annual Counts
4-Yr Linear Trend Chart
Linear Trend Analysis 4 Most Recent Years Annual Count
| 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | Trend | ||||||
| 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Annual Counts
3-Yr Alt Baseline Calculation
| Alternative Baseline Calculation: 3-Year Baseline Period | |||||||
| Baseline Period | Comparison Year | % Change | |||||
| (Multi-year average | |||||||
| calculated from annual data) | (3 years later than last year in multi-year baseline period) | (Comparison year versus baseline period) | |||||
| (2012-2014) avg. | ERROR:#DIV/0! | (2017) | 0 | ERROR:#DIV/0! |
(2013-2015) avg. ERROR:#DIV/0! (2018) 0 ERROR:#DIV/0!
(2014-2016) avg. ERROR:#DIV/0! (2019) 0 ERROR:#DIV/0!
Average % Change ERROR:#DIV/0!
| Current Multi-Year Base | 2022 Projection | |
| (2017-2019) avg. | ERROR:#DIV/0! | ERROR:#DIV/0! |
5-Yr Alt Baseline Calculation
| Alternative Baseline Calculation: 5-Year Baseline Period | |||||||
| Baseline Period | Comparison Year | % Change | |||||
| (Multi-year average | |||||||
| calculated from annual data) | (3 years later than last year in multi-year baseline period) | (Comparison year versus baseline period) | |||||
| (2010-2014) avg. | ? | (2017) | 0 | ? |
(2011-2015) avg. ? (2018) 0 ?
(2012-2016) avg. ? (2019) 0 ?
Average % Change ?
| Current Multi-Year Base | 2022 Projection | |
| (2015-2019) avg. | ERROR:#DIV/0! | ? |
File details come from the government source that posted it. Updated .