Business Rate Properties
Rohit Guha
3 December 2017
1. Introduction
Business rates is the commonly used of non-domestic rates, a tax on the occupation of non-domestic property (National Non-Domestic Rates - NNDR). Rates are a property tax with ancient roots. Business rates are the latest incarnation of a series of taxes for funding local services known as rates, based on property values. The first rate was part of the Elizabethan Poor Law Act 1572, which established relief for the poor at the local parish level, paid for by inhabitants of the parish. A system of rates to fund local government and services evolved over the next three centuries, including a separate system for London from 1869 to 1963. Changes included a stricter definition of how to value for a rate, the introduction of a valuation list containing the assessed values, the ability to object to the assessed value and the introduction of the valuation officer, appointed by the Commissioners of Inland Revenue (now Her Majesty’s Revenue and Customs), as the assessor.
2. Overview of the study
Business rates are charged on most non-domestic properties, like:
shops
offices
pubs
warehouses
factories
Our field study concerns on business rate properties of companies resided in United Kingdom.
3. Business rate properties of UK companies
3.1 Overview
What Are Business Rates? If your business depends on having physical location - and we don’t just mean a shop front, but a factory, office, holiday let or café - then you’re sure to have run into the issue of business rates before now. Understanding precisely how these fit into your small business’ budget can be tricky when you’re facing the hundreds of other issues that come with starting a business. So our simple guide is here to help you better understand business rates.
3.2 Data
For this we have collected data from the official website of United Kingdom data storage https://data.gov.uk/data/search?theme-primary=Business%20%26%20Economy. Rating lists are created and maintained by the Valuation Office Agency, a UK Government Executive Agency. Rating lists can be altered either to reflect changes in properties, or as valuations are appealed against. New rating lists are normally created every five years, however, the 2015 revaluation has been postponed until 2017.
3.3 Model
In order to test Hypothesis 1a, we proposed the following model: Price=??0+??Period.Charge+??2EXEM.AMT???Weekend+??
rate <- read.csv(paste("FOIAllacounts+201017.csv",sep=""))
library(psych)
describe(rate)## Warning in FUN(newX[, i], ...): no non-missing arguments to min; returning
## Inf
## Warning in FUN(newX[, i], ...): no non-missing arguments to min; returning
## Inf
## Warning in FUN(newX[, i], ...): no non-missing arguments to min; returning
## Inf
## Warning in FUN(newX[, i], ...): no non-missing arguments to min; returning
## Inf## Warning in FUN(newX[, i], ...): no non-missing arguments to max; returning
## -Inf
## Warning in FUN(newX[, i], ...): no non-missing arguments to max; returning
## -Inf
## Warning in FUN(newX[, i], ...): no non-missing arguments to max; returning
## -Inf
## Warning in FUN(newX[, i], ...): no non-missing arguments to max; returning
## -Inf## vars n mean sd median
## Additional.Rlf* 1 9782 1.00 2.000000e-02 1.00000e+00
## Additional.Rlf.1 2 1049 3.81 6.166000e+01 0.00000e+00
## Period.Charge 3 1049 15893.61 5.233486e+04 2.93580e+03
## Charge.Type* 4 9782 1.14 4.200000e-01 1.00000e+00
## EXEM.AMT 5 1049 474.23 5.137220e+03 0.00000e+00
## EXEM.CD* 6 9782 1.16 1.120000e+00 1.00000e+00
## PLACE.REF 7 1049 4620711630.40 2.897661e+09 4.96006e+09
## SBR.APPLIED 8 1049 -0.22 4.200000e-01 0.00000e+00
## SBR* 9 0 NaN NA NA
## SBR.SUPPLE 10 1049 306.04 1.296280e+03 0.00000e+00
## X* 11 0 NaN NA NA
## SBR.RELIEF. 12 1049 560.80 1.251650e+03 0.00000e+00
## X.1* 13 0 NaN NA NA
## MAND.CHAR.* 14 9782 1.01 1.500000e-01 1.00000e+00
## MAND.CHARI 15 1049 620.74 9.615000e+03 0.00000e+00
## X.2* 16 0 NaN NA NA
## DISC.CHARIT* 17 9782 1.00 4.000000e-02 1.00000e+00
## DIS.RLF.AMT 18 1049 0.00 0.000000e+00 0.00000e+00
## CHARITY.RLF. 19 1049 12.45 2.622900e+02 0.00000e+00
## ANALYSIS.CD* 20 9782 3.06 7.220000e+00 1.00000e+00
## RV 21 1049 31273.50 1.003666e+05 6.70000e+03
## SURNAME* 22 9782 37.04 1.172000e+02 1.00000e+00
## Billing.Address.1* 23 9782 12.59 4.651000e+01 1.00000e+00
## Billing.Address.2* 24 9782 9.75 3.761000e+01 1.00000e+00
## Billing.Address.3* 25 9782 8.05 2.816000e+01 1.00000e+00
## Billing.Address.4* 26 9782 2.35 7.960000e+00 1.00000e+00
## Billing.Address.5* 27 9782 1.26 2.120000e+00 1.00000e+00
## Billing.Post.Code* 28 9782 10.01 3.860000e+01 1.00000e+00
## Liability.Start.Date* 29 9782 24.59 8.821000e+01 1.00000e+00
## Property.Address.1* 30 9782 54.51 1.793000e+02 1.00000e+00
## Property.Address.2* 31 9782 25.00 7.696000e+01 1.00000e+00
## Property.Address.3* 32 9782 9.71 3.058000e+01 1.00000e+00
## Property.Address.4* 33 9782 2.66 6.780000e+00 1.00000e+00
## Property.Address.5* 34 9782 1.12 6.600000e-01 1.00000e+00
## Property.Post* 35 9782 25.73 8.397000e+01 1.00000e+00
## UB.PROP.RVú* 36 9782 8.19 2.345000e+01 1.00000e+00
## trimmed mad min max
## Additional.Rlf* 1.00 0.000000e+00 1 2.000000e+00
## Additional.Rlf.1 0.00 0.000000e+00 0 1.000000e+03
## Period.Charge 5226.00 3.385370e+03 0 7.148931e+05
## Charge.Type* 1.01 0.000000e+00 1 3.000000e+00
## EXEM.AMT 53.73 0.000000e+00 0 1.393383e+05
## EXEM.CD* 1.00 0.000000e+00 1 1.000000e+01
## PLACE.REF 4605718431.54 3.697704e+09 13008009 9.973002e+09
## SBR.APPLIED -0.15 0.000000e+00 -1 0.000000e+00
## SBR* NaN NA Inf -Inf
## SBR.SUPPLE 30.14 0.000000e+00 0 1.677000e+04
## X* NaN NA Inf -Inf
## SBR.RELIEF. 223.52 0.000000e+00 0 6.417840e+03
## X.1* NaN NA Inf -Inf
## MAND.CHAR.* 1.00 0.000000e+00 1 3.000000e+00
## MAND.CHARI 0.00 0.000000e+00 0 2.977007e+05
## X.2* NaN NA Inf -Inf
## DISC.CHARIT* 1.00 0.000000e+00 1 3.000000e+00
## DIS.RLF.AMT 0.00 0.000000e+00 0 0.000000e+00
## CHARITY.RLF. 0.00 0.000000e+00 0 6.232750e+03
## ANALYSIS.CD* 1.06 0.000000e+00 1 5.600000e+01
## RV 11088.56 7.598320e+03 0 1.290000e+06
## SURNAME* 1.28 0.000000e+00 1 5.920000e+02
## Billing.Address.1* 1.00 0.000000e+00 1 2.830000e+02
## Billing.Address.2* 1.00 0.000000e+00 1 2.440000e+02
## Billing.Address.3* 1.00 0.000000e+00 1 1.630000e+02
## Billing.Address.4* 1.00 0.000000e+00 1 7.500000e+01
## Billing.Address.5* 1.00 0.000000e+00 1 2.700000e+01
## Billing.Post.Code* 1.00 0.000000e+00 1 2.700000e+02
## Liability.Start.Date* 1.22 0.000000e+00 1 5.750000e+02
## Property.Address.1* 1.33 0.000000e+00 1 9.420000e+02
## Property.Address.2* 1.32 0.000000e+00 1 4.040000e+02
## Property.Address.3* 1.00 0.000000e+00 1 1.600000e+02
## Property.Address.4* 1.00 0.000000e+00 1 3.800000e+01
## Property.Address.5* 1.00 0.000000e+00 1 5.000000e+00
## Property.Post* 1.19 0.000000e+00 1 4.490000e+02
## UB.PROP.RVú* 1.08 0.000000e+00 1 1.230000e+02
## range skew kurtosis se
## Additional.Rlf* 1.000000e+00 49.41 2440.00 0.00
## Additional.Rlf.1 1.000000e+03 16.08 256.76 1.90
## Period.Charge 7.148931e+05 7.29 65.91 1615.86
## Charge.Type* 2.000000e+00 3.20 9.73 0.00
## EXEM.AMT 1.393383e+05 22.25 551.67 158.61
## EXEM.CD* 9.000000e+00 6.77 44.15 0.01
## PLACE.REF 9.959994e+09 0.00 -1.37 89466363.43
## SBR.APPLIED 1.000000e+00 -1.34 -0.22 0.01
## SBR* -Inf NA NA NA
## SBR.SUPPLE 1.677000e+04 7.47 67.87 40.02
## X* -Inf NA NA NA
## SBR.RELIEF. 6.417840e+03 2.32 4.60 38.65
## X.1* -Inf NA NA NA
## MAND.CHAR.* 2.000000e+00 12.87 164.34 0.00
## MAND.CHARI 2.977007e+05 28.56 868.40 296.87
## X.2* -Inf NA NA NA
## DISC.CHARIT* 2.000000e+00 43.99 1987.29 0.00
## DIS.RLF.AMT 0.000000e+00 NaN NaN 0.00
## CHARITY.RLF. 6.232750e+03 22.56 512.40 8.10
## ANALYSIS.CD* 5.500000e+01 4.33 20.42 0.07
## RV 1.290000e+06 7.27 64.60 3098.86
## SURNAME* 5.910000e+02 3.31 9.82 1.19
## Billing.Address.1* 2.820000e+02 4.18 16.77 0.47
## Billing.Address.2* 2.430000e+02 4.60 20.66 0.38
## Billing.Address.3* 1.620000e+02 4.08 15.56 0.28
## Billing.Address.4* 7.400000e+01 6.45 42.52 0.08
## Billing.Address.5* 2.600000e+01 9.28 88.66 0.02
## Billing.Post.Code* 2.690000e+02 4.85 23.92 0.39
## Liability.Start.Date* 5.740000e+02 4.27 18.09 0.89
## Property.Address.1* 9.410000e+02 3.50 11.26 1.81
## Property.Address.2* 4.030000e+02 3.30 9.97 0.78
## Property.Address.3* 1.590000e+02 3.64 12.07 0.31
## Property.Address.4* 3.700000e+01 4.34 17.69 0.07
## Property.Address.5* 4.000000e+00 5.45 28.36 0.01
## Property.Post* 4.480000e+02 3.65 12.61 0.85
## UB.PROP.RVú* 1.220000e+02 3.35 10.31 0.243.4 Results
We found empirical support for H1. The average period charge for any company was 2610 in comaprision to 1118 companies. Whereas the average exemption amount was 247.3 while there were some companies with 0 exemption ampunt for their companies. The regression analysis has been tested for period change with respect to SBR SUPPLE, SBR RELIEF and RV. The average period charge exempted by the companies was 9819 with p-value: < 2.2e-16.
4. Conclusion
This paper gives a proper analysis of the rate exempted by companies for business rate properties which varies with respect to the Supplemental Balancing Reserve(APPLIED/SUPPLE/RELIEF) of the companies under UK government.
5. References
Stack Exchange https://stats.stackexchange.com
System security services | National Grid UK https://www.nationalgrid.com
Wikipedia “Business Rates in England” https://en.wikipedia.org/wiki/Business_rates_in_England
Rates https://en.wikipedia.org/wiki/Rates_(tax)
Property tax https://en.wikipedia.org/wiki/Property_tax
UK data search https://data.gov.uk/data/search
Introducation to UK government business rates https://www.gov.uk/introduction-to-business-rates
Table: Summary satistics of Business Rate for period charge
summary(rate$Period.Charge)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 0 1037 2936 15894 8854 714893 8733summary(rate$EXEM.AMT)## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 0.0 0.0 0.0 474.2 0.0 139338.3 8733Appendix 1:
Decriptive Statistics for individual elements
#Descriptive statistics for Supplemental Balancing Reverse
min(rate$SBR.SUPPLE)## [1] NAmedian(rate$SBR.SUPPLE)## [1] NAmax(rate$SBR.SUPPLE)## [1] NA#Descriptive statistics for Supplemental Balancing Reverse Relief
min(rate$SBR.RELIEF.)## [1] NAmedian(rate$SBR.RELIEF.)## [1] NAmax(rate$SBR.RELIEF.)## [1] NAlibrary(gmodels)Box plot
#Box plot for Period Change
boxplot(rate$Period.Charge, horizontal=TRUE, main="Period Charge")
#Box plot for Exemption
boxplot(rate$EXEM.AMT, horizontal=TRUE, main="Exemption")
#Box plot for Supplemental Balancing Reverse
boxplot(rate$SBR.SUPPLE, horizontal=TRUE, main="Supplemental Balancing Reverse")
#Box plot for Mandatory Charity
boxplot(rate$MAND.CHARI, horizontal=TRUE, main="Mandatory Charity")
Appendix 2:
Two-way contingency tables for period charge, exemption amount, supplemental balancing reserve and mandatory charity.
CrossTable(rate$Period.Charge)##
##
## Cell Contents
## |-------------------------|
## | N |
## | N / Table Total |
## |-------------------------|
##
##
## Total Observations in Table: 1049
##
##
## | 0 | 46.6 | 94.73 | 150.08 | 155.51 |
## |-----------|-----------|-----------|-----------|-----------|
## | 8 | 2 | 3 | 1 | 6 |
## | 0.008 | 0.002 | 0.003 | 0.001 | 0.006 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 162.21 | 163.1 | 181.43 | 189.46 | 233 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 39 | 2 | 2 | 1 |
## | 0.001 | 0.037 | 0.002 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 233.26 | 241.04 | 259.18 | 285.1 | 311.02 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 5 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 312.22 | 326.2 | 358.82 | 360.86 | 363.35 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 17 | 1 | 1 | 1 |
## | 0.001 | 0.016 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 363.48 | 388.77 | 391.44 | 399.14 | 414.69 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 1 | 1 |
## | 0.001 | 0.002 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 419.4 | 424.06 | 430.24 | 438.04 | 444.31 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 445.79 | 454.19 | 464.06 | 464.56 | 466 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 2 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 466.53 | 483.81 | 489.3 | 500.95 | 502.81 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 8 | 1 | 1 |
## | 0.001 | 0.001 | 0.008 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 508 | 518.36 | 547.55 | 562.8 | 572.67 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 5 | 1 | 1 | 1 |
## | 0.001 | 0.005 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 583.16 | 594.15 | 596.12 | 609.08 | 612.16 |
## |-----------|-----------|-----------|-----------|-----------|
## | 3 | 2 | 1 | 1 | 2 |
## | 0.003 | 0.002 | 0.001 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 617.45 | 622.04 | 629.1 | 640.75 | 652.4 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 3 | 1 | 1 | 10 |
## | 0.002 | 0.003 | 0.001 | 0.001 | 0.010 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 664.05 | 687.35 | 699 | 712.75 | 722.3 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 4 | 1 | 5 |
## | 0.001 | 0.002 | 0.004 | 0.001 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 725.71 | 733.95 | 745.6 | 748.34 | 757.25 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 5 | 1 | 1 | 1 |
## | 0.001 | 0.005 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 760.27 | 768.9 | 771.04 | 777.55 | 780.55 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 3 | 5 |
## | 0.001 | 0.002 | 0.001 | 0.003 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 789.89 | 792.2 | 799.76 | 803.85 | 815.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 4 | 12 |
## | 0.001 | 0.002 | 0.001 | 0.004 | 0.011 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 827.15 | 829.38 | 838.8 | 849.13 | 850.45 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 3 | 1 | 3 |
## | 0.001 | 0.001 | 0.003 | 0.001 | 0.003 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 855.3 | 873.75 | 885.4 | 888.62 | 894.18 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 1 | 1 |
## | 0.001 | 0.002 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 897.05 | 906.47 | 907.14 | 908.37 | 908.7 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 2 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 918.24 | 919.23 | 920.1 | 920.35 | 920.96 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 2 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 928.12 | 932 | 943.65 | 978.6 | 987.36 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 7 | 2 | 3 | 1 |
## | 0.001 | 0.007 | 0.002 | 0.003 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1010.81 | 1013.55 | 1025.2 | 1026.85 | 1034.14 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1036.73 | 1036.85 | 1037.67 | 1046.6 | 1048.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 1 | 2 |
## | 0.001 | 0.002 | 0.001 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1060.15 | 1062.65 | 1066.35 | 1082.6 | 1083.45 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1086.1 | 1089.61 | 1106.75 | 1110.74 | 1114.48 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1118.4 | 1125.59 | 1130.05 | 1141.7 | 1144.45 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 4 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.004 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1145.34 | 1149.04 | 1151.08 | 1153.35 | 1153.36 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1165 | 1166.28 | 1166.32 | 1167.23 | 1169.51 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1184.83 | 1187.21 | 1192.24 | 1198.71 | 1211.6 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 5 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1224.33 | 1227.94 | 1234.9 | 1258.2 | 1263.51 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 2 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1263.82 | 1281.5 | 1282.95 | 1295.91 | 1303.32 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 3 | 1 | 2 | 1 |
## | 0.001 | 0.003 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1304.8 | 1319.61 | 1328.1 | 1351.4 | 1382.3 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 3 | 1 | 1 |
## | 0.002 | 0.001 | 0.003 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1398 | 1399.58 | 1421.8 | 1444.6 | 1467.9 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 2 | 2 | 4 |
## | 0.002 | 0.001 | 0.002 | 0.002 | 0.004 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1477.34 | 1481.04 | 1491.2 | 1492.48 | 1514.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 2 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1520.53 | 1536.92 | 1537.8 | 1555.09 | 1579.78 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 5 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.005 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1581.01 | 1584.4 | 1599.52 | 1606.93 | 1607.7 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 3 | 1 | 2 | 1 |
## | 0.001 | 0.003 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1622.06 | 1632.85 | 1677.6 | 1700.9 | 1747.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 5 | 1 | 1 |
## | 0.001 | 0.002 | 0.005 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1770.8 | 1788.36 | 1794.1 | 1797 | 1814.27 |
## |-----------|-----------|-----------|-----------|-----------|
## | 4 | 1 | 1 | 1 | 1 |
## | 0.004 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1840.19 | 1840.7 | 1864 | 1866.11 | 1875.98 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 4 | 1 | 1 | 1 |
## | 0.002 | 0.004 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1887.3 | 1905.87 | 1910.6 | 1915.48 | 1933.9 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1954.97 | 1957.2 | 1974.72 | 1980.5 | 2003.71 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 1 | 1 |
## | 0.001 | 0.002 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2003.8 | 2021.62 | 2022.31 | 2027.1 | 2050.4 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 2 | 1 | 2 | 3 |
## | 0.002 | 0.002 | 0.001 | 0.002 | 0.003 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2053.71 | 2073.46 | 2073.7 | 2097 | 2120.3 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 2 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2143.6 | 2166.9 | 2172.19 | 2177.13 | 2190.2 |
## |-----------|-----------|-----------|-----------|-----------|
## | 4 | 2 | 2 | 1 | 2 |
## | 0.004 | 0.002 | 0.002 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2195.31 | 2203.05 | 2213.5 | 2236.8 | 2238.72 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 4 | 2 | 1 |
## | 0.001 | 0.002 | 0.004 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2251.18 | 2254.88 | 2260.1 | 2283.4 | 2290.68 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 2 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2306.7 | 2358.56 | 2376.6 | 2384.47 | 2410.39 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 3 | 1 | 1 |
## | 0.001 | 0.001 | 0.003 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2423.2 | 2448.73 | 2454.86 | 2462.23 | 2469.8 |
## |-----------|-----------|-----------|-----------|-----------|
## | 8 | 1 | 1 | 1 | 1 |
## | 0.008 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2488.15 | 2514.07 | 2516.4 | 2527.64 | 2539.98 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 3 | 1 | 1 |
## | 0.001 | 0.002 | 0.003 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2547.79 | 2563 | 2591.82 | 2609.6 | 2643.66 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 4 | 1 | 3 | 1 |
## | 0.001 | 0.004 | 0.001 | 0.003 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2646.12 | 2656.2 | 2685.62 | 2702.8 | 2747.33 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 2 | 1 | 1 | 3 |
## | 0.002 | 0.002 | 0.001 | 0.001 | 0.003 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2749.4 | 2796 | 2799.17 | 2823.58 | 2842.6 |
## |-----------|-----------|-----------|-----------|-----------|
## | 8 | 4 | 3 | 1 | 5 |
## | 0.008 | 0.004 | 0.003 | 0.001 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2889.2 | 2902.84 | 2935.8 | 2954.67 | 2982.4 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 4 | 3 | 1 |
## | 0.002 | 0.001 | 0.004 | 0.003 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3006.51 | 3029 | 3058.35 | 3068.85 | 3075.6 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 5 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3080.56 | 3110.18 | 3122.2 | 3168.8 | 3188.59 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 1 | 1 |
## | 0.001 | 0.002 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3199.05 | 3213.86 | 3215.4 | 3238.54 | 3251.64 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3262 | 3278.04 | 3308.6 | 3317.53 | 3369.37 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 4 | 1 | 1 |
## | 0.002 | 0.001 | 0.004 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3401.16 | 3401.8 | 3421.2 | 3436.01 | 3448.4 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 5 | 1 | 1 | 3 |
## | 0.001 | 0.005 | 0.001 | 0.001 | 0.003 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3473.04 | 3495 | 3524.88 | 3541.6 | 3588.2 |
## |-----------|-----------|-----------|-----------|-----------|
## | 3 | 3 | 1 | 2 | 3 |
## | 0.003 | 0.003 | 0.001 | 0.002 | 0.003 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3615.77 | 3634.8 | 3645.33 | 3672.98 | 3673.1 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 3 | 1 | 1 | 1 |
## | 0.001 | 0.003 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3681.4 | 3732.22 | 3759.92 | 3774.6 | 3821.2 |
## |-----------|-----------|-----------|-----------|-----------|
## | 3 | 1 | 1 | 3 | 2 |
## | 0.003 | 0.001 | 0.001 | 0.003 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3830.96 | 3842.39 | 3867.8 | 3870.45 | 3914.4 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 8 | 1 | 1 |
## | 0.001 | 0.001 | 0.008 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 3938.62 | 3939.57 | 3961 | 4007.6 | 4054.2 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 3 | 1 | 1 |
## | 0.001 | 0.001 | 0.003 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 4095.08 | 4100.8 | 4147.4 | 4194 | 4203.72 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 5 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.005 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 4240.6 | 4245.65 | 4287.2 | 4333.8 | 4344.38 |
## |-----------|-----------|-----------|-----------|-----------|
## | 4 | 1 | 2 | 1 | 1 |
## | 0.004 | 0.001 | 0.002 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 4443.12 | 4473.6 | 4509.77 | 4520.2 | 4541.86 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 3 | 1 | 2 | 1 |
## | 0.002 | 0.003 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 4561.6 | 4566.8 | 4590.1 | 4613.44 | 4614.15 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 4660 | 4776.5 | 4838.06 | 4872.62 | 4893 |
## |-----------|-----------|-----------|-----------|-----------|
## | 5 | 2 | 2 | 1 | 5 |
## | 0.005 | 0.002 | 0.002 | 0.001 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 5009.5 | 5126 | 5134.27 | 5165.9 | 5242.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 3 | 3 | 1 | 1 | 5 |
## | 0.003 | 0.003 | 0.001 | 0.001 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 5287.45 | 5358.79 | 5359 | 5442.82 | 5475.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 7 | 1 | 9 |
## | 0.001 | 0.001 | 0.007 | 0.001 | 0.009 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 5572.41 | 5592 | 5702 | 5708.5 | 5708.82 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 6 | 1 | 3 | 1 |
## | 0.001 | 0.006 | 0.001 | 0.003 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 5821.81 | 5825 | 5922.89 | 5924.16 | 5941.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 5 | 1 | 2 | 3 |
## | 0.001 | 0.005 | 0.001 | 0.002 | 0.003 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 6022.9 | 6049.7 | 6052.99 | 6058 | 6090.78 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 6220.37 | 6281.42 | 6291 | 6349.96 | 6407.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 3 | 1 | 1 |
## | 0.001 | 0.001 | 0.003 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 6417.84 | 6479.55 | 6524 | 6757 | 6873.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 5 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.005 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 6942.38 | 6990 | 7106.5 | 7108.99 | 7244.25 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 4 | 1 | 1 | 1 |
## | 0.001 | 0.004 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 7339.5 | 7456 | 7572.5 | 7645.87 | 7689 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 6 | 1 | 3 |
## | 0.001 | 0.002 | 0.006 | 0.001 | 0.003 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 7805.5 | 7898.88 | 8038.5 | 8053.16 | 8096.35 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 8155 | 8322.89 | 8330.85 | 8388 | 8491.3 |
## |-----------|-----------|-----------|-----------|-----------|
## | 3 | 1 | 1 | 1 | 1 |
## | 0.003 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 8504.5 | 8590.03 | 8621 | 8737.5 | 8787.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 2 | 2 | 1 |
## | 0.002 | 0.001 | 0.002 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 8854 | 8886.24 | 8936.99 | 8941.78 | 8970.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 4 | 1 | 1 | 3 |
## | 0.002 | 0.004 | 0.001 | 0.001 | 0.003 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 9087 | 9182.45 | 9203.5 | 9209.56 | 9281.18 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 9320 | 9436.5 | 9580.48 | 9669.5 | 10252 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 2 | 1 | 2 |
## | 0.001 | 0.002 | 0.002 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 10330.25 | 10367.28 | 10552.41 | 10601.5 | 10663.49 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 2 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 10774.57 | 11067.5 | 11107.8 | 11184 | 11218.88 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 11385.5 | 11441.03 | 11552.11 | 11650 | 11766.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 2 | 1 |
## | 0.001 | 0.002 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 11774.27 | 11885.35 | 11996.42 | 11999.5 | 12052.3 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 3 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.003 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 12232.5 | 12329.66 | 12440.74 | 12465.5 | 12551.81 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 3 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.003 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 12662.89 | 12781.58 | 12815 | 13048 | 13107.2 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 13218.28 | 13329.36 | 13440.44 | 13514 | 13630.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 3 | 1 | 1 | 1 | 1 |
## | 0.003 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 13662.59 | 13995.83 | 14020.51 | 14096.5 | 14162.45 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 14213 | 14217.98 | 14562.5 | 14662.3 | 14717.84 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 14773.37 | 14884.45 | 15106.61 | 15217.69 | 15279.23 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 15328.76 | 15439.84 | 15494.5 | 15550.92 | 15727.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 15844 | 16106.31 | 16310 | 16384.01 | 16426.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 16439.54 | 16522.85 | 16550.62 | 16800.55 | 16994.93 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 17078.24 | 17125.5 | 17591.5 | 18011.07 | 18327.87 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 18640 | 18772.18 | 18779.79 | 18903.35 | 19105.42 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 19106 | 19438.65 | 19882.96 | 20154.5 | 20327.27 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 20549.43 | 20561.3 | 20660.51 | 20737 | 20900.1 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 20993.74 | 21086.5 | 21203 | 21438.05 | 21552.5 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 21660.21 | 21771.29 | 21882.37 | 22493.3 | 22882.07 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 3 | 1 | 1 |
## | 0.001 | 0.001 | 0.003 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 23104.22 | 23300 | 23548.54 | 23766 | 23770.69 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 23992.85 | 24465 | 24698 | 25103.63 | 25325.78 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 1 | 3 | 1 |
## | 0.001 | 0.002 | 0.001 | 0.003 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 25397 | 25547.94 | 25770.1 | 25992.25 | 26103.33 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 26329 | 26562 | 26658.72 | 26880.88 | 27385.48 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 1 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 28193 | 28658.12 | 29102.44 | 29109.04 | 29591 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 29991.06 | 30290 | 31546.15 | 31657.23 | 31768.31 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 32154 | 33834.69 | 34950 | 35100.65 | 35267.27 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 35989.27 | 36115 | 36433.58 | 37988.68 | 39377 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 41098.86 | 41797.54 | 41931.95 | 42209.64 | 43804 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 49318.63 | 51856.69 | 52873.13 | 55865.82 | 55983.31 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 56852 | 59179.89 | 60126.77 | 60870.74 | 62493.96 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 63440.84 | 64143.84 | 65240 | 66638 | 68424.05 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 69595.55 | 69752.05 | 70542.43 | 71489.31 | 73383.06 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 74200.1 | 74803.38 | 75276.82 | 78590.89 | 80420.47 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 80958.09 | 82851.85 | 83974.97 | 84272.16 | 86210 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 88533.12 | 89006 | 90900.31 | 93977.67 | 95530 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 97055.02 | 97394 | 99422.22 | 102986 | 103452 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 106893.47 | 107646 | 109364.44 | 113151.95 | 115519.15 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 123094.17 | 129315 | 135883.51 | 146766.13 | 148186.44 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 166887.29 | 184641.26 | 194110.04 | 195293.64 | 201211.63 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 228126.32 | 233000 | 246188.34 | 256300 | 265125.91 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 285879.4 | 321938.6 | 331407.38 | 355079.34 | 362180.93 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 371649.71 | 416626.43 | 473439.12 | 534986.21 | 714893.07 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
##
## CrossTable(rate$EXEM.AMT)##
##
## Cell Contents
## |-------------------------|
## | N |
## | N / Table Total |
## |-------------------------|
##
##
## Total Observations in Table: 1049
##
##
## | 0 | 47.9 | 97.37 | 160.06 | 161.36 |
## |-----------|-----------|-----------|-----------|-----------|
## | 839 | 2 | 3 | 1 | 4 |
## | 0.800 | 0.002 | 0.003 | 0.001 | 0.004 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 167.65 | 194.75 | 251.44 | 293.42 | 320.12 |
## |-----------|-----------|-----------|-----------|-----------|
## | 21 | 2 | 1 | 1 | 1 |
## | 0.020 | 0.002 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 322.72 | 335.3 | 373.62 | 416.69 | 431.1 |
## |-----------|-----------|-----------|-----------|-----------|
## | 4 | 7 | 1 | 1 | 1 |
## | 0.004 | 0.007 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 432.57 | 435.89 | 448.77 | 450.26 | 454.84 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 464.98 | 484.08 | 497.14 | 502.95 | 523.94 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 7 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.007 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 562.83 | 578.4 | 588.27 | 608.51 | 610.73 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 2 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 613.67 | 624.9 | 626.96 | 628.41 | 634.68 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 2 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 640.24 | 645.44 | 646.65 | 658.63 | 670.6 |
## |-----------|-----------|-----------|-----------|-----------|
## | 2 | 1 | 1 | 1 | 9 |
## | 0.002 | 0.001 | 0.001 | 0.001 | 0.009 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 682.58 | 706.53 | 718.5 | 742.45 | 754.43 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 2 | 4 | 4 | 5 |
## | 0.001 | 0.002 | 0.004 | 0.004 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 757.24 | 764.06 | 766.4 | 778.38 | 778.8 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 790.35 | 802.33 | 806.8 | 814.3 | 821.54 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 4 | 1 | 2 | 1 |
## | 0.001 | 0.004 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 826.28 | 838.25 | 850.23 | 862.2 | 874.18 |
## |-----------|-----------|-----------|-----------|-----------|
## | 3 | 6 | 1 | 2 | 2 |
## | 0.003 | 0.006 | 0.001 | 0.002 | 0.002 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 892.35 | 898.13 | 910.1 | 922.08 | 927.33 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 930.47 | 942.29 | 946.65 | 950.55 | 958 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 1 | 5 |
## | 0.001 | 0.001 | 0.002 | 0.001 | 0.005 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 969.98 | 1005.9 | 1008.16 | 1041.83 | 1074.23 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1088.78 | 1106.58 | 1110 | 1137.63 | 1146.33 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 2 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.002 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1148.99 | 1149.6 | 1173.29 | 1173.55 | 1177.6 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1185.53 | 1197.5 | 1232.15 | 1245.4 | 1254.56 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 2 | 4 | 1 |
## | 0.001 | 0.001 | 0.002 | 0.004 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1262.2 | 1269.35 | 1290.47 | 1317.25 | 1330.62 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1341.2 | 1440.53 | 1534.12 | 1552.71 | 1571.28 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 1600.59 | 1640.81 | 1724.4 | 1844.15 | 2142.36 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 2371.05 | 2437.86 | 2490.8 | 3731.51 | 3747.02 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 4358.9 | 5443.98 | 5747.91 | 6227 | 6239.93 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 6694.05 | 8981.25 | 9466.48 | 16286 | 26687.75 |
## |-----------|-----------|-----------|-----------|-----------|
## | 1 | 1 | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|-----------|-----------|
##
##
## | 35925 | 75255.06 | 139338.3 |
## |-----------|-----------|-----------|
## | 1 | 1 | 1 |
## | 0.001 | 0.001 | 0.001 |
## |-----------|-----------|-----------|
##
##
##
## Histogram
#Histogram for Period charge with respect to number of counts
hist(rate$Period.Charge,
main=" Period Charge",
xlab="Charge per category",
ylab="Count",
xlim = c(0,100000),
breaks=100,
col="gray43")
#Histogram for Exemption with respect to the number of counts
hist(rate$EXEM.AMT,
main="Exemption",
xlab="Charge per category",
ylab="Count",
xlim = c(0,10000),
breaks=100,
col="gray43")
Scatterplot Matrix
data1 <- rate[ which(rate$Charge.Type == 'V'),]
View(data1)
library(car)##
## Attaching package: 'car'## The following object is masked from 'package:psych':
##
## logitscatterplotMatrix(formula = ~ Period.Charge + EXEM.AMT , data = data1, main = "Scatter Plot Matrix")
Chi-square test
newdata2 <- xtabs(~ Period.Charge, data = rate)
newdata2## Period.Charge
## 0 46.6 94.73 150.08 155.51 162.21 163.1
## 8 2 3 1 6 1 39
## 181.43 189.46 233 233.26 241.04 259.18 285.1
## 2 2 1 1 1 1 1
## 311.02 312.22 326.2 358.82 360.86 363.35 363.48
## 5 1 17 1 1 1 1
## 388.77 391.44 399.14 414.69 419.4 424.06 430.24
## 2 1 1 1 1 1 1
## 438.04 444.31 445.79 454.19 464.06 464.56 466
## 1 1 1 1 1 1 2
## 466.53 483.81 489.3 500.95 502.81 508 518.36
## 1 1 8 1 1 1 5
## 547.55 562.8 572.67 583.16 594.15 596.12 609.08
## 1 1 1 3 2 1 1
## 612.16 617.45 622.04 629.1 640.75 652.4 664.05
## 2 2 3 1 1 10 1
## 687.35 699 712.75 722.3 725.71 733.95 745.6
## 2 4 1 5 1 5 1
## 748.34 757.25 760.27 768.9 771.04 777.55 780.55
## 1 1 1 2 1 3 5
## 789.89 792.2 799.76 803.85 815.5 827.15 829.38
## 1 2 1 4 12 1 1
## 838.8 849.13 850.45 855.3 873.75 885.4 888.62
## 3 1 3 1 2 1 1
## 894.18 897.05 906.47 907.14 908.37 908.7 918.24
## 1 1 1 2 1 2 1
## 919.23 920.1 920.35 920.96 928.12 932 943.65
## 1 2 1 2 1 7 2
## 978.6 987.36 1010.81 1013.55 1025.2 1026.85 1034.14
## 3 1 1 1 2 1 1
## 1036.73 1036.85 1037.67 1046.6 1048.5 1060.15 1062.65
## 1 2 1 1 2 2 1
## 1066.35 1082.6 1083.45 1086.1 1089.61 1106.75 1110.74
## 1 1 1 1 1 2 1
## 1114.48 1118.4 1125.59 1130.05 1141.7 1144.45 1145.34
## 1 1 1 1 4 1 2
## 1149.04 1151.08 1153.35 1153.36 1165 1166.28 1166.32
## 1 1 1 1 2 1 1
## 1167.23 1169.51 1184.83 1187.21 1192.24 1198.71 1211.6
## 1 1 1 1 1 2 5
## 1224.33 1227.94 1234.9 1258.2 1263.51 1263.82 1281.5
## 1 1 2 2 1 1 3
## 1282.95 1295.91 1303.32 1304.8 1319.61 1328.1 1351.4
## 1 2 1 2 1 3 1
## 1382.3 1398 1399.58 1421.8 1444.6 1467.9 1477.34
## 1 2 1 2 2 4 1
## 1481.04 1491.2 1492.48 1514.5 1520.53 1536.92 1537.8
## 1 1 1 2 1 1 1
## 1555.09 1579.78 1581.01 1584.4 1599.52 1606.93 1607.7
## 5 1 1 3 1 2 1
## 1622.06 1632.85 1677.6 1700.9 1747.5 1770.8 1788.36
## 1 2 5 1 1 4 1
## 1794.1 1797 1814.27 1840.19 1840.7 1864 1866.11
## 1 1 1 2 4 1 1
## 1875.98 1887.3 1905.87 1910.6 1915.48 1933.9 1954.97
## 1 1 1 1 1 1 1
## 1957.2 1974.72 1980.5 2003.71 2003.8 2021.62 2022.31
## 2 1 1 1 2 2 1
## 2027.1 2050.4 2053.71 2073.46 2073.7 2097 2120.3
## 2 3 1 1 2 2 1
## 2143.6 2166.9 2172.19 2177.13 2190.2 2195.31 2203.05
## 4 2 2 1 2 1 2
## 2213.5 2236.8 2238.72 2251.18 2254.88 2260.1 2283.4
## 4 2 1 1 1 1 2
## 2290.68 2306.7 2358.56 2376.6 2384.47 2410.39 2423.2
## 2 1 1 3 1 1 8
## 2448.73 2454.86 2462.23 2469.8 2488.15 2514.07 2516.4
## 1 1 1 1 1 2 3
## 2527.64 2539.98 2547.79 2563 2591.82 2609.6 2643.66
## 1 1 1 4 1 3 1
## 2646.12 2656.2 2685.62 2702.8 2747.33 2749.4 2796
## 2 2 1 1 3 8 4
## 2799.17 2823.58 2842.6 2889.2 2902.84 2935.8 2954.67
## 3 1 5 2 1 4 3
## 2982.4 3006.51 3029 3058.35 3068.85 3075.6 3080.56
## 1 1 1 1 1 5 1
## 3110.18 3122.2 3168.8 3188.59 3199.05 3213.86 3215.4
## 2 1 1 1 1 1 1
## 3238.54 3251.64 3262 3278.04 3308.6 3317.53 3369.37
## 1 1 2 1 4 1 1
## 3401.16 3401.8 3421.2 3436.01 3448.4 3473.04 3495
## 1 5 1 1 3 3 3
## 3524.88 3541.6 3588.2 3615.77 3634.8 3645.33 3672.98
## 1 2 3 1 3 1 1
## 3673.1 3681.4 3732.22 3759.92 3774.6 3821.2 3830.96
## 1 3 1 1 3 2 1
## 3842.39 3867.8 3870.45 3914.4 3938.62 3939.57 3961
## 1 8 1 1 1 1 3
## 4007.6 4054.2 4095.08 4100.8 4147.4 4194 4203.72
## 1 1 1 1 2 5 1
## 4240.6 4245.65 4287.2 4333.8 4344.38 4443.12 4473.6
## 4 1 2 1 1 2 3
## 4509.77 4520.2 4541.86 4561.6 4566.8 4590.1 4613.44
## 1 2 1 2 1 1 1
## 4614.15 4660 4776.5 4838.06 4872.62 4893 5009.5
## 1 5 2 2 1 5 3
## 5126 5134.27 5165.9 5242.5 5287.45 5358.79 5359
## 3 1 1 5 1 1 7
## 5442.82 5475.5 5572.41 5592 5702 5708.5 5708.82
## 1 9 1 6 1 3 1
## 5821.81 5825 5922.89 5924.16 5941.5 6022.9 6049.7
## 1 5 1 2 3 1 1
## 6052.99 6058 6090.78 6220.37 6281.42 6291 6349.96
## 1 1 1 1 1 3 1
## 6407.5 6417.84 6479.55 6524 6757 6873.5 6942.38
## 1 1 1 2 5 1 1
## 6990 7106.5 7108.99 7244.25 7339.5 7456 7572.5
## 4 1 1 1 1 2 6
## 7645.87 7689 7805.5 7898.88 8038.5 8053.16 8096.35
## 1 3 2 1 1 1 1
## 8155 8322.89 8330.85 8388 8491.3 8504.5 8590.03
## 3 1 1 1 1 2 1
## 8621 8737.5 8787.5 8854 8886.24 8936.99 8941.78
## 2 2 1 2 4 1 1
## 8970.5 9087 9182.45 9203.5 9209.56 9281.18 9320
## 3 2 1 1 1 1 1
## 9436.5 9580.48 9669.5 10252 10330.25 10367.28 10552.41
## 2 2 1 2 1 1 2
## 10601.5 10663.49 10774.57 11067.5 11107.8 11184 11218.88
## 1 2 1 1 1 2 1
## 11385.5 11441.03 11552.11 11650 11766.5 11774.27 11885.35
## 1 2 1 2 1 1 1
## 11996.42 11999.5 12052.3 12232.5 12329.66 12440.74 12465.5
## 1 3 1 2 1 1 3
## 12551.81 12662.89 12781.58 12815 13048 13107.2 13218.28
## 1 2 1 1 1 1 3
## 13329.36 13440.44 13514 13630.5 13662.59 13995.83 14020.51
## 1 1 1 1 1 1 1
## 14096.5 14162.45 14213 14217.98 14562.5 14662.3 14717.84
## 2 1 1 1 1 1 1
## 14773.37 14884.45 15106.61 15217.69 15279.23 15328.76 15439.84
## 2 1 1 1 1 1 1
## 15494.5 15550.92 15727.5 15844 16106.31 16310 16384.01
## 1 1 1 1 1 2 1
## 16426.5 16439.54 16522.85 16550.62 16800.55 16994.93 17078.24
## 1 1 1 1 1 1 1
## 17125.5 17591.5 18011.07 18327.87 18640 18772.18 18779.79
## 1 2 1 1 1 1 1
## 18903.35 19105.42 19106 19438.65 19882.96 20154.5 20327.27
## 1 1 1 1 1 1 1
## 20549.43 20561.3 20660.51 20737 20900.1 20993.74 21086.5
## 1 1 2 1 1 1 1
## 21203 21438.05 21552.5 21660.21 21771.29 21882.37 22493.3
## 1 1 1 1 1 3 1
## 22882.07 23104.22 23300 23548.54 23766 23770.69 23992.85
## 1 2 1 1 1 1 1
## 24465 24698 25103.63 25325.78 25397 25547.94 25770.1
## 2 1 3 1 1 1 1
## 25992.25 26103.33 26329 26562 26658.72 26880.88 27385.48
## 1 1 2 1 1 1 1
## 28193 28658.12 29102.44 29109.04 29591 29991.06 30290
## 1 1 1 1 1 1 1
## 31546.15 31657.23 31768.31 32154 33834.69 34950 35100.65
## 1 1 1 1 1 1 1
## 35267.27 35989.27 36115 36433.58 37988.68 39377 41098.86
## 1 1 1 1 2 1 1
## 41797.54 41931.95 42209.64 43804 49318.63 51856.69 52873.13
## 1 1 1 1 1 1 1
## 55865.82 55983.31 56852 59179.89 60126.77 60870.74 62493.96
## 1 1 1 1 1 1 1
## 63440.84 64143.84 65240 66638 68424.05 69595.55 69752.05
## 1 1 1 1 1 1 1
## 70542.43 71489.31 73383.06 74200.1 74803.38 75276.82 78590.89
## 1 2 1 1 1 1 1
## 80420.47 80958.09 82851.85 83974.97 84272.16 86210 88533.12
## 1 1 1 1 1 1 1
## 89006 90900.31 93977.67 95530 97055.02 97394 99422.22
## 1 1 1 1 1 1 1
## 102986 103452 106893.47 107646 109364.44 113151.95 115519.15
## 1 1 1 1 1 1 1
## 123094.17 129315 135883.51 146766.13 148186.44 166887.29 184641.26
## 1 1 1 1 1 1 1
## 194110.04 195293.64 201211.63 228126.32 233000 246188.34 256300
## 1 1 1 1 1 1 1
## 265125.91 285879.4 321938.6 331407.38 355079.34 362180.93 371649.71
## 1 1 1 1 1 1 1
## 416626.43 473439.12 534986.21 714893.07
## 1 1 2 1chisq.test(newdata2)## Warning in chisq.test(newdata2): Chi-squared approximation may be incorrect##
## Chi-squared test for given probabilities
##
## data: newdata2
## X-squared = 1606.5, df = 619, p-value < 2.2e-16t-test for Period Charge and Exemption
t.test(rate$Period.Charge, rate$EXEM.AMT)##
## Welch Two Sample t-test
##
## data: rate$Period.Charge and rate$EXEM.AMT
## t = 9.4969, df = 1068.2, p-value < 2.2e-16
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
## 12233.53 18605.24
## sample estimates:
## mean of x mean of y
## 15893.6108 474.2282Regression
r1<- lm(Period.Charge~ SBR.SUPPLE+SBR.RELIEF.+RV, data=rate)
summary(r1)##
## Call:
## lm(formula = Period.Charge ~ SBR.SUPPLE + SBR.RELIEF. + RV, data = rate)
##
## Residuals:
## Min 1Q Median 3Q Max
## -68929 -1657 -1041 569 119314
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1567.12541 318.76643 4.916 1.02e-06 ***
## SBR.SUPPLE 18.27568 1.38223 13.222 < 2e-16 ***
## SBR.RELIEF. -0.05332 0.20311 -0.263 0.793
## RV 0.28021 0.01785 15.696 < 2e-16 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 8183 on 1045 degrees of freedom
## (8733 observations deleted due to missingness)
## Multiple R-squared: 0.9756, Adjusted R-squared: 0.9755
## F-statistic: 1.394e+04 on 3 and 1045 DF, p-value: < 2.2e-16