607 Project 2

Project Overview
Dataset 1: Avocado Prices
Dataset 3: Color and Heat Absorption
Dataset 2: 2010-2018 Census Data

Project Overview

The goal of this assignment is to practice preparing different datasets for downstream analysis work.

Choose any three of the “wide” datasets identified in the Week 6 Discussion items.

For each of the three chosen datasets:

Create a .CSV file (or optionally, a MySQL database!) that includes all of the information included in the dataset. You’re encouraged to use a “wide” structure similar to how the information appears in the discussion item, so that you can practice tidying and transformations as described below.
Read the information from your .CSV file into R, and use tidyr and dplyr as needed to tidy and transform your data.
Perform the analysis requested in the discussion item.
Your code should be in an R Markdown file, posted to rpubs.com, and should include narrative descriptions of your data cleanup work, analysis, and conclusions.

library("tidyr")
library("dplyr")

## 
## Attaching package: 'dplyr'

## The following objects are masked from 'package:stats':
## 
##     filter, lag

## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

library("plyr")

## -------------------------------------------------------------------------

## You have loaded plyr after dplyr - this is likely to cause problems.
## If you need functions from both plyr and dplyr, please load plyr first, then dplyr:
## library(plyr); library(dplyr)

## -------------------------------------------------------------------------

## 
## Attaching package: 'plyr'

## The following objects are masked from 'package:dplyr':
## 
##     arrange, count, desc, failwith, id, mutate, rename, summarise,
##     summarize

library("stringr")
library("kableExtra")

## Warning: package 'kableExtra' was built under R version 3.5.2

library("ggplot2")

Avocado Prices

This dataset, submitted by Samriti Malhotra, contains weekly 2018 retail scan data for National retail volume (units) and price. Retail scan data comes directly from retailers’ cash registers based on actual retail sales of Hass avocados. Multi-outlet reporting includes an aggregation of the following channels: grocery, mass, club, drug, dollar and military. The Average Price (of avocados) in the table reflects a per unit (per avocado) cost, even when multiple units (avocados) are sold in bags. The Product Lookup codes (PLU’s) in the table are only for Hass avocados.

Tidy Data

#Read in data
avocadoPrices <- read.csv("https://raw.githubusercontent.com/KatherineEvers/607-Project-2/master/avocadoPrices.csv", header = TRUE)

#Rename columns
names(avocadoPrices)[4] <- "4046"
names(avocadoPrices)[5] <- "4225"
names(avocadoPrices)[6] <- "4770"

head(avocadoPrices)

##         Date AveragePrice Total.Volume     4046     4225     4770
## 1 2018-12-02         1.22     27652426  9516477  7462866 521910.0
## 2 2018-11-25         1.25     21855494  7140335  6021450 402865.8
## 3 2018-11-18         1.14     29871135  9719229  7271528 497404.3
## 4 2018-11-11         1.00     39042283 13355864 10385141 603032.8
## 5 2018-11-04         1.01     38363283 12420772 10192035 528277.9
## 6 2018-10-28         1.01     39402227 12142265 10845124 549490.8
##   Total.Bags Small.Bags Large.Bags XLarge.Bags
## 1   10151173    7174281    2895343    81547.92
## 2    8290842    6016143    2183011    91688.68
## 3   12382973    9174635    3103023   105315.78
## 4   14698246   10721367    3865596   111282.12
## 5   15222197   10602849    4538743    80604.81
## 6   15865346   11437563    4320344   107438.89

avocadoPrices1 <- avocadoPrices %>%
  #separate data into type and sold count columns
  gather(Type, soldCount, 4:10)

#manipulate table style
avocadoPrices1  %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

Date	AveragePrice	Total.Volume	Type	soldCount
2018-12-02	1.22	27652426	4046	9516477.21
2018-11-25	1.25	21855494	4046	7140335.30
2018-11-18	1.14	29871135	4046	9719228.92
2018-11-11	1.00	39042283	4046	13355863.68
2018-11-04	1.01	38363283	4046	12420772.32
2018-10-28	1.01	39402227	4046	12142265.30
2018-10-21	1.13	34002535	4046	10104600.64
2018-10-14	1.08	36869560	4046	11397965.02
2018-10-07	1.08	38061760	4046	11931876.96
2018-09-30	1.10	37588534	4046	11693993.09
2018-09-23	1.19	34866282	4046	10635595.44
2018-09-16	1.22	35609955	4046	11598586.86
2018-09-09	1.24	37484254	4046	11028194.47
2018-09-02	1.29	36169162	4046	10916802.88
2018-08-26	1.22	36867975	4046	11171123.21
2018-08-19	1.13	40735733	4046	12009246.19
2018-07-15	1.07	43126773	4046	13457479.92
2018-07-08	1.03	47848190	4046	14624443.74
2018-07-01	1.05	45572739	4046	14978439.61
2018-06-24	1.04	44742750	4046	14643774.28
2018-06-17	1.09	44009085	4046	14909830.72
2018-06-10	1.03	45613372	4046	15949807.24
2018-06-03	1.07	44705039	4046	15241658.25
2018-05-27	1.03	47105314	4046	15644843.58
2018-05-20	1.02	44458798	4046	15391298.20
2018-05-13	1.00	46371246	4046	15432480.06
2018-05-06	0.89	63716144	4046	21137400.46
2018-04-29	1.07	43856759	4046	14254036.95
2018-04-22	1.04	44313979	4046	14522577.86
2018-04-15	1.03	47098678	4046	15307339.31
2018-04-08	1.04	42964068	4046	13410251.75
2018-04-01	1.10	41109689	4046	13467728.25
2018-03-25	1.03	43409836	4046	14130799.10
2018-03-18	1.05	41386314	4046	13707389.51
2018-03-11	1.09	40449603	4046	14089091.05
2018-03-04	1.07	40741214	4046	14439547.46
2018-02-25	1.06	40021529	4046	13829857.87
2018-02-18	1.08	36709887	4046	13262751.42
2018-02-11	0.97	43167806	4046	15870677.70
2018-02-04	0.87	62505647	4046	21620180.90
2018-01-28	1.09	40171641	4046	14551799.50
2018-01-21	1.08	42939822	4046	14218843.83
2018-01-14	1.20	37299945	4046	12600918.24
2018-01-07	1.13	36703157	4046	13730992.75
2018-12-02	1.22	27652426	4225	7462865.75
2018-11-25	1.25	21855494	4225	6021450.19
2018-11-18	1.14	29871135	4225	7271528.37
2018-11-11	1.00	39042283	4225	10385141.10
2018-11-04	1.01	38363283	4225	10192035.49
2018-10-28	1.01	39402227	4225	10845124.43
2018-10-21	1.13	34002535	4225	9817026.08
2018-10-14	1.08	36869560	4225	10293294.29
2018-10-07	1.08	38061760	4225	10220788.39
2018-09-30	1.10	37588534	4225	10028231.18
2018-09-23	1.19	34866282	4225	10368078.03
2018-09-16	1.22	35609955	4225	9716277.38
2018-09-09	1.24	37484254	4225	11898526.09
2018-09-02	1.29	36169162	4225	10880826.30
2018-08-26	1.22	36867975	4225	11286479.97
2018-08-19	1.13	40735733	4225	11634725.16
2018-07-15	1.07	43126773	4225	12125207.59
2018-07-08	1.03	47848190	4225	14184132.58
2018-07-01	1.05	45572739	4225	12542937.62
2018-06-24	1.04	44742750	4225	12717017.35
2018-06-17	1.09	44009085	4225	12904472.84
2018-06-10	1.03	45613372	4225	13691955.59
2018-06-03	1.07	44705039	4225	12611264.58
2018-05-27	1.03	47105314	4225	13548819.31
2018-05-20	1.02	44458798	4225	12092088.69
2018-05-13	1.00	46371246	4225	12367251.74
2018-05-06	0.89	63716144	4225	19900871.87
2018-04-29	1.07	43856759	4225	13240108.54
2018-04-22	1.04	44313979	4225	12709402.97
2018-04-15	1.03	47098678	4225	13807126.47
2018-04-08	1.04	42964068	4225	13040703.22
2018-04-01	1.10	41109689	4225	10744041.46
2018-03-25	1.03	43409836	4225	12125711.42
2018-03-18	1.05	41386314	4225	11061051.69
2018-03-11	1.09	40449603	4225	10758039.45
2018-03-04	1.07	40741214	4225	11289307.37
2018-02-25	1.06	40021529	4225	10415463.59
2018-02-18	1.08	36709887	4225	10491918.44
2018-02-11	0.97	43167806	4225	11541844.87
2018-02-04	0.87	62505647	4225	20445501.03
2018-01-28	1.09	40171641	4225	12119884.61
2018-01-21	1.08	42939822	4225	13929702.12
2018-01-14	1.20	37299945	4225	11866197.84
2018-01-07	1.13	36703157	4225	10781339.21
2018-12-02	1.22	27652426	4770	521910.02
2018-11-25	1.25	21855494	4770	402865.82
2018-11-18	1.14	29871135	4770	497404.35
2018-11-11	1.00	39042283	4770	603032.80
2018-11-04	1.01	38363283	4770	528277.90
2018-10-28	1.01	39402227	4770	549490.79
2018-10-21	1.13	34002535	4770	530698.97
2018-10-14	1.08	36869560	4770	599007.52
2018-10-07	1.08	38061760	4770	794611.30
2018-09-30	1.10	37588534	4770	659678.66
2018-09-23	1.19	34866282	4770	644554.31
2018-09-16	1.22	35609955	4770	743851.12
2018-09-09	1.24	37484254	4770	859246.52
2018-09-02	1.29	36169162	4770	777527.98
2018-08-26	1.22	36867975	4770	699010.18
2018-08-19	1.13	40735733	4770	1116318.45
2018-07-15	1.07	43126773	4770	908599.10
2018-07-08	1.03	47848190	4770	1169255.61
2018-07-01	1.05	45572739	4770	969238.95
2018-06-24	1.04	44742750	4770	1110724.00
2018-06-17	1.09	44009085	4770	782043.10
2018-06-10	1.03	45613372	4770	753786.21
2018-06-03	1.07	44705039	4770	828737.97
2018-05-27	1.03	47105314	4770	793658.51
2018-05-20	1.02	44458798	4770	736111.95
2018-05-13	1.00	46371246	4770	759855.73
2018-05-06	0.89	63716144	4770	1052499.15
2018-04-29	1.07	43856759	4770	744030.09
2018-04-22	1.04	44313979	4770	722558.85
2018-04-15	1.03	47098678	4770	894946.43
2018-04-08	1.04	42964068	4770	737515.63
2018-04-01	1.10	41109689	4770	732443.87
2018-03-25	1.03	43409836	4770	758801.12
2018-03-18	1.05	41386314	4770	645380.85
2018-03-11	1.09	40449603	4770	707578.82
2018-03-04	1.07	40741214	4770	571747.72
2018-02-25	1.06	40021529	4770	724330.16
2018-02-18	1.08	36709887	4770	552969.73
2018-02-11	0.97	43167806	4770	652856.58
2018-02-04	0.87	62505647	4770	1066830.22
2018-01-28	1.09	40171641	4770	575974.74
2018-01-21	1.08	42939822	4770	928815.12
2018-01-14	1.20	37299945	4770	652808.40
2018-01-07	1.13	36703157	4770	677714.86
2018-12-02	1.22	27652426	Total.Bags	10151172.64
2018-11-25	1.25	21855494	Total.Bags	8290842.38
2018-11-18	1.14	29871135	Total.Bags	12382973.38
2018-11-11	1.00	39042283	Total.Bags	14698245.76
2018-11-04	1.01	38363283	Total.Bags	15222197.02
2018-10-28	1.01	39402227	Total.Bags	15865346.06
2018-10-21	1.13	34002535	Total.Bags	13550209.00
2018-10-14	1.08	36869560	Total.Bags	14579293.56
2018-10-07	1.08	38061760	Total.Bags	15114483.01
2018-09-30	1.10	37588534	Total.Bags	15206631.23
2018-09-23	1.19	34866282	Total.Bags	13218054.50
2018-09-16	1.22	35609955	Total.Bags	13551240.03
2018-09-09	1.24	37484254	Total.Bags	13698286.67
2018-09-02	1.29	36169162	Total.Bags	13594004.41
2018-08-26	1.22	36867975	Total.Bags	13711361.22
2018-08-19	1.13	40735733	Total.Bags	15975442.88
2018-07-15	1.07	43126773	Total.Bags	16635486.61
2018-07-08	1.03	47848190	Total.Bags	17870357.86
2018-07-01	1.05	45572739	Total.Bags	17082122.99
2018-06-24	1.04	44742750	Total.Bags	16271234.25
2018-06-17	1.09	44009085	Total.Bags	15412738.12
2018-06-10	1.03	45613372	Total.Bags	15217823.38
2018-06-03	1.07	44705039	Total.Bags	16023378.25
2018-05-27	1.03	47105314	Total.Bags	17117992.88
2018-05-20	1.02	44458798	Total.Bags	16239299.46
2018-05-13	1.00	46371246	Total.Bags	17811658.31
2018-05-06	0.89	63716144	Total.Bags	21625372.67
2018-04-29	1.07	43856759	Total.Bags	15618583.41
2018-04-22	1.04	44313979	Total.Bags	16359439.62
2018-04-15	1.03	47098678	Total.Bags	17089265.47
2018-04-08	1.04	42964068	Total.Bags	15775597.08
2018-04-01	1.10	41109689	Total.Bags	16165475.14
2018-03-25	1.03	43409836	Total.Bags	16394524.11
2018-03-18	1.05	41386314	Total.Bags	15972492.07
2018-03-11	1.09	40449603	Total.Bags	14894893.80
2018-03-04	1.07	40741214	Total.Bags	14440611.50
2018-02-25	1.06	40021529	Total.Bags	15051877.14
2018-02-18	1.08	36709887	Total.Bags	12402247.90
2018-02-11	0.97	43167806	Total.Bags	15102426.94
2018-02-04	0.87	62505647	Total.Bags	19373134.37
2018-01-28	1.09	40171641	Total.Bags	12923981.99
2018-01-21	1.08	42939822	Total.Bags	13862460.48
2018-01-14	1.20	37299945	Total.Bags	12180020.74
2018-01-07	1.13	36703157	Total.Bags	11513109.90
2018-12-02	1.22	27652426	Small.Bags	7174281.40
2018-11-25	1.25	21855494	Small.Bags	6016142.82
2018-11-18	1.14	29871135	Small.Bags	9174635.04
2018-11-11	1.00	39042283	Small.Bags	10721367.16
2018-11-04	1.01	38363283	Small.Bags	10602848.85
2018-10-28	1.01	39402227	Small.Bags	11437562.67
2018-10-21	1.13	34002535	Small.Bags	9914169.64
2018-10-14	1.08	36869560	Small.Bags	10460714.07
2018-10-07	1.08	38061760	Small.Bags	11085671.50
2018-09-30	1.10	37588534	Small.Bags	11080362.15
2018-09-23	1.19	34866282	Small.Bags	9638333.84
2018-09-16	1.22	35609955	Small.Bags	9562607.70
2018-09-09	1.24	37484254	Small.Bags	9876854.43
2018-09-02	1.29	36169162	Small.Bags	9783860.21
2018-08-26	1.22	36867975	Small.Bags	9484135.03
2018-08-19	1.13	40735733	Small.Bags	11055173.29
2018-07-15	1.07	43126773	Small.Bags	11924570.43
2018-07-08	1.03	47848190	Small.Bags	12817172.90
2018-07-01	1.05	45572739	Small.Bags	11945298.31
2018-06-24	1.04	44742750	Small.Bags	11708299.17
2018-06-17	1.09	44009085	Small.Bags	11486168.32
2018-06-10	1.03	45613372	Small.Bags	11228599.99
2018-06-03	1.07	44705039	Small.Bags	11035193.03
2018-05-27	1.03	47105314	Small.Bags	11620663.52
2018-05-20	1.02	44458798	Small.Bags	11427676.19
2018-05-13	1.00	46371246	Small.Bags	13110016.21
2018-05-06	0.89	63716144	Small.Bags	15436246.72
2018-04-29	1.07	43856759	Small.Bags	11122006.81
2018-04-22	1.04	44313979	Small.Bags	11850825.63
2018-04-15	1.03	47098678	Small.Bags	12283244.61
2018-04-08	1.04	42964068	Small.Bags	10948345.06
2018-04-01	1.10	41109689	Small.Bags	11826774.74
2018-03-25	1.03	43409836	Small.Bags	12540327.19
2018-03-18	1.05	41386314	Small.Bags	11712807.19
2018-03-11	1.09	40449603	Small.Bags	11392828.89
2018-03-04	1.07	40741214	Small.Bags	10832907.44
2018-02-25	1.06	40021529	Small.Bags	10666942.78
2018-02-18	1.08	36709887	Small.Bags	9023351.68
2018-02-11	0.97	43167806	Small.Bags	10844852.22
2018-02-04	0.87	62505647	Small.Bags	13384586.80
2018-01-28	1.09	40171641	Small.Bags	9749412.19
2018-01-21	1.08	42939822	Small.Bags	9866218.28
2018-01-14	1.20	37299945	Small.Bags	8128241.88
2018-01-07	1.13	36703157	Small.Bags	8231766.23
2018-12-02	1.22	27652426	Large.Bags	2895343.32
2018-11-25	1.25	21855494	Large.Bags	2183010.88
2018-11-18	1.14	29871135	Large.Bags	3103022.56
2018-11-11	1.00	39042283	Large.Bags	3865596.48
2018-11-04	1.01	38363283	Large.Bags	4538743.36
2018-10-28	1.01	39402227	Large.Bags	4320344.50
2018-10-21	1.13	34002535	Large.Bags	3463120.27
2018-10-14	1.08	36869560	Large.Bags	3928694.16
2018-10-07	1.08	38061760	Large.Bags	3792435.33
2018-09-30	1.10	37588534	Large.Bags	3869002.42
2018-09-23	1.19	34866282	Large.Bags	3294142.37
2018-09-16	1.22	35609955	Large.Bags	3684646.74
2018-09-09	1.24	37484254	Large.Bags	3505978.13
2018-09-02	1.29	36169162	Large.Bags	3485418.35
2018-08-26	1.22	36867975	Large.Bags	3930111.90
2018-08-19	1.13	40735733	Large.Bags	4500204.69
2018-07-15	1.07	43126773	Large.Bags	4460656.29
2018-07-08	1.03	47848190	Large.Bags	4735852.45
2018-07-01	1.05	45572739	Large.Bags	4934540.62
2018-06-24	1.04	44742750	Large.Bags	4262204.76
2018-06-17	1.09	44009085	Large.Bags	3707918.88
2018-06-10	1.03	45613372	Large.Bags	3724800.50
2018-06-03	1.07	44705039	Large.Bags	4684090.46
2018-05-27	1.03	47105314	Large.Bags	5229855.39
2018-05-20	1.02	44458798	Large.Bags	4549192.20
2018-05-13	1.00	46371246	Large.Bags	4432536.78
2018-05-06	0.89	63716144	Large.Bags	5840414.83
2018-04-29	1.07	43856759	Large.Bags	4208203.84
2018-04-22	1.04	44313979	Large.Bags	4207588.22
2018-04-15	1.03	47098678	Large.Bags	4522004.01
2018-04-08	1.04	42964068	Large.Bags	4555612.68
2018-04-01	1.10	41109689	Large.Bags	4055704.74
2018-03-25	1.03	43409836	Large.Bags	3544729.39
2018-03-18	1.05	41386314	Large.Bags	3988101.74
2018-03-11	1.09	40449603	Large.Bags	3229556.62
2018-03-04	1.07	40741214	Large.Bags	3339214.96
2018-02-25	1.06	40021529	Large.Bags	4081397.72
2018-02-18	1.08	36709887	Large.Bags	3151157.42
2018-02-11	0.97	43167806	Large.Bags	4023485.04
2018-02-04	0.87	62505647	Large.Bags	5719096.61
2018-01-28	1.09	40171641	Large.Bags	3041125.42
2018-01-21	1.08	42939822	Large.Bags	3789722.90
2018-01-14	1.20	37299945	Large.Bags	3917569.95
2018-01-07	1.13	36703157	Large.Bags	3130919.10
2018-12-02	1.22	27652426	XLarge.Bags	81547.92
2018-11-25	1.25	21855494	XLarge.Bags	91688.68
2018-11-18	1.14	29871135	XLarge.Bags	105315.78
2018-11-11	1.00	39042283	XLarge.Bags	111282.12
2018-11-04	1.01	38363283	XLarge.Bags	80604.81
2018-10-28	1.01	39402227	XLarge.Bags	107438.89
2018-10-21	1.13	34002535	XLarge.Bags	172919.09
2018-10-14	1.08	36869560	XLarge.Bags	189885.33
2018-10-07	1.08	38061760	XLarge.Bags	236376.18
2018-09-30	1.10	37588534	XLarge.Bags	257266.66
2018-09-23	1.19	34866282	XLarge.Bags	285578.29
2018-09-16	1.22	35609955	XLarge.Bags	303985.59
2018-09-09	1.24	37484254	XLarge.Bags	315454.11
2018-09-02	1.29	36169162	XLarge.Bags	324725.85
2018-08-26	1.22	36867975	XLarge.Bags	297114.29
2018-08-19	1.13	40735733	XLarge.Bags	420064.90
2018-07-15	1.07	43126773	XLarge.Bags	250259.89
2018-07-08	1.03	47848190	XLarge.Bags	317332.51
2018-07-01	1.05	45572739	XLarge.Bags	202284.06
2018-06-24	1.04	44742750	XLarge.Bags	300730.32
2018-06-17	1.09	44009085	XLarge.Bags	218650.92
2018-06-10	1.03	45613372	XLarge.Bags	264422.89
2018-06-03	1.07	44705039	XLarge.Bags	304094.76
2018-05-27	1.03	47105314	XLarge.Bags	267473.97
2018-05-20	1.02	44458798	XLarge.Bags	262431.07
2018-05-13	1.00	46371246	XLarge.Bags	269105.32
2018-05-06	0.89	63716144	XLarge.Bags	348711.12
2018-04-29	1.07	43856759	XLarge.Bags	288372.76
2018-04-22	1.04	44313979	XLarge.Bags	301025.77
2018-04-15	1.03	47098678	XLarge.Bags	284016.85
2018-04-08	1.04	42964068	XLarge.Bags	271639.34
2018-04-01	1.10	41109689	XLarge.Bags	282995.66
2018-03-25	1.03	43409836	XLarge.Bags	309467.53
2018-03-18	1.05	41386314	XLarge.Bags	271583.14
2018-03-11	1.09	40449603	XLarge.Bags	272508.29
2018-03-04	1.07	40741214	XLarge.Bags	268489.10
2018-02-25	1.06	40021529	XLarge.Bags	303536.64
2018-02-18	1.08	36709887	XLarge.Bags	227738.80
2018-02-11	0.97	43167806	XLarge.Bags	234089.68
2018-02-04	0.87	62505647	XLarge.Bags	269450.96
2018-01-28	1.09	40171641	XLarge.Bags	133444.38
2018-01-21	1.08	42939822	XLarge.Bags	206519.30
2018-01-14	1.20	37299945	XLarge.Bags	134208.91
2018-01-07	1.13	36703157	XLarge.Bags	150424.57

avocadoPrices2 <- avocadoPrices1 %>%
  #Order rows by chronological date and then type
  arrange(Date, Type)

#Split date column into separate year, month, and day columns
avocadoPrices3 <- separate(data = avocadoPrices2,col = "Date",into = c("Year","Month","Day"))
#Create a subset of the data
avocadoPrices3 <- subset(avocadoPrices3, select = c("Month", "Total.Volume", "Type", "soldCount"))
#Remove rows with total bags
avocadoPrices3 <- avocadoPrices3[!grepl("Total.Bags", avocadoPrices3$Type),]

avocadoPrices3  %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

	Month	Total.Volume	Type	soldCount
