Linear TrendAnalysisTool_temp Law Enforcement Attachment.xlsx

XLSX spreadsheet 36 KB Posted Jan 30, 2020

Attached to: Indian Highway Safety Law Enforcement Grants
Opportunity number: BIA-IHSP-2020-0003
Issued by: Department of the Interior Bureau of Indian Affairs and Indian Education

About this file

From the source

Linear Trend Analysis

View the file

Other files

File	Type	Posted
SF424_2_1-V2.1.pdf	PDF	Dec 31, 2019
Law Enforcement Grant Application with Instructions OMB Approved.pdf	PDF	Dec 31, 2019

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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.