Goal: Determine which stores are Under/Over Performing based on Region, Years Open

1) An underperforming store will be 1 standard deviation below their Region numbers and 1 standard deviation below their Years Open group.

2) I have identified 52 stores that were a full standard deviation below both Region and Years Open groups, and 10 stores 1.5 standard deviations below both Region and Years Open.

3) I have identified 66 stores that were a full standard deviation above both Region and Years Open groups.

4) By Region and number of underperforming stores

##    region bad_stores
## 1     CAN          8
## 2     TXH          5
## 3     NCC          5
## 4     CAL          5
## 5     INI          4
## 6     OKO          3
## 7     MIA          3
## 8     GAA          3
## 9     VAR          2
## 10    MNM          2
## 11    KSK          2
## 12    FLJ          2
## 13    WAS          1
## 14    UTS          1
## 15    TXS          1
## 16    NVL          1
## 17    ILC          1
## 18    COD          1
## 19    CAS          1
## 20    AZP          1

5) By Region and number of overperforming stores

##    region good_stores
## 1     WAS           9
## 2     AZP           7
## 3     TXS           6
## 4     TXD           6
## 5     NMA           5
## 6     MIA           5
## 7     COD           4
## 8     TNN           3
## 9     ILC           3
## 10    UTS           2
## 11    TXH           2
## 12    NVL           2
## 13    NCC           2
## 14    MNM           2
## 15    GAA           2
## 16    VAR           1
## 17    OKO           1
## 18    KSK           1
## 19    INI           1
## 20    FLJ           1
## 21    CAS           1

6) Average Revenue by Region

##    region region_rev
## 1     TXS   359132.5
## 2     WAS   327872.1
## 3     NMA   277139.9
## 4     TNN   232024.8
## 5     TXD   231628.0
## 6     MIA   229805.9
## 7     MNM   221593.4
## 8     ILC   213736.4
## 9     NVL   212099.9
## 10    AZP   208053.6
## 11    COD   203877.4
## 12    UTS   185700.2
## 13    FLJ   173266.7
## 14    CAS   170452.1
## 15    INI   170170.1
## 16    TXH   169913.7
## 17    VAR   167120.2
## 18    KSK   166948.9
## 19    CAN   163354.8
## 20    OKO   160047.1
## 21    CAL   148131.8
## 22    GAA   147374.1
## 23    NCC   135893.6

7) List of stores 1.5 standard deviations below both groups (stores we need to help the most)

##                    store region  revenue group_rev region_rev
## 1    MENTOR AVE (OHN 05)    MIA 15176.84  130640.0   229805.9
## 2    ROMEOVILLE (ILC 10)    ILC 50437.88  226036.7   213736.4
## 3       ROSWELL (GAA 09)    GAA 33596.24  226036.7   147374.1
## 4    ROY ROGERS (CAL 34)    CAL 21368.80  221546.8   148131.8
## 5     S FONTANA (CAL 39)    CAL 48505.86  221546.8   148131.8
## 6  STATE BRIDGE (GAA 04)    GAA 18725.97  226036.7   147374.1
## 7      TUALATIN (ORP 06)    WAS 62125.20  221546.8   327872.1
## 8  WELCOME LANE (TXH 09)    TXH 24302.16  211356.9   169913.7
## 9   WEST COVINA (CAL 47)    CAL 75761.72  194074.0   148131.8
## 10    WEST SHAW (CAN 53)    CAN 12593.70  130640.0   163354.8

8) List of stores 1 standard deviation above below groups

                            store region   revenue group_rev region_rev