1	01	36703157	4046	13730992.75
2	01	36703157	4225	10781339.21
3	01	36703157	4770	677714.86
4	01	36703157	Large.Bags	3130919.10
5	01	36703157	Small.Bags	8231766.23
7	01	36703157	XLarge.Bags	150424.57
8	01	37299945	4046	12600918.24
9	01	37299945	4225	11866197.84
10	01	37299945	4770	652808.40
11	01	37299945	Large.Bags	3917569.95
12	01	37299945	Small.Bags	8128241.88
14	01	37299945	XLarge.Bags	134208.91
15	01	42939822	4046	14218843.83
16	01	42939822	4225	13929702.12
17	01	42939822	4770	928815.12
18	01	42939822	Large.Bags	3789722.90
19	01	42939822	Small.Bags	9866218.28
21	01	42939822	XLarge.Bags	206519.30
22	01	40171641	4046	14551799.50
23	01	40171641	4225	12119884.61
24	01	40171641	4770	575974.74
25	01	40171641	Large.Bags	3041125.42
26	01	40171641	Small.Bags	9749412.19
28	01	40171641	XLarge.Bags	133444.38
29	02	62505647	4046	21620180.90
30	02	62505647	4225	20445501.03
31	02	62505647	4770	1066830.22
32	02	62505647	Large.Bags	5719096.61
33	02	62505647	Small.Bags	13384586.80
35	02	62505647	XLarge.Bags	269450.96
36	02	43167806	4046	15870677.70
37	02	43167806	4225	11541844.87
38	02	43167806	4770	652856.58
39	02	43167806	Large.Bags	4023485.04
40	02	43167806	Small.Bags	10844852.22
42	02	43167806	XLarge.Bags	234089.68
43	02	36709887	4046	13262751.42
44	02	36709887	4225	10491918.44
45	02	36709887	4770	552969.73
46	02	36709887	Large.Bags	3151157.42
47	02	36709887	Small.Bags	9023351.68
49	02	36709887	XLarge.Bags	227738.80
50	02	40021529	4046	13829857.87
51	02	40021529	4225	10415463.59
52	02	40021529	4770	724330.16
53	02	40021529	Large.Bags	4081397.72
54	02	40021529	Small.Bags	10666942.78
56	02	40021529	XLarge.Bags	303536.64
57	03	40741214	4046	14439547.46
58	03	40741214	4225	11289307.37
59	03	40741214	4770	571747.72
60	03	40741214	Large.Bags	3339214.96
61	03	40741214	Small.Bags	10832907.44
63	03	40741214	XLarge.Bags	268489.10
64	03	40449603	4046	14089091.05
65	03	40449603	4225	10758039.45
66	03	40449603	4770	707578.82
67	03	40449603	Large.Bags	3229556.62
68	03	40449603	Small.Bags	11392828.89
70	03	40449603	XLarge.Bags	272508.29
71	03	41386314	4046	13707389.51
72	03	41386314	4225	11061051.69
73	03	41386314	4770	645380.85
74	03	41386314	Large.Bags	3988101.74
75	03	41386314	Small.Bags	11712807.19
77	03	41386314	XLarge.Bags	271583.14
78	03	43409836	4046	14130799.10
79	03	43409836	4225	12125711.42
80	03	43409836	4770	758801.12
81	03	43409836	Large.Bags	3544729.39
82	03	43409836	Small.Bags	12540327.19
84	03	43409836	XLarge.Bags	309467.53
85	04	41109689	4046	13467728.25
86	04	41109689	4225	10744041.46
87	04	41109689	4770	732443.87
88	04	41109689	Large.Bags	4055704.74
89	04	41109689	Small.Bags	11826774.74
91	04	41109689	XLarge.Bags	282995.66
92	04	42964068	4046	13410251.75
93	04	42964068	4225	13040703.22
94	04	42964068	4770	737515.63
95	04	42964068	Large.Bags	4555612.68
96	04	42964068	Small.Bags	10948345.06
98	04	42964068	XLarge.Bags	271639.34
99	04	47098678	4046	15307339.31
100	04	47098678	4225	13807126.47
101	04	47098678	4770	894946.43
102	04	47098678	Large.Bags	4522004.01
103	04	47098678	Small.Bags	12283244.61
105	04	47098678	XLarge.Bags	284016.85
106	04	44313979	4046	14522577.86
107	04	44313979	4225	12709402.97
108	04	44313979	4770	722558.85
109	04	44313979	Large.Bags	4207588.22
110	04	44313979	Small.Bags	11850825.63
112	04	44313979	XLarge.Bags	301025.77
113	04	43856759	4046	14254036.95
114	04	43856759	4225	13240108.54
115	04	43856759	4770	744030.09
116	04	43856759	Large.Bags	4208203.84
117	04	43856759	Small.Bags	11122006.81
119	04	43856759	XLarge.Bags	288372.76
120	05	63716144	4046	21137400.46
121	05	63716144	4225	19900871.87
122	05	63716144	4770	1052499.15
123	05	63716144	Large.Bags	5840414.83
124	05	63716144	Small.Bags	15436246.72
126	05	63716144	XLarge.Bags	348711.12
127	05	46371246	4046	15432480.06
128	05	46371246	4225	12367251.74
129	05	46371246	4770	759855.73
130	05	46371246	Large.Bags	4432536.78
131	05	46371246	Small.Bags	13110016.21
133	05	46371246	XLarge.Bags	269105.32
134	05	44458798	4046	15391298.20
135	05	44458798	4225	12092088.69
136	05	44458798	4770	736111.95
137	05	44458798	Large.Bags	4549192.20
138	05	44458798	Small.Bags	11427676.19
140	05	44458798	XLarge.Bags	262431.07
141	05	47105314	4046	15644843.58
142	05	47105314	4225	13548819.31
143	05	47105314	4770	793658.51
144	05	47105314	Large.Bags	5229855.39
145	05	47105314	Small.Bags	11620663.52
147	05	47105314	XLarge.Bags	267473.97
148	06	44705039	4046	15241658.25
149	06	44705039	4225	12611264.58
150	06	44705039	4770	828737.97
151	06	44705039	Large.Bags	4684090.46
152	06	44705039	Small.Bags	11035193.03
154	06	44705039	XLarge.Bags	304094.76
155	06	45613372	4046	15949807.24
156	06	45613372	4225	13691955.59
157	06	45613372	4770	753786.21
158	06	45613372	Large.Bags	3724800.50
159	06	45613372	Small.Bags	11228599.99
161	06	45613372	XLarge.Bags	264422.89
162	06	44009085	4046	14909830.72
163	06	44009085	4225	12904472.84
164	06	44009085	4770	782043.10
165	06	44009085	Large.Bags	3707918.88
166	06	44009085	Small.Bags	11486168.32
168	06	44009085	XLarge.Bags	218650.92
169	06	44742750	4046	14643774.28
170	06	44742750	4225	12717017.35
171	06	44742750	4770	1110724.00
172	06	44742750	Large.Bags	4262204.76
173	06	44742750	Small.Bags	11708299.17
175	06	44742750	XLarge.Bags	300730.32
176	07	45572739	4046	14978439.61
177	07	45572739	4225	12542937.62
178	07	45572739	4770	969238.95
179	07	45572739	Large.Bags	4934540.62
180	07	45572739	Small.Bags	11945298.31
182	07	45572739	XLarge.Bags	202284.06
183	07	47848190	4046	14624443.74
184	07	47848190	4225	14184132.58
185	07	47848190	4770	1169255.61
186	07	47848190	Large.Bags	4735852.45
187	07	47848190	Small.Bags	12817172.90
189	07	47848190	XLarge.Bags	317332.51
190	07	43126773	4046	13457479.92
191	07	43126773	4225	12125207.59
192	07	43126773	4770	908599.10
193	07	43126773	Large.Bags	4460656.29
194	07	43126773	Small.Bags	11924570.43
196	07	43126773	XLarge.Bags	250259.89
197	08	40735733	4046	12009246.19
198	08	40735733	4225	11634725.16
199	08	40735733	4770	1116318.45
200	08	40735733	Large.Bags	4500204.69
201	08	40735733	Small.Bags	11055173.29
203	08	40735733	XLarge.Bags	420064.90
204	08	36867975	4046	11171123.21
205	08	36867975	4225	11286479.97
206	08	36867975	4770	699010.18
207	08	36867975	Large.Bags	3930111.90
208	08	36867975	Small.Bags	9484135.03
210	08	36867975	XLarge.Bags	297114.29
211	09	36169162	4046	10916802.88
212	09	36169162	4225	10880826.30
213	09	36169162	4770	777527.98
214	09	36169162	Large.Bags	3485418.35
215	09	36169162	Small.Bags	9783860.21
217	09	36169162	XLarge.Bags	324725.85
218	09	37484254	4046	11028194.47
219	09	37484254	4225	11898526.09
220	09	37484254	4770	859246.52
221	09	37484254	Large.Bags	3505978.13
222	09	37484254	Small.Bags	9876854.43
224	09	37484254	XLarge.Bags	315454.11
225	09	35609955	4046	11598586.86
226	09	35609955	4225	9716277.38
227	09	35609955	4770	743851.12
228	09	35609955	Large.Bags	3684646.74
229	09	35609955	Small.Bags	9562607.70
231	09	35609955	XLarge.Bags	303985.59
232	09	34866282	4046	10635595.44
233	09	34866282	4225	10368078.03
234	09	34866282	4770	644554.31
235	09	34866282	Large.Bags	3294142.37
236	09	34866282	Small.Bags	9638333.84
238	09	34866282	XLarge.Bags	285578.29
239	09	37588534	4046	11693993.09
240	09	37588534	4225	10028231.18
241	09	37588534	4770	659678.66
242	09	37588534	Large.Bags	3869002.42
243	09	37588534	Small.Bags	11080362.15
245	09	37588534	XLarge.Bags	257266.66
246	10	38061760	4046	11931876.96
247	10	38061760	4225	10220788.39
248	10	38061760	4770	794611.30
249	10	38061760	Large.Bags	3792435.33
250	10	38061760	Small.Bags	11085671.50
252	10	38061760	XLarge.Bags	236376.18
253	10	36869560	4046	11397965.02
254	10	36869560	4225	10293294.29
255	10	36869560	4770	599007.52
256	10	36869560	Large.Bags	3928694.16
257	10	36869560	Small.Bags	10460714.07
259	10	36869560	XLarge.Bags	189885.33
260	10	34002535	4046	10104600.64
261	10	34002535	4225	9817026.08
262	10	34002535	4770	530698.97
263	10	34002535	Large.Bags	3463120.27
264	10	34002535	Small.Bags	9914169.64
266	10	34002535	XLarge.Bags	172919.09
267	10	39402227	4046	12142265.30
268	10	39402227	4225	10845124.43
269	10	39402227	4770	549490.79
270	10	39402227	Large.Bags	4320344.50
271	10	39402227	Small.Bags	11437562.67
273	10	39402227	XLarge.Bags	107438.89
274	11	38363283	4046	12420772.32
275	11	38363283	4225	10192035.49
276	11	38363283	4770	528277.90
277	11	38363283	Large.Bags	4538743.36
278	11	38363283	Small.Bags	10602848.85
280	11	38363283	XLarge.Bags	80604.81
281	11	39042283	4046	13355863.68
282	11	39042283	4225	10385141.10
283	11	39042283	4770	603032.80
284	11	39042283	Large.Bags	3865596.48
285	11	39042283	Small.Bags	10721367.16
287	11	39042283	XLarge.Bags	111282.12
288	11	29871135	4046	9719228.92
289	11	29871135	4225	7271528.37
290	11	29871135	4770	497404.35
291	11	29871135	Large.Bags	3103022.56
292	11	29871135	Small.Bags	9174635.04
294	11	29871135	XLarge.Bags	105315.78
295	11	21855494	4046	7140335.30
296	11	21855494	4225	6021450.19
297	11	21855494	4770	402865.82
298	11	21855494	Large.Bags	2183010.88
299	11	21855494	Small.Bags	6016142.82
301	11	21855494	XLarge.Bags	91688.68
302	12	27652426	4046	9516477.21
303	12	27652426	4225	7462865.75
304	12	27652426	4770	521910.02
305	12	27652426	Large.Bags	2895343.32
306	12	27652426	Small.Bags	7174281.40
308	12	27652426	XLarge.Bags	81547.92

Analyze Data

#Calculate the percentage of each avocado type sold for each date
avocadoPrices4 <- avocadoPrices2 %>% 
        mutate(soldPercent = round(soldCount / Total.Volume * 100, 2))

avocadoPrices4  %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

Date	AveragePrice	Total.Volume	Type	soldCount	soldPercent
2018-01-07	1.13	36703157	4046	13730992.75	37.41
2018-01-07	1.13	36703157	4225	10781339.21	29.37
2018-01-07	1.13	36703157	4770	677714.86	1.85
2018-01-07	1.13	36703157	Large.Bags	3130919.10	8.53
2018-01-07	1.13	36703157	Small.Bags	8231766.23	22.43
2018-01-07	1.13	36703157	Total.Bags	11513109.90	31.37
2018-01-07	1.13	36703157	XLarge.Bags	150424.57	0.41
2018-01-14	1.20	37299945	4046	12600918.24	33.78
2018-01-14	1.20	37299945	4225	11866197.84	31.81
2018-01-14	1.20	37299945	4770	652808.40	1.75
2018-01-14	1.20	37299945	Large.Bags	3917569.95	10.50
2018-01-14	1.20	37299945	Small.Bags	8128241.88	21.79
2018-01-14	1.20	37299945	Total.Bags	12180020.74	32.65
2018-01-14	1.20	37299945	XLarge.Bags	134208.91	0.36
2018-01-21	1.08	42939822	4046	14218843.83	33.11
2018-01-21	1.08	42939822	4225	13929702.12	32.44
2018-01-21	1.08	42939822	4770	928815.12	2.16
2018-01-21	1.08	42939822	Large.Bags	3789722.90	8.83
2018-01-21	1.08	42939822	Small.Bags	9866218.28	22.98
2018-01-21	1.08	42939822	Total.Bags	13862460.48	32.28
2018-01-21	1.08	42939822	XLarge.Bags	206519.30	0.48
2018-01-28	1.09	40171641	4046	14551799.50	36.22
2018-01-28	1.09	40171641	4225	12119884.61	30.17
2018-01-28	1.09	40171641	4770	575974.74	1.43
2018-01-28	1.09	40171641	Large.Bags	3041125.42	7.57
2018-01-28	1.09	40171641	Small.Bags	9749412.19	24.27
2018-01-28	1.09	40171641	Total.Bags	12923981.99	32.17
2018-01-28	1.09	40171641	XLarge.Bags	133444.38	0.33
2018-02-04	0.87	62505647	4046	21620180.90	34.59
2018-02-04	0.87	62505647	4225	20445501.03	32.71
2018-02-04	0.87	62505647	4770	1066830.22	1.71
2018-02-04	0.87	62505647	Large.Bags	5719096.61	9.15
2018-02-04	0.87	62505647	Small.Bags	13384586.80	21.41
2018-02-04	0.87	62505647	Total.Bags	19373134.37	30.99
2018-02-04	0.87	62505647	XLarge.Bags	269450.96	0.43
2018-02-11	0.97	43167806	4046	15870677.70	36.77
2018-02-11	0.97	43167806	4225	11541844.87	26.74
2018-02-11	0.97	43167806	4770	652856.58	1.51
2018-02-11	0.97	43167806	Large.Bags	4023485.04	9.32
2018-02-11	0.97	43167806	Small.Bags	10844852.22	25.12
2018-02-11	0.97	43167806	Total.Bags	15102426.94	34.99
2018-02-11	0.97	43167806	XLarge.Bags	234089.68	0.54
2018-02-18	1.08	36709887	4046	13262751.42	36.13
2018-02-18	1.08	36709887	4225	10491918.44	28.58
2018-02-18	1.08	36709887	4770	552969.73	1.51
2018-02-18	1.08	36709887	Large.Bags	3151157.42	8.58
2018-02-18	1.08	36709887	Small.Bags	9023351.68	24.58
2018-02-18	1.08	36709887	Total.Bags	12402247.90	33.78
2018-02-18	1.08	36709887	XLarge.Bags	227738.80	0.62
2018-02-25	1.06	40021529	4046	13829857.87	34.56
2018-02-25	1.06	40021529	4225	10415463.59	26.02
2018-02-25	1.06	40021529	4770	724330.16	1.81
2018-02-25	1.06	40021529	Large.Bags	4081397.72	10.20
2018-02-25	1.06	40021529	Small.Bags	10666942.78	26.65
2018-02-25	1.06	40021529	Total.Bags	15051877.14	37.61
2018-02-25	1.06	40021529	XLarge.Bags	303536.64	0.76
2018-03-04	1.07	40741214	4046	14439547.46	35.44
2018-03-04	1.07	40741214	4225	11289307.37	27.71
2018-03-04	1.07	40741214	4770	571747.72	1.40
2018-03-04	1.07	40741214	Large.Bags	3339214.96	8.20
2018-03-04	1.07	40741214	Small.Bags	10832907.44	26.59
2018-03-04	1.07	40741214	Total.Bags	14440611.50	35.44
2018-03-04	1.07	40741214	XLarge.Bags	268489.10	0.66
2018-03-11	1.09	40449603	4046	14089091.05	34.83
2018-03-11	1.09	40449603	4225	10758039.45	26.60
2018-03-11	1.09	40449603	4770	707578.82	1.75
2018-03-11	1.09	40449603	Large.Bags	3229556.62	7.98
2018-03-11	1.09	40449603	Small.Bags	11392828.89	28.17
2018-03-11	1.09	40449603	Total.Bags	14894893.80	36.82
2018-03-11	1.09	40449603	XLarge.Bags	272508.29	0.67
2018-03-18	1.05	41386314	4046	13707389.51	33.12
2018-03-18	1.05	41386314	4225	11061051.69	26.73
2018-03-18	1.05	41386314	4770	645380.85	1.56
2018-03-18	1.05	41386314	Large.Bags	3988101.74	9.64
2018-03-18	1.05	41386314	Small.Bags	11712807.19	28.30
2018-03-18	1.05	41386314	Total.Bags	15972492.07	38.59
2018-03-18	1.05	41386314	XLarge.Bags	271583.14	0.66
2018-03-25	1.03	43409836	4046	14130799.10	32.55
2018-03-25	1.03	43409836	4225	12125711.42	27.93
2018-03-25	1.03	43409836	4770	758801.12	1.75
2018-03-25	1.03	43409836	Large.Bags	3544729.39	8.17
2018-03-25	1.03	43409836	Small.Bags	12540327.19	28.89
2018-03-25	1.03	43409836	Total.Bags	16394524.11	37.77
2018-03-25	1.03	43409836	XLarge.Bags	309467.53	0.71
2018-04-01	1.10	41109689	4046	13467728.25	32.76
2018-04-01	1.10	41109689	4225	10744041.46	26.14
2018-04-01	1.10	41109689	4770	732443.87	1.78
2018-04-01	1.10	41109689	Large.Bags	4055704.74	9.87
2018-04-01	1.10	41109689	Small.Bags	11826774.74	28.77
2018-04-01	1.10	41109689	Total.Bags	16165475.14	39.32
2018-04-01	1.10	41109689	XLarge.Bags	282995.66	0.69
2018-04-08	1.04	42964068	4046	13410251.75	31.21
2018-04-08	1.04	42964068	4225	13040703.22	30.35
2018-04-08	1.04	42964068	4770	737515.63	1.72
2018-04-08	1.04	42964068	Large.Bags	4555612.68	10.60
2018-04-08	1.04	42964068	Small.Bags	10948345.06	25.48
2018-04-08	1.04	42964068	Total.Bags	15775597.08	36.72
2018-04-08	1.04	42964068	XLarge.Bags	271639.34	0.63
2018-04-15	1.03	47098678	4046	15307339.31	32.50
2018-04-15	1.03	47098678	4225	13807126.47	29.32
2018-04-15	1.03	47098678	4770	894946.43	1.90
2018-04-15	1.03	47098678	Large.Bags	4522004.01	9.60
2018-04-15	1.03	47098678	Small.Bags	12283244.61	26.08
2018-04-15	1.03	47098678	Total.Bags	17089265.47	36.28
2018-04-15	1.03	47098678	XLarge.Bags	284016.85	0.60
2018-04-22	1.04	44313979	4046	14522577.86	32.77
2018-04-22	1.04	44313979	4225	12709402.97	28.68
2018-04-22	1.04	44313979	4770	722558.85	1.63
2018-04-22	1.04	44313979	Large.Bags	4207588.22	9.49
2018-04-22	1.04	44313979	Small.Bags	11850825.63	26.74
2018-04-22	1.04	44313979	Total.Bags	16359439.62	36.92
2018-04-22	1.04	44313979	XLarge.Bags	301025.77	0.68
2018-04-29	1.07	43856759	4046	14254036.95	32.50
2018-04-29	1.07	43856759	4225	13240108.54	30.19
2018-04-29	1.07	43856759	4770	744030.09	1.70
2018-04-29	1.07	43856759	Large.Bags	4208203.84	9.60
2018-04-29	1.07	43856759	Small.Bags	11122006.81	25.36
2018-04-29	1.07	43856759	Total.Bags	15618583.41	35.61
2018-04-29	1.07	43856759	XLarge.Bags	288372.76	0.66
2018-05-06	0.89	63716144	4046	21137400.46	33.17
2018-05-06	0.89	63716144	4225	19900871.87	31.23
2018-05-06	0.89	63716144	4770	1052499.15	1.65
2018-05-06	0.89	63716144	Large.Bags	5840414.83	9.17
2018-05-06	0.89	63716144	Small.Bags	15436246.72	24.23
2018-05-06	0.89	63716144	Total.Bags	21625372.67	33.94
2018-05-06	0.89	63716144	XLarge.Bags	348711.12	0.55
2018-05-13	1.00	46371246	4046	15432480.06	33.28
2018-05-13	1.00	46371246	4225	12367251.74	26.67
2018-05-13	1.00	46371246	4770	759855.73	1.64
2018-05-13	1.00	46371246	Large.Bags	4432536.78	9.56
2018-05-13	1.00	46371246	Small.Bags	13110016.21	28.27
2018-05-13	1.00	46371246	Total.Bags	17811658.31	38.41
2018-05-13	1.00	46371246	XLarge.Bags	269105.32	0.58
2018-05-20	1.02	44458798	4046	15391298.20	34.62
2018-05-20	1.02	44458798	4225	12092088.69	27.20
2018-05-20	1.02	44458798	4770	736111.95	1.66
2018-05-20	1.02	44458798	Large.Bags	4549192.20	10.23
2018-05-20	1.02	44458798	Small.Bags	11427676.19	25.70
2018-05-20	1.02	44458798	Total.Bags	16239299.46	36.53
2018-05-20	1.02	44458798	XLarge.Bags	262431.07	0.59
2018-05-27	1.03	47105314	4046	15644843.58	33.21
2018-05-27	1.03	47105314	4225	13548819.31	28.76
2018-05-27	1.03	47105314	4770	793658.51	1.68
2018-05-27	1.03	47105314	Large.Bags	5229855.39	11.10
2018-05-27	1.03	47105314	Small.Bags	11620663.52	24.67
2018-05-27	1.03	47105314	Total.Bags	17117992.88	36.34
2018-05-27	1.03	47105314	XLarge.Bags	267473.97	0.57
2018-06-03	1.07	44705039	4046	15241658.25	34.09
2018-06-03	1.07	44705039	4225	12611264.58	28.21
2018-06-03	1.07	44705039	4770	828737.97	1.85
2018-06-03	1.07	44705039	Large.Bags	4684090.46	10.48
2018-06-03	1.07	44705039	Small.Bags	11035193.03	24.68
2018-06-03	1.07	44705039	Total.Bags	16023378.25	35.84
2018-06-03	1.07	44705039	XLarge.Bags	304094.76	0.68
2018-06-10	1.03	45613372	4046	15949807.24	34.97
2018-06-10	1.03	45613372	4225	13691955.59	30.02
2018-06-10	1.03	45613372	4770	753786.21	1.65
2018-06-10	1.03	45613372	Large.Bags	3724800.50	8.17
2018-06-10	1.03	45613372	Small.Bags	11228599.99	24.62
2018-06-10	1.03	45613372	Total.Bags	15217823.38	33.36
2018-06-10	1.03	45613372	XLarge.Bags	264422.89	0.58
2018-06-17	1.09	44009085	4046	14909830.72	33.88
2018-06-17	1.09	44009085	4225	12904472.84	29.32
2018-06-17	1.09	44009085	4770	782043.10	1.78
2018-06-17	1.09	44009085	Large.Bags	3707918.88	8.43
2018-06-17	1.09	44009085	Small.Bags	11486168.32	26.10
2018-06-17	1.09	44009085	Total.Bags	15412738.12	35.02
2018-06-17	1.09	44009085	XLarge.Bags	218650.92	0.50
2018-06-24	1.04	44742750	4046	14643774.28	32.73
2018-06-24	1.04	44742750	4225	12717017.35	28.42
2018-06-24	1.04	44742750	4770	1110724.00	2.48
2018-06-24	1.04	44742750	Large.Bags	4262204.76	9.53
2018-06-24	1.04	44742750	Small.Bags	11708299.17	26.17
2018-06-24	1.04	44742750	Total.Bags	16271234.25	36.37
2018-06-24	1.04	44742750	XLarge.Bags	300730.32	0.67
2018-07-01	1.05	45572739	4046	14978439.61	32.87
2018-07-01	1.05	45572739	4225	12542937.62	27.52
2018-07-01	1.05	45572739	4770	969238.95	2.13
2018-07-01	1.05	45572739	Large.Bags	4934540.62	10.83
2018-07-01	1.05	45572739	Small.Bags	11945298.31	26.21
2018-07-01	1.05	45572739	Total.Bags	17082122.99	37.48
2018-07-01	1.05	45572739	XLarge.Bags	202284.06	0.44
2018-07-08	1.03	47848190	4046	14624443.74	30.56
2018-07-08	1.03	47848190	4225	14184132.58	29.64
2018-07-08	1.03	47848190	4770	1169255.61	2.44
2018-07-08	1.03	47848190	Large.Bags	4735852.45	9.90
2018-07-08	1.03	47848190	Small.Bags	12817172.90	26.79
2018-07-08	1.03	47848190	Total.Bags	17870357.86	37.35
2018-07-08	1.03	47848190	XLarge.Bags	317332.51	0.66
2018-07-15	1.07	43126773	4046	13457479.92	31.20
2018-07-15	1.07	43126773	4225	12125207.59	28.12
2018-07-15	1.07	43126773	4770	908599.10	2.11
2018-07-15	1.07	43126773	Large.Bags	4460656.29	10.34
2018-07-15	1.07	43126773	Small.Bags	11924570.43	27.65
2018-07-15	1.07	43126773	Total.Bags	16635486.61	38.57
2018-07-15	1.07	43126773	XLarge.Bags	250259.89	0.58
2018-08-19	1.13	40735733	4046	12009246.19	29.48
2018-08-19	1.13	40735733	4225	11634725.16	28.56
2018-08-19	1.13	40735733	4770	1116318.45	2.74
2018-08-19	1.13	40735733	Large.Bags	4500204.69	11.05
2018-08-19	1.13	40735733	Small.Bags	11055173.29	27.14
2018-08-19	1.13	40735733	Total.Bags	15975442.88	39.22
2018-08-19	1.13	40735733	XLarge.Bags	420064.90	1.03
2018-08-26	1.22	36867975	4046	11171123.21	30.30
2018-08-26	1.22	36867975	4225	11286479.97	30.61
2018-08-26	1.22	36867975	4770	699010.18	1.90
2018-08-26	1.22	36867975	Large.Bags	3930111.90	10.66
2018-08-26	1.22	36867975	Small.Bags	9484135.03	25.72
2018-08-26	1.22	36867975	Total.Bags	13711361.22	37.19
2018-08-26	1.22	36867975	XLarge.Bags	297114.29	0.81
2018-09-02	1.29	36169162	4046	10916802.88	30.18
2018-09-02	1.29	36169162	4225	10880826.30	30.08
2018-09-02	1.29	36169162	4770	777527.98	2.15
2018-09-02	1.29	36169162	Large.Bags	3485418.35	9.64
2018-09-02	1.29	36169162	Small.Bags	9783860.21	27.05
2018-09-02	1.29	36169162	Total.Bags	13594004.41	37.58
2018-09-02	1.29	36169162	XLarge.Bags	324725.85	0.90
2018-09-09	1.24	37484254	4046	11028194.47	29.42
2018-09-09	1.24	37484254	4225	11898526.09	31.74
2018-09-09	1.24	37484254	4770	859246.52	2.29
2018-09-09	1.24	37484254	Large.Bags	3505978.13	9.35
2018-09-09	1.24	37484254	Small.Bags	9876854.43	26.35
2018-09-09	1.24	37484254	Total.Bags	13698286.67	36.54
2018-09-09	1.24	37484254	XLarge.Bags	315454.11	0.84
2018-09-16	1.22	35609955	4046	11598586.86	32.57
2018-09-16	1.22	35609955	4225	9716277.38	27.29
2018-09-16	1.22	35609955	4770	743851.12	2.09
2018-09-16	1.22	35609955	Large.Bags	3684646.74	10.35
2018-09-16	1.22	35609955	Small.Bags	9562607.70	26.85
2018-09-16	1.22	35609955	Total.Bags	13551240.03	38.05
2018-09-16	1.22	35609955	XLarge.Bags	303985.59	0.85
2018-09-23	1.19	34866282	4046	10635595.44	30.50
2018-09-23	1.19	34866282	4225	10368078.03	29.74
2018-09-23	1.19	34866282	4770	644554.31	1.85
2018-09-23	1.19	34866282	Large.Bags	3294142.37	9.45
2018-09-23	1.19	34866282	Small.Bags	9638333.84	27.64
2018-09-23	1.19	34866282	Total.Bags	13218054.50	37.91
2018-09-23	1.19	34866282	XLarge.Bags	285578.29	0.82
2018-09-30	1.10	37588534	4046	11693993.09	31.11
2018-09-30	1.10	37588534	4225	10028231.18	26.68
2018-09-30	1.10	37588534	4770	659678.66	1.75
2018-09-30	1.10	37588534	Large.Bags	3869002.42	10.29
2018-09-30	1.10	37588534	Small.Bags	11080362.15	29.48
2018-09-30	1.10	37588534	Total.Bags	15206631.23	40.46
2018-09-30	1.10	37588534	XLarge.Bags	257266.66	0.68
2018-10-07	1.08	38061760	4046	11931876.96	31.35
2018-10-07	1.08	38061760	4225	10220788.39	26.85
2018-10-07	1.08	38061760	4770	794611.30	2.09
2018-10-07	1.08	38061760	Large.Bags	3792435.33	9.96
2018-10-07	1.08	38061760	Small.Bags	11085671.50	29.13
2018-10-07	1.08	38061760	Total.Bags	15114483.01	39.71
2018-10-07	1.08	38061760	XLarge.Bags	236376.18	0.62
2018-10-14	1.08	36869560	4046	11397965.02	30.91
2018-10-14	1.08	36869560	4225	10293294.29	27.92
2018-10-14	1.08	36869560	4770	599007.52	1.62
2018-10-14	1.08	36869560	Large.Bags	3928694.16	10.66
2018-10-14	1.08	36869560	Small.Bags	10460714.07	28.37
2018-10-14	1.08	36869560	Total.Bags	14579293.56	39.54
2018-10-14	1.08	36869560	XLarge.Bags	189885.33	0.52
2018-10-21	1.13	34002535	4046	10104600.64	29.72
2018-10-21	1.13	34002535	4225	9817026.08	28.87
2018-10-21	1.13	34002535	4770	530698.97	1.56
2018-10-21	1.13	34002535	Large.Bags	3463120.27	10.18
2018-10-21	1.13	34002535	Small.Bags	9914169.64	29.16
2018-10-21	1.13	34002535	Total.Bags	13550209.00	39.85
2018-10-21	1.13	34002535	XLarge.Bags	172919.09	0.51
2018-10-28	1.01	39402227	4046	12142265.30	30.82
2018-10-28	1.01	39402227	4225	10845124.43	27.52
2018-10-28	1.01	39402227	4770	549490.79	1.39
2018-10-28	1.01	39402227	Large.Bags	4320344.50	10.96
2018-10-28	1.01	39402227	Small.Bags	11437562.67	29.03
2018-10-28	1.01	39402227	Total.Bags	15865346.06	40.27
2018-10-28	1.01	39402227	XLarge.Bags	107438.89	0.27
2018-11-04	1.01	38363283	4046	12420772.32	32.38
2018-11-04	1.01	38363283	4225	10192035.49	26.57
2018-11-04	1.01	38363283	4770	528277.90	1.38
2018-11-04	1.01	38363283	Large.Bags	4538743.36	11.83
2018-11-04	1.01	38363283	Small.Bags	10602848.85	27.64
2018-11-04	1.01	38363283	Total.Bags	15222197.02	39.68
2018-11-04	1.01	38363283	XLarge.Bags	80604.81	0.21
2018-11-11	1.00	39042283	4046	13355863.68	34.21
2018-11-11	1.00	39042283	4225	10385141.10	26.60
2018-11-11	1.00	39042283	4770	603032.80	1.54
2018-11-11	1.00	39042283	Large.Bags	3865596.48	9.90
2018-11-11	1.00	39042283	Small.Bags	10721367.16	27.46
2018-11-11	1.00	39042283	Total.Bags	14698245.76	37.65
2018-11-11	1.00	39042283	XLarge.Bags	111282.12	0.29
2018-11-18	1.14	29871135	4046	9719228.92	32.54
2018-11-18	1.14	29871135	4225	7271528.37	24.34
2018-11-18	1.14	29871135	4770	497404.35	1.67
2018-11-18	1.14	29871135	Large.Bags	3103022.56	10.39
2018-11-18	1.14	29871135	Small.Bags	9174635.04	30.71
2018-11-18	1.14	29871135	Total.Bags	12382973.38	41.45
2018-11-18	1.14	29871135	XLarge.Bags	105315.78	0.35
2018-11-25	1.25	21855494	4046	7140335.30	32.67
2018-11-25	1.25	21855494	4225	6021450.19	27.55
2018-11-25	1.25	21855494	4770	402865.82	1.84
2018-11-25	1.25	21855494	Large.Bags	2183010.88	9.99
2018-11-25	1.25	21855494	Small.Bags	6016142.82	27.53
2018-11-25	1.25	21855494	Total.Bags	8290842.38	37.93
2018-11-25	1.25	21855494	XLarge.Bags	91688.68	0.42
2018-12-02	1.22	27652426	4046	9516477.21	34.41
2018-12-02	1.22	27652426	4225	7462865.75	26.99
2018-12-02	1.22	27652426	4770	521910.02	1.89
2018-12-02	1.22	27652426	Large.Bags	2895343.32	10.47
2018-12-02	1.22	27652426	Small.Bags	7174281.40	25.94
2018-12-02	1.22	27652426	Total.Bags	10151172.64	36.71
2018-12-02	1.22	27652426	XLarge.Bags	81547.92	0.29

