Linear TrendAnalysisTool_temp Law Enforcement Attachment.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- Indian Highway Safety Law Enforcement Grants
- Opportunity number
- BIA-IHSP-2022-0003
About this file
Linear Trend Analysis
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Law Enforcement Grant Application & Instructions (exp.11-30-2024).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
| ERROR:#DIV/0! | ERROR:#DIV/0! | |
| 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 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2021 | ERROR:#DIV/0! | ERROR:#DIV/0! |
| 2022 | ||
| 2023 | ||
| 2024 | ||
| 2025 |
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 2017 2018 2019 2020 2021 2022 2023 2024 3-Yr Moving Avg 2017 2018 2019 2020 2021 2022 2023 2024 0 0 0 0 0 0 0 5-Yr Moving Avg 2017 2018 2019 2020 2021 2022 2023 2024 0 0 0 0 0 0 0
ChartSheet
| 5- yr | ||
| FATALITY SLOPE | FATALITY TRENDLINE | |
| ERROR:#VALUE! | 2017 | ERROR:#VALUE! |
| FATALITY INTERCEPT | 2018 | ERROR:#VALUE! |
| ERROR:#DIV/0! | 2019 | ERROR:#VALUE! |
| 2020 | ERROR:#VALUE! | |
| 2021 | ERROR:#VALUE! | |
| 2022 | ERROR:#VALUE! | |
| 2023 | ERROR:#VALUE! | |
| 2024 | ERROR:#VALUE! |
| 4-year | 0.83 | ||
| FATALITY SLOPE | FATALITY TRENDLINE | ||
| ERROR:#VALUE! | 2018 | ERROR:#VALUE! | |
| FATALITY INTERCEPT | 2019 | ERROR:#VALUE! | |
| ERROR:#DIV/0! | 2020 | ERROR:#VALUE! | |
| 2021 | ERROR:#VALUE! | ||
| 2022 | ERROR:#VALUE! | ||
| 2023 | ERROR:#VALUE! | ||
| 2024 | ERROR:#VALUE! |
5-Yr Linear Trend Chart
Linear Trend Analysis 5 Most Recent Years Annual Count 2017 2018 2019 2020 2021 2022 2023 2024 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
| 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | Trend | ||||||
| 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 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) | |||||
| (-) avg. | ERROR:#DIV/0! | (2019) | 0 | ERROR:#DIV/0! |
(-2017) avg. ERROR:#DIV/0! (2020) 0 ERROR:#DIV/0!
(-2018) avg. ERROR:#DIV/0! (2021) 0 ERROR:#DIV/0!
Average % Change ERROR:#DIV/0!
| Current Multi-Year Base | 2024 Projection | |
| (2019-2021) 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) | |||||
| (-) avg. | ? | (2019) | 0 | ? |
(-2017) avg. ? (2020) 0 ?
(-2018) avg. ? (2021) 0 ?
Average % Change ?
| Current Multi-Year Base | 2024 Projection | |
| (2017-2021) avg. | ERROR:#DIV/0! | ? |
File details come from the government source that posted it. Updated .