1               ANTELOPE (CAN 52)    CAN  54732.20  130640.0   163354.8
2                ARDMORE (OKA 01)    OKO  26457.50  130640.0   160047.1
3       ASHLEY PHOSPHATE (SCC 18)    NCC  37439.76  130640.0   135893.6
4           BARRETT PKWY (GAA 39)    GAA  24735.84  130640.0   147374.1
5           CALVINE ROAD (CAN 50)    CAN  54987.92  130640.0   163354.8
6                 CANOGA (CAL 22)    CAL  99063.71  226036.7   148131.8
7  DEER SPRINGS CROSSING (NVL 26)    NVL  36921.00  130640.0   212099.9
8             EAST ILIFF (COD 16)    COD  43400.94  211356.9   203877.4
9               ERTEL RD (OHS 05)    INI 116362.02  194074.0   170170.1
10          FIRST COLONY (TXH 44)    TXH  82090.32  226036.7   169913.7
11          FISHINGER RD (OHC 02)    INI 114779.66  226036.7   170170.1
12                FLORIN (CAN 06)    CAN  63237.36  211356.9   163354.8
13              FOUNTAIN (AZP 41)    AZP 124247.74  221546.8   208053.6
14           FOUR POINTS (TXA 22)    TXS  20434.90  130640.0   359132.5
15               FREMONT (CAN 04)    CAN  83230.55  211356.9   163354.8
16              FRY ROAD (TXH 84)    TXH 109785.10  194074.0   169913.7
17          GRAND ISLAND (NEG 01)    KSK 116852.89  194074.0   166948.9
18              HARRISON (NCC 16)    NCC  85084.50  221546.8   135893.6
19        HULL STREET RD (VAR 03)    VAR 105913.22  194074.0   167120.2
20            JOHN YOUNG (FLO 03)    FLJ 116199.92  226036.7   173266.7
21       KELLOGG WEBB RD (KSW 03)    OKO  50101.20  130640.0   160047.1
22           KINGSBRIDGE (TXH 79)    TXH  95409.25  221546.8   169913.7
23            MALL DRIVE (VAR 05)    VAR  51496.54  130640.0   167120.2
24            MASON CITY (IAN 03)    MNM  26258.54  130640.0   221593.4
25            MENTOR AVE (OHN 05)    MIA  15176.84  130640.0   229805.9
26       N BROOKLYN PARK (MNM 24)    MNM 132419.34  221546.8   221593.4
27          NORTH MYRTLE (SCC 17)    NCC  35716.86  130640.0   135893.6
28         NW EXPRESSWAY (OKO 13)    OKO 100392.91  194074.0   160047.1
29         OVERLAND PARK (KSK 02)    KSK  94757.35  194074.0   166948.9
30             PALO ALTO (CAN 49)    CAN  56412.68  194074.0   163354.8
31           PENASQUITOS (CAS 45)    CAS  92134.86  221546.8   170452.1
32             PITTSBURG (CAN 56)    CAN  20659.52  130640.0   163354.8
33            ROMEOVILLE (ILC 10)    ILC  50437.88  226036.7   213736.4
34               ROSWELL (GAA 09)    GAA  33596.24  226036.7   147374.1
35            ROY ROGERS (CAL 34)    CAL  21368.80  221546.8   148131.8
36                S BLVD (NCC 04)    NCC  74938.68  226036.7   135893.6
37             S FONTANA (CAL 39)    CAL  48505.86  221546.8   148131.8
38              S SHAVER (TXH 07)    TXH  38478.75  211356.9   169913.7
39               S TRYON (NCC 06)    NCC  84013.98  226036.7   135893.6
40                 SANDY (UTS 08)    UTS  30262.28  211356.9   185700.2
41               SAWMILL (OHC 04)    INI 108845.42  226036.7   170170.1
42              ST JOHNS (FLJ 11)    FLJ  52065.54  130640.0   173266.7
43          STATE BRIDGE (GAA 04)    GAA  18725.97  226036.7   147374.1
44          THOUSAND OAK (CAL 31)    CAL  82221.96  221546.8   148131.8
45                  TROY (MID 03)    MIA  52369.70  211356.9   229805.9
46              TUALATIN (ORP 06)    WAS  62125.20  221546.8   327872.1
47             WASHTENAW (MIA 02)    MIA  35375.93  211356.9   229805.9
48          WELCOME LANE (TXH 09)    TXH  24302.16  211356.9   169913.7
49          WEST CHESTER (OHS 02)    INI 100824.42  194074.0   170170.1
50           WEST COVINA (CAL 47)    CAL  75761.72  194074.0   148131.8
51             WEST SHAW (CAN 53)    CAN  12593.70  130640.0   163354.8
52             YUBA CITY (CAN 55)    CAN  43652.40  130640.0   163354.8

9) List of stores 1 standard deviation below above groups

                          store region   revenue group_rev region_rev