#Sum volume and soldCount by Month and Type for each avocado type
avocadoPrices6 <- avocadoPrices3 %>% 
  group_by(Month, Type) %>% 
  summarise_all(funs(sum))

#Calculate monthly percent sold of each type
avocadoPrices7 <- avocadoPrices6 %>% 
        mutate(soldPercent = round(soldCount / Total.Volume * 100, 2))

avocadoPrices7  %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

Month	Type	Total.Volume	soldCount	soldPercent
01	4046	157114564	55102554.32	35.07
01	4225	157114564	48697123.78	30.99
01	4770	157114564	2835313.12	1.80
01	Large.Bags	157114564	13879337.37	8.83
01	Small.Bags	157114564	35975638.58	22.90
01	XLarge.Bags	157114564	624597.16	0.40
02	4046	182404869	64583467.89	35.41
02	4225	182404869	52894727.93	29.00
02	4770	182404869	2996986.69	1.64
02	Large.Bags	182404869	16975136.79	9.31
02	Small.Bags	182404869	43919733.48	24.08
02	XLarge.Bags	182404869	1034816.08	0.57
03	4046	165986967	56366827.12	33.96
03	4225	165986967	45234109.93	27.25
03	4770	165986967	2683508.51	1.62
03	Large.Bags	165986967	14101602.71	8.50
03	Small.Bags	165986967	46478870.71	28.00
03	XLarge.Bags	165986967	1122048.06	0.68
04	4046	219343172	70961934.12	32.35
04	4225	219343172	63541382.66	28.97
04	4770	219343172	3831494.87	1.75
04	Large.Bags	219343172	21549113.49	9.82
04	Small.Bags	219343172	58031196.85	26.46
04	XLarge.Bags	219343172	1428050.38	0.65
05	4046	201651503	67606022.30	33.53
05	4225	201651503	57909031.61	28.72
05	4770	201651503	3342125.34	1.66
05	Large.Bags	201651503	20051999.20	9.94
05	Small.Bags	201651503	51594602.64	25.59
05	XLarge.Bags	201651503	1147721.48	0.57
06	4046	179070246	60745070.49	33.92
06	4225	179070246	51924710.36	29.00
06	4770	179070246	3475291.28	1.94
06	Large.Bags	179070246	16379014.60	9.15
06	Small.Bags	179070246	45458260.51	25.39
06	XLarge.Bags	179070246	1087898.89	0.61
07	4046	136547702	43060363.27	31.54
07	4225	136547702	38852277.79	28.45
07	4770	136547702	3047093.66	2.23
07	Large.Bags	136547702	14131049.36	10.35
07	Small.Bags	136547702	36687041.64	26.87
07	XLarge.Bags	136547702	769876.46	0.56
08	4046	77603707	23180369.40	29.87
08	4225	77603707	22921205.13	29.54
08	4770	77603707	1815328.63	2.34
08	Large.Bags	77603707	8430316.59	10.86
08	Small.Bags	77603707	20539308.32	26.47
08	XLarge.Bags	77603707	717179.19	0.92
09	4046	181718187	55873172.74	30.75
09	4225	181718187	52891938.98	29.11
09	4770	181718187	3684858.59	2.03
09	Large.Bags	181718187	17839188.01	9.82
09	Small.Bags	181718187	49942018.33	27.48
09	XLarge.Bags	181718187	1487010.50	0.82
10	4046	148336081	45576707.92	30.73
10	4225	148336081	41176233.19	27.76
10	4770	148336081	2473808.58	1.67
10	Large.Bags	148336081	15504594.26	10.45
10	Small.Bags	148336081	42898117.88	28.92
10	XLarge.Bags	148336081	706619.49	0.48
11	4046	129132195	42636200.22	33.02
11	4225	129132195	33870155.15	26.23
11	4770	129132195	2031580.87	1.57
11	Large.Bags	129132195	13690373.28	10.60
11	Small.Bags	129132195	36514993.87	28.28
11	XLarge.Bags	129132195	388891.39	0.30
12	4046	27652426	9516477.21	34.41
12	4225	27652426	7462865.75	26.99
12	4770	27652426	521910.02	1.89
12	Large.Bags	27652426	2895343.32	10.47
12	Small.Bags	27652426	7174281.40	25.94
12	XLarge.Bags	27652426	81547.92	0.29

#Remove month column
avocadoSummary <- subset(avocadoPrices3, select = c("Type", "soldCount"))

#Sum volume and soldCount byType
avocadoSummary2 <- ddply(avocadoSummary, "Type", numcolwise(sum))
total = sum(avocadoSummary2$soldCount)

#Calculate overall percentage of each type sold
avocadoSummary3 <- avocadoSummary2 %>%
        mutate(soldPercent = round(soldCount / total * 100, 2)) %>%
        arrange(desc(soldPercent))

avocadoSummary3 %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed"))

Type	soldCount	soldPercent
4046	595209167	32.95
4225	517375762	28.64
Small.Bags	475214064	26.30
Large.Bags	175427069	9.71
4770	32739300	1.81
XLarge.Bags	10596257	0.59

Visualize Data

plot <- ggplot(avocadoSummary3, aes(y = soldPercent, x =Type, color =Type, fill = Type)) + 
    geom_bar( stat = "identity") +
    geom_text(aes(label = soldPercent), vjust = -.3) +
    ggtitle("Avocado Sales Percentages") +
    labs(y = "Percentage sold") 

plot

plot1 <- ggplot(avocadoPrices2, aes(x=Date, y=AveragePrice, colour = AveragePrice)) + 
  geom_point() +
  theme(axis.text.x = element_text(angle = 45, hjust = 1)) +
  theme(axis.text.x=element_text(size=8)) +
  ggtitle("Average Price through 2018")

plot1

#Prices are low from late January through July and then rise

plot2 <- ggplot(avocadoPrices2, aes(x=Total.Volume, y=AveragePrice, colour = AveragePrice)) + 
  geom_point() +
  ggtitle("Average Price vs. Volume")

plot2

#Average price and volume have an indirect relationship - as volume increases, price decreases

plot3 <- ggplot(avocadoPrices7, aes(x = Month, y = soldPercent, fill = Type, label = soldPercent)) +
  geom_bar(stat = "identity", width = 0.95, position = "stack") +
  geom_text(size = 3, position = position_stack(vjust = 0.5)) +
  ggtitle("Month Sales Percentages")

plot3

#4046 avocados are the most popular type sold while large bags are the least popular sold.

Conclusion

This analysis on 2018 avocado retail scan data revealed many insights. Overall, avocados with PLU 4046 were most popularly purchased (32.95%), followed by 4225 (28.64%), small bags (26.3%), large bags (9.71%), 4770 (1.81%), and x-large bags (0.59%). Comparing the monthly percentages of each avocado type sold revealed that popularity ranking did not change. Average price and volume had an indirect relationship. Average price was lowest from late January through July and ranged from $1.00 - $1.10.

Color and Heat Absorption

This dataset was submitted by Christopher Ayre. He helped his daughter on a project for the science fair. For their experiment, they placed thermometers in 5 different color t-shirts and recorded the temperatures at 10 minute intervals for 1 hour as the garments were exposed to heat. The heater was turned off, and the temperatures measured again at 10 minute intervals as the garments cooled. This data can be used to analyze the rate at which different colors absorb and release heat.

Requested analysis:

The table is wide and does not meet the criteria for tidy data:

Multiple types of observational units are stored in the same table

Separate table for heating and cooling

The variable of elapsed time does not have its own column

Create time column

Tidy Data

#Read in data
absorption <- read.csv("https://raw.githubusercontent.com/KatherineEvers/607-Project-2/master/science%20proj%20data.csv")

#Rename columns
colnames(absorption) <- c("Color", 0, 10, 20, 30, 40, 50, 60, "Phase")

absorption1 <- absorption %>%
  #separate data into minutes and temperature columns
  gather(Minutes, Temperature, 2:8 ) %>%
  #spread color into separate columns
  spread(1,4)

#Create separate tables for heating and cooling
cooling <- subset(absorption1, Phase == "cooling")

cooling %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

Phase	Minutes	black	green	pink	red	white
cooling	0	121	105	102	109	98
cooling	10	108	94	96	106	96
cooling	20	98	90	90	95	93
cooling	30	90	82	83	87	80
cooling	40	84	80	80	82	78
cooling	50	79	78	78	80	78
cooling	60	78	78	78	78	78

heating <- subset(absorption1, Phase == "heating")

heating %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

	Phase	Minutes	black	green	pink	red	white
8	heating	0	78	78	78	78	78
9	heating	10	88	81	82	82	81
10	heating	20	92	85	84	90	83
11	heating	30	98	91	90	93	88
12	heating	40	108	95	96	98	93
13	heating	50	116	102	99	106	96
14	heating	60	121	105	102	109	98

Analyze Data

#Calculate temperature rate of change for cooling
cooling1 <- cooling %>%
   mutate(blackPctChange = (lead(black)/black - 1) * 100) %>%
   mutate(greenPctChange = (lead(green)/green - 1) * 100) %>%
   mutate(pinkPctChange = (lead(pink)/pink - 1) * 100) %>%
   mutate(redPctChange = (lead(red)/red - 1) * 100) %>%
   mutate(whitePctChange = (lead(white)/white - 1) * 100) 

#Remove row with NA
cooling1 <- cooling1 [!is.na(cooling1$blackPctChange), ]

cooling1 %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

Phase	Minutes	black	green	pink	red	white	blackPctChange	greenPctChange	pinkPctChange	redPctChange	whitePctChange
cooling	0	121	105	102	109	98	-10.743802	-10.476190	-5.882353	-2.752294	-2.040816
cooling	10	108	94	96	106	96	-9.259259	-4.255319	-6.250000	-10.377358	-3.125000
cooling	20	98	90	90	95	93	-8.163265	-8.888889	-7.777778	-8.421053	-13.978495
cooling	30	90	82	83	87	80	-6.666667	-2.439024	-3.614458	-5.747126	-2.500000
cooling	40	84	80	80	82	78	-5.952381	-2.500000	-2.500000	-2.439024	0.000000
cooling	50	79	78	78	80	78	-1.265823	0.000000	0.000000	-2.500000	0.000000

#Calculate temperature rate of change for heating
heating1 <- heating %>%
   mutate(blackPctChange = (lead(black)/black - 1) * 100) %>%
   mutate(greenPctChange = (lead(green)/green - 1) * 100) %>%
   mutate(pinkPctChange = (lead(pink)/pink - 1) * 100) %>%
   mutate(redPctChange = (lead(red)/red - 1) * 100) %>%
   mutate(whitePctChange = (lead(white)/white - 1) * 100) 

#Remove row with NA
heating1 <- heating1[!is.na(heating1$blackPctChange), ]

heating1 %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

	Phase	Minutes	black	green	pink	red	white	blackPctChange	greenPctChange	pinkPctChange	redPctChange	whitePctChange
8	heating	0	78	78	78	78	78	12.820513	3.846154	5.128205	5.128205	3.846154
9	heating	10	88	81	82	82	81	4.545454	4.938272	2.439024	9.756098	2.469136
10	heating	20	92	85	84	90	83	6.521739	7.058823	7.142857	3.333333	6.024096
11	heating	30	98	91	90	93	88	10.204082	4.395604	6.666667	5.376344	5.681818
12	heating	40	108	95	96	98	93	7.407407	7.368421	3.125000	8.163265	3.225807
13	heating	50	116	102	99	106	96	4.310345	2.941177	3.030303	2.830189	2.083333

#Calculate overall cooling temperature change percentage
blackCooling <- round((last(cooling$black) - first(cooling$black)) / last(cooling$black),2)
greenCooling <- round((last(cooling$green) - first(cooling$green)) / last(cooling$green),2)
pinkCooling <- round((last(cooling$pink) - first(cooling$pink)) / last(cooling$pink),2)
redCooling <- round((last(cooling$red) - first(cooling$red)) / last(cooling$red),2)
whiteCooling <- round((last(cooling$white) - first(cooling$white)) / last(cooling$white),2)

coolingPct <- c(blackCooling, greenCooling, pinkCooling, redCooling, whiteCooling)
colors <- c("Black", "Green", "Pink", "Red", "White")

#Calculate overall heating temperature change percentage
blackHeating <- round((last(heating$black) - first(heating$black)) / last(heating$black),2)
greenHeating <- round((last(heating$green) - first(heating$green)) / last(heating$green),2)
pinkHeating <- round((last(heating$pink) - first(heating$pink)) / last(heating$pink),2)
redHeating <- round((last(heating$red) - first(heating$red)) / last(heating$red),2)
whiteHeating <- round((last(heating$white) - first(heating$white)) / last(heating$white),2)

heatingPct <- c(blackHeating, greenHeating, pinkHeating, redHeating, whiteHeating)

Visualize Data

col <- c( "black", "green","pink", "red", "white")
barplot(heatingPct, names.arg = colors, col = col, main = "Overall Heating Temperature Change Rate")

barplot(coolingPct, names.arg = colors, col = col, main = "Overall Cooling Temperature Change Rate")

heatingPlot <- ggplot(heating, aes(x = Minutes, group = 1)) + 
  geom_point(aes(y = black, colour= "black")) +
  geom_line(aes(y = black, colour= "black")) +
  geom_point(aes(y = green, colour= "green")) +
  geom_line(aes(y = green, colour= "green")) +
  geom_point(aes(y = pink, colour= "pink")) +
  geom_line(aes(y = pink, colour= "pink")) +
  geom_point(aes(y = red, colour = "red")) +
  geom_line(aes(y = red, colour= "red")) +
  geom_point(aes(y = white, colour= "white")) +
  geom_line(aes(y = white, colour= "white")) +
  scale_color_manual(values=c( "black", "green","pink", "red", "white")) +
  labs(y = "Temperature (F)") +
  ggtitle("Heating: T-Shirt Temperature")

heatingPlot

coolingPlot <- ggplot(cooling, aes(x = Minutes, group = 1)) + 
  geom_point(aes(y = black, colour= "black")) +
  geom_line(aes(y = black, colour= "black")) +
  geom_point(aes(y = green, colour= "green")) +
  geom_line(aes(y = green, colour= "green")) +
  geom_point(aes(y = pink, colour= "pink")) +
  geom_line(aes(y = pink, colour= "pink")) +
  geom_point(aes(y = red, colour = "red")) +
  geom_line(aes(y = red, colour= "red")) +
  geom_point(aes(y = white, colour= "white")) +
  geom_line(aes(y = white, colour= "white")) +
  scale_color_manual(values=c( "black", "green","pink", "red", "white")) +
  labs(y = "Temperature (F)") +
  ggtitle("Cooling: T-Shirt Temperature") 

coolingPlot

heatingPlot1 <- ggplot(heating1, aes(x = Minutes, group = 1)) + 
  geom_point(aes(y = blackPctChange, colour= "black")) +
  geom_line(aes(y = blackPctChange, colour= "black")) +
  geom_point(aes(y = greenPctChange, colour= "green")) +
  geom_line(aes(y = greenPctChange, colour= "green")) +
  geom_point(aes(y = pinkPctChange, colour= "pink")) +
  geom_line(aes(y = pinkPctChange, colour= "pink")) +
  geom_point(aes(y = redPctChange, colour = "red")) +
  geom_line(aes(y = redPctChange, colour= "red")) +
  geom_point(aes(y = whitePctChange, colour= "white")) +
  geom_line(aes(y = whitePctChange, colour= "white")) +
  scale_color_manual(values=c( "black", "green","pink", "red", "white")) +
  labs(y = "Percentage change") +
  ggtitle("Heating: Temperature Change Rate")

heatingPlot1

coolingPlot1 <- ggplot(cooling1, aes(x = Minutes, group = 1)) + 
  geom_point(aes(y = blackPctChange, colour= "black")) +
  geom_line(aes(y = blackPctChange, colour= "black")) +
  geom_point(aes(y = greenPctChange, colour= "green")) +
  geom_line(aes(y = greenPctChange, colour= "green")) +
  geom_point(aes(y = pinkPctChange, colour= "pink")) +
  geom_line(aes(y = pinkPctChange, colour= "pink")) +
  geom_point(aes(y = redPctChange, colour = "red")) +
  geom_line(aes(y = redPctChange, colour= "red")) +
  geom_point(aes(y = whitePctChange, colour= "white")) +
  geom_line(aes(y = whitePctChange, colour= "white")) +
  scale_color_manual(values=c( "black", "green","pink", "red", "white")) +
  labs(y = "Percentage change") +
  ggtitle("Cooling: Temperature Change Rate")

coolingPlot1

Conclusion

From the plots, we see that black had the greatest heating and cooling temperature change rate and temperatures while white had the smallest. In general, the largest rate of temperature change occurred in the first 0 to 10 minutes.

2010-2018 Census Data

Arun Reddy found a census dataset for United States and Puerto Rico population for 2010 to 2018. The dataset gives population metrics such as estimated population, change in population from the estimate, and national rank in population for each year from 2010 to 2018.

Requested analysis:

This is a good example of untidy data can be cleansed and make it more presentable. The following steps can be performed to cleanse the data.

All the 4 metrics by years are spread out by column-wise can be changed into rows.
Row names/Column name which includes the year as a concatenation can be well formatted to make more readable.
Some of the column names don’t have the right data type like population change, national rank is factorial data type which is unnecessary.

Tidy Data

#Read in data
population <- read.csv("https://raw.githubusercontent.com/KatherineEvers/607-Project-2/master/Population%20DataSet.csv")

#Remove unneccessary identification columns
population1 <- population[,6:62]

#Let's focus on individual states and DC (Exclude entire US, territories, and Puerto Rico)
population1 <- population1[!population1$NAME == "United States",]
population1 <- population1[!population1$NAME == "Northeast Region",]
population1 <- population1[!population1$NAME == "Midwest Region",]
population1 <- population1[!population1$NAME == "South Region",]
population1 <- population1[!population1$NAME == "West Region",]
population1 <- population1[!population1$NAME == "Puerto Rico",]

#rename column
colnames(population1)[1] <- "State"

population2 <- population1 %>%
  #separate data into metric and value columns
  gather(Metric, Value, 2:57 )

## Warning: attributes are not identical across measure variables;
## they will be dropped

#Create vector of years
Year <- as.numeric(str_extract(population2$Metric, "([0-9]{4})"))
#Remove year from metric description
population2$Metric <- gsub("([0-9])|(_)","",population2$Metric)

#Add year as column to datafram
population3 <- cbind(Year, population2)

population3 %>% 
  kable() %>% 
  kable_styling(bootstrap_options = c("striped", "hover", "condensed")) %>%
  scroll_box(width = "100%", height = "200px")

Year	State	Metric	Value
2010	Alabama	ESTIMATESBASE	4780138
2010	Alaska	ESTIMATESBASE	710249
2010	Arizona	ESTIMATESBASE	6392288
2010	Arkansas	ESTIMATESBASE	2916028
2010	California	ESTIMATESBASE	37254523
2010	Colorado	ESTIMATESBASE	5029316
2010	Connecticut	ESTIMATESBASE	3574147
2010	Delaware	ESTIMATESBASE	897934
2010	District of Columbia	ESTIMATESBASE	601766
2010	Florida	ESTIMATESBASE	18804580
2010	Georgia	ESTIMATESBASE	9688709
2010	Hawaii	ESTIMATESBASE	1360307
2010	Idaho	ESTIMATESBASE	1567657
2010	Illinois	ESTIMATESBASE	12831572
2010	Indiana	ESTIMATESBASE	6484061
2010	Iowa	ESTIMATESBASE	3046872
2010	Kansas	ESTIMATESBASE	2853126
2010	Kentucky	ESTIMATESBASE	4339333
2010	Louisiana	ESTIMATESBASE	4533485
2010	Maine	ESTIMATESBASE	1328369
2010	Maryland	ESTIMATESBASE	5773798
2010	Massachusetts	ESTIMATESBASE	6547790
2010	Michigan	ESTIMATESBASE	9884117
2010	Minnesota	ESTIMATESBASE	5303925
2010	Mississippi	ESTIMATESBASE	2968118
2010	Missouri	ESTIMATESBASE	5988952
2010	Montana	ESTIMATESBASE	989409
2010	Nebraska	ESTIMATESBASE	1826305
2010	Nevada	ESTIMATESBASE	2700679
2010	New Hampshire	ESTIMATESBASE	1316464
2010	New Jersey	ESTIMATESBASE	8791962
2010	New Mexico	ESTIMATESBASE	2059180
2010	New York	ESTIMATESBASE	19378124
2010	North Carolina	ESTIMATESBASE	9535736
2010	North Dakota	ESTIMATESBASE	672576
2010	Ohio	ESTIMATESBASE	11536757
2010	Oklahoma	ESTIMATESBASE	3751583
2010	Oregon	ESTIMATESBASE	3831075
2010	Pennsylvania	ESTIMATESBASE	12702873
2010	Rhode Island	ESTIMATESBASE	1052957
2010	South Carolina	ESTIMATESBASE	4625381
2010	South Dakota	ESTIMATESBASE	814198
2010	Tennessee	ESTIMATESBASE	6346286
2010	Texas	ESTIMATESBASE	25146114
2010	Utah	ESTIMATESBASE	2763891
2010	Vermont	ESTIMATESBASE	625744
2010	Virginia	ESTIMATESBASE	8001055
2010	Washington	ESTIMATESBASE	6724540
2010	West Virginia	ESTIMATESBASE	1853001
2010	Wisconsin	ESTIMATESBASE	5687282
2010	Wyoming	ESTIMATESBASE	563773
2010	Alabama	POPESTIMATE	4785448
2010	Alaska	POPESTIMATE	713906
2010	Arizona	POPESTIMATE	6407774
2010	Arkansas	POPESTIMATE	2921978
2010	California	POPESTIMATE	37320903
2010	Colorado	POPESTIMATE	5048281
2010	Connecticut	POPESTIMATE	3579125
2010	Delaware	POPESTIMATE	899595
2010	District of Columbia	POPESTIMATE	605085
2010	Florida	POPESTIMATE	18845785
2010	Georgia	POPESTIMATE	9711810
2010	Hawaii	POPESTIMATE	1363963
2010	Idaho	POPESTIMATE	1570773
2010	Illinois	POPESTIMATE	12840762
2010	Indiana	POPESTIMATE	6490436
2010	Iowa	POPESTIMATE	3050767
2010	Kansas	POPESTIMATE	2858213
2010	Kentucky	POPESTIMATE	4348200
2010	Louisiana	POPESTIMATE	4544532
2010	Maine	POPESTIMATE	1327632
2010	Maryland	POPESTIMATE	5788642
2010	Massachusetts	POPESTIMATE	6566431
2010	Michigan	POPESTIMATE	9877535
2010	Minnesota	POPESTIMATE	5310843
2010	Mississippi	POPESTIMATE	2970536
2010	Missouri	POPESTIMATE	5995976
2010	Montana	POPESTIMATE	990722
2010	Nebraska	POPESTIMATE	1829536
2010	Nevada	POPESTIMATE	2702464
2010	New Hampshire	POPESTIMATE	1316777
2010	New Jersey	POPESTIMATE	8799624
2010	New Mexico	POPESTIMATE	2064588
2010	New York	POPESTIMATE	19400080
2010	North Carolina	POPESTIMATE	9574293
2010	North Dakota	POPESTIMATE	674710
2010	Ohio	POPESTIMATE	11539327
2010	Oklahoma	POPESTIMATE	3759632
2010	Oregon	POPESTIMATE	3837532
2010	Pennsylvania	POPESTIMATE	12711158
2010	Rhode Island	POPESTIMATE	1053938
2010	South Carolina	POPESTIMATE	4635656
2010	South Dakota	POPESTIMATE	816165
2010	Tennessee	POPESTIMATE	6355301
2010	Texas	POPESTIMATE	25242679
2010	Utah	POPESTIMATE	2775334
2010	Vermont	POPESTIMATE	625880
2010	Virginia	POPESTIMATE	8023680
2010	Washington	POPESTIMATE	6742902
2010	West Virginia	POPESTIMATE	1854214
2010	Wisconsin	POPESTIMATE	5690479
2010	Wyoming	POPESTIMATE	564483
2011	Alabama	POPESTIMATE	4798834
2011	Alaska	POPESTIMATE	722038
2011	Arizona	POPESTIMATE	6473497
2011	Arkansas	POPESTIMATE	2940407
2011	California	POPESTIMATE	37641823
2011	Colorado	POPESTIMATE	5121771
2011	Connecticut	POPESTIMATE	3588023
2011	Delaware	POPESTIMATE	907316
2011	District of Columbia	POPESTIMATE	619602
2011	Florida	POPESTIMATE	19093352
2011	Georgia	POPESTIMATE	9801578
2011	Hawaii	POPESTIMATE	1379252
2011	Idaho	POPESTIMATE	1583828
2011	Illinois	POPESTIMATE	12867291
2011	Indiana	POPESTIMATE	6516045
2011	Iowa	POPESTIMATE	3066054
2011	Kansas	POPESTIMATE	2869035
2011	Kentucky	POPESTIMATE	4369488
2011	Louisiana	POPESTIMATE	4575184
2011	Maine	POPESTIMATE	1328150
2011	Maryland	POPESTIMATE	5838991
2011	Massachusetts	POPESTIMATE	6613149
2011	Michigan	POPESTIMATE	9881521
2011	Minnesota	POPESTIMATE	5345668
2011	Mississippi	POPESTIMATE	2978470
2011	Missouri	POPESTIMATE	6009641
2011	Montana	POPESTIMATE	997221
2011	Nebraska	POPESTIMATE	1840538
2011	Nevada	POPESTIMATE	2712799
2011	New Hampshire	POPESTIMATE	1319815
2011	New Jersey	POPESTIMATE	8827783
2011	New Mexico	POPESTIMATE	2080395
2011	New York	POPESTIMATE	19498514
2011	North Carolina	POPESTIMATE	9656754
2011	North Dakota	POPESTIMATE	685136
2011	Ohio	POPESTIMATE	11543463
2011	Oklahoma	POPESTIMATE	3787821
2011	Oregon	POPESTIMATE	3871728
2011	Pennsylvania	POPESTIMATE	12744583
2011	Rhode Island	POPESTIMATE	1053536
2011	South Carolina	POPESTIMATE	4671422
2011	South Dakota	POPESTIMATE	823484
2011	Tennessee	POPESTIMATE	6397410
2011	Texas	POPESTIMATE	25646227
2011	Utah	POPESTIMATE	2814216
2011	Vermont	POPESTIMATE	626979
2011	Virginia	POPESTIMATE	8100469
2011	Washington	POPESTIMATE	6821655
2011	West Virginia	POPESTIMATE	1856074
2011	Wisconsin	POPESTIMATE	5704755
2011	Wyoming	POPESTIMATE	567224
2012	Alabama	POPESTIMATE	4815564
2012	Alaska	POPESTIMATE	730399
2012	Arizona	POPESTIMATE	6556629
2012	Arkansas	POPESTIMATE	2952109
2012	California	POPESTIMATE	37960782
2012	Colorado	POPESTIMATE	5193721
2012	Connecticut	POPESTIMATE	3594395
2012	Delaware	POPESTIMATE	915188
2012	District of Columbia	POPESTIMATE	634725
2012	Florida	POPESTIMATE	19326230
2012	Georgia	POPESTIMATE	9901496
2012	Hawaii	POPESTIMATE	1394905
2012	Idaho	POPESTIMATE	1595441
2012	Illinois	POPESTIMATE	12884119
2012	Indiana	POPESTIMATE	6537640
2012	Iowa	POPESTIMATE	3076097
2012	Kansas	POPESTIMATE	2885361
2012	Kentucky	POPESTIMATE	4386381
2012	Louisiana	POPESTIMATE	4600814
2012	Maine	POPESTIMATE	1327691
2012	Maryland	POPESTIMATE	5887072
2012	Massachusetts	POPESTIMATE	6663158
2012	Michigan	POPESTIMATE	9896930
2012	Minnesota	POPESTIMATE	5376550
2012	Mississippi	POPESTIMATE	2983767
2012	Missouri	POPESTIMATE	6024081
2012	Montana	POPESTIMATE	1003754
2012	Nebraska	POPESTIMATE	1853323
2012	Nevada	POPESTIMATE	2744566
2012	New Hampshire	POPESTIMATE	1323962
2012	New Jersey	POPESTIMATE	8845483
2012	New Mexico	POPESTIMATE	2087549
2012	New York	POPESTIMATE	19574549
2012	North Carolina	POPESTIMATE	9749123
2012	North Dakota	POPESTIMATE	701116
2012	Ohio	POPESTIMATE	11548369
2012	Oklahoma	POPESTIMATE	3818600
2012	Oregon	POPESTIMATE	3899118
2012	Pennsylvania	POPESTIMATE	12766827
2012	Rhode Island	POPESTIMATE	1054601
2012	South Carolina	POPESTIMATE	4717112
2012	South Dakota	POPESTIMATE	833496
2012	Tennessee	POPESTIMATE	6451281
2012	Texas	POPESTIMATE	26089620
2012	Utah	POPESTIMATE	2853467
2012	Vermont	POPESTIMATE	626063
2012	Virginia	POPESTIMATE	8185229
2012	Washington	POPESTIMATE	6892876
2012	West Virginia	POPESTIMATE	1856764
2012	Wisconsin	POPESTIMATE	5719855
2012	Wyoming	POPESTIMATE	576270
2013	Alabama	POPESTIMATE	4830460
2013	Alaska	POPESTIMATE	737045
2013	Arizona	POPESTIMATE	6634999
2013	Arkansas	POPESTIMATE	2959549
2013	California	POPESTIMATE	38280824
2013	Colorado	POPESTIMATE	5270482
2013	Connecticut	POPESTIMATE	3594915
2013	Delaware	POPESTIMATE	923638
2013	District of Columbia	POPESTIMATE	650431
2013	Florida	POPESTIMATE	19563166
2013	Georgia	POPESTIMATE	9973326
2013	Hawaii	POPESTIMATE	1408453
2013	Idaho	POPESTIMATE	1611530
2013	Illinois	POPESTIMATE	12898269
2013	Indiana	POPESTIMATE	6568367
2013	Iowa	POPESTIMATE	3093078
2013	Kansas	POPESTIMATE	2893510
2013	Kentucky	POPESTIMATE	4404817
2013	Louisiana	POPESTIMATE	4624577
2013	Maine	POPESTIMATE	1328196
2013	Maryland	POPESTIMATE	5923704
2013	Massachusetts	POPESTIMATE	6713944
2013	Michigan	POPESTIMATE	9913349
2013	Minnesota	POPESTIMATE	5413693
2013	Mississippi	POPESTIMATE	2988797
2013	Missouri	POPESTIMATE	6040658
2013	Montana	POPESTIMATE	1013564
2013	Nebraska	POPESTIMATE	1865414
2013	Nevada	POPESTIMATE	2776972
2013	New Hampshire	POPESTIMATE	1326408
2013	New Jersey	POPESTIMATE	8858362
2013	New Mexico	POPESTIMATE	2092792
2013	New York	POPESTIMATE	19628043
2013	North Carolina	POPESTIMATE	9843599
2013	North Dakota	POPESTIMATE	721999
2013	Ohio	POPESTIMATE	11576576
2013	Oklahoma	POPESTIMATE	3853205
2013	Oregon	POPESTIMATE	3922908
2013	Pennsylvania	POPESTIMATE	12776621
2013	Rhode Island	POPESTIMATE	1055122
2013	South Carolina	POPESTIMATE	4764153
2013	South Dakota	POPESTIMATE	842270
2013	Tennessee	POPESTIMATE	6493432
2013	Texas	POPESTIMATE	26489464
2013	Utah	POPESTIMATE	2897927
2013	Vermont	POPESTIMATE	626212
2013	Virginia	POPESTIMATE	8253053
2013	Washington	POPESTIMATE	6962906
2013	West Virginia	POPESTIMATE	1853873
2013	Wisconsin	POPESTIMATE	5736952
2013	Wyoming	POPESTIMATE	582123
2014	Alabama	POPESTIMATE	4842481
2014	Alaska	POPESTIMATE	736307
2014	Arizona	POPESTIMATE	6733840
2014	Arkansas	POPESTIMATE	2967726
2014	California	POPESTIMATE	38625139
2014	Colorado	POPESTIMATE	5351218
2014	Connecticut	POPESTIMATE	3594783
2014	Delaware	POPESTIMATE	932596
2014	District of Columbia	POPESTIMATE	662513
2014	Florida	POPESTIMATE	19860330
2014	Georgia	POPESTIMATE	10069001
2014	Hawaii	POPESTIMATE	1414862
2014	Idaho	POPESTIMATE	1631479
2014	Illinois	POPESTIMATE	12888962
2014	Indiana	POPESTIMATE	6593533
2014	Iowa	POPESTIMATE	3109504
2014	Kansas	POPESTIMATE	2900896
2014	Kentucky	POPESTIMATE	4414483
2014	Louisiana	POPESTIMATE	4644204
2014	Maine	POPESTIMATE	1330760
2014	Maryland	POPESTIMATE	5958165
2014	Massachusetts	POPESTIMATE	6763652
2014	Michigan	POPESTIMATE	9930589
2014	Minnesota	POPESTIMATE	5451522
2014	Mississippi	POPESTIMATE	2990623
2014	Missouri	POPESTIMATE	6056293
2014	Montana	POPESTIMATE	1021891
2014	Nebraska	POPESTIMATE	1879522
2014	Nevada	POPESTIMATE	2819012
2014	New Hampshire	POPESTIMATE	1333223
2014	New Jersey	POPESTIMATE	8866780
2014	New Mexico	POPESTIMATE	2090342
2014	New York	POPESTIMATE	19656330
2014	North Carolina	POPESTIMATE	9933944
2014	North Dakota	POPESTIMATE	737382
2014	Ohio	POPESTIMATE	11602973
2014	Oklahoma	POPESTIMATE	3878367
2014	Oregon	POPESTIMATE	3964106
2014	Pennsylvania	POPESTIMATE	12789101
2014	Rhode Island	POPESTIMATE	1056017
2014	South Carolina	POPESTIMATE	4823793
2014	South Dakota	POPESTIMATE	849088
2014	Tennessee	POPESTIMATE	6540826
2014	Texas	POPESTIMATE	26977142
2014	Utah	POPESTIMATE	2937399
2014	Vermont	POPESTIMATE	625218
2014	Virginia	POPESTIMATE	8312076
2014	Washington	POPESTIMATE	7052439
2014	West Virginia	POPESTIMATE	1849467
2014	Wisconsin	POPESTIMATE	5751974
2014	Wyoming	POPESTIMATE	582548
2015	Alabama	POPESTIMATE	4853160
2015	Alaska	POPESTIMATE	737547
2015	Arizona	POPESTIMATE	6833596
2015	Arkansas	POPESTIMATE	2978407
2015	California	POPESTIMATE	38953142
2015	Colorado	POPESTIMATE	5452107
2015	Connecticut	POPESTIMATE	3587509
2015	Delaware	POPESTIMATE	941413
2015	District of Columbia	POPESTIMATE	675254
2015	Florida	POPESTIMATE	20224249
2015	Georgia	POPESTIMATE	10181111
2015	Hawaii	POPESTIMATE	1422484
2015	Idaho	POPESTIMATE	1651523
2015	Illinois	POPESTIMATE	12864342
2015	Indiana	POPESTIMATE	6608296
2015	Iowa	POPESTIMATE	3121460
2015	Kansas	POPESTIMATE	2909502
2015	Kentucky	POPESTIMATE	4425999
2015	Louisiana	POPESTIMATE	4664851
2015	Maine	POPESTIMATE	1328484
2015	Maryland	POPESTIMATE	5986717
2015	Massachusetts	POPESTIMATE	6795891
2015	Michigan	POPESTIMATE	9932573
2015	Minnesota	POPESTIMATE	5482503
2015	Mississippi	POPESTIMATE	2988693
2015	Missouri	POPESTIMATE	6071745
2015	Montana	POPESTIMATE	1030503
2015	Nebraska	POPESTIMATE	1891507
2015	Nevada	POPESTIMATE	2868666
2015	New Hampshire	POPESTIMATE	1336294
2015	New Jersey	POPESTIMATE	8870869
2015	New Mexico	POPESTIMATE	2090211
2015	New York	POPESTIMATE	19661411
2015	North Carolina	POPESTIMATE	10033079
2015	North Dakota	POPESTIMATE	754022
2015	Ohio	POPESTIMATE	11617850
2015	Oklahoma	POPESTIMATE	3909831
2015	Oregon	POPESTIMATE	4016918
2015	Pennsylvania	POPESTIMATE	12785759
2015	Rhode Island	POPESTIMATE	1056173
2015	South Carolina	POPESTIMATE	4892253
2015	South Dakota	POPESTIMATE	853933
2015	Tennessee	POPESTIMATE	6590808
2015	Texas	POPESTIMATE	27486814
2015	Utah	POPESTIMATE	2982497
2015	Vermont	POPESTIMATE	625197
2015	Virginia	POPESTIMATE	8362907
2015	Washington	POPESTIMATE	7163543
2015	West Virginia	POPESTIMATE	1841996
2015	Wisconsin	POPESTIMATE	5761406
2015	Wyoming	POPESTIMATE	585668
2016	Alabama	POPESTIMATE	4864745
2016	Alaska	POPESTIMATE	741504
2016	Arizona	POPESTIMATE	6945452
2016	Arkansas	POPESTIMATE	2990410
2016	California	POPESTIMATE	39209127
2016	Colorado	POPESTIMATE	5540921
2016	Connecticut	POPESTIMATE	3578674
2016	Delaware	POPESTIMATE	949216
2016	District of Columbia	POPESTIMATE	686575
2016	Florida	POPESTIMATE	20629982
2016	Georgia	POPESTIMATE	10304763
2016	Hawaii	POPESTIMATE	1428105
2016	Idaho	POPESTIMATE	1682930
2016	Illinois	POPESTIMATE	12826895
2016	Indiana	POPESTIMATE	6633344
2016	Iowa	POPESTIMATE	3131785
2016	Kansas	POPESTIMATE	2911263
2016	Kentucky	POPESTIMATE	4438229
2016	Louisiana	POPESTIMATE	4678215
2016	Maine	POPESTIMATE	1331370
2016	Maryland	POPESTIMATE	6004692
2016	Massachusetts	POPESTIMATE	6826022
2016	Michigan	POPESTIMATE	9951890
2016	Minnesota	POPESTIMATE	5523409
2016	Mississippi	POPESTIMATE	2988298
2016	Missouri	POPESTIMATE	6087203
2016	Montana	POPESTIMATE	1040863
2016	Nebraska	POPESTIMATE	1905924
2016	Nevada	POPESTIMATE	2919772
2016	New Hampshire	POPESTIMATE	1342373
2016	New Jersey	POPESTIMATE	8874516
2016	New Mexico	POPESTIMATE	2092789
2016	New York	POPESTIMATE	19641589
2016	North Carolina	POPESTIMATE	10156679
2016	North Dakota	POPESTIMATE	754353
2016	Ohio	POPESTIMATE	11635003
2016	Oklahoma	POPESTIMATE	3926769
2016	Oregon	POPESTIMATE	4091404
2016	Pennsylvania	POPESTIMATE	12783538
2016	Rhode Island	POPESTIMATE	1057063
2016	South Carolina	POPESTIMATE	4958235
2016	South Dakota	POPESTIMATE	862890
2016	Tennessee	POPESTIMATE	6645011
2016	Texas	POPESTIMATE	27937492
2016	Utah	POPESTIMATE	3042613
2016	Vermont	POPESTIMATE	623644
2016	Virginia	POPESTIMATE	8410946
2016	Washington	POPESTIMATE	7294680
2016	West Virginia	POPESTIMATE	1830929
2016	Wisconsin	POPESTIMATE	5772958
2016	Wyoming	POPESTIMATE	584290
2017	Alabama	POPESTIMATE	4875120
2017	Alaska	POPESTIMATE	739786
2017	Arizona	POPESTIMATE	7048876
2017	Arkansas	POPESTIMATE	3002997
2017	California	POPESTIMATE	39399349
2017	Colorado	POPESTIMATE	5615902
2017	Connecticut	POPESTIMATE	3573880
2017	Delaware	POPESTIMATE	957078
2017	District of Columbia	POPESTIMATE	695691
2017	Florida	POPESTIMATE	20976812
2017	Georgia	POPESTIMATE	10413055
2017	Hawaii	POPESTIMATE	1424203
2017	Idaho	POPESTIMATE	1718904
2017	Illinois	POPESTIMATE	12786196
2017	Indiana	POPESTIMATE	6660082
2017	Iowa	POPESTIMATE	3143637
2017	Kansas	POPESTIMATE	2910689
2017	Kentucky	POPESTIMATE	4453874
2017	Louisiana	POPESTIMATE	4670818
2017	Maine	POPESTIMATE	1335063
2017	Maryland	POPESTIMATE	6024891
2017	Massachusetts	POPESTIMATE	6863246
2017	Michigan	POPESTIMATE	9976447
2017	Minnesota	POPESTIMATE	5568155
2017	Mississippi	POPESTIMATE	2989663
2017	Missouri	POPESTIMATE	6108612
2017	Montana	POPESTIMATE	1053090
2017	Nebraska	POPESTIMATE	1917575
2017	Nevada	POPESTIMATE	2972405
2017	New Hampshire	POPESTIMATE	1349767
2017	New Jersey	POPESTIMATE	8888543
2017	New Mexico	POPESTIMATE	2093395
2017	New York	POPESTIMATE	19590719
2017	North Carolina	POPESTIMATE	10270800
2017	North Dakota	POPESTIMATE	755176
2017	Ohio	POPESTIMATE	11664129
2017	Oklahoma	POPESTIMATE	3932640
2017	Oregon	POPESTIMATE	4146592
2017	Pennsylvania	POPESTIMATE	12790447
2017	Rhode Island	POPESTIMATE	1056486
2017	South Carolina	POPESTIMATE	5021219
2017	South Dakota	POPESTIMATE	873286
2017	Tennessee	POPESTIMATE	6708794
2017	Texas	POPESTIMATE	28322717
2017	Utah	POPESTIMATE	3103118
2017	Vermont	POPESTIMATE	624525
2017	Virginia	POPESTIMATE	8465207
2017	Washington	POPESTIMATE	7425432
2017	West Virginia	POPESTIMATE	1817048
2017	Wisconsin	POPESTIMATE	5792051
2017	Wyoming	POPESTIMATE	578934
2018	Alabama	POPESTIMATE	4887871
2018	Alaska	POPESTIMATE	737438
2018	Arizona	POPESTIMATE	7171646
2018	Arkansas	POPESTIMATE	3013825
2018	California	POPESTIMATE	39557045
2018	Colorado	POPESTIMATE	5695564
2018	Connecticut	POPESTIMATE	3572665
2018	Delaware	POPESTIMATE	967171
2018	District of Columbia	POPESTIMATE	702455
2018	Florida	POPESTIMATE	21299325
2018	Georgia	POPESTIMATE	10519475
2018	Hawaii	POPESTIMATE	1420491
2018	Idaho	POPESTIMATE	1754208
2018	Illinois	POPESTIMATE	12741080
2018	Indiana	POPESTIMATE	6691878
2018	Iowa	POPESTIMATE	3156145
2018	Kansas	POPESTIMATE	2911505
2018	Kentucky	POPESTIMATE	4468402
2018	Louisiana	POPESTIMATE	4659978
2018	Maine	POPESTIMATE	1338404
2018	Maryland	POPESTIMATE	6042718
2018	Massachusetts	POPESTIMATE	6902149
2018	Michigan	POPESTIMATE	9995915
2018	Minnesota	POPESTIMATE	5611179
2018	Mississippi	POPESTIMATE	2986530
2018	Missouri	POPESTIMATE	6126452
2018	Montana	POPESTIMATE	1062305
2018	Nebraska	POPESTIMATE	1929268
2018	Nevada	POPESTIMATE	3034392
2018	New Hampshire	POPESTIMATE	1356458
2018	New Jersey	POPESTIMATE	8908520
2018	New Mexico	POPESTIMATE	2095428
2018	New York	POPESTIMATE	19542209
2018	North Carolina	POPESTIMATE	10383620
2018	North Dakota	POPESTIMATE	760077
2018	Ohio	POPESTIMATE	11689442
2018	Oklahoma	POPESTIMATE	3943079
2018	Oregon	POPESTIMATE	4190713
2018	Pennsylvania	POPESTIMATE	12807060
2018	Rhode Island	POPESTIMATE	1057315
2018	South Carolina	POPESTIMATE	5084127
2018	South Dakota	POPESTIMATE	882235
2018	Tennessee	POPESTIMATE	6770010
2018	Texas	POPESTIMATE	28701845
2018	Utah	POPESTIMATE	3161105
2018	Vermont	POPESTIMATE	626299
2018	Virginia	POPESTIMATE	8517685
2018	Washington	POPESTIMATE	7535591
2018	West Virginia	POPESTIMATE	1805832
2018	Wisconsin	POPESTIMATE	5813568
2018	Wyoming	POPESTIMATE	577737
2010	Alabama	NPOPCHG	5310
2010	Alaska	NPOPCHG	3657
2010	Arizona	NPOPCHG	15486
2010	Arkansas	NPOPCHG	5950
2010	California	NPOPCHG	66380
2010	Colorado	NPOPCHG	18965
2010	Connecticut	NPOPCHG	4978
2010	Delaware	NPOPCHG	1661
2010	District of Columbia	NPOPCHG	3319
2010	Florida	NPOPCHG	41205
2010	Georgia	NPOPCHG	23101
2010	Hawaii	NPOPCHG	3656
2010	Idaho	NPOPCHG	3116
2010	Illinois	NPOPCHG	9190
2010	Indiana	NPOPCHG	6375
2010	Iowa	NPOPCHG	3895
2010	Kansas	NPOPCHG	5087
2010	Kentucky	NPOPCHG	8867
2010	Louisiana	NPOPCHG	11047
2010	Maine	NPOPCHG	-737
2010	Maryland	NPOPCHG	14844
2010	Massachusetts	NPOPCHG	18641
2010	Michigan	NPOPCHG	-6582
2010	Minnesota	NPOPCHG	6918
2010	Mississippi	NPOPCHG	2418
2010	Missouri	NPOPCHG	7024
2010	Montana	NPOPCHG	1313
2010	Nebraska	NPOPCHG	3231
2010	Nevada	NPOPCHG	1785
2010	New Hampshire	NPOPCHG	313
2010	New Jersey	NPOPCHG	7662
2010	New Mexico	NPOPCHG	5408
2010	New York	NPOPCHG	21956
2010	North Carolina	NPOPCHG	38557
2010	North Dakota	NPOPCHG	2134
2010	Ohio	NPOPCHG	2570
2010	Oklahoma	NPOPCHG	8049
2010	Oregon	NPOPCHG	6457
2010	Pennsylvania	NPOPCHG	8285
2010	Rhode Island	NPOPCHG	981
2010	South Carolina	NPOPCHG	10275
2010	South Dakota	NPOPCHG	1967
2010	Tennessee	NPOPCHG	9015
2010	Texas	NPOPCHG	96565
2010	Utah	NPOPCHG	11443
2010	Vermont	NPOPCHG	136
2010	Virginia	NPOPCHG	22625
2010	Washington	NPOPCHG	18362
2010	West Virginia	NPOPCHG	1213
2010	Wisconsin	NPOPCHG	3197
2010	Wyoming	NPOPCHG	710
2011	Alabama	NPOPCHG	13386
2011	Alaska	NPOPCHG	8132
2011	Arizona	NPOPCHG	65723
2011	Arkansas	NPOPCHG	18429
2011	California	NPOPCHG	320920
2011	Colorado	NPOPCHG	73490
2011	Connecticut	NPOPCHG	8898
2011	Delaware	NPOPCHG	7721
2011	District of Columbia	NPOPCHG	14517
2011	Florida	NPOPCHG	247567
2011	Georgia	NPOPCHG	89768
2011	Hawaii	NPOPCHG	15289
2011	Idaho	NPOPCHG	13055
2011	Illinois	NPOPCHG	26529
2011	Indiana	NPOPCHG	25609
2011	Iowa	NPOPCHG	15287
2011	Kansas	NPOPCHG	10822
2011	Kentucky	NPOPCHG	21288
2011	Louisiana	NPOPCHG	30652
2011	Maine	NPOPCHG	518
2011	Maryland	NPOPCHG	50349
2011	Massachusetts	NPOPCHG	46718
2011	Michigan	NPOPCHG	3986
2011	Minnesota	NPOPCHG	34825
2011	Mississippi	NPOPCHG	7934
2011	Missouri	NPOPCHG	13665
2011	Montana	NPOPCHG	6499
2011	Nebraska	NPOPCHG	11002
2011	Nevada	NPOPCHG	10335
2011	New Hampshire	NPOPCHG	3038
2011	New Jersey	NPOPCHG	28159
2011	New Mexico	NPOPCHG	15807
2011	New York	NPOPCHG	98434
2011	North Carolina	NPOPCHG	82461
2011	North Dakota	NPOPCHG	10426
2011	Ohio	NPOPCHG	4136
2011	Oklahoma	NPOPCHG	28189
2011	Oregon	NPOPCHG	34196
2011	Pennsylvania	NPOPCHG	33425
2011	Rhode Island	NPOPCHG	-402
2011	South Carolina	NPOPCHG	35766
2011	South Dakota	NPOPCHG	7319
2011	Tennessee	NPOPCHG	42109
2011	Texas	NPOPCHG	403548
2011	Utah	NPOPCHG	38882
2011	Vermont	NPOPCHG	1099
2011	Virginia	NPOPCHG	76789
2011	Washington	NPOPCHG	78753
2011	West Virginia	NPOPCHG	1860
2011	Wisconsin	NPOPCHG	14276
2011	Wyoming	NPOPCHG	2741
2012	Alabama	NPOPCHG	16730
2012	Alaska	NPOPCHG	8361
2012	Arizona	NPOPCHG	83132
2012	Arkansas	NPOPCHG	11702
2012	California	NPOPCHG	318959
2012	Colorado	NPOPCHG	71950
2012	Connecticut	NPOPCHG	6372
2012	Delaware	NPOPCHG	7872
2012	District of Columbia	NPOPCHG	15123
2012	Florida	NPOPCHG	232878
2012	Georgia	NPOPCHG	99918
2012	Hawaii	NPOPCHG	15653
2012	Idaho	NPOPCHG	11613
2012	Illinois	NPOPCHG	16828
2012	Indiana	NPOPCHG	21595
2012	Iowa	NPOPCHG	10043
2012	Kansas	NPOPCHG	16326
2012	Kentucky	NPOPCHG	16893
2012	Louisiana	NPOPCHG	25630
2012	Maine	NPOPCHG	-459
2012	Maryland	NPOPCHG	48081
2012	Massachusetts	NPOPCHG	50009
2012	Michigan	NPOPCHG	15409
2012	Minnesota	NPOPCHG	30882
2012	Mississippi	NPOPCHG	5297
2012	Missouri	NPOPCHG	14440
2012	Montana	NPOPCHG	6533
2012	Nebraska	NPOPCHG	12785
2012	Nevada	NPOPCHG	31767
2012	New Hampshire	NPOPCHG	4147
2012	New Jersey	NPOPCHG	17700
2012	New Mexico	NPOPCHG	7154
2012	New York	NPOPCHG	76035
2012	North Carolina	NPOPCHG	92369
2012	North Dakota	NPOPCHG	15980
2012	Ohio	NPOPCHG	4906
2012	Oklahoma	NPOPCHG	30779
2012	Oregon	NPOPCHG	27390
2012	Pennsylvania	NPOPCHG	22244
2012	Rhode Island	NPOPCHG	1065
2012	South Carolina	NPOPCHG	45690
2012	South Dakota	NPOPCHG	10012
2012	Tennessee	NPOPCHG	53871
2012	Texas	NPOPCHG	443393
2012	Utah	NPOPCHG	39251
2012	Vermont	NPOPCHG	-916
2012	Virginia	NPOPCHG	84760
2012	Washington	NPOPCHG	71221
2012	West Virginia	NPOPCHG	690
2012	Wisconsin	NPOPCHG	15100
2012	Wyoming	NPOPCHG	9046
2013	Alabama	NPOPCHG	14896
2013	Alaska	NPOPCHG	6646
2013	Arizona	NPOPCHG	78370
2013	Arkansas	NPOPCHG	7440
2013	California	NPOPCHG	320042
2013	Colorado	NPOPCHG	76761
2013	Connecticut	NPOPCHG	520
2013	Delaware	NPOPCHG	8450
2013	District of Columbia	NPOPCHG	15706
2013	Florida	NPOPCHG	236936
2013	Georgia	NPOPCHG	71830
2013	Hawaii	NPOPCHG	13548
2013	Idaho	NPOPCHG	16089
2013	Illinois	NPOPCHG	14150
2013	Indiana	NPOPCHG	30727
2013	Iowa	NPOPCHG	16981
2013	Kansas	NPOPCHG	8149
2013	Kentucky	NPOPCHG	18436
2013	Louisiana	NPOPCHG	23763
2013	Maine	NPOPCHG	505
2013	Maryland	NPOPCHG	36632
2013	Massachusetts	NPOPCHG	50786
2013	Michigan	NPOPCHG	16419
2013	Minnesota	NPOPCHG	37143
2013	Mississippi	NPOPCHG	5030
2013	Missouri	NPOPCHG	16577
2013	Montana	NPOPCHG	9810
2013	Nebraska	NPOPCHG	12091
2013	Nevada	NPOPCHG	32406
2013	New Hampshire	NPOPCHG	2446
2013	New Jersey	NPOPCHG	12879
2013	New Mexico	NPOPCHG	5243
2013	New York	NPOPCHG	53494
2013	North Carolina	NPOPCHG	94476
2013	North Dakota	NPOPCHG	20883
2013	Ohio	NPOPCHG	28207
2013	Oklahoma	NPOPCHG	34605
2013	Oregon	NPOPCHG	23790
2013	Pennsylvania	NPOPCHG	9794
2013	Rhode Island	NPOPCHG	521
2013	South Carolina	NPOPCHG	47041
2013	South Dakota	NPOPCHG	8774
2013	Tennessee	NPOPCHG	42151
2013	Texas	NPOPCHG	399844
2013	Utah	NPOPCHG	44460
2013	Vermont	NPOPCHG	149
2013	Virginia	NPOPCHG	67824
2013	Washington	NPOPCHG	70030
2013	West Virginia	NPOPCHG	-2891
2013	Wisconsin	NPOPCHG	17097
2013	Wyoming	NPOPCHG	5853
2014	Alabama	NPOPCHG	12021
2014	Alaska	NPOPCHG	-738
2014	Arizona	NPOPCHG	98841
2014	Arkansas	NPOPCHG	8177
2014	California	NPOPCHG	344315
2014	Colorado	NPOPCHG	80736
2014	Connecticut	NPOPCHG	-132
2014	Delaware	NPOPCHG	8958
2014	District of Columbia	NPOPCHG	12082
2014	Florida	NPOPCHG	297164
2014	Georgia	NPOPCHG	95675
2014	Hawaii	NPOPCHG	6409
2014	Idaho	NPOPCHG	19949
2014	Illinois	NPOPCHG	-9307
2014	Indiana	NPOPCHG	25166
2014	Iowa	NPOPCHG	16426
2014	Kansas	NPOPCHG	7386
2014	Kentucky	NPOPCHG	9666
2014	Louisiana	NPOPCHG	19627
2014	Maine	NPOPCHG	2564
2014	Maryland	NPOPCHG	34461
2014	Massachusetts	NPOPCHG	49708
2014	Michigan	NPOPCHG	17240
2014	Minnesota	NPOPCHG	37829
2014	Mississippi	NPOPCHG	1826
2014	Missouri	NPOPCHG	15635
2014	Montana	NPOPCHG	8327
2014	Nebraska	NPOPCHG	14108
2014	Nevada	NPOPCHG	42040
2014	New Hampshire	NPOPCHG	6815
2014	New Jersey	NPOPCHG	8418
2014	New Mexico	NPOPCHG	-2450
2014	New York	NPOPCHG	28287
2014	North Carolina	NPOPCHG	90345
2014	North Dakota	NPOPCHG	15383
2014	Ohio	NPOPCHG	26397
2014	Oklahoma	NPOPCHG	25162
2014	Oregon	NPOPCHG	41198
2014	Pennsylvania	NPOPCHG	12480
2014	Rhode Island	NPOPCHG	895
2014	South Carolina	NPOPCHG	59640
2014	South Dakota	NPOPCHG	6818
2014	Tennessee	NPOPCHG	47394
2014	Texas	NPOPCHG	487678
2014	Utah	NPOPCHG	39472
2014	Vermont	NPOPCHG	-994
2014	Virginia	NPOPCHG	59023
2014	Washington	NPOPCHG	89533
2014	West Virginia	NPOPCHG	-4406
2014	Wisconsin	NPOPCHG	15022
2014	Wyoming	NPOPCHG	425
2015	Alabama	NPOPCHG	10679
2015	Alaska	NPOPCHG	1240
2015	Arizona	NPOPCHG	99756
2015	Arkansas	NPOPCHG	10681
2015	California	NPOPCHG	328003
2015	Colorado	NPOPCHG	100889
2015	Connecticut	NPOPCHG	-7274
2015	Delaware	NPOPCHG	8817
2015	District of Columbia	NPOPCHG	12741
2015	Florida	NPOPCHG	363919
2015	Georgia	NPOPCHG	112110
2015	Hawaii	NPOPCHG	7622
2015	Idaho	NPOPCHG	20044
2015	Illinois	NPOPCHG	-24620
2015	Indiana	NPOPCHG	14763
2015	Iowa	NPOPCHG	11956
2015	Kansas	NPOPCHG	8606
2015	Kentucky	NPOPCHG	11516
2015	Louisiana	NPOPCHG	20647
2015	Maine	NPOPCHG	-2276
2015	Maryland	NPOPCHG	28552
2015	Massachusetts	NPOPCHG	32239
2015	Michigan	NPOPCHG	1984
2015	Minnesota	NPOPCHG	30981
2015	Mississippi	NPOPCHG	-1930
2015	Missouri	NPOPCHG	15452
2015	Montana	NPOPCHG	8612
2015	Nebraska	NPOPCHG	11985
2015	Nevada	NPOPCHG	49654
2015	New Hampshire	NPOPCHG	3071
2015	New Jersey	NPOPCHG	4089
2015	New Mexico	NPOPCHG	-131
2015	New York	NPOPCHG	5081
2015	North Carolina	NPOPCHG	99135
2015	North Dakota	NPOPCHG	16640
2015	Ohio	NPOPCHG	14877
2015	Oklahoma	NPOPCHG	31464
2015	Oregon	NPOPCHG	52812
2015	Pennsylvania	NPOPCHG	-3342
2015	Rhode Island	NPOPCHG	156
2015	South Carolina	NPOPCHG	68460
2015	South Dakota	NPOPCHG	4845
2015	Tennessee	NPOPCHG	49982
2015	Texas	NPOPCHG	509672
2015	Utah	NPOPCHG	45098
2015	Vermont	NPOPCHG	-21
2015	Virginia	NPOPCHG	50831
2015	Washington	NPOPCHG	111104
2015	West Virginia	NPOPCHG	-7471
2015	Wisconsin	NPOPCHG	9432
2015	Wyoming	NPOPCHG	3120
2016	Alabama	NPOPCHG	11585
2016	Alaska	NPOPCHG	3957
2016	Arizona	NPOPCHG	111856
2016	Arkansas	NPOPCHG	12003
2016	California	NPOPCHG	255985
2016	Colorado	NPOPCHG	88814
2016	Connecticut	NPOPCHG	-8835
2016	Delaware	NPOPCHG	7803
2016	District of Columbia	NPOPCHG	11321
2016	Florida	NPOPCHG	405733
2016	Georgia	NPOPCHG	123652
2016	Hawaii	NPOPCHG	5621
2016	Idaho	NPOPCHG	31407
2016	Illinois	NPOPCHG	-37447
2016	Indiana	NPOPCHG	25048
2016	Iowa	NPOPCHG	10325
2016	Kansas	NPOPCHG	1761
2016	Kentucky	NPOPCHG	12230
2016	Louisiana	NPOPCHG	13364
2016	Maine	NPOPCHG	2886
2016	Maryland	NPOPCHG	17975
2016	Massachusetts	NPOPCHG	30131
2016	Michigan	NPOPCHG	19317
2016	Minnesota	NPOPCHG	40906
2016	Mississippi	NPOPCHG	-395
2016	Missouri	NPOPCHG	15458
2016	Montana	NPOPCHG	10360
2016	Nebraska	NPOPCHG	14417
2016	Nevada	NPOPCHG	51106
2016	New Hampshire	NPOPCHG	6079
2016	New Jersey	NPOPCHG	3647
2016	New Mexico	NPOPCHG	2578
2016	New York	NPOPCHG	-19822
2016	North Carolina	NPOPCHG	123600
2016	North Dakota	NPOPCHG	331
2016	Ohio	NPOPCHG	17153
2016	Oklahoma	NPOPCHG	16938
2016	Oregon	NPOPCHG	74486
2016	Pennsylvania	NPOPCHG	-2221
2016	Rhode Island	NPOPCHG	890
2016	South Carolina	NPOPCHG	65982
2016	South Dakota	NPOPCHG	8957
2016	Tennessee	NPOPCHG	54203
2016	Texas	NPOPCHG	450678
2016	Utah	NPOPCHG	60116
2016	Vermont	NPOPCHG	-1553
2016	Virginia	NPOPCHG	48039
2016	Washington	NPOPCHG	131137
2016	West Virginia	NPOPCHG	-11067
2016	Wisconsin	NPOPCHG	11552
2016	Wyoming	NPOPCHG	-1378
2017	Alabama	NPOPCHG	10375
2017	Alaska	NPOPCHG	-1718
2017	Arizona	NPOPCHG	103424
2017	Arkansas	NPOPCHG	12587
2017	California	NPOPCHG	190222
2017	Colorado	NPOPCHG	74981
2017	Connecticut	NPOPCHG	-4794
2017	Delaware	NPOPCHG	7862
2017	District of Columbia	NPOPCHG	9116
2017	Florida	NPOPCHG	346830
2017	Georgia	NPOPCHG	108292
2017	Hawaii	NPOPCHG	-3902
2017	Idaho	NPOPCHG	35974
2017	Illinois	NPOPCHG	-40699
2017	Indiana	NPOPCHG	26738
2017	Iowa	NPOPCHG	11852
2017	Kansas	NPOPCHG	-574
2017	Kentucky	NPOPCHG	15645
2017	Louisiana	NPOPCHG	-7397
2017	Maine	NPOPCHG	3693
2017	Maryland	NPOPCHG	20199
2017	Massachusetts	NPOPCHG	37224
2017	Michigan	NPOPCHG	24557
2017	Minnesota	NPOPCHG	44746
2017	Mississippi	NPOPCHG	1365
2017	Missouri	NPOPCHG	21409
2017	Montana	NPOPCHG	12227
2017	Nebraska	NPOPCHG	11651
2017	Nevada	NPOPCHG	52633
2017	New Hampshire	NPOPCHG	7394
2017	New Jersey	NPOPCHG	14027
2017	New Mexico	NPOPCHG	606
2017	New York	NPOPCHG	-50870
2017	North Carolina	NPOPCHG	114121
2017	North Dakota	NPOPCHG	823
2017	Ohio	NPOPCHG	29126
2017	Oklahoma	NPOPCHG	5871
2017	Oregon	NPOPCHG	55188
2017	Pennsylvania	NPOPCHG	6909
2017	Rhode Island	NPOPCHG	-577
2017	South Carolina	NPOPCHG	62984
2017	South Dakota	NPOPCHG	10396
2017	Tennessee	NPOPCHG	63783
2017	Texas	NPOPCHG	385225
2017	Utah	NPOPCHG	60505
2017	Vermont	NPOPCHG	881
2017	Virginia	NPOPCHG	54261
2017	Washington	NPOPCHG	130752
2017	West Virginia	NPOPCHG	-13881
2017	Wisconsin	NPOPCHG	19093
2017	Wyoming	NPOPCHG	-5356
2018	Alabama	NPOPCHG	12751
2018	Alaska	NPOPCHG	-2348
2018	Arizona	NPOPCHG	122770
2018	Arkansas	NPOPCHG	10828
2018	California	NPOPCHG	157696
2018	Colorado	NPOPCHG	79662
2018	Connecticut	NPOPCHG	-1215
2018	Delaware	NPOPCHG	10093
2018	District of Columbia	NPOPCHG	6764
2018	Florida	NPOPCHG	322513
2018	Georgia	NPOPCHG	106420
2018	Hawaii	NPOPCHG	-3712
2018	Idaho	NPOPCHG	35304
2018	Illinois	NPOPCHG	-45116
2018	Indiana	NPOPCHG	31796
2018	Iowa	NPOPCHG	12508
2018	Kansas	NPOPCHG	816
2018	Kentucky	NPOPCHG	14528
2018	Louisiana	NPOPCHG	-10840
2018	Maine	NPOPCHG	3341
2018	Maryland	NPOPCHG	17827
2018	Massachusetts	NPOPCHG	38903
2018	Michigan	NPOPCHG	19468
2018	Minnesota	NPOPCHG	43024
2018	Mississippi	NPOPCHG	-3133
2018	Missouri	NPOPCHG	17840
2018	Montana	NPOPCHG	9215
2018	Nebraska	NPOPCHG	11693
2018	Nevada	NPOPCHG	61987
2018	New Hampshire	NPOPCHG	6691
2018	New Jersey	NPOPCHG	19977
2018	New Mexico	NPOPCHG	2033
2018	New York	NPOPCHG	-48510
2018	North Carolina	NPOPCHG	112820
2018	North Dakota	NPOPCHG	4901
2018	Ohio	NPOPCHG	25313
2018	Oklahoma	NPOPCHG	10439
2018	Oregon	NPOPCHG	44121
2018	Pennsylvania	NPOPCHG	16613
2018	Rhode Island	NPOPCHG	829
2018	South Carolina	NPOPCHG	62908
2018	South Dakota	NPOPCHG	8949
2018	Tennessee	NPOPCHG	61216
2018	Texas	NPOPCHG	379128
2018	Utah	NPOPCHG	57987
2018	Vermont	NPOPCHG	1774
2018	Virginia	NPOPCHG	52478
2018	Washington	NPOPCHG	110159
2018	West Virginia	NPOPCHG	-11216
2018	Wisconsin	NPOPCHG	21517
2018	Wyoming	NPOPCHG	-1197
2010	Alabama	PPOPCHG	0.1110846591
2010	Alaska	PPOPCHG	0.5148898485
2010	Arizona	PPOPCHG	0.2422606741
2010	Arkansas	PPOPCHG	0.20404468
2010	California	PPOPCHG	0.1781797072
2010	Colorado	PPOPCHG	0.3770890515
2010	Connecticut	PPOPCHG	0.1392779872
2010	Delaware	PPOPCHG	0.1849801879
2010	District of Columbia	PPOPCHG	0.5515432909
2010	Florida	PPOPCHG	0.21912215
2010	Georgia	PPOPCHG	0.2384321791
2010	Hawaii	PPOPCHG	0.2687628601
2010	Idaho	PPOPCHG	0.1987679703
2010	Illinois	PPOPCHG	0.0716202193
2010	Indiana	PPOPCHG	0.098318014
2010	Iowa	PPOPCHG	0.1278360233
2010	Kansas	PPOPCHG	0.1782956659
2010	Kentucky	PPOPCHG	0.2043401601
2010	Louisiana	PPOPCHG	0.2436756711
2010	Maine	PPOPCHG	-0.055481572
2010	Maryland	PPOPCHG	0.2570924719
2010	Massachusetts	PPOPCHG	0.2846914761
2010	Michigan	PPOPCHG	-0.066591684
2010	Minnesota	PPOPCHG	0.1304317086
2010	Mississippi	PPOPCHG	0.0814657638
2010	Missouri	PPOPCHG	0.1172826231
2010	Montana	PPOPCHG	0.1327054838
2010	Nebraska	PPOPCHG	0.1769145898
2010	Nevada	PPOPCHG	0.0660944896
2010	New Hampshire	PPOPCHG	0.0237758116
2010	New Jersey	PPOPCHG	0.0871477834
2010	New Mexico	PPOPCHG	0.2626288134
2010	New York	PPOPCHG	0.1133030215
2010	North Carolina	PPOPCHG	0.4043421504
2010	North Dakota	PPOPCHG	0.317287563
2010	Ohio	PPOPCHG	0.0222766242
2010	Oklahoma	PPOPCHG	0.2145494315
2010	Oregon	PPOPCHG	0.1685427719
2010	Pennsylvania	PPOPCHG	0.065221466
2010	Rhode Island	PPOPCHG	0.0931661977
2010	South Carolina	PPOPCHG	0.2221438623
2010	South Dakota	PPOPCHG	0.2415874271
2010	Tennessee	PPOPCHG	0.1420515873
2010	Texas	PPOPCHG	0.3840155978
2010	Utah	PPOPCHG	0.4140177742
2010	Vermont	PPOPCHG	0.0217341277
2010	Virginia	PPOPCHG	0.282775209
2010	Washington	PPOPCHG	0.2730595699
2010	West Virginia	PPOPCHG	0.0654613786
2010	Wisconsin	PPOPCHG	0.0562131436
2010	Wyoming	PPOPCHG	0.1259372123
2011	Alabama	PPOPCHG	0.279723027
2011	Alaska	PPOPCHG	1.1390855379
2011	Arizona	PPOPCHG	1.0256759992
2011	Arkansas	PPOPCHG	0.6307029006
2011	California	PPOPCHG	0.859893449
2011	Colorado	PPOPCHG	1.4557430539
2011	Connecticut	PPOPCHG	0.2486082492
2011	Delaware	PPOPCHG	0.8582751127
2011	District of Columbia	PPOPCHG	2.3991670592
2011	Florida	PPOPCHG	1.3136465263
2011	Georgia	PPOPCHG	0.9243179181
2011	Hawaii	PPOPCHG	1.1209248345
2011	Idaho	PPOPCHG	0.8311194552
2011	Illinois	PPOPCHG	0.2065998887
2011	Indiana	PPOPCHG	0.3945651725
2011	Iowa	PPOPCHG	0.5010871037
2011	Kansas	PPOPCHG	0.3786281848
2011	Kentucky	PPOPCHG	0.489581896
2011	Louisiana	PPOPCHG	0.6744808926
2011	Maine	PPOPCHG	0.039016836
2011	Maryland	PPOPCHG	0.8697894947
2011	Massachusetts	PPOPCHG	0.7114671577
2011	Michigan	PPOPCHG	0.0403541977
2011	Minnesota	PPOPCHG	0.655733939
2011	Mississippi	PPOPCHG	0.2670898451
2011	Missouri	PPOPCHG	0.2279028468
2011	Montana	PPOPCHG	0.6559862403
2011	Nebraska	PPOPCHG	0.6013546604
2011	Nevada	PPOPCHG	0.3824287761
2011	New Hampshire	PPOPCHG	0.2307148439
2011	New Jersey	PPOPCHG	0.3200023092
2011	New Mexico	PPOPCHG	0.7656249092
2011	New York	PPOPCHG	0.5073896602
2011	North Carolina	PPOPCHG	0.8612750832
2011	North Dakota	PPOPCHG	1.5452564806
2011	Ohio	PPOPCHG	0.0358426449
2011	Oklahoma	PPOPCHG	0.7497808296
2011	Oregon	PPOPCHG	0.8910935466
2011	Pennsylvania	PPOPCHG	0.2629579461
2011	Rhode Island	PPOPCHG	-0.038142661
2011	South Carolina	PPOPCHG	0.7715412878
2011	South Dakota	PPOPCHG	0.8967549454
2011	Tennessee	PPOPCHG	0.6625807338
2011	Texas	PPOPCHG	1.5986734213
2011	Utah	PPOPCHG	1.4009845302
2011	Vermont	PPOPCHG	0.1755927654
2011	Virginia	PPOPCHG	0.9570296921
2011	Washington	PPOPCHG	1.1679392641
2011	West Virginia	PPOPCHG	0.100312046
2011	Wisconsin	PPOPCHG	0.2508751899
2011	Wyoming	PPOPCHG	0.4855770679
2012	Alabama	PPOPCHG	0.3486263538
2012	Alaska	PPOPCHG	1.1579722951
2012	Arizona	PPOPCHG	1.2841899826
2012	Arkansas	PPOPCHG	0.3979721175
2012	California	PPOPCHG	0.8473526906
2012	Colorado	PPOPCHG	1.4047875237
2012	Connecticut	PPOPCHG	0.1775908348
2012	Delaware	PPOPCHG	0.8676139294
2012	District of Columbia	PPOPCHG	2.4407603591
2012	Florida	PPOPCHG	1.2196810701
2012	Georgia	PPOPCHG	1.0194072832
2012	Hawaii	PPOPCHG	1.1348905059
2012	Idaho	PPOPCHG	0.7332235571
2012	Illinois	PPOPCHG	0.1307812188
2012	Indiana	PPOPCHG	0.3314126898
2012	Iowa	PPOPCHG	0.3275545701
2012	Kansas	PPOPCHG	0.569041507
2012	Kentucky	PPOPCHG	0.3866128022
2012	Louisiana	PPOPCHG	0.5601960489
2012	Maine	PPOPCHG	-0.034559349
2012	Maryland	PPOPCHG	0.8234470647
2012	Massachusetts	PPOPCHG	0.7562055535
2012	Michigan	PPOPCHG	0.1559375323
2012	Minnesota	PPOPCHG	0.577701421
2012	Mississippi	PPOPCHG	0.1778429865
2012	Missouri	PPOPCHG	0.2402805758
2012	Montana	PPOPCHG	0.6551205801
2012	Nebraska	PPOPCHG	0.6946338516
2012	Nevada	PPOPCHG	1.1710045602
2012	New Hampshire	PPOPCHG	0.3142107038
2012	New Jersey	PPOPCHG	0.2005033427
2012	New Mexico	PPOPCHG	0.3438770041
2012	New York	PPOPCHG	0.3899527933
2012	North Carolina	PPOPCHG	0.9565222434
2012	North Dakota	PPOPCHG	2.3323836435
2012	Ohio	PPOPCHG	0.0425002445
2012	Oklahoma	PPOPCHG	0.8125779967
2012	Oregon	PPOPCHG	0.7074360596
2012	Pennsylvania	PPOPCHG	0.1745368993
2012	Rhode Island	PPOPCHG	0.1010881451
2012	South Carolina	PPOPCHG	0.9780747704
2012	South Dakota	PPOPCHG	1.2158099004
2012	Tennessee	PPOPCHG	0.8420751523
2012	Texas	PPOPCHG	1.7288819911
2012	Utah	PPOPCHG	1.3947401337
2012	Vermont	PPOPCHG	-0.146097397
2012	Virginia	PPOPCHG	1.0463591676
2012	Washington	PPOPCHG	1.0440428312
2012	West Virginia	PPOPCHG	0.0371752419
2012	Wisconsin	PPOPCHG	0.2646914723
2012	Wyoming	PPOPCHG	1.5947844238
2013	Alabama	PPOPCHG	0.3093303297
2013	Alaska	PPOPCHG	0.9099136226
2013	Arizona	PPOPCHG	1.1952788544
2013	Arkansas	PPOPCHG	0.2520232146
2013	California	PPOPCHG	0.8430858985
2013	Colorado	PPOPCHG	1.4779577109
2013	Connecticut	PPOPCHG	0.0144669687
2013	Delaware	PPOPCHG	0.9233075609
2013	District of Columbia	PPOPCHG	2.4744574422
2013	Florida	PPOPCHG	1.225981477
2013	Georgia	PPOPCHG	0.7254459326
2013	Hawaii	PPOPCHG	0.9712489381
2013	Idaho	PPOPCHG	1.0084359121
2013	Illinois	PPOPCHG	0.1098251266
2013	Indiana	PPOPCHG	0.4700014072
2013	Iowa	PPOPCHG	0.5520307064
2013	Kansas	PPOPCHG	0.2824256653
2013	Kentucky	PPOPCHG	0.4203009269
2013	Louisiana	PPOPCHG	0.5164955593
2013	Maine	PPOPCHG	0.0380359587
2013	Maryland	PPOPCHG	0.6222448103
2013	Massachusetts	PPOPCHG	0.7621911412
2013	Michigan	PPOPCHG	0.1658999306
2013	Minnesota	PPOPCHG	0.6908333411
2013	Mississippi	PPOPCHG	0.1685788468
2013	Missouri	PPOPCHG	0.2751789028
2013	Montana	PPOPCHG	0.9773310991
2013	Nebraska	PPOPCHG	0.6523957238
2013	Nevada	PPOPCHG	1.1807331287
2013	New Hampshire	PPOPCHG	0.1847485049
2013	New Jersey	PPOPCHG	0.1455997372
2013	New Mexico	PPOPCHG	0.2511557813
2013	New York	PPOPCHG	0.2732834355
2013	North Carolina	PPOPCHG	0.9690717821
2013	North Dakota	PPOPCHG	2.9785370752
2013	Ohio	PPOPCHG	0.2442509414
2013	Oklahoma	PPOPCHG	0.9062221757
2013	Oregon	PPOPCHG	0.6101379851
2013	Pennsylvania	PPOPCHG	0.0767144413
2013	Rhode Island	PPOPCHG	0.0494025703
2013	South Carolina	PPOPCHG	0.9972415325
2013	South Dakota	PPOPCHG	1.0526745179
2013	Tennessee	PPOPCHG	0.6533741128
2013	Texas	PPOPCHG	1.532578857
2013	Utah	PPOPCHG	1.5581045794
2013	Vermont	PPOPCHG	0.0237995218
2013	Virginia	PPOPCHG	0.828614569
2013	Washington	PPOPCHG	1.0159764952
2013	West Virginia	PPOPCHG	-0.155700994
2013	Wisconsin	PPOPCHG	0.2989061786
2013	Wyoming	PPOPCHG	1.0156697381
2014	Alabama	PPOPCHG	0.2488582868
2014	Alaska	PPOPCHG	-0.100129571
2014	Arizona	PPOPCHG	1.4896912569
2014	Arkansas	PPOPCHG	0.2762920972
2014	California	PPOPCHG	0.8994451112
2014	Colorado	PPOPCHG	1.531852305
2014	Connecticut	PPOPCHG	-0.003671853
2014	Delaware	PPOPCHG	0.9698604865
2014	District of Columbia	PPOPCHG	1.8575375405
2014	Florida	PPOPCHG	1.5189974874
2014	Georgia	PPOPCHG	0.9593088605
2014	Hawaii	PPOPCHG	0.4550382583
2014	Idaho	PPOPCHG	1.2378919412
2014	Illinois	PPOPCHG	-0.072156969
2014	Indiana	PPOPCHG	0.3831393709
2014	Iowa	PPOPCHG	0.5310567661
2014	Kansas	PPOPCHG	0.2552609115
2014	Kentucky	PPOPCHG	0.2194415795
2014	Louisiana	PPOPCHG	0.4244063835
2014	Maine	PPOPCHG	0.1930437978
2014	Maryland	PPOPCHG	0.5817475012
2014	Massachusetts	PPOPCHG	0.740369595
2014	Michigan	PPOPCHG	0.1739069209
2014	Minnesota	PPOPCHG	0.6987651498
2014	Mississippi	PPOPCHG	0.0610948151
2014	Missouri	PPOPCHG	0.2588294189
2014	Montana	PPOPCHG	0.8215564089
2014	Nebraska	PPOPCHG	0.7562932411
2014	Nevada	PPOPCHG	1.5138791461
2014	New Hampshire	PPOPCHG	0.5137936442
2014	New Jersey	PPOPCHG	0.0950288552
2014	New Mexico	PPOPCHG	-0.11706849
2014	New York	PPOPCHG	0.1441152335
2014	North Carolina	PPOPCHG	0.917804555
2014	North Dakota	PPOPCHG	2.1306123693
2014	Ohio	PPOPCHG	0.2280207896
2014	Oklahoma	PPOPCHG	0.6530148279
2014	Oregon	PPOPCHG	1.050190318
2014	Pennsylvania	PPOPCHG	0.0976784081
2014	Rhode Island	PPOPCHG	0.0848243142
2014	South Carolina	PPOPCHG	1.2518489645
2014	South Dakota	PPOPCHG	0.8094791456
2014	Tennessee	PPOPCHG	0.7298759731
2014	Texas	PPOPCHG	1.8410263039
2014	Utah	PPOPCHG	1.3620770986
2014	Vermont	PPOPCHG	-0.158732187
2014	Virginia	PPOPCHG	0.7151656484
2014	Washington	PPOPCHG	1.285856796
2014	West Virginia	PPOPCHG	-0.237664608
2014	Wisconsin	PPOPCHG	0.2618463602
2014	Wyoming	PPOPCHG	0.0730086253
2015	Alabama	PPOPCHG	0.2205274528
2015	Alaska	PPOPCHG	0.1684080146
2015	Arizona	PPOPCHG	1.4814132798
2015	Arkansas	PPOPCHG	0.3599051934
2015	California	PPOPCHG	0.8491956495
2015	Colorado	PPOPCHG	1.8853464763
2015	Connecticut	PPOPCHG	-0.202348793
2015	Delaware	PPOPCHG	0.9454254575
2015	District of Columbia	PPOPCHG	1.9231320744
2015	Florida	PPOPCHG	1.8323915061
2015	Georgia	PPOPCHG	1.1134173092
2015	Hawaii	PPOPCHG	0.5387097823
2015	Idaho	PPOPCHG	1.2285784861
2015	Illinois	PPOPCHG	-0.191016158
2015	Indiana	PPOPCHG	0.2239012074
2015	Iowa	PPOPCHG	0.384498621
2015	Kansas	PPOPCHG	0.2966669608
2015	Kentucky	PPOPCHG	0.2608686
2015	Louisiana	PPOPCHG	0.4445756474
2015	Maine	PPOPCHG	-0.171030088
2015	Maryland	PPOPCHG	0.4792079441
2015	Massachusetts	PPOPCHG	0.4766507798
2015	Michigan	PPOPCHG	0.019978674
2015	Minnesota	PPOPCHG	0.5683000087
2015	Mississippi	PPOPCHG	-0.064535048
2015	Missouri	PPOPCHG	0.2551395714
2015	Montana	PPOPCHG	0.8427513306
2015	Nebraska	PPOPCHG	0.637662129
2015	Nevada	PPOPCHG	1.7613972555
2015	New Hampshire	PPOPCHG	0.230344061
2015	New Jersey	PPOPCHG	0.0461159519
2015	New Mexico	PPOPCHG	-0.006266917
2015	New York	PPOPCHG	0.0258491794
2015	North Carolina	PPOPCHG	0.9979420057
2015	North Dakota	PPOPCHG	2.2566322476
2015	Ohio	PPOPCHG	0.1282171388
2015	Oklahoma	PPOPCHG	0.8112692791
2015	Oregon	PPOPCHG	1.3322549902
2015	Pennsylvania	PPOPCHG	-0.026131626
2015	Rhode Island	PPOPCHG	0.0147724895
2015	South Carolina	PPOPCHG	1.419215128
2015	South Dakota	PPOPCHG	0.5706122334
2015	Tennessee	PPOPCHG	0.7641542521
2015	Texas	PPOPCHG	1.889273519
2015	Utah	PPOPCHG	1.5353038521
2015	Vermont	PPOPCHG	-0.003358828
2015	Virginia	PPOPCHG	0.6115319446
2015	Washington	PPOPCHG	1.5753982417
2015	West Virginia	PPOPCHG	-0.40395422
2015	Wisconsin	PPOPCHG	0.1639784881
2015	Wyoming	PPOPCHG	0.5355781841
2016	Alabama	PPOPCHG	0.2387104485
2016	Alaska	PPOPCHG	0.5365081819
2016	Arizona	PPOPCHG	1.6368541541
2016	Arkansas	PPOPCHG	0.4030006644
2016	California	PPOPCHG	0.6571613658
2016	Colorado	PPOPCHG	1.6289849044
2016	Connecticut	PPOPCHG	-0.246271159
2016	Delaware	PPOPCHG	0.828860447
2016	District of Columbia	PPOPCHG	1.676554304
2016	Florida	PPOPCHG	2.006170909
2016	Georgia	PPOPCHG	1.2145236409
2016	Hawaii	PPOPCHG	0.3951538295
2016	Idaho	PPOPCHG	1.9016992194
2016	Illinois	PPOPCHG	-0.291091453
2016	Indiana	PPOPCHG	0.3790387113
2016	Iowa	PPOPCHG	0.3307747016
2016	Kansas	PPOPCHG	0.0605258219
2016	Kentucky	PPOPCHG	0.2763217976
2016	Louisiana	PPOPCHG	0.2864828909
2016	Maine	PPOPCHG	0.2172401023
2016	Maryland	PPOPCHG	0.3002480324
2016	Massachusetts	PPOPCHG	0.4433708545
2016	Michigan	PPOPCHG	0.1944813293
2016	Minnesota	PPOPCHG	0.7461190628
2016	Mississippi	PPOPCHG	-0.01321648
2016	Missouri	PPOPCHG	0.2545890844
2016	Montana	PPOPCHG	1.0053342882
2016	Nebraska	PPOPCHG	0.762196492
2016	Nevada	PPOPCHG	1.7815249318
2016	New Hampshire	PPOPCHG	0.4549148615
2016	New Jersey	PPOPCHG	0.041112094
2016	New Mexico	PPOPCHG	0.1233368306
2016	New York	PPOPCHG	-0.100816773
2016	North Carolina	PPOPCHG	1.2319249156
2016	North Dakota	PPOPCHG	0.0438979234
2016	Ohio	PPOPCHG	0.1476434969
2016	Oklahoma	PPOPCHG	0.4332156556
2016	Oregon	PPOPCHG	1.8543072077
2016	Pennsylvania	PPOPCHG	-0.017370889
2016	Rhode Island	PPOPCHG	0.084266498
2016	South Carolina	PPOPCHG	1.3487037567
2016	South Dakota	PPOPCHG	1.0489113315
2016	Tennessee	PPOPCHG	0.8224029588
2016	Texas	PPOPCHG	1.6396152715
2016	Utah	PPOPCHG	2.0156265036
2016	Vermont	PPOPCHG	-0.248401704
2016	Virginia	PPOPCHG	0.5744294418
2016	Washington	PPOPCHG	1.830616498
2016	West Virginia	PPOPCHG	-0.600815637
2016	Wisconsin	PPOPCHG	0.2005066124
2016	Wyoming	PPOPCHG	-0.235286886
2017	Alabama	PPOPCHG	0.2132691436
2017	Alaska	PPOPCHG	-0.231691265
2017	Arizona	PPOPCHG	1.489089551
2017	Arkansas	PPOPCHG	0.4209121826
2017	California	PPOPCHG	0.4851472465
2017	Colorado	PPOPCHG	1.3532226863
2017	Connecticut	PPOPCHG	-0.133960232
2017	Delaware	PPOPCHG	0.8282624819
2017	District of Columbia	PPOPCHG	1.3277500637
2017	Florida	PPOPCHG	1.6811939051
2017	Georgia	PPOPCHG	1.0508926794
2017	Hawaii	PPOPCHG	-0.273229209
2017	Idaho	PPOPCHG	2.1375814799
2017	Illinois	PPOPCHG	-0.317294248
2017	Indiana	PPOPCHG	0.403084779
2017	Iowa	PPOPCHG	0.378442326
2017	Kansas	PPOPCHG	-0.019716529
2017	Kentucky	PPOPCHG	0.3525054701
2017	Louisiana	PPOPCHG	-0.158115863
2017	Maine	PPOPCHG	0.2773834471
2017	Maryland	PPOPCHG	0.3363869454
2017	Massachusetts	PPOPCHG	0.5453249345
2017	Michigan	PPOPCHG	0.2467571486
2017	Minnesota	PPOPCHG	0.8101156369
2017	Mississippi	PPOPCHG	0.0456781753
2017	Missouri	PPOPCHG	0.3517050442
2017	Montana	PPOPCHG	1.1746983032
2017	Nebraska	PPOPCHG	0.6113045431
2017	Nevada	PPOPCHG	1.8026407541
2017	New Hampshire	PPOPCHG	0.5508156079
2017	New Jersey	PPOPCHG	0.158059324
2017	New Mexico	PPOPCHG	0.0289565742
2017	New York	PPOPCHG	-0.258991266
2017	North Carolina	PPOPCHG	1.123605462
2017	North Dakota	PPOPCHG	0.1091001163
2017	Ohio	PPOPCHG	0.2503308336
2017	Oklahoma	PPOPCHG	0.1495122326
2017	Oregon	PPOPCHG	1.3488768159
2017	Pennsylvania	PPOPCHG	0.0540460708
2017	Rhode Island	PPOPCHG	-0.054585204
2017	South Carolina	PPOPCHG	1.2702907385
2017	South Dakota	PPOPCHG	1.2047885594
2017	Tennessee	PPOPCHG	0.9598629709
2017	Texas	PPOPCHG	1.3788818266
2017	Utah	PPOPCHG	1.9885867838
2017	Vermont	PPOPCHG	0.1412664918
2017	Virginia	PPOPCHG	0.6451236282
2017	Washington	PPOPCHG	1.7924295514
2017	West Virginia	PPOPCHG	-0.75813972
2017	Wisconsin	PPOPCHG	0.330731663
2017	Wyoming	PPOPCHG	-0.916668093
2018	Alabama	PPOPCHG	0.2615525361
2018	Alaska	PPOPCHG	-0.317389083
2018	Arizona	PPOPCHG	1.7416961229
2018	Arkansas	PPOPCHG	0.3605731208
2018	California	PPOPCHG	0.4002502681
2018	Colorado	PPOPCHG	1.4185076591
2018	Connecticut	PPOPCHG	-0.033996665
2018	Delaware	PPOPCHG	1.0545639958
2018	District of Columbia	PPOPCHG	0.9722707351
2018	Florida	PPOPCHG	1.5374738545
2018	Georgia	PPOPCHG	1.0219863431
2018	Hawaii	PPOPCHG	-0.260637002
2018	Idaho	PPOPCHG	2.0538668826
2018	Illinois	PPOPCHG	-0.352849276
2018	Indiana	PPOPCHG	0.4774115394
2018	Iowa	PPOPCHG	0.3978830889
2018	Kansas	PPOPCHG	0.0280345994
2018	Kentucky	PPOPCHG	0.3261879433
2018	Louisiana	PPOPCHG	-0.232079263
2018	Maine	PPOPCHG	0.2502503627
2018	Maryland	PPOPCHG	0.2958891704
2018	Massachusetts	PPOPCHG	0.5668309135
2018	Michigan	PPOPCHG	0.1951396123
2018	Minnesota	PPOPCHG	0.7726796398
2018	Mississippi	PPOPCHG	-0.10479442
2018	Missouri	PPOPCHG	0.2920467039
2018	Montana	PPOPCHG	0.8750439184
2018	Nebraska	PPOPCHG	0.6097805822
2018	Nevada	PPOPCHG	2.0854156819
2018	New Hampshire	PPOPCHG	0.4957151864
2018	New Jersey	PPOPCHG	0.2247499956
2018	New Mexico	PPOPCHG	0.0971149735
2018	New York	PPOPCHG	-0.247617252
2018	North Carolina	PPOPCHG	1.0984538692
2018	North Dakota	PPOPCHG	0.6489877856
2018	Ohio	PPOPCHG	0.2170157755
2018	Oklahoma	PPOPCHG	0.2654450954
2018	Oregon	PPOPCHG	1.0640304134
2018	Pennsylvania	PPOPCHG	0.1298860001
2018	Rhode Island	PPOPCHG	0.0784676749
2018	South Carolina	PPOPCHG	1.2528431841
2018	South Dakota	PPOPCHG	1.0247501964
2018	Tennessee	PPOPCHG	0.9124739856
2018	Texas	PPOPCHG	1.3386003892
2018	Utah	PPOPCHG	1.8686688679
2018	Vermont	PPOPCHG	0.2840558825
2018	Virginia	PPOPCHG	0.6199257738
2018	Washington	PPOPCHG	1.4835365808
2018	West Virginia	PPOPCHG	-0.617264926
2018	Wisconsin	PPOPCHG	0.3714918947
2018	Wyoming	PPOPCHG	-0.20675932
2010	Alabama	NRANKESTBASE	23
2010	Alaska	NRANKESTBASE	47
2010	Arizona	NRANKESTBASE	16
2010	Arkansas	NRANKESTBASE	32
2010	California	NRANKESTBASE	1
2010	Colorado	NRANKESTBASE	22
2010	Connecticut	NRANKESTBASE	29
2010	Delaware	NRANKESTBASE	45
2010	District of Columbia	NRANKESTBASE	50
2010	Florida	NRANKESTBASE	4
2010	Georgia	NRANKESTBASE	9
2010	Hawaii	NRANKESTBASE	40
2010	Idaho	NRANKESTBASE	39
2010	Illinois	NRANKESTBASE	5
2010	Indiana	NRANKESTBASE	15
2010	Iowa	NRANKESTBASE	30
2010	Kansas	NRANKESTBASE	33
2010	Kentucky	NRANKESTBASE	26
2010	Louisiana	NRANKESTBASE	25
2010	Maine	NRANKESTBASE	41
2010	Maryland	NRANKESTBASE	19
2010	Massachusetts	NRANKESTBASE	14
2010	Michigan	NRANKESTBASE	8
2010	Minnesota	NRANKESTBASE	21
2010	Mississippi	NRANKESTBASE	31
2010	Missouri	NRANKESTBASE	18
2010	Montana	NRANKESTBASE	44
2010	Nebraska	NRANKESTBASE	38
2010	Nevada	NRANKESTBASE	35
2010	New Hampshire	NRANKESTBASE	42
2010	New Jersey	NRANKESTBASE	11
2010	New Mexico	NRANKESTBASE	36
2010	New York	NRANKESTBASE	3
2010	North Carolina	NRANKESTBASE	10
2010	North Dakota	NRANKESTBASE	48
2010	Ohio	NRANKESTBASE	7
2010	Oklahoma	NRANKESTBASE	28
2010	Oregon	NRANKESTBASE	27
2010	Pennsylvania	NRANKESTBASE	6
2010	Rhode Island	NRANKESTBASE	43
2010	South Carolina	NRANKESTBASE	24
2010	South Dakota	NRANKESTBASE	46
2010	Tennessee	NRANKESTBASE	17
2010	Texas	NRANKESTBASE	2
2010	Utah	NRANKESTBASE	34
2010	Vermont	NRANKESTBASE	49
2010	Virginia	NRANKESTBASE	12
2010	Washington	NRANKESTBASE	13
2010	West Virginia	NRANKESTBASE	37
2010	Wisconsin	NRANKESTBASE	20
2010	Wyoming	NRANKESTBASE	51
2010	Alabama	NRANKPOPEST	23
2010	Alaska	NRANKPOPEST	47
2010	Arizona	NRANKPOPEST	16
2010	Arkansas	NRANKPOPEST	32
2010	California	NRANKPOPEST	1
2010	Colorado	NRANKPOPEST	22
2010	Connecticut	NRANKPOPEST	29
2010	Delaware	NRANKPOPEST	45
2010	District of Columbia	NRANKPOPEST	50
2010	Florida	NRANKPOPEST	4
2010	Georgia	NRANKPOPEST	9
2010	Hawaii	NRANKPOPEST	40
2010	Idaho	NRANKPOPEST	39
2010	Illinois	NRANKPOPEST	5
2010	Indiana	NRANKPOPEST	15
2010	Iowa	NRANKPOPEST	30
2010	Kansas	NRANKPOPEST	33
2010	Kentucky	NRANKPOPEST	26
2010	Louisiana	NRANKPOPEST	25
2010	Maine	NRANKPOPEST	41
2010	Maryland	NRANKPOPEST	19
2010	Massachusetts	NRANKPOPEST	14
2010	Michigan	NRANKPOPEST	8
2010	Minnesota	NRANKPOPEST	21
2010	Mississippi	NRANKPOPEST	31
2010	Missouri	NRANKPOPEST	18
2010	Montana	NRANKPOPEST	44
2010	Nebraska	NRANKPOPEST	38
2010	Nevada	NRANKPOPEST	35
2010	New Hampshire	NRANKPOPEST	42
2010	New Jersey	NRANKPOPEST	11
2010	New Mexico	NRANKPOPEST	36
2010	New York	NRANKPOPEST	3
2010	North Carolina	NRANKPOPEST	10
2010	North Dakota	NRANKPOPEST	48
2010	Ohio	NRANKPOPEST	7
2010	Oklahoma	NRANKPOPEST	28
2010	Oregon	NRANKPOPEST	27
2010	Pennsylvania	NRANKPOPEST	6
2010	Rhode Island	NRANKPOPEST	43
2010	South Carolina	NRANKPOPEST	24
2010	South Dakota	NRANKPOPEST	46
2010	Tennessee	NRANKPOPEST	17
2010	Texas	NRANKPOPEST	2
2010	Utah	NRANKPOPEST	34
2010	Vermont	NRANKPOPEST	49
2010	Virginia	NRANKPOPEST	12
2010	Washington	NRANKPOPEST	13
2010	West Virginia	NRANKPOPEST	37
2010	Wisconsin	NRANKPOPEST	20
2010	Wyoming	NRANKPOPEST	51
2011	Alabama	NRANKPOPEST	23
2011	Alaska	NRANKPOPEST	47
2011	Arizona	NRANKPOPEST	16
2011	Arkansas	NRANKPOPEST	32
2011	California	NRANKPOPEST	1
2011	Colorado	NRANKPOPEST	22
2011	Connecticut	NRANKPOPEST	29
2011	Delaware	NRANKPOPEST	45
2011	District of Columbia	NRANKPOPEST	50
2011	Florida	NRANKPOPEST	4
2011	Georgia	NRANKPOPEST	9
2011	Hawaii	NRANKPOPEST	40
2011	Idaho	NRANKPOPEST	39
2011	Illinois	NRANKPOPEST	5
2011	Indiana	NRANKPOPEST	15
2011	Iowa	NRANKPOPEST	30
2011	Kansas	NRANKPOPEST	33
2011	Kentucky	NRANKPOPEST	26
2011	Louisiana	NRANKPOPEST	25
2011	Maine	NRANKPOPEST	41
2011	Maryland	NRANKPOPEST	19
2011	Massachusetts	NRANKPOPEST	14
2011	Michigan	NRANKPOPEST	8
2011	Minnesota	NRANKPOPEST	21
2011	Mississippi	NRANKPOPEST	31
2011	Missouri	NRANKPOPEST	18
2011	Montana	NRANKPOPEST	44
2011	Nebraska	NRANKPOPEST	38
2011	Nevada	NRANKPOPEST	35
2011	New Hampshire	NRANKPOPEST	42
2011	New Jersey	NRANKPOPEST	11
2011	New Mexico	NRANKPOPEST	36
2011	New York	NRANKPOPEST	3
2011	North Carolina	NRANKPOPEST	10
2011	North Dakota	NRANKPOPEST	48
2011	Ohio	NRANKPOPEST	7
2011	Oklahoma	NRANKPOPEST	28
2011	Oregon	NRANKPOPEST	27
2011	Pennsylvania	NRANKPOPEST	6
2011	Rhode Island	NRANKPOPEST	43
2011	South Carolina	NRANKPOPEST	24
2011	South Dakota	NRANKPOPEST	46
2011	Tennessee	NRANKPOPEST	17
2011	Texas	NRANKPOPEST	2
2011	Utah	NRANKPOPEST	34
2011	Vermont	NRANKPOPEST	49
2011	Virginia	NRANKPOPEST	12
2011	Washington	NRANKPOPEST	13
2011	West Virginia	NRANKPOPEST	37
2011	Wisconsin	NRANKPOPEST	20
2011	Wyoming	NRANKPOPEST	51
2012	Alabama	NRANKPOPEST	23
2012	Alaska	NRANKPOPEST	47
2012	Arizona	NRANKPOPEST	15
2012	Arkansas	NRANKPOPEST	32
2012	California	NRANKPOPEST	1
2012	Colorado	NRANKPOPEST	22
2012	Connecticut	NRANKPOPEST	29
2012	Delaware	NRANKPOPEST	45
2012	District of Columbia	NRANKPOPEST	49
2012	Florida	NRANKPOPEST	4
2012	Georgia	NRANKPOPEST	8
2012	Hawaii	NRANKPOPEST	40
2012	Idaho	NRANKPOPEST	39
2012	Illinois	NRANKPOPEST	5
2012	Indiana	NRANKPOPEST	16
2012	Iowa	NRANKPOPEST	30
2012	Kansas	NRANKPOPEST	33
2012	Kentucky	NRANKPOPEST	26
2012	Louisiana	NRANKPOPEST	25
2012	Maine	NRANKPOPEST	41
2012	Maryland	NRANKPOPEST	19
2012	Massachusetts	NRANKPOPEST	14
2012	Michigan	NRANKPOPEST	9
2012	Minnesota	NRANKPOPEST	21
2012	Mississippi	NRANKPOPEST	31
2012	Missouri	NRANKPOPEST	18
2012	Montana	NRANKPOPEST	44
2012	Nebraska	NRANKPOPEST	38
2012	Nevada	NRANKPOPEST	35
2012	New Hampshire	NRANKPOPEST	42
2012	New Jersey	NRANKPOPEST	11
2012	New Mexico	NRANKPOPEST	36
2012	New York	NRANKPOPEST	3
2012	North Carolina	NRANKPOPEST	10
2012	North Dakota	NRANKPOPEST	48
2012	Ohio	NRANKPOPEST	7
2012	Oklahoma	NRANKPOPEST	28
2012	Oregon	NRANKPOPEST	27
2012	Pennsylvania	NRANKPOPEST	6
2012	Rhode Island	NRANKPOPEST	43
2012	South Carolina	NRANKPOPEST	24
2012	South Dakota	NRANKPOPEST	46
2012	Tennessee	NRANKPOPEST	17
2012	Texas	NRANKPOPEST	2
2012	Utah	NRANKPOPEST	34
2012	Vermont	NRANKPOPEST	50
2012	Virginia	NRANKPOPEST	12
2012	Washington	NRANKPOPEST	13
2012	West Virginia	NRANKPOPEST	37
2012	Wisconsin	NRANKPOPEST	20
2012	Wyoming	NRANKPOPEST	51
2013	Alabama	NRANKPOPEST	23
2013	Alaska	NRANKPOPEST	47
2013	Arizona	NRANKPOPEST	15
2013	Arkansas	NRANKPOPEST	32
2013	California	NRANKPOPEST	1
2013	Colorado	NRANKPOPEST	22
2013	Connecticut	NRANKPOPEST	29
2013	Delaware	NRANKPOPEST	45
2013	District of Columbia	NRANKPOPEST	49
2013	Florida	NRANKPOPEST	4
2013	Georgia	NRANKPOPEST	8
2013	Hawaii	NRANKPOPEST	40
2013	Idaho	NRANKPOPEST	39
2013	Illinois	NRANKPOPEST	5
2013	Indiana	NRANKPOPEST	16
2013	Iowa	NRANKPOPEST	30
2013	Kansas	NRANKPOPEST	34
2013	Kentucky	NRANKPOPEST	26
2013	Louisiana	NRANKPOPEST	25
2013	Maine	NRANKPOPEST	41
2013	Maryland	NRANKPOPEST	19
2013	Massachusetts	NRANKPOPEST	14
2013	Michigan	NRANKPOPEST	9
2013	Minnesota	NRANKPOPEST	21
2013	Mississippi	NRANKPOPEST	31
2013	Missouri	NRANKPOPEST	18
2013	Montana	NRANKPOPEST	44
2013	Nebraska	NRANKPOPEST	37
2013	Nevada	NRANKPOPEST	35
2013	New Hampshire	NRANKPOPEST	42
2013	New Jersey	NRANKPOPEST	11
2013	New Mexico	NRANKPOPEST	36
2013	New York	NRANKPOPEST	3
2013	North Carolina	NRANKPOPEST	10
2013	North Dakota	NRANKPOPEST	48
2013	Ohio	NRANKPOPEST	7
2013	Oklahoma	NRANKPOPEST	28
2013	Oregon	NRANKPOPEST	27
2013	Pennsylvania	NRANKPOPEST	6
2013	Rhode Island	NRANKPOPEST	43
2013	South Carolina	NRANKPOPEST	24
2013	South Dakota	NRANKPOPEST	46
2013	Tennessee	NRANKPOPEST	17
2013	Texas	NRANKPOPEST	2
2013	Utah	NRANKPOPEST	33
2013	Vermont	NRANKPOPEST	50
2013	Virginia	NRANKPOPEST	12
2013	Washington	NRANKPOPEST	13
2013	West Virginia	NRANKPOPEST	38
2013	Wisconsin	NRANKPOPEST	20
2013	Wyoming	NRANKPOPEST	51
2014	Alabama	NRANKPOPEST	23
2014	Alaska	NRANKPOPEST	48
2014	Arizona	NRANKPOPEST	15
2014	Arkansas	NRANKPOPEST	32
2014	California	NRANKPOPEST	1
2014	Colorado	NRANKPOPEST	22
2014	Connecticut	NRANKPOPEST	29
2014	Delaware	NRANKPOPEST	45
2014	District of Columbia	NRANKPOPEST	49
2014	Florida	NRANKPOPEST	3
2014	Georgia	NRANKPOPEST	8
2014	Hawaii	NRANKPOPEST	40
2014	Idaho	NRANKPOPEST	39
2014	Illinois	NRANKPOPEST	5
2014	Indiana	NRANKPOPEST	16
2014	Iowa	NRANKPOPEST	30
2014	Kansas	NRANKPOPEST	34
2014	Kentucky	NRANKPOPEST	26
2014	Louisiana	NRANKPOPEST	25
2014	Maine	NRANKPOPEST	42
2014	Maryland	NRANKPOPEST	19
2014	Massachusetts	NRANKPOPEST	14
2014	Michigan	NRANKPOPEST	10
2014	Minnesota	NRANKPOPEST	21
2014	Mississippi	NRANKPOPEST	31
2014	Missouri	NRANKPOPEST	18
2014	Montana	NRANKPOPEST	44
2014	Nebraska	NRANKPOPEST	37
2014	Nevada	NRANKPOPEST	35
2014	New Hampshire	NRANKPOPEST	41
2014	New Jersey	NRANKPOPEST	11
2014	New Mexico	NRANKPOPEST	36
2014	New York	NRANKPOPEST	4
2014	North Carolina	NRANKPOPEST	9
2014	North Dakota	NRANKPOPEST	47
2014	Ohio	NRANKPOPEST	7
2014	Oklahoma	NRANKPOPEST	28
2014	Oregon	NRANKPOPEST	27
2014	Pennsylvania	NRANKPOPEST	6
2014	Rhode Island	NRANKPOPEST	43
2014	South Carolina	NRANKPOPEST	24
2014	South Dakota	NRANKPOPEST	46
2014	Tennessee	NRANKPOPEST	17
2014	Texas	NRANKPOPEST	2
2014	Utah	NRANKPOPEST	33
2014	Vermont	NRANKPOPEST	50
2014	Virginia	NRANKPOPEST	12
2014	Washington	NRANKPOPEST	13
2014	West Virginia	NRANKPOPEST	38
2014	Wisconsin	NRANKPOPEST	20
2014	Wyoming	NRANKPOPEST	51
2015	Alabama	NRANKPOPEST	24
2015	Alaska	NRANKPOPEST	48
2015	Arizona	NRANKPOPEST	14
2015	Arkansas	NRANKPOPEST	33
2015	California	NRANKPOPEST	1
2015	Colorado	NRANKPOPEST	22
2015	Connecticut	NRANKPOPEST	29
2015	Delaware	NRANKPOPEST	45
2015	District of Columbia	NRANKPOPEST	49
2015	Florida	NRANKPOPEST	3
2015	Georgia	NRANKPOPEST	8
2015	Hawaii	NRANKPOPEST	40
2015	Idaho	NRANKPOPEST	39
2015	Illinois	NRANKPOPEST	5
2015	Indiana	NRANKPOPEST	16
2015	Iowa	NRANKPOPEST	30
2015	Kansas	NRANKPOPEST	34
2015	Kentucky	NRANKPOPEST	26
2015	Louisiana	NRANKPOPEST	25
2015	Maine	NRANKPOPEST	42
2015	Maryland	NRANKPOPEST	19
2015	Massachusetts	NRANKPOPEST	15
2015	Michigan	NRANKPOPEST	10
2015	Minnesota	NRANKPOPEST	21
2015	Mississippi	NRANKPOPEST	31
2015	Missouri	NRANKPOPEST	18
2015	Montana	NRANKPOPEST	44
2015	Nebraska	NRANKPOPEST	37
2015	Nevada	NRANKPOPEST	35
2015	New Hampshire	NRANKPOPEST	41
2015	New Jersey	NRANKPOPEST	11
2015	New Mexico	NRANKPOPEST	36
2015	New York	NRANKPOPEST	4
2015	North Carolina	NRANKPOPEST	9
2015	North Dakota	NRANKPOPEST	47
2015	Ohio	NRANKPOPEST	7
2015	Oklahoma	NRANKPOPEST	28
2015	Oregon	NRANKPOPEST	27
2015	Pennsylvania	NRANKPOPEST	6
2015	Rhode Island	NRANKPOPEST	43
2015	South Carolina	NRANKPOPEST	23
2015	South Dakota	NRANKPOPEST	46
2015	Tennessee	NRANKPOPEST	17
2015	Texas	NRANKPOPEST	2
2015	Utah	NRANKPOPEST	32
2015	Vermont	NRANKPOPEST	50
2015	Virginia	NRANKPOPEST	12
2015	Washington	NRANKPOPEST	13
2015	West Virginia	NRANKPOPEST	38
2015	Wisconsin	NRANKPOPEST	20
2015	Wyoming	NRANKPOPEST	51
2016	Alabama	NRANKPOPEST	24
2016	Alaska	NRANKPOPEST	48
2016	Arizona	NRANKPOPEST	14
2016	Arkansas	NRANKPOPEST	32
2016	California	NRANKPOPEST	1
2016	Colorado	NRANKPOPEST	21
2016	Connecticut	NRANKPOPEST	29
2016	Delaware	NRANKPOPEST	45
2016	District of Columbia	NRANKPOPEST	49
2016	Florida	NRANKPOPEST	3
2016	Georgia	NRANKPOPEST	8
2016	Hawaii	NRANKPOPEST	40
2016	Idaho	NRANKPOPEST	39
2016	Illinois	NRANKPOPEST	5
2016	Indiana	NRANKPOPEST	17
2016	Iowa	NRANKPOPEST	30
2016	Kansas	NRANKPOPEST	35
2016	Kentucky	NRANKPOPEST	26
2016	Louisiana	NRANKPOPEST	25
2016	Maine	NRANKPOPEST	42
2016	Maryland	NRANKPOPEST	19
2016	Massachusetts	NRANKPOPEST	15
2016	Michigan	NRANKPOPEST	10
2016	Minnesota	NRANKPOPEST	22
2016	Mississippi	NRANKPOPEST	33
2016	Missouri	NRANKPOPEST	18
2016	Montana	NRANKPOPEST	44
2016	Nebraska	NRANKPOPEST	37
2016	Nevada	NRANKPOPEST	34
2016	New Hampshire	NRANKPOPEST	41
2016	New Jersey	NRANKPOPEST	11
2016	New Mexico	NRANKPOPEST	36
2016	New York	NRANKPOPEST	4
2016	North Carolina	NRANKPOPEST	9
2016	North Dakota	NRANKPOPEST	47
2016	Ohio	NRANKPOPEST	7
2016	Oklahoma	NRANKPOPEST	28
2016	Oregon	NRANKPOPEST	27
2016	Pennsylvania	NRANKPOPEST	6
2016	Rhode Island	NRANKPOPEST	43
2016	South Carolina	NRANKPOPEST	23
2016	South Dakota	NRANKPOPEST	46
2016	Tennessee	NRANKPOPEST	16
2016	Texas	NRANKPOPEST	2
2016	Utah	NRANKPOPEST	31
2016	Vermont	NRANKPOPEST	50
2016	Virginia	NRANKPOPEST	12
2016	Washington	NRANKPOPEST	13
2016	West Virginia	NRANKPOPEST	38
2016	Wisconsin	NRANKPOPEST	20
2016	Wyoming	NRANKPOPEST	51
2017	Alabama	NRANKPOPEST	24
2017	Alaska	NRANKPOPEST	48
2017	Arizona	NRANKPOPEST	14
2017	Arkansas	NRANKPOPEST	32
2017	California	NRANKPOPEST	1
2017	Colorado	NRANKPOPEST	21
2017	Connecticut	NRANKPOPEST	29
2017	Delaware	NRANKPOPEST	45
2017	District of Columbia	NRANKPOPEST	49
2017	Florida	NRANKPOPEST	3
2017	Georgia	NRANKPOPEST	8
2017	Hawaii	NRANKPOPEST	40
2017	Idaho	NRANKPOPEST	39
2017	Illinois	NRANKPOPEST	6
2017	Indiana	NRANKPOPEST	17
2017	Iowa	NRANKPOPEST	30
2017	Kansas	NRANKPOPEST	35
2017	Kentucky	NRANKPOPEST	26
2017	Louisiana	NRANKPOPEST	25
2017	Maine	NRANKPOPEST	42
2017	Maryland	NRANKPOPEST	19
2017	Massachusetts	NRANKPOPEST	15
2017	Michigan	NRANKPOPEST	10
2017	Minnesota	NRANKPOPEST	22
2017	Mississippi	NRANKPOPEST	33
2017	Missouri	NRANKPOPEST	18
2017	Montana	NRANKPOPEST	44
2017	Nebraska	NRANKPOPEST	37
2017	Nevada	NRANKPOPEST	34
2017	New Hampshire	NRANKPOPEST	41
2017	New Jersey	NRANKPOPEST	11
2017	New Mexico	NRANKPOPEST	36
2017	New York	NRANKPOPEST	4
2017	North Carolina	NRANKPOPEST	9
2017	North Dakota	NRANKPOPEST	47
2017	Ohio	NRANKPOPEST	7
2017	Oklahoma	NRANKPOPEST	28
2017	Oregon	NRANKPOPEST	27
2017	Pennsylvania	NRANKPOPEST	5
2017	Rhode Island	NRANKPOPEST	43
2017	South Carolina	NRANKPOPEST	23
2017	South Dakota	NRANKPOPEST	46
2017	Tennessee	NRANKPOPEST	16
2017	Texas	NRANKPOPEST	2
2017	Utah	NRANKPOPEST	31
2017	Vermont	NRANKPOPEST	50
2017	Virginia	NRANKPOPEST	12
2017	Washington	NRANKPOPEST	13
2017	West Virginia	NRANKPOPEST	38
2017	Wisconsin	NRANKPOPEST	20
2017	Wyoming	NRANKPOPEST	51
2018	Alabama	NRANKPOPEST	24
2018	Alaska	NRANKPOPEST	48
2018	Arizona	NRANKPOPEST	14
2018	Arkansas	NRANKPOPEST	33
2018	California	NRANKPOPEST	1
2018	Colorado	NRANKPOPEST	21
2018	Connecticut	NRANKPOPEST	29
2018	Delaware	NRANKPOPEST	45
2018	District of Columbia	NRANKPOPEST	49
2018	Florida	NRANKPOPEST	3
2018	Georgia	NRANKPOPEST	8
2018	Hawaii	NRANKPOPEST	40
2018	Idaho	NRANKPOPEST	39
2018	Illinois	NRANKPOPEST	6
2018	Indiana	NRANKPOPEST	17
2018	Iowa	NRANKPOPEST	31
2018	Kansas	NRANKPOPEST	35
2018	Kentucky	NRANKPOPEST	26
2018	Louisiana	NRANKPOPEST	25
2018	Maine	NRANKPOPEST	42
2018	Maryland	NRANKPOPEST	19
2018	Massachusetts	NRANKPOPEST	15
2018	Michigan	NRANKPOPEST	10
2018	Minnesota	NRANKPOPEST	22
2018	Mississippi	NRANKPOPEST	34
2018	Missouri	NRANKPOPEST	18
2018	Montana	NRANKPOPEST	43
2018	Nebraska	NRANKPOPEST	37
2018	Nevada	NRANKPOPEST	32
2018	New Hampshire	NRANKPOPEST	41
2018	New Jersey	NRANKPOPEST	11
2018	New Mexico	NRANKPOPEST	36
2018	New York	NRANKPOPEST	4
2018	North Carolina	NRANKPOPEST	9
2018	North Dakota	NRANKPOPEST	47
2018	Ohio	NRANKPOPEST	7
2018	Oklahoma	NRANKPOPEST	28
2018	Oregon	NRANKPOPEST	27
2018	Pennsylvania	NRANKPOPEST	5
2018	Rhode Island	NRANKPOPEST	44
2018	South Carolina	NRANKPOPEST	23
2018	South Dakota	NRANKPOPEST	46
2018	Tennessee	NRANKPOPEST	16
2018	Texas	NRANKPOPEST	2
2018	Utah	NRANKPOPEST	30
2018	Vermont	NRANKPOPEST	50
2018	Virginia	NRANKPOPEST	12
2018	Washington	NRANKPOPEST	13
2018	West Virginia	NRANKPOPEST	38
2018	Wisconsin	NRANKPOPEST	20
2018	Wyoming	NRANKPOPEST	51
2010	Alabama	NRANKNPCHG	28
2010	Alaska	NRANKNPCHG	32
2010	Arizona	NRANKNPCHG	11
2010	Arkansas	NRANKNPCHG	26
2010	California	NRANKNPCHG	2
2010	Colorado	NRANKNPCHG	8
2010	Connecticut	NRANKNPCHG	30
2010	Delaware	NRANKNPCHG	43
2010	District of Columbia	NRANKNPCHG	34
2010	Florida	NRANKNPCHG	3
2010	Georgia	NRANKNPCHG	5
2010	Hawaii	NRANKNPCHG	33
2010	Idaho	NRANKNPCHG	37
2010	Illinois	NRANKNPCHG	16
2010	Indiana	NRANKNPCHG	25
2010	Iowa	NRANKNPCHG	31
2010	Kansas	NRANKNPCHG	29
2010	Kentucky	NRANKNPCHG	18
2010	Louisiana	NRANKNPCHG	14
2010	Maine	NRANKNPCHG	50
2010	Maryland	NRANKNPCHG	12
2010	Massachusetts	NRANKNPCHG	9
2010	Michigan	NRANKNPCHG	51
2010	Minnesota	NRANKNPCHG	23
2010	Mississippi	NRANKNPCHG	39
2010	Missouri	NRANKNPCHG	22
2010	Montana	NRANKNPCHG	44
2010	Nebraska	NRANKNPCHG	35
2010	Nevada	NRANKNPCHG	42
2010	New Hampshire	NRANKNPCHG	48
2010	New Jersey	NRANKNPCHG	21
2010	New Mexico	NRANKNPCHG	27
2010	New York	NRANKNPCHG	7
2010	North Carolina	NRANKNPCHG	4
2010	North Dakota	NRANKNPCHG	40
2010	Ohio	NRANKNPCHG	38
2010	Oklahoma	NRANKNPCHG	20
2010	Oregon	NRANKNPCHG	24
2010	Pennsylvania	NRANKNPCHG	19
2010	Rhode Island	NRANKNPCHG	46
2010	South Carolina	NRANKNPCHG	15
2010	South Dakota	NRANKNPCHG	41
2010	Tennessee	NRANKNPCHG	17
2010	Texas	NRANKNPCHG	1
2010	Utah	NRANKNPCHG	13
2010	Vermont	NRANKNPCHG	49
2010	Virginia	NRANKNPCHG	6
2010	Washington	NRANKNPCHG	10
2010	West Virginia	NRANKNPCHG	45
2010	Wisconsin	NRANKNPCHG	36
2010	Wyoming	NRANKNPCHG	47
2011	Alabama	NRANKNPCHG	32
2011	Alaska	NRANKNPCHG	39
2011	Arizona	NRANKNPCHG	10
2011	Arkansas	NRANKNPCHG	25
2011	California	NRANKNPCHG	2
2011	Colorado	NRANKNPCHG	9
2011	Connecticut	NRANKNPCHG	38
2011	Delaware	NRANKNPCHG	41
2011	District of Columbia	NRANKNPCHG	29
2011	Florida	NRANKNPCHG	3
2011	Georgia	NRANKNPCHG	5
2011	Hawaii	NRANKNPCHG	27
2011	Idaho	NRANKNPCHG	33
2011	Illinois	NRANKNPCHG	22
2011	Indiana	NRANKNPCHG	23
2011	Iowa	NRANKNPCHG	28
2011	Kansas	NRANKNPCHG	35
2011	Kentucky	NRANKNPCHG	24
2011	Louisiana	NRANKNPCHG	19
2011	Maine	NRANKNPCHG	50
2011	Maryland	NRANKNPCHG	11
2011	Massachusetts	NRANKNPCHG	12
2011	Michigan	NRANKNPCHG	45
2011	Minnesota	NRANKNPCHG	16
2011	Mississippi	NRANKNPCHG	40
2011	Missouri	NRANKNPCHG	31
2011	Montana	NRANKNPCHG	43
2011	Nebraska	NRANKNPCHG	34
2011	Nevada	NRANKNPCHG	37
2011	New Hampshire	NRANKNPCHG	46
2011	New Jersey	NRANKNPCHG	21
2011	New Mexico	NRANKNPCHG	26
2011	New York	NRANKNPCHG	4
2011	North Carolina	NRANKNPCHG	6
2011	North Dakota	NRANKNPCHG	36
2011	Ohio	NRANKNPCHG	44
2011	Oklahoma	NRANKNPCHG	20
2011	Oregon	NRANKNPCHG	17
2011	Pennsylvania	NRANKNPCHG	18
2011	Rhode Island	NRANKNPCHG	51
2011	South Carolina	NRANKNPCHG	15
2011	South Dakota	NRANKNPCHG	42
2011	Tennessee	NRANKNPCHG	13
2011	Texas	NRANKNPCHG	1
2011	Utah	NRANKNPCHG	14
2011	Vermont	NRANKNPCHG	49
2011	Virginia	NRANKNPCHG	8
2011	Washington	NRANKNPCHG	7
2011	West Virginia	NRANKNPCHG	48
2011	Wisconsin	NRANKNPCHG	30
2011	Wyoming	NRANKNPCHG	47
2012	Alabama	NRANKNPCHG	26
2012	Alaska	NRANKNPCHG	40
2012	Arizona	NRANKNPCHG	7
2012	Arkansas	NRANKNPCHG	35
2012	California	NRANKNPCHG	2
2012	Colorado	NRANKNPCHG	9
2012	Connecticut	NRANKNPCHG	44
2012	Delaware	NRANKNPCHG	41
2012	District of Columbia	NRANKNPCHG	31
2012	Florida	NRANKNPCHG	3
2012	Georgia	NRANKNPCHG	4
2012	Hawaii	NRANKNPCHG	29
2012	Idaho	NRANKNPCHG	36
2012	Illinois	NRANKNPCHG	25
2012	Indiana	NRANKNPCHG	22
2012	Iowa	NRANKNPCHG	37
2012	Kansas	NRANKNPCHG	27
2012	Kentucky	NRANKNPCHG	24
2012	Louisiana	NRANKNPCHG	20
2012	Maine	NRANKNPCHG	50
2012	Maryland	NRANKNPCHG	13
2012	Massachusetts	NRANKNPCHG	12
2012	Michigan	NRANKNPCHG	30
2012	Minnesota	NRANKNPCHG	17
2012	Mississippi	NRANKNPCHG	45
2012	Missouri	NRANKNPCHG	33
2012	Montana	NRANKNPCHG	43
2012	Nebraska	NRANKNPCHG	34
2012	Nevada	NRANKNPCHG	16
2012	New Hampshire	NRANKNPCHG	47
2012	New Jersey	NRANKNPCHG	23
2012	New Mexico	NRANKNPCHG	42
2012	New York	NRANKNPCHG	8
2012	North Carolina	NRANKNPCHG	5
2012	North Dakota	NRANKNPCHG	28
2012	Ohio	NRANKNPCHG	46
2012	Oklahoma	NRANKNPCHG	18
2012	Oregon	NRANKNPCHG	19
2012	Pennsylvania	NRANKNPCHG	21
2012	Rhode Island	NRANKNPCHG	48
2012	South Carolina	NRANKNPCHG	14
2012	South Dakota	NRANKNPCHG	38
2012	Tennessee	NRANKNPCHG	11
2012	Texas	NRANKNPCHG	1
2012	Utah	NRANKNPCHG	15
2012	Vermont	NRANKNPCHG	51
2012	Virginia	NRANKNPCHG	6
2012	Washington	NRANKNPCHG	10
2012	West Virginia	NRANKNPCHG	49
2012	Wisconsin	NRANKNPCHG	32
2012	Wyoming	NRANKNPCHG	39
2013	Alabama	NRANKNPCHG	31
2013	Alaska	NRANKNPCHG	42
2013	Arizona	NRANKNPCHG	5
2013	Arkansas	NRANKNPCHG	41
2013	California	NRANKNPCHG	2
2013	Colorado	NRANKNPCHG	6
2013	Connecticut	NRANKNPCHG	48
2013	Delaware	NRANKNPCHG	39
2013	District of Columbia	NRANKNPCHG	30
2013	Florida	NRANKNPCHG	3
2013	Georgia	NRANKNPCHG	7
2013	Hawaii	NRANKNPCHG	33
2013	Idaho	NRANKNPCHG	29
2013	Illinois	NRANKNPCHG	32
2013	Indiana	NRANKNPCHG	19
2013	Iowa	NRANKNPCHG	26
2013	Kansas	NRANKNPCHG	40
2013	Kentucky	NRANKNPCHG	24
2013	Louisiana	NRANKNPCHG	22
2013	Maine	NRANKNPCHG	49
2013	Maryland	NRANKNPCHG	16
2013	Massachusetts	NRANKNPCHG	11
2013	Michigan	NRANKNPCHG	28
2013	Minnesota	NRANKNPCHG	15
2013	Mississippi	NRANKNPCHG	45
2013	Missouri	NRANKNPCHG	27
2013	Montana	NRANKNPCHG	36
2013	Nebraska	NRANKNPCHG	35
2013	Nevada	NRANKNPCHG	18
2013	New Hampshire	NRANKNPCHG	46
2013	New Jersey	NRANKNPCHG	34
2013	New Mexico	NRANKNPCHG	44
2013	New York	NRANKNPCHG	10
2013	North Carolina	NRANKNPCHG	4
2013	North Dakota	NRANKNPCHG	23
2013	Ohio	NRANKNPCHG	20
2013	Oklahoma	NRANKNPCHG	17
2013	Oregon	NRANKNPCHG	21
2013	Pennsylvania	NRANKNPCHG	37
2013	Rhode Island	NRANKNPCHG	47
2013	South Carolina	NRANKNPCHG	12
2013	South Dakota	NRANKNPCHG	38
2013	Tennessee	NRANKNPCHG	14
2013	Texas	NRANKNPCHG	1
2013	Utah	NRANKNPCHG	13
2013	Vermont	NRANKNPCHG	50
2013	Virginia	NRANKNPCHG	9
2013	Washington	NRANKNPCHG	8
2013	West Virginia	NRANKNPCHG	51
2013	Wisconsin	NRANKNPCHG	25
2013	Wyoming	NRANKNPCHG	43
2014	Alabama	NRANKNPCHG	32
2014	Alaska	NRANKNPCHG	47
2014	Arizona	NRANKNPCHG	4
2014	Arkansas	NRANKNPCHG	37
2014	California	NRANKNPCHG	2
2014	Colorado	NRANKNPCHG	8
2014	Connecticut	NRANKNPCHG	46
2014	Delaware	NRANKNPCHG	34
2014	District of Columbia	NRANKNPCHG	31
2014	Florida	NRANKNPCHG	3
2014	Georgia	NRANKNPCHG	5
2014	Hawaii	NRANKNPCHG	41
2014	Idaho	NRANKNPCHG	22
2014	Illinois	NRANKNPCHG	51
2014	Indiana	NRANKNPCHG	20
2014	Iowa	NRANKNPCHG	25
2014	Kansas	NRANKNPCHG	38
2014	Kentucky	NRANKNPCHG	33
2014	Louisiana	NRANKNPCHG	23
2014	Maine	NRANKNPCHG	42
2014	Maryland	NRANKNPCHG	17
2014	Massachusetts	NRANKNPCHG	11
2014	Michigan	NRANKNPCHG	24
2014	Minnesota	NRANKNPCHG	16
2014	Mississippi	NRANKNPCHG	43
2014	Missouri	NRANKNPCHG	26
2014	Montana	NRANKNPCHG	36
2014	Nebraska	NRANKNPCHG	29
2014	Nevada	NRANKNPCHG	13
2014	New Hampshire	NRANKNPCHG	40
2014	New Jersey	NRANKNPCHG	35
2014	New Mexico	NRANKNPCHG	49
2014	New York	NRANKNPCHG	18
2014	North Carolina	NRANKNPCHG	6
2014	North Dakota	NRANKNPCHG	27
2014	Ohio	NRANKNPCHG	19
2014	Oklahoma	NRANKNPCHG	21
2014	Oregon	NRANKNPCHG	14
2014	Pennsylvania	NRANKNPCHG	30
2014	Rhode Island	NRANKNPCHG	44
2014	South Carolina	NRANKNPCHG	9
2014	South Dakota	NRANKNPCHG	39
2014	Tennessee	NRANKNPCHG	12
2014	Texas	NRANKNPCHG	1
2014	Utah	NRANKNPCHG	15
2014	Vermont	NRANKNPCHG	48
2014	Virginia	NRANKNPCHG	10
2014	Washington	NRANKNPCHG	7
2014	West Virginia	NRANKNPCHG	50
2014	Wisconsin	NRANKNPCHG	28
2014	Wyoming	NRANKNPCHG	45
2015	Alabama	NRANKNPCHG	30
2015	Alaska	NRANKNPCHG	42
2015	Arizona	NRANKNPCHG	7
2015	Arkansas	NRANKNPCHG	29
2015	California	NRANKNPCHG	3
2015	Colorado	NRANKNPCHG	6
2015	Connecticut	NRANKNPCHG	49
2015	Delaware	NRANKNPCHG	32
2015	District of Columbia	NRANKNPCHG	25
2015	Florida	NRANKNPCHG	2
2015	Georgia	NRANKNPCHG	4
2015	Hawaii	NRANKNPCHG	35
2015	Idaho	NRANKNPCHG	20
2015	Illinois	NRANKNPCHG	51
2015	Indiana	NRANKNPCHG	24
2015	Iowa	NRANKNPCHG	27
2015	Kansas	NRANKNPCHG	34
2015	Kentucky	NRANKNPCHG	28
2015	Louisiana	NRANKNPCHG	19
2015	Maine	NRANKNPCHG	47
2015	Maryland	NRANKNPCHG	18
2015	Massachusetts	NRANKNPCHG	15
2015	Michigan	NRANKNPCHG	41
2015	Minnesota	NRANKNPCHG	17
2015	Mississippi	NRANKNPCHG	46
2015	Missouri	NRANKNPCHG	22
2015	Montana	NRANKNPCHG	33
2015	Nebraska	NRANKNPCHG	26
2015	Nevada	NRANKNPCHG	13
2015	New Hampshire	NRANKNPCHG	40
2015	New Jersey	NRANKNPCHG	38
2015	New Mexico	NRANKNPCHG	45
2015	New York	NRANKNPCHG	36
2015	North Carolina	NRANKNPCHG	8
2015	North Dakota	NRANKNPCHG	21
2015	Ohio	NRANKNPCHG	23
2015	Oklahoma	NRANKNPCHG	16
2015	Oregon	NRANKNPCHG	10
2015	Pennsylvania	NRANKNPCHG	48
2015	Rhode Island	NRANKNPCHG	43
2015	South Carolina	NRANKNPCHG	9
2015	South Dakota	NRANKNPCHG	37
2015	Tennessee	NRANKNPCHG	12
2015	Texas	NRANKNPCHG	1
2015	Utah	NRANKNPCHG	14
2015	Vermont	NRANKNPCHG	44
2015	Virginia	NRANKNPCHG	11
2015	Washington	NRANKNPCHG	5
2015	West Virginia	NRANKNPCHG	50
2015	Wisconsin	NRANKNPCHG	31
2015	Wyoming	NRANKNPCHG	39
2016	Alabama	NRANKNPCHG	28
2016	Alaska	NRANKNPCHG	37
2016	Arizona	NRANKNPCHG	7
2016	Arkansas	NRANKNPCHG	27
2016	California	NRANKNPCHG	3
2016	Colorado	NRANKNPCHG	8
2016	Connecticut	NRANKNPCHG	48
2016	Delaware	NRANKNPCHG	34
2016	District of Columbia	NRANKNPCHG	30
2016	Florida	NRANKNPCHG	2
2016	Georgia	NRANKNPCHG	5
2016	Hawaii	NRANKNPCHG	36
2016	Idaho	NRANKNPCHG	16
2016	Illinois	NRANKNPCHG	51
2016	Indiana	NRANKNPCHG	18
2016	Iowa	NRANKNPCHG	32
2016	Kansas	NRANKNPCHG	41
2016	Kentucky	NRANKNPCHG	26
2016	Louisiana	NRANKNPCHG	25
2016	Maine	NRANKNPCHG	39
2016	Maryland	NRANKNPCHG	20
2016	Massachusetts	NRANKNPCHG	17
2016	Michigan	NRANKNPCHG	19
2016	Minnesota	NRANKNPCHG	15
2016	Mississippi	NRANKNPCHG	44
2016	Missouri	NRANKNPCHG	23
2016	Montana	NRANKNPCHG	31
2016	Nebraska	NRANKNPCHG	24
2016	Nevada	NRANKNPCHG	13
2016	New Hampshire	NRANKNPCHG	35
2016	New Jersey	NRANKNPCHG	38
2016	New Mexico	NRANKNPCHG	40
2016	New York	NRANKNPCHG	50
2016	North Carolina	NRANKNPCHG	6
2016	North Dakota	NRANKNPCHG	43
2016	Ohio	NRANKNPCHG	21
2016	Oklahoma	NRANKNPCHG	22
2016	Oregon	NRANKNPCHG	9
2016	Pennsylvania	NRANKNPCHG	47
2016	Rhode Island	NRANKNPCHG	42
2016	South Carolina	NRANKNPCHG	10
2016	South Dakota	NRANKNPCHG	33
2016	Tennessee	NRANKNPCHG	12
2016	Texas	NRANKNPCHG	1
2016	Utah	NRANKNPCHG	11
2016	Vermont	NRANKNPCHG	46
2016	Virginia	NRANKNPCHG	14
2016	Washington	NRANKNPCHG	4
2016	West Virginia	NRANKNPCHG	49
2016	Wisconsin	NRANKNPCHG	29
2016	Wyoming	NRANKNPCHG	45
2017	Alabama	NRANKNPCHG	31
2017	Alaska	NRANKNPCHG	44
2017	Arizona	NRANKNPCHG	7
2017	Arkansas	NRANKNPCHG	26
2017	California	NRANKNPCHG	3
2017	Colorado	NRANKNPCHG	8
2017	Connecticut	NRANKNPCHG	46
2017	Delaware	NRANKNPCHG	33
2017	District of Columbia	NRANKNPCHG	32
2017	Florida	NRANKNPCHG	2
2017	Georgia	NRANKNPCHG	6
2017	Hawaii	NRANKNPCHG	45
2017	Idaho	NRANKNPCHG	17
2017	Illinois	NRANKNPCHG	50
2017	Indiana	NRANKNPCHG	19
2017	Iowa	NRANKNPCHG	28
2017	Kansas	NRANKNPCHG	42
2017	Kentucky	NRANKNPCHG	24
2017	Louisiana	NRANKNPCHG	48
2017	Maine	NRANKNPCHG	37
2017	Maryland	NRANKNPCHG	22
2017	Massachusetts	NRANKNPCHG	16
2017	Michigan	NRANKNPCHG	20
2017	Minnesota	NRANKNPCHG	15
2017	Mississippi	NRANKNPCHG	38
2017	Missouri	NRANKNPCHG	21
2017	Montana	NRANKNPCHG	27
2017	Nebraska	NRANKNPCHG	29
2017	Nevada	NRANKNPCHG	14
2017	New Hampshire	NRANKNPCHG	34
2017	New Jersey	NRANKNPCHG	25
2017	New Mexico	NRANKNPCHG	41
2017	New York	NRANKNPCHG	51
2017	North Carolina	NRANKNPCHG	5
2017	North Dakota	NRANKNPCHG	40
2017	Ohio	NRANKNPCHG	18
2017	Oklahoma	NRANKNPCHG	36
2017	Oregon	NRANKNPCHG	12
2017	Pennsylvania	NRANKNPCHG	35
2017	Rhode Island	NRANKNPCHG	43
2017	South Carolina	NRANKNPCHG	10
2017	South Dakota	NRANKNPCHG	30
2017	Tennessee	NRANKNPCHG	9
2017	Texas	NRANKNPCHG	1
2017	Utah	NRANKNPCHG	11
2017	Vermont	NRANKNPCHG	39
2017	Virginia	NRANKNPCHG	13
2017	Washington	NRANKNPCHG	4
2017	West Virginia	NRANKNPCHG	49
2017	Wisconsin	NRANKNPCHG	23
2017	Wyoming	NRANKNPCHG	47
2018	Alabama	NRANKNPCHG	27
2018	Alaska	NRANKNPCHG	45
2018	Arizona	NRANKNPCHG	4
2018	Arkansas	NRANKNPCHG	30
2018	California	NRANKNPCHG	3
2018	Colorado	NRANKNPCHG	8
2018	Connecticut	NRANKNPCHG	44
2018	Delaware	NRANKNPCHG	32
2018	District of Columbia	NRANKNPCHG	35
2018	Florida	NRANKNPCHG	2
2018	Georgia	NRANKNPCHG	7
2018	Hawaii	NRANKNPCHG	47
2018	Idaho	NRANKNPCHG	17
2018	Illinois	NRANKNPCHG	50
2018	Indiana	NRANKNPCHG	18
2018	Iowa	NRANKNPCHG	28
2018	Kansas	NRANKNPCHG	42
2018	Kentucky	NRANKNPCHG	26
2018	Louisiana	NRANKNPCHG	48
2018	Maine	NRANKNPCHG	38
2018	Maryland	NRANKNPCHG	24
2018	Massachusetts	NRANKNPCHG	16
2018	Michigan	NRANKNPCHG	22
2018	Minnesota	NRANKNPCHG	15
2018	Mississippi	NRANKNPCHG	46
2018	Missouri	NRANKNPCHG	23
2018	Montana	NRANKNPCHG	33
2018	Nebraska	NRANKNPCHG	29
2018	Nevada	NRANKNPCHG	10
2018	New Hampshire	NRANKNPCHG	36
2018	New Jersey	NRANKNPCHG	21
2018	New Mexico	NRANKNPCHG	39
2018	New York	NRANKNPCHG	51
2018	North Carolina	NRANKNPCHG	5
2018	North Dakota	NRANKNPCHG	37
2018	Ohio	NRANKNPCHG	19
2018	Oklahoma	NRANKNPCHG	31
2018	Oregon	NRANKNPCHG	14
2018	Pennsylvania	NRANKNPCHG	25
2018	Rhode Island	NRANKNPCHG	41
2018	South Carolina	NRANKNPCHG	9
2018	South Dakota	NRANKNPCHG	34
2018	Tennessee	NRANKNPCHG	11
2018	Texas	NRANKNPCHG	1
2018	Utah	NRANKNPCHG	12
2018	Vermont	NRANKNPCHG	40
2018	Virginia	NRANKNPCHG	13
2018	Washington	NRANKNPCHG	6
2018	West Virginia	NRANKNPCHG	49
2018	Wisconsin	NRANKNPCHG	20
2018	Wyoming	NRANKNPCHG	43
2010	Alabama	NRANKPPCHG	37
2010	Alaska	NRANKPPCHG	2
2010	Arizona	NRANKPPCHG	15
2010	Arkansas	NRANKPPCHG	22
2010	California	NRANKPPCHG	26
2010	Colorado	NRANKPPCHG	6
2010	Connecticut	NRANKPPCHG	30
2010	Delaware	NRANKPPCHG	24
2010	District of Columbia	NRANKPPCHG	1
2010	Florida	NRANKPPCHG	19
2010	Georgia	NRANKPPCHG	17
2010	Hawaii	NRANKPPCHG	11
2010	Idaho	NRANKPPCHG	23
2010	Illinois	NRANKPPCHG	42
2010	Indiana	NRANKPPCHG	38
2010	Iowa	NRANKPPCHG	33
2010	Kansas	NRANKPPCHG	25
2010	Kentucky	NRANKPPCHG	21
2010	Louisiana	NRANKPPCHG	14
2010	Maine	NRANKPPCHG	50
2010	Maryland	NRANKPPCHG	13
2010	Massachusetts	NRANKPPCHG	8
2010	Michigan	NRANKPPCHG	51
2010	Minnesota	NRANKPPCHG	32
2010	Mississippi	NRANKPPCHG	41
2010	Missouri	NRANKPPCHG	35
2010	Montana	NRANKPPCHG	31
2010	Nebraska	NRANKPPCHG	27
2010	Nevada	NRANKPPCHG	43
2010	New Hampshire	NRANKPPCHG	47
2010	New Jersey	NRANKPPCHG	40
2010	New Mexico	NRANKPPCHG	12
2010	New York	NRANKPPCHG	36
2010	North Carolina	NRANKPPCHG	4
2010	North Dakota	NRANKPPCHG	7
2010	Ohio	NRANKPPCHG	48
2010	Oklahoma	NRANKPPCHG	20
2010	Oregon	NRANKPPCHG	28
2010	Pennsylvania	NRANKPPCHG	45
2010	Rhode Island	NRANKPPCHG	39
2010	South Carolina	NRANKPPCHG	18
2010	South Dakota	NRANKPPCHG	16
2010	Tennessee	NRANKPPCHG	29
2010	Texas	NRANKPPCHG	5
2010	Utah	NRANKPPCHG	3
2010	Vermont	NRANKPPCHG	49
2010	Virginia	NRANKPPCHG	9
2010	Washington	NRANKPPCHG	10
2010	West Virginia	NRANKPPCHG	44
2010	Wisconsin	NRANKPPCHG	46
2010	Wyoming	NRANKPPCHG	34
2011	Alabama	NRANKPPCHG	38
2011	Alaska	NRANKPPCHG	8
2011	Arizona	NRANKPPCHG	10
2011	Arkansas	NRANKPPCHG	28
2011	California	NRANKPPCHG	17
2011	Colorado	NRANKPPCHG	4
2011	Connecticut	NRANKPPCHG	42
2011	Delaware	NRANKPPCHG	18
2011	District of Columbia	NRANKPPCHG	1
2011	Florida	NRANKPPCHG	6
2011	Georgia	NRANKPPCHG	12
2011	Hawaii	NRANKPPCHG	9
2011	Idaho	NRANKPPCHG	19
2011	Illinois	NRANKPPCHG	45
2011	Indiana	NRANKPPCHG	34
2011	Iowa	NRANKPPCHG	31
2011	Kansas	NRANKPPCHG	36
2011	Kentucky	NRANKPPCHG	32
2011	Louisiana	NRANKPPCHG	24
2011	Maine	NRANKPPCHG	49
2011	Maryland	NRANKPPCHG	15
2011	Massachusetts	NRANKPPCHG	23
2011	Michigan	NRANKPPCHG	48
2011	Minnesota	NRANKPPCHG	27
2011	Mississippi	NRANKPPCHG	39
2011	Missouri	NRANKPPCHG	44
2011	Montana	NRANKPPCHG	26
2011	Nebraska	NRANKPPCHG	29
2011	Nevada	NRANKPPCHG	35
2011	New Hampshire	NRANKPPCHG	43
2011	New Jersey	NRANKPPCHG	37
2011	New Mexico	NRANKPPCHG	21
2011	New York	NRANKPPCHG	30
2011	North Carolina	NRANKPPCHG	16
2011	North Dakota	NRANKPPCHG	3
2011	Ohio	NRANKPPCHG	50
2011	Oklahoma	NRANKPPCHG	22
2011	Oregon	NRANKPPCHG	14
2011	Pennsylvania	NRANKPPCHG	40
2011	Rhode Island	NRANKPPCHG	51
2011	South Carolina	NRANKPPCHG	20
2011	South Dakota	NRANKPPCHG	13
2011	Tennessee	NRANKPPCHG	25
2011	Texas	NRANKPPCHG	2
2011	Utah	NRANKPPCHG	5
2011	Vermont	NRANKPPCHG	46
2011	Virginia	NRANKPPCHG	11
2011	Washington	NRANKPPCHG	7
2011	West Virginia	NRANKPPCHG	47
2011	Wisconsin	NRANKPPCHG	41
2011	Wyoming	NRANKPPCHG	33
2012	Alabama	NRANKPPCHG	34
2012	Alaska	NRANKPPCHG	11
2012	Arizona	NRANKPPCHG	7
2012	Arkansas	NRANKPPCHG	31
2012	California	NRANKPPCHG	19
2012	Colorado	NRANKPPCHG	5
2012	Connecticut	NRANKPPCHG	43
2012	Delaware	NRANKPPCHG	18
2012	District of Columbia	NRANKPPCHG	1
2012	Florida	NRANKPPCHG	8
2012	Georgia	NRANKPPCHG	15
2012	Hawaii	NRANKPPCHG	12
2012	Idaho	NRANKPPCHG	24
2012	Illinois	NRANKPPCHG	46
2012	Indiana	NRANKPPCHG	36
2012	Iowa	NRANKPPCHG	37
2012	Kansas	NRANKPPCHG	29
2012	Kentucky	NRANKPPCHG	33
2012	Louisiana	NRANKPPCHG	30
2012	Maine	NRANKPPCHG	50
2012	Maryland	NRANKPPCHG	21
2012	Massachusetts	NRANKPPCHG	23
2012	Michigan	NRANKPPCHG	45
2012	Minnesota	NRANKPPCHG	28
2012	Mississippi	NRANKPPCHG	42
2012	Missouri	NRANKPPCHG	40
2012	Montana	NRANKPPCHG	27
2012	Nebraska	NRANKPPCHG	26
2012	Nevada	NRANKPPCHG	10
2012	New Hampshire	NRANKPPCHG	38
2012	New Jersey	NRANKPPCHG	41
2012	New Mexico	NRANKPPCHG	35
2012	New York	NRANKPPCHG	32
2012	North Carolina	NRANKPPCHG	17
2012	North Dakota	NRANKPPCHG	2
2012	Ohio	NRANKPPCHG	48
2012	Oklahoma	NRANKPPCHG	22
2012	Oregon	NRANKPPCHG	25
2012	Pennsylvania	NRANKPPCHG	44
2012	Rhode Island	NRANKPPCHG	47
2012	South Carolina	NRANKPPCHG	16
2012	South Dakota	NRANKPPCHG	9
2012	Tennessee	NRANKPPCHG	20
2012	Texas	NRANKPPCHG	3
2012	Utah	NRANKPPCHG	6
2012	Vermont	NRANKPPCHG	51
2012	Virginia	NRANKPPCHG	13
2012	Washington	NRANKPPCHG	14
2012	West Virginia	NRANKPPCHG	49
2012	Wisconsin	NRANKPPCHG	39
2012	Wyoming	NRANKPPCHG	4
2013	Alabama	NRANKPPCHG	33
2013	Alaska	NRANKPPCHG	18
2013	Arizona	NRANKPPCHG	7
2013	Arkansas	NRANKPPCHG	38
2013	California	NRANKPPCHG	20
2013	Colorado	NRANKPPCHG	5
2013	Connecticut	NRANKPPCHG	50
2013	Delaware	NRANKPPCHG	17
2013	District of Columbia	NRANKPPCHG	2
2013	Florida	NRANKPPCHG	6
2013	Georgia	NRANKPPCHG	23
2013	Hawaii	NRANKPPCHG	15
2013	Idaho	NRANKPPCHG	12
2013	Illinois	NRANKPPCHG	45
2013	Indiana	NRANKPPCHG	31
2013	Iowa	NRANKPPCHG	29
2013	Kansas	NRANKPPCHG	35
2013	Kentucky	NRANKPPCHG	32
2013	Louisiana	NRANKPPCHG	30
2013	Maine	NRANKPPCHG	48
2013	Maryland	NRANKPPCHG	27
2013	Massachusetts	NRANKPPCHG	22
2013	Michigan	NRANKPPCHG	43
2013	Minnesota	NRANKPPCHG	24
2013	Mississippi	NRANKPPCHG	42
2013	Missouri	NRANKPPCHG	36
2013	Montana	NRANKPPCHG	14
2013	Nebraska	NRANKPPCHG	26
2013	Nevada	NRANKPPCHG	8
2013	New Hampshire	NRANKPPCHG	41
2013	New Jersey	NRANKPPCHG	44
2013	New Mexico	NRANKPPCHG	39
2013	New York	NRANKPPCHG	37
2013	North Carolina	NRANKPPCHG	16
2013	North Dakota	NRANKPPCHG	1
2013	Ohio	NRANKPPCHG	40
2013	Oklahoma	NRANKPPCHG	19
2013	Oregon	NRANKPPCHG	28
2013	Pennsylvania	NRANKPPCHG	46
2013	Rhode Island	NRANKPPCHG	47
2013	South Carolina	NRANKPPCHG	13
2013	South Dakota	NRANKPPCHG	9
2013	Tennessee	NRANKPPCHG	25
2013	Texas	NRANKPPCHG	4
2013	Utah	NRANKPPCHG	3
2013	Vermont	NRANKPPCHG	49
2013	Virginia	NRANKPPCHG	21
2013	Washington	NRANKPPCHG	10
2013	West Virginia	NRANKPPCHG	51
2013	Wisconsin	NRANKPPCHG	34
2013	Wyoming	NRANKPPCHG	11
2014	Alabama	NRANKPPCHG	35
2014	Alaska	NRANKPPCHG	48
2014	Arizona	NRANKPPCHG	7
2014	Arkansas	NRANKPPCHG	31
2014	California	NRANKPPCHG	16
2014	Colorado	NRANKPPCHG	4
2014	Connecticut	NRANKPPCHG	46
2014	Delaware	NRANKPPCHG	13
2014	District of Columbia	NRANKPPCHG	2
2014	Florida	NRANKPPCHG	5
2014	Georgia	NRANKPPCHG	14
2014	Hawaii	NRANKPPCHG	28
2014	Idaho	NRANKPPCHG	11
2014	Illinois	NRANKPPCHG	47
2014	Indiana	NRANKPPCHG	30
2014	Iowa	NRANKPPCHG	26
2014	Kansas	NRANKPPCHG	34
2014	Kentucky	NRANKPPCHG	37
2014	Louisiana	NRANKPPCHG	29
2014	Maine	NRANKPPCHG	38
2014	Maryland	NRANKPPCHG	25
2014	Massachusetts	NRANKPPCHG	20
2014	Michigan	NRANKPPCHG	39
2014	Minnesota	NRANKPPCHG	23
2014	Mississippi	NRANKPPCHG	45
2014	Missouri	NRANKPPCHG	33
2014	Montana	NRANKPPCHG	17
2014	Nebraska	NRANKPPCHG	19
2014	Nevada	NRANKPPCHG	6
2014	New Hampshire	NRANKPPCHG	27
2014	New Jersey	NRANKPPCHG	42
2014	New Mexico	NRANKPPCHG	49
2014	New York	NRANKPPCHG	40
2014	North Carolina	NRANKPPCHG	15
2014	North Dakota	NRANKPPCHG	1
2014	Ohio	NRANKPPCHG	36
2014	Oklahoma	NRANKPPCHG	24
2014	Oregon	NRANKPPCHG	12
2014	Pennsylvania	NRANKPPCHG	41
2014	Rhode Island	NRANKPPCHG	43
2014	South Carolina	NRANKPPCHG	10
2014	South Dakota	NRANKPPCHG	18
2014	Tennessee	NRANKPPCHG	21
2014	Texas	NRANKPPCHG	3
2014	Utah	NRANKPPCHG	8
2014	Vermont	NRANKPPCHG	50
2014	Virginia	NRANKPPCHG	22
2014	Washington	NRANKPPCHG	9
2014	West Virginia	NRANKPPCHG	51
2014	Wisconsin	NRANKPPCHG	32
2014	Wyoming	NRANKPPCHG	44
2015	Alabama	NRANKPPCHG	36
2015	Alaska	NRANKPPCHG	37
2015	Arizona	NRANKPPCHG	9
2015	Arkansas	NRANKPPCHG	30
2015	California	NRANKPPCHG	16
2015	Colorado	NRANKPPCHG	4
2015	Connecticut	NRANKPPCHG	50
2015	Delaware	NRANKPPCHG	15
2015	District of Columbia	NRANKPPCHG	2
2015	Florida	NRANKPPCHG	5
2015	Georgia	NRANKPPCHG	13
2015	Hawaii	NRANKPPCHG	24
2015	Idaho	NRANKPPCHG	12
2015	Illinois	NRANKPPCHG	49
2015	Indiana	NRANKPPCHG	35
2015	Iowa	NRANKPPCHG	29
2015	Kansas	NRANKPPCHG	31
2015	Kentucky	NRANKPPCHG	32
2015	Louisiana	NRANKPPCHG	28
2015	Maine	NRANKPPCHG	48
2015	Maryland	NRANKPPCHG	26
2015	Massachusetts	NRANKPPCHG	27
2015	Michigan	NRANKPPCHG	42
2015	Minnesota	NRANKPPCHG	23
2015	Mississippi	NRANKPPCHG	47
2015	Missouri	NRANKPPCHG	33
2015	Montana	NRANKPPCHG	17
2015	Nebraska	NRANKPPCHG	20
2015	Nevada	NRANKPPCHG	6
2015	New Hampshire	NRANKPPCHG	34
2015	New Jersey	NRANKPPCHG	40
2015	New Mexico	NRANKPPCHG	45
2015	New York	NRANKPPCHG	41
2015	North Carolina	NRANKPPCHG	14
2015	North Dakota	NRANKPPCHG	1
2015	Ohio	NRANKPPCHG	39
2015	Oklahoma	NRANKPPCHG	18
2015	Oregon	NRANKPPCHG	11
2015	Pennsylvania	NRANKPPCHG	46
2015	Rhode Island	NRANKPPCHG	43
2015	South Carolina	NRANKPPCHG	10
2015	South Dakota	NRANKPPCHG	22
2015	Tennessee	NRANKPPCHG	19
2015	Texas	NRANKPPCHG	3
2015	Utah	NRANKPPCHG	8
2015	Vermont	NRANKPPCHG	44
2015	Virginia	NRANKPPCHG	21
2015	Washington	NRANKPPCHG	7
2015	West Virginia	NRANKPPCHG	51
2015	Wisconsin	NRANKPPCHG	38
2015	Wyoming	NRANKPPCHG	25
2016	Alabama	NRANKPPCHG	34
2016	Alaska	NRANKPPCHG	22
2016	Arizona	NRANKPPCHG	9
2016	Arkansas	NRANKPPCHG	26
2016	California	NRANKPPCHG	20
2016	Colorado	NRANKPPCHG	10
2016	Connecticut	NRANKPPCHG	48
2016	Delaware	NRANKPPCHG	16
2016	District of Columbia	NRANKPPCHG	7
2016	Florida	NRANKPPCHG	2
2016	Georgia	NRANKPPCHG	13
2016	Hawaii	NRANKPPCHG	27
2016	Idaho	NRANKPPCHG	3
2016	Illinois	NRANKPPCHG	50
2016	Indiana	NRANKPPCHG	28
2016	Iowa	NRANKPPCHG	29
2016	Kansas	NRANKPPCHG	41
2016	Kentucky	NRANKPPCHG	32
2016	Louisiana	NRANKPPCHG	31
2016	Maine	NRANKPPCHG	35
2016	Maryland	NRANKPPCHG	30
2016	Massachusetts	NRANKPPCHG	24
2016	Michigan	NRANKPPCHG	37
2016	Minnesota	NRANKPPCHG	19
2016	Mississippi	NRANKPPCHG	44
2016	Missouri	NRANKPPCHG	33
2016	Montana	NRANKPPCHG	15
2016	Nebraska	NRANKPPCHG	18
2016	Nevada	NRANKPPCHG	6
2016	New Hampshire	NRANKPPCHG	23
2016	New Jersey	NRANKPPCHG	43
2016	New Mexico	NRANKPPCHG	39
2016	New York	NRANKPPCHG	46
2016	North Carolina	NRANKPPCHG	12
2016	North Dakota	NRANKPPCHG	42
2016	Ohio	NRANKPPCHG	38
2016	Oklahoma	NRANKPPCHG	25
2016	Oregon	NRANKPPCHG	4
2016	Pennsylvania	NRANKPPCHG	45
2016	Rhode Island	NRANKPPCHG	40
2016	South Carolina	NRANKPPCHG	11
2016	South Dakota	NRANKPPCHG	14
2016	Tennessee	NRANKPPCHG	17
2016	Texas	NRANKPPCHG	8
2016	Utah	NRANKPPCHG	1
2016	Vermont	NRANKPPCHG	49
2016	Virginia	NRANKPPCHG	21
2016	Washington	NRANKPPCHG	5
2016	West Virginia	NRANKPPCHG	51
2016	Wisconsin	NRANKPPCHG	36
2016	Wyoming	NRANKPPCHG	47
2017	Alabama	NRANKPPCHG	34
2017	Alaska	NRANKPPCHG	46
2017	Arizona	NRANKPPCHG	6
2017	Arkansas	NRANKPPCHG	24
2017	California	NRANKPPCHG	23
2017	Colorado	NRANKPPCHG	8
2017	Connecticut	NRANKPPCHG	44
2017	Delaware	NRANKPPCHG	17
2017	District of Columbia	NRANKPPCHG	10
2017	Florida	NRANKPPCHG	5
2017	Georgia	NRANKPPCHG	15
2017	Hawaii	NRANKPPCHG	48
2017	Idaho	NRANKPPCHG	1
2017	Illinois	NRANKPPCHG	49
2017	Indiana	NRANKPPCHG	25
2017	Iowa	NRANKPPCHG	26
2017	Kansas	NRANKPPCHG	42
2017	Kentucky	NRANKPPCHG	27
2017	Louisiana	NRANKPPCHG	45
2017	Maine	NRANKPPCHG	31
2017	Maryland	NRANKPPCHG	29
2017	Massachusetts	NRANKPPCHG	22
2017	Michigan	NRANKPPCHG	33
2017	Minnesota	NRANKPPCHG	18
2017	Mississippi	NRANKPPCHG	40
2017	Missouri	NRANKPPCHG	28
2017	Montana	NRANKPPCHG	13
2017	Nebraska	NRANKPPCHG	20
2017	Nevada	NRANKPPCHG	3
2017	New Hampshire	NRANKPPCHG	21
2017	New Jersey	NRANKPPCHG	35
2017	New Mexico	NRANKPPCHG	41
2017	New York	NRANKPPCHG	47
2017	North Carolina	NRANKPPCHG	14
2017	North Dakota	NRANKPPCHG	38
2017	Ohio	NRANKPPCHG	32
2017	Oklahoma	NRANKPPCHG	36
2017	Oregon	NRANKPPCHG	9
2017	Pennsylvania	NRANKPPCHG	39
2017	Rhode Island	NRANKPPCHG	43
2017	South Carolina	NRANKPPCHG	11
2017	South Dakota	NRANKPPCHG	12
2017	Tennessee	NRANKPPCHG	16
2017	Texas	NRANKPPCHG	7
2017	Utah	NRANKPPCHG	2
2017	Vermont	NRANKPPCHG	37
2017	Virginia	NRANKPPCHG	19
2017	Washington	NRANKPPCHG	4
2017	West Virginia	NRANKPPCHG	50
2017	Wisconsin	NRANKPPCHG	30
2017	Wyoming	NRANKPPCHG	51
2018	Alabama	NRANKPPCHG	34
2018	Alaska	NRANKPPCHG	49
2018	Arizona	NRANKPPCHG	4
2018	Arkansas	NRANKPPCHG	28
2018	California	NRANKPPCHG	25
2018	Colorado	NRANKPPCHG	7
2018	Connecticut	NRANKPPCHG	43
2018	Delaware	NRANKPPCHG	12
2018	District of Columbia	NRANKPPCHG	15
2018	Florida	NRANKPPCHG	5
2018	Georgia	NRANKPPCHG	14
2018	Hawaii	NRANKPPCHG	48
2018	Idaho	NRANKPPCHG	2
2018	Illinois	NRANKPPCHG	50
2018	Indiana	NRANKPPCHG	24
2018	Iowa	NRANKPPCHG	26
2018	Kansas	NRANKPPCHG	42
2018	Kentucky	NRANKPPCHG	29
2018	Louisiana	NRANKPPCHG	46
2018	Maine	NRANKPPCHG	35
2018	Maryland	NRANKPPCHG	30
2018	Massachusetts	NRANKPPCHG	22
2018	Michigan	NRANKPPCHG	38
2018	Minnesota	NRANKPPCHG	18
2018	Mississippi	NRANKPPCHG	44
2018	Missouri	NRANKPPCHG	31
2018	Montana	NRANKPPCHG	17
2018	Nebraska	NRANKPPCHG	21
2018	Nevada	NRANKPPCHG	1
2018	New Hampshire	NRANKPPCHG	23
2018	New Jersey	NRANKPPCHG	36
2018	New Mexico	NRANKPPCHG	40
2018	New York	NRANKPPCHG	47
2018	North Carolina	NRANKPPCHG	10
2018	North Dakota	NRANKPPCHG	19
2018	Ohio	NRANKPPCHG	37
2018	Oklahoma	NRANKPPCHG	33
2018	Oregon	NRANKPPCHG	11
2018	Pennsylvania	NRANKPPCHG	39
2018	Rhode Island	NRANKPPCHG	41
2018	South Carolina	NRANKPPCHG	9
2018	South Dakota	NRANKPPCHG	13
2018	Tennessee	NRANKPPCHG	16
2018	Texas	NRANKPPCHG	8
2018	Utah	NRANKPPCHG	3
2018	Vermont	NRANKPPCHG	32
2018	Virginia	NRANKPPCHG	20
2018	Washington	NRANKPPCHG	6
2018	West Virginia	NRANKPPCHG	51
2018	Wisconsin	NRANKPPCHG	27
2018	Wyoming	NRANKPPCHG	45