64                32ND (AZY 01)    AZP  472780.4  211356.9   208053.6
80               AIKEN (SCA 01)    GAA  331685.7  194074.0   147374.1
87               ALCOA (TNN 13)    TNN  434424.5  221546.8   232024.8
126              AZURE (NVL 11)    NVL  418934.0  221546.8   212099.9
161               BEND (ORP 08)    WAS  720306.3  221546.8   327872.1
164           BILLINGS (MTB 01)    COD  299521.3  130640.0   203877.4
183          BREMERTON (WAS 11)    WAS  473841.7  211356.9   327872.1
204           BURLESON (TXD 51)    TXD  329437.1  226036.7   231628.0
249        CLARKSVILLE (TNN 14)    TNN  438496.1  194074.0   232024.8
256              CLIVE (IAD 04)    KSK  281148.4  194074.0   166948.9
311       DEZAVALA/I10 (TXS 12)    TXS  551183.0  226036.7   359132.5
317            DRENNAN (TXH 74)    TXH  322784.4  221546.8   169913.7
320             DULUTH (MNM 22)    MNM  336664.9  221546.8   221593.4
333           EAGLE RD (IDB 01)    UTS  310451.4  221546.8   185700.2
343          EL CENTRO (CAS 39)    CAS  392418.4  226036.7   170452.1
353             EUGENE (ORP 02)    WAS  600118.2  211356.9   327872.1
357         EVANSVILLE (INE 01)    INI  373338.0  221546.8   170170.1
361         FARMINGTON (NMF 01)    NMA  376343.5  221546.8   277139.9
420           GRAYHAWK (AZP 55)    AZP  307254.2  221546.8   208053.6
434            GRESHAM (ORP 03)    WAS  507956.5  211356.9   327872.1
437            GULL RD (MIK 31)    MIA  390118.6  226036.7   229805.9
445        HANOVERPARK (ILC 31)    ILC  295272.7  194074.0   213736.4
446       HAPPY VALLEY (AZP 53)    AZP  344276.0  221546.8   208053.6
462     HIGHWAY 6 & 50 (COG 03)    COD  326951.5  194074.0   203877.4
466          HILLCREST (TXS 09)    TXS  551577.8  211356.9   359132.5
470         HINESVILLE (GAE 01)    GAA  235622.0  130640.0   147374.1
475            HOLLAND (MIG 29)    MIA  358480.3  226036.7   229805.9
499        IDAHO FALLS (IDB 05)    UTS  312962.4  194074.0   185700.2
522          JUAN TABO (NMA 05)    NMA  364665.7  211356.9   277139.9
531            KILLEEN (TXA 08)    TXS  549116.3  226036.7   359132.5
539          KNOXVILLE (TNK 01)    TNN  331608.3  221546.8   232024.8
545              LACEY (WAS 12)    WAS  546737.3  211356.9   327872.1
551  LAKE HAVASU AVE N (AZH 01)    AZP  405962.5  226036.7   208053.6
555         LAKE WORTH (TXD 44)    TXD  334010.6  226036.7   231628.0
564             LAWTON (OKO 12)    OKO  285126.3  194074.0   160047.1
569           LEE BLVD (AZN 02)    AZP  407215.8  226036.7   208053.6
590           LONGMONT (COD 28)    COD  341183.4  226036.7   203877.4
594         LOOP 1604W (TXS 15)    TXS  972986.7  226036.7   359132.5
662       MNT PROSPECT (ILC 13)    ILC  343701.8  226036.7   213736.4
688         N DIVISION (WAE 02)    WAS  580287.4  211356.9   327872.1
708      NEW BALTIMORE (MID 06)    MIA  460785.3  211356.9   229805.9
760       PAN AMERICAN (NMA 04)    NMA  425696.4  211356.9   277139.9
777          PENSACOLA (FLP 01)    FLJ  344121.3  221546.8   173266.7
791         PORT HURON (MID 13)    MIA  399996.9  211356.9   229805.9
793             PORTER (TXH 92)    TXH  384065.8  194074.0   169913.7
797             POWERS (COS 05)    COD  355173.4  226036.7   203877.4
805        QUEEN CREEK (AZP 50)    AZP  340894.9  221546.8   208053.6
824         RIO RANCHO (NMA 03)    NMA  399621.0  226036.7   277139.9
839           ROCKWALL (TXD 39)    TXD  399051.7  226036.7   231628.0
840             ROGERS (MNM 16)    MNM  362225.2  221546.8   221593.4
866      S. RAEFORD RD (NCC 38)    NCC  297187.1  130640.0   135893.6
869              SALEM (ORP 05)    WAS  466104.4  226036.7   327872.1
888            SARIVAL (AZP 51)    AZP  314471.1  221546.8   208053.6
893               SERN (NMA 09)    NMA  429395.7  221546.8   277139.9
894          SFIELD RD (MID 24)    MIA  370091.7  221546.8   229805.9
978          THE FORUM (TXS 17)    TXS  595309.0  226036.7   359132.5
1009         VANCOUVER (WAV 01)    WAS  464048.9  211356.9   327872.1
1027           W LAKES (TXS 08)    TXS 1457376.6  211356.9   359132.5
1043       WATER STEET (NVL 23)    NVL  357829.5  221546.8   212099.9
1046          WAUKESHA (WIM 02)    ILC  347599.0  221546.8   213736.4
1048        WAXAHACHIE (TXD 69)    TXD  356862.3  221546.8   231628.0
1049        WAYNESBORO (VAW 01)    VAR  228350.0  130640.0   167120.2
1050       WEATHERFORD (TXD 61)    TXD  307829.6  221546.8   231628.0
1052         WENATCHEE (WAS 18)    WAS  537283.9  221546.8   327872.1
1063      WESTERN BLVD (NCC 37)    NCC  204754.8  130640.0   135893.6
1069     WICHITA FALLS (TXN 01)    TXD  460586.7  211356.9   231628.0