#Create subset dataframe with only ppopchange
ppopchg <- subset(population3, Metric == "PPOPCHG")

Analyze Data

#Let's investigate which state had the maximum and minimum population percent change each year

#Find the states with the largest increase in population percentage each year
top <- ppopchg %>% 
    group_by(Year) %>% 
    slice(which.max(Value))

top

## # A tibble: 9 x 4
## # Groups:   Year [9]
##    Year State                Metric  Value       
##   <dbl> <fct>                <chr>   <chr>       
## 1  2010 District of Columbia PPOPCHG 0.5515432909
## 2  2011 District of Columbia PPOPCHG 2.3991670592
## 3  2012 District of Columbia PPOPCHG 2.4407603591
## 4  2013 North Dakota         PPOPCHG 2.9785370752
## 5  2014 North Dakota         PPOPCHG 2.1306123693
## 6  2015 North Dakota         PPOPCHG 2.2566322476
## 7  2016 Utah                 PPOPCHG 2.0156265036
## 8  2017 Idaho                PPOPCHG 2.1375814799
## 9  2018 Nevada               PPOPCHG 2.0854156819

#Create a frequency table
countTop <- as.data.frame(table(top$State))
#Replace 0 with NA
countTop[countTop==0] <- NA
#Remove rows with NA
countTop <- countTop[!is.na(countTop$Freq), ]

#Arrange rows by decreasing values
countTop <- countTop %>%
  arrange(desc(Freq))
colnames(countTop)[1] <- "State"

countTop

##                  State Freq
## 1 District of Columbia    3
## 2         North Dakota    3
## 3                Idaho    1
## 4               Nevada    1
## 5                 Utah    1

#Repeat precious process to find the states with the largest decrease in population percentage each year
bottom <- ppopchg %>% 
    group_by(Year) %>% 
    slice(which.min(Value))

bottom

## # A tibble: 9 x 4
## # Groups:   Year [9]
##    Year State         Metric  Value       
##   <dbl> <fct>         <chr>   <chr>       
## 1  2010 Michigan      PPOPCHG -0.066591684
## 2  2011 Rhode Island  PPOPCHG -0.038142661
## 3  2012 Vermont       PPOPCHG -0.146097397
## 4  2013 West Virginia PPOPCHG -0.155700994
## 5  2014 West Virginia PPOPCHG -0.237664608
## 6  2015 West Virginia PPOPCHG -0.40395422 
## 7  2016 West Virginia PPOPCHG -0.600815637
## 8  2017 Wyoming       PPOPCHG -0.916668093
## 9  2018 West Virginia PPOPCHG -0.617264926

countBottom <- as.data.frame(table(bottom$State))
countBottom[countBottom==0] <- NA
countBottom <- countBottom[!is.na(countBottom$Freq), ]

countBottom <- countBottom %>%
  arrange(desc(Freq))
colnames(countBottom)[1] <- "State"

countBottom

##           State Freq
## 1 West Virginia    5
## 2      Michigan    1
## 3  Rhode Island    1
## 4       Vermont    1
## 5       Wyoming    1

Visualize Data

plot <- ggplot(countTop, aes(y = Freq, x = State, color = State, fill = State)) + 
    geom_bar( stat = "identity") +
    labs(y = "Frequency") +
    ggtitle("Frequency of States with the Largest Population Increase Percentage") 

plot

plot1 <- ggplot(countBottom, aes(y = Freq, x = State, color = State, fill = State)) + 
    geom_bar( stat = "identity") +
    labs(y = "Frequency") +
    ggtitle("Frequency of States with the Largest Population Decrease Percentage") 

plot1

Conclusion

From this analysis of 2010-2018 U.S. census data, we see the largest population percentage increases occurred in D.C., North Dakota, Idaho, Nevada, and Utah. We see the largest population precentage decreases occurred in West Virginia, Michigan, Rhode Island, Vermont,and Wyoming. Further analysis could investigate why so many people were moving to or from these states.

607 Project 2

Katherine Evers

3/2/2019

Contents

Project Overview

Avocado Prices

Tidy Data

Analyze Data

Visualize Data

Conclusion

Color and Heat Absorption

Tidy Data

Analyze Data

Visualize Data

Conclusion

2010-2018 Census Data

Tidy Data

Analyze Data

Visualize Data

Conclusion