I Need help in R & RStudio

profileAziz1100
Week-1-Homework.xlsx
Home>Mathematics homework help>Statistics homework help>I Need help in R & RStudio

New Drug

Subject Treatment Age Gender Before_exp_BP After_exp_BP
D1 1 65 F 103.3 80.5
D2 1 59 F 93.6 85.9
D3 1 60 M 92 85.2
D4 1 54 F 93 87.8
D5 1 65 F 95.4 85.3
D6 1 57 M 109.6 94.2
D7 1 69 M 97.9 83.9
D8 1 62 M 96 85
D9 1 49 F 98.4 86.3
D10 1 45 F 98.4 90
D11 1 65 F 95.5 85.2
D12 1 62 M 91.7 87.9
D13 1 64 M 98.6 84.6
D14 1 68 F 98 83.8
D15 1 70 M 96.4 85.5
D16 1 66 M 104.4 93
D17 1 65 F 111.7 85.4
D18 1 63 F 108.6 84.8
D19 1 61 F 99.1 82.4
D20 1 63 M 106.8 88.7
D21 1 69 M 111.5 86.5
D22 1 56 M 97.4 82.4
D23 1 58 F 87.5 78
D24 1 46 M 98.1 83.8
D25 1 56 F 98.6 87
D26 1 64 M 99.1 86.3
D27 1 61 F 96.4 87.6
D28 1 66 F 101.2 84.8
C1 0 63 F 97.4 93.1
C2 0 56 F 97.2 92.4
C3 0 54 M 98.8 94.6
C4 0 69 M 98.4 92.3
C5 0 75 M 89.8 89.3
C6 0 62 F 103.4 99.7
C7 0 61 F 90.1 88.4
C8 0 59 M 93.7 90.4
C9 0 73 F 96.4 91.1
C10 0 57 F 98.6 90.5
C11 0 48 M 95.2 90.4
C12 0 64 M 95 89.3
C13 0 61 F 97.4 93.8
C14 0 66 F 97.4 92.6
C15 0 57 M 101.6 96.9
C16 0 65 M 101.2 98.9
C17 0 63 M 97.5 89.9
A18 0 51 F 92.2 86.2
A19 0 68 M 96.6 92.6
A20 0 65 F 96.9 90.4
A21 0 65 F 102.6 91.5
A22 0 64 M 99.5 93.8

MS Stock

Date Open High Low Close Volume
1/3/17 43.09 43.630001 42.450001 43.049999 8316900
1/4/17 43.299999 43.82 43.040001 43.619999 7747400
1/5/17 43.529999 43.630001 42.189999 43.220001 9883200
1/6/17 43.560001 44.130001 43.18 43.849998 9152800
1/9/17 43.490002 43.540001 42.68 42.709999 11104000
1/10/17 42.98 43.52 42.75 43.060001 9074300
1/11/17 43.130001 43.669998 42.779999 43.669998 8777100
1/12/17 43.599998 43.709999 42.84 43.630001 8595600
1/13/17 44.02 44.599998 43.5 43.810001 12904500
1/17/17 43.779999 43.84 41.77 42.150002 21840400
1/18/17 42.290001 43.150002 41.98 42.860001 15906900
1/19/17 42.57 43 41.950001 42.450001 15040100
1/20/17 42.48 42.869999 42.349998 42.59 10779600
1/23/17 42.200001 42.580002 41.779999 41.959999 12344700
1/24/17 42.080002 43.130001 42.029999 42.73 12164200
1/25/17 43.200001 43.900002 42.959999 43.860001 13961000
1/26/17 43.939999 44.419998 43.75 44.02 10628900
1/27/17 43.75 43.950001 43.560001 43.650002 7635600
1/30/17 43.240002 43.290001 42.470001 43.119999 7216200
1/31/17 43.080002 43.369999 42.32 42.490002 10811000
2/1/17 43.299999 43.400002 42.549999 42.700001 9731300
2/2/17 42.189999 42.509998 41.830002 42.130001 11481000
2/3/17 43.099998 44.599998 42.919998 44.43 16692200
2/6/17 44.259998 45.029999 44.139999 44.630001 12577100
2/7/17 44.880001 45.029999 44.619999 44.869999 10055700
2/8/17 44.580002 44.59 43.619999 43.91 10586500
2/9/17 44.349998 45.029999 43.889999 44.849998 13166700
2/10/17 45.130001 45.150002 44.34 44.700001 8909400
2/13/17 45 45.599998 44.939999 45.259998 13256300
2/14/17 45.189999 46.259998 45.099998 46.040001 12958700
2/15/17 46.380001 46.75 46 46.490002 10115100
2/16/17 46.419998 46.5 45.799999 46.110001 10752500
2/17/17 45.549999 46.169998 45.400002 46.150002 8310100
2/21/17 46.27 46.700001 46.27 46.560001 7628400
2/22/17 46.209999 46.82 46.139999 46.52 7612800
2/23/17 46.580002 46.59 46.200001 46.580002 11877100
2/24/17 45.889999 45.950001 45.240002 45.529999 11837200
2/27/17 45.52 46.029999 45.459999 45.84 7887000
2/28/17 45.599998 45.830002 45.130001 45.669998 13789400
3/1/17 46.950001 47.169998 46.610001 46.810001 14373700
3/2/17 47.080002 47.09 46.040001 46.279999 8477000
3/3/17 46.27 47.060001 46.220001 46.830002 11404300
3/6/17 46.529999 46.639999 45.98 46.57 9332600
3/7/17 46.650002 46.790001 46.209999 46.330002 9411000
3/8/17 46.970001 47.330002 46.34 46.389999 11464700
3/9/17 46.599998 47.119999 46.540001 46.68 11135400
3/10/17 47.040001 47.09 46.209999 46.490002 8579400
3/13/17 46.68 46.75 46.23 46.259998 7160400
3/14/17 46.259998 46.259998 45.73 46.189999 6916200
3/15/17 46.259998 46.630001 45.68 45.849998 10796100
3/16/17 46.169998 46.59 46.02 46.330002 9284100
3/17/17 46.259998 46.360001 44.93 45.02 13474500
3/20/17 44.740002 44.959999 44.330002 44.59 9734200
3/21/17 44.77 44.93 42.419998 42.66 20018400
3/22/17 42.16 42.75 41.639999 42.209999 19046600
3/23/17 41.98 42.98 41.779999 42.59 14888800
3/24/17 42.779999 43 42.150002 42.459999 10815300
3/27/17 40.66 41.720001 40.060001 41.580002 21631100
3/28/17 41.580002 42.77 41.57 42.490002 12944900
3/29/17 43.09 43.25 42.540001 42.799999 14543900
3/30/17 42.849998 43.709999 42.799999 43.43 11264300
3/31/17 43.25 43.25 42.669998 42.84 11203300
4/3/17 42.810001 42.990002 42.080002 42.709999 12531800
4/4/17 42.540001 42.84 42.349998 42.509998 7837100
4/5/17 43.009998 43.099998 41.610001 41.740002 12455100
4/6/17 41.630001 42.369999 41.43 42.09 9520900
4/7/17 41.619999 42.25 41.419998 41.950001 9319600
4/10/17 41.900002 42.150002 41.389999 41.91 8677200
4/11/17 41.560001 41.779999 40.990002 41.580002 10318400
4/12/17 41.5 41.52 41.009998 41.07 10440600
4/13/17 40.830002 41.68 40.5 40.689999 10516500
4/17/17 40.779999 41.549999 40.580002 41.490002 7959700
4/18/17 40.990002 41.549999 40.75 41.209999 13872400
4/19/17 42.310001 42.939999 41.959999 42.040001 19850300
4/20/17 42.610001 42.759998 42.099998 42.5 13816200
4/21/17 42.209999 42.610001 41.709999 41.799999 12951300
4/24/17 43.389999 43.73 43.189999 43.560001 16188100
4/25/17 43.98 44.450001 43.919998 44.27 13857600
4/26/17 44.169998 44.860001 44.139999 44.369999 12938400
4/27/17 44.16 44.209999 43.389999 43.540001 9041300
4/28/17 43.599998 43.810001 43.34 43.369999 9049100
5/1/17 43.759998 44.060001 43.490002 43.740002 7552200
5/2/17 43.669998 43.779999 43 43.349998 8126400
5/3/17 43.150002 43.77 43.119999 43.48 5578300
5/4/17 43.849998 43.970001 43.220001 43.279999 7367800
5/5/17 43.360001 43.560001 42.869999 43.080002 6893400
5/8/17 43.150002 43.310001 42.93 43.02 7171700
5/9/17 43.049999 43.34 42.669998 42.830002 6068700
5/10/17 42.799999 43.200001 42.669998 43.099998 7367800
5/11/17 42.98 43.200001 42.439999 42.869999 6340000
5/12/17 42.610001 42.759998 42.360001 42.73 5836300
5/15/17 42.82 43.619999 42.799999 43.43 9941100
5/16/17 43.540001 43.639999 43.290001 43.380001 6888900
5/17/17 43.380001 43.380001 40.43 40.970001 22899900
5/18/17 41 41.880001 40.919998 41.310001 14498400
5/19/17 41.59 42.220001 41.360001 41.799999 10486700
5/22/17 42.049999 42.169998 41.5 41.66 6752600
5/23/17 41.509998 42.650002 41.330002 42.419998 10761300
5/24/17 42.360001 42.740002 42.299999 42.630001 6583400
5/25/17 42.830002 42.970001 42.490002 42.630001 5062800
5/26/17 42.450001 42.970001 42.439999 42.84 5229300
5/30/17 42.580002 42.720001 42.049999 42.279999 6377900
5/31/17 42.189999 42.189999 41.07 41.740002 13637900
6/1/17 41.98 42.73 41.75 42.610001 9654300
6/2/17 42.150002 42.939999 41.900002 42.52 10016400
6/5/17 42.549999 43.400002 42.450001 42.889999 6892800
6/6/17 42.450001 43.07 42.209999 42.939999 7863200
6/7/17 43.139999 43.450001 42.919998 43.279999 6378500
6/8/17 43.279999 44.720001 43.150002 44.099998 11032500
6/9/17 44.360001 45.349998 44.360001 44.91 13489900
6/12/17 44.91 45.5 44.380001 44.849998 10384200
6/13/17 45.07 45.98 45.049999 45.150002 9857800
6/14/17 44.57 45.119999 44.220001 44.91 11796300
6/15/17 44.48 45.080002 44.419998 44.689999 6904900
6/16/17 44.77 44.84 44.240002 44.48 9483200
6/19/17 44.880001 45.91 44.830002 45.720001 9153900
6/20/17 45.48 45.720001 45.279999 45.5 6680500
6/21/17 45.450001 45.529999 44.810001 44.91 7257600
6/22/17 44.700001 44.869999 44.380001 44.610001 7750500
6/23/17 44.700001 44.73 43.509998 43.689999 15915100
6/26/17 43.959999 44.330002 43.48 44 5780400
6/27/17 44.34 44.759998 44.16 44.220001 8318800
6/28/17 44.459999 44.799999 44.200001 44.32 15848600
6/29/17 45.439999 45.610001 44.27 44.75 15728200
6/30/17 45.330002 45.43 44.439999 44.560001 8300800
7/3/17 45 46.02 44.98 45.610001 7486400
7/5/17 45.889999 46.25 45.540001 46.16 9843200
7/6/17 46.099998 46.639999 45.77 46.130001 10417300
7/7/17 46.32 46.400002 45.959999 46.049999 6442000
7/10/17 45.950001 46.240002 45.799999 45.990002 5321500
7/11/17 45.830002 45.93 45.380001 45.48 8454700
7/12/17 45.330002 45.330002 44.73 44.959999 10234400
7/13/17 45.169998 45.73 44.990002 45.52 6204200
7/14/17 44.880001 45.400002 44.32 45.200001 8220600
7/17/17 45.150002 45.529999 44.93 45.330002 5141600
7/18/17 44.93 45.25 44.689999 45.139999 9594100
7/19/17 46.950001 47 45.98 46.619999 17586300
7/20/17 46.349998 47.189999 46.349998 46.509998 10652400
7/21/17 46.119999 46.790001 46.099998 46.59 9021300
7/24/17 46.5 46.970001 46.459999 46.709999 7443600
7/25/17 47.23 48.040001 47.23 47.610001 11885000
7/26/17 47.720001 47.849998 47.119999 47.209999 9034500
7/27/17 47.139999 47.599998 46.630001 47.09 9439300
7/28/17 46.98 47.200001 46.459999 46.66 7959600
7/31/17 46.939999 47.150002 46.599998 46.900002 6764600
8/1/17 47.25 47.529999 47.060001 47.209999 6330000
8/2/17 47.139999 47.459999 46.830002 47.330002 6020000
8/3/17 47.240002 47.549999 47.110001 47.259998 6479300
8/4/17 47.790001 48.450001 47.52 48.080002 8906800
8/7/17 48.200001 48.400002 47.950001 48.310001 7761600
8/8/17 48.240002 48.900002 47.810001 47.93 7771800
8/9/17 47.220001 47.689999 46.939999 47.650002 8282900
8/10/17 47.290001 47.470001 46.23 46.299999 10099800
8/11/17 46.380001 46.529999 45.470001 45.650002 13505800
8/14/17 46.209999 46.939999 46.18 46.509998 7032900
8/15/17 47.009998 47.299999 46.43 46.43 7663000
8/16/17 46.610001 46.82 45.919998 46.009998 8350800
8/17/17 45.830002 45.98 45.029999 45.09 9426800
8/18/17 44.939999 45.82 44.869999 45.389999 7284000
8/21/17 45.400002 45.400002 44.529999 44.68 8501900
8/22/17 45 45.709999 44.93 45.57 7130700
8/23/17 45.200001 45.950001 45.110001 45.799999 5464800
8/24/17 45.970001 46.18 45.73 46 6640700
8/25/17 46.169998 46.419998 45.73 45.939999 5656400

PNC Stock

Date Open High Low Close Volume
1/3/17 118.779999 119.470001 116.970001 117.970001 2989100
1/4/17 118.32 119.269997 117.760002 118.970001 2279700
1/5/17 118.410004 119.029999 116.599998 117.379997 2405000
1/6/17 118.209999 119.739998 117.849998 119.050003 3003900
1/9/17 118.309998 118.5 117.07 118.199997 3294300
1/10/17 118.010002 118.849998 117.529999 118.669998 2914400
1/11/17 117.93 121.330002 117.519997 121.330002 4408600
1/12/17 120.129997 120.300003 116.730003 117.93 3970800
1/13/17 118.959999 121.25 117.18 118.790001 4034700
1/17/17 117.940002 117.989998 113.699997 113.93 4301500
1/18/17 114.690002 116.389999 113.660004 116.32 3086200
1/19/17 116.669998 117.300003 115.040001 115.610001 2589900
1/20/17 116.290001 117.589996 115.989998 117.349998 2876800
1/23/17 116.809998 117.860001 116.5 116.93 2485800
1/24/17 117.5 119.440002 116.919998 118.660004 2566000
1/25/17 120 121.190002 119.529999 121.010002 2572900
1/26/17 121.169998 121.980003 120.739998 121.629997 1947000
1/27/17 121.339996 121.900002 120.889999 121.639999 1609000
1/30/17 120.970001 121.110001 119.639999 120.379997 1995400
1/31/17 120.160004 121.019997 119.589996 120.459999 2620200
2/1/17 121.660004 122.580002 121.019997 121.139999 2673200
2/2/17 120.199997 120.760002 119 120.010002 2090800
2/3/17 122.18 122.419998 121.059998 122.160004 1955200
2/6/17 121.610001 122.82 121.339996 122.410004 1563900
2/7/17 122.809998 123.25 121.279999 121.470001 2680900
2/8/17 122.199997 122.199997 120.5 121.459999 2892400
2/9/17 121.459999 122.93 121.279999 122.389999 2076700
2/10/17 123.300003 123.540001 122.68 123.099998 2099000
2/13/17 124 125.349998 123.620003 124.419998 1929500
2/14/17 124.540001 126.230003 123.769997 126.099998 2420200
2/15/17 126.279999 127.919998 125.370003 127.760002 2589500
2/16/17 127.300003 127.660004 126 126.959999 1930800
2/17/17 125.730003 126.889999 125.449997 126.860001 1734000
2/21/17 127.43 127.839996 126.769997 127.550003 1748600
2/22/17 126.779999 128.520004 126.690002 127.760002 1541700
2/23/17 127.839996 128.229996 126.839996 128.139999 1221200
2/24/17 126.919998 127.419998 126.139999 126.879997 2586300
2/27/17 127.190002 128.490005 126.800003 128.130005 1895300
2/28/17 127.360001 127.980003 126.660004 127.230003 2343300
3/1/17 130.479996 131.830002 129.860001 130.850006 3367200
3/2/17 130.979996 131.009995 127.389999 127.510002 2092400
3/3/17 127.410004 128.25 126.980003 127.830002 2493200
3/6/17 126.760002 127.93 126.089996 127.589996 2289900
3/7/17 127.400002 128.050003 126.400002 127.400002 1764800
3/8/17 128.919998 129.339996 127.459999 127.550003 2258500
3/9/17 128.039993 129.289993 127.239998 127.480003 3435700
3/10/17 128.25 128.490005 125.440002 126.459999 3731100
3/13/17 126.650002 126.879997 125.709999 126.400002 1815100
3/14/17 125.900002 126.419998 124.690002 126.220001 1660600
3/15/17 126.739998 126.739998 124.620003 125.230003 2106600
3/16/17 125.769997 126.279999 124.900002 125.720001 2413600
3/17/17 125.919998 126.209999 124.349998 124.349998 5739000
3/20/17 124.160004 125.309998 123.739998 123.790001 2576000
3/21/17 124.129997 124.339996 118.589996 118.699997 6317000
3/22/17 117.900002 119.300003 116.489998 118.650002 4424000
3/23/17 118.669998 121.260002 118.150002 119.279999 4002600
3/24/17 119.900002 120.580002 118.589996 119.400002 2425900
3/27/17 116.5 118.440002 115.25 118.199997 3440300
3/28/17 118.059998 120.809998 117.720001 120.269997 2657600
3/29/17 120.07 120.639999 119.290001 119.339996 1758600
3/30/17 119.220001 122 119.220001 121.529999 2091300
3/31/17 120.970001 121.25 120.160004 120.239998 2189200
4/3/17 120.650002 121 118.339996 119.839996 2124200
4/4/17 119.330002 119.989998 118.68 119.150002 1871700
4/5/17 120.779999 121.019997 118.139999 118.290001 1872800
4/6/17 118.25 119.790001 117.480003 119.260002 2071700
4/7/17 118.519997 119.839996 118 119.169998 1921000
4/10/17 119.080002 119.639999 117.889999 118.370003 2084300
4/11/17 117.440002 118.07 116.07 118.029999 3339500
4/12/17 116.989998 117.699997 115.870003 116 3039100
4/13/17 118 120.650002 115.599998 115.800003 5112400
4/17/17 115.980003 118.529999 115.449997 118.410004 3241200
4/18/17 117.410004 118.43 115.769997 116.410004 2915200
4/19/17 117.459999 118.370003 115.970001 116.480003 2275100
4/20/17 117.309998 119.190002 116.699997 118.830002 2053600
4/21/17 118.550003 119.470001 117.830002 118.169998 1960600
4/24/17 121 121.800003 120.169998 120.860001 2727700
4/25/17 122.059998 122.730003 121.07 121.110001 2955600
4/26/17 121.290001 122.989998 121.099998 122 2052200
4/27/17 122.169998 122.459999 120.139999 121.019997 1556000
4/28/17 120.690002 121.57 119.739998 119.75 1865200
5/1/17 120.690002 121.860001 119.860001 121.150002 1857400
5/2/17 121.489998 121.769997 119.830002 120.660004 1597300
5/3/17 120.059998 122.589996 119.769997 122.440002 1675500
5/4/17 123.690002 124.440002 122.760002 123.449997 2076300
5/5/17 123.760002 123.860001 122.370003 123.120003 1697000
5/8/17 123.190002 124.059998 123.080002 123.68 4159000
5/9/17 123.639999 124.129997 121.510002 121.959999 2222000
5/10/17 121.830002 122.769997 121.400002 122.449997 1594300
5/11/17 122.019997 122.139999 120.279999 121.739998 1570000
5/12/17 120.550003 121.18 119.559998 120.809998 1547400
5/15/17 120.779999 122.639999 120.779999 122.139999 1401700
5/16/17 122.309998 122.739998 121.620003 122.620003 1167500
5/17/17 122.620003 122.620003 116.959999 117.190002 2657400
5/18/17 117.269997 118.190002 115.660004 117.360001 3153300
5/19/17 117.510002 119.919998 117.5 118.760002 2229800
5/22/17 119.220001 119.739998 118.260002 119.449997 1571600
5/23/17 119.449997 121.699997 119.110001 121.150002 1476100
5/24/17 121.849998 121.900002 120.57 120.959999 1787400
5/25/17 120.959999 121.989998 120.779999 121.449997 1311100
5/26/17 120.959999 122 120.639999 121.32 1173300
5/30/17 120.5 120.639999 118.260002 118.860001 2779200
5/31/17 118.879997 119.25 116.629997 118.699997 2749600
6/1/17 119.349998 120.129997 117.360001 120.129997 1679800
6/2/17 118.93 119.879997 117.730003 119.160004 2253600
6/5/17 119.459999 120.209999 118.489998 118.580002 1695500
6/6/17 117.589996 118.68 117.059998 118.150002 1764100
6/7/17 118.599998 120.199997 118.239998 119.900002 1434600
6/8/17 119.900002 122.290001 119.410004 121.010002 3139800
6/9/17 121.790001 123.769997 121.790001 123.169998 2105400
6/12/17 123.18 124.099998 121.860001 122.839996 2944500
6/13/17 123.389999 124.239998 122.75 123.809998 2242200
6/14/17 122.790001 124.099998 121.550003 123.970001 1952600
6/15/17 123.279999 124.57 122.639999 122.970001 1723300
6/16/17 122.860001 123.099998 121.900002 122.510002 2255000
6/19/17 123.550003 124.580002 123.080002 123.790001 1868200
6/20/17 123.669998 123.93 122.949997 122.989998 1851300
6/21/17 123.5 123.5 121.769997 122.330002 1793500
6/22/17 121.860001 122.169998 120.339996 120.760002 1872100
6/23/17 121.510002 121.510002 118.889999 119.550003 2689500
6/26/17 119.989998 120.970001 119.410004 120.379997 2315900
6/27/17 121.32 122.889999 120.919998 121.120003 1871200
6/28/17 122.190002 123.760002 122.029999 123.400002 2580900
6/29/17 126.629997 128.25 124.190002 125.25 2668100
6/30/17 126 126.059998 124.400002 124.870003 1652200
7/3/17 125.650002 126.540001 125.239998 126 1589900
7/5/17 125.980003 126.519997 124.839996 126.080002 2496000
7/6/17 126.150002 127.830002 125.800003 126.010002 1763100
7/7/17 126.959999 126.959999 125.059998 126.540001 1842000
7/10/17 126.160004 127.690002 125.949997 127.199997 2178700
7/11/17 127.349998 127.800003 126.339996 127.389999 2663300
7/12/17 126.980003 127.589996 126.480003 127.220001 1975500
7/13/17 126.93 127.980003 125.919998 127.32 3160100
7/14/17 125.900002 127.550003 124.940002 127.169998 2437200
7/17/17 127.040001 128.25 126.769997 127.360001 2321400
7/18/17 126.290001 127.190002 125.099998 125.57 2891200
7/19/17 126.07 126.809998 125.419998 126.400002 1966100
7/20/17 126.389999 127.620003 126.220001 126.949997 2158400
7/21/17 126.410004 127.370003 125.879997 126.239998 1445300
7/24/17 126.239998 127.43 126.139999 127.139999 1495400
7/25/17 129.389999 130 128.869995 129.330002 2977400
7/26/17 129.169998 129.550003 126.790001 127.360001 2554700
7/27/17 127.279999 128.199997 126.730003 127.669998 2478700
7/28/17 127.57 128.020004 126.779999 127.650002 1568000
7/31/17 127.910004 129.279999 127.459999 128.800003 2013200
8/1/17 129.589996 130.410004 129.149994 130.410004 2392700
8/2/17 130.630005 130.929993 129.800003 130.679993 2055900
8/3/17 130.5 130.990005 129.889999 130.509995 2312200
8/4/17 131.309998 132.669998 130.910004 132.169998 2399600
8/7/17 131.940002 132.199997 130.509995 131.110001 2516900
8/8/17 130.600006 133.259995 130.600006 132.360001 2802900
8/9/17 131.660004 132.190002 130.910004 131.729996 2246800
8/10/17 130.399994 131.229996 128.600006 128.990005 2652000
8/11/17 128.720001 129.779999 127.639999 128.050003 2931700
8/14/17 129.419998 131.419998 128.960007 130.899994 2246900
8/15/17 131.770004 132.289993 130.190002 130.339996 2615700
8/16/17 130.919998 131.139999 129.259995 130.100006 3122900
8/17/17 129.580002 129.839996 127.18 127.300003 2770600
8/18/17 126.650002 128.119995 126.150002 127.110001 1511700
8/21/17 127.339996 127.339996 126.419998 126.599998 1376100
8/22/17 126.889999 127.839996 126.889999 127.510002 1216500
8/23/17 126.599998 128.029999 126.449997 127.529999 1082500
8/24/17 127.809998 128.029999 127.110001 127.669998 889500
8/25/17 128.179993 128.449997 127.629997 127.879997 990900

Sales

Saleperson Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8
Alex 602 319 475 658 547 697 218 477
John 530 218 278 350 267 395 442 797
Joe 513 711 435 135 751 92 745 364
Mary 554 219 344 323 265 532 292 414
Sarah 652 459 686 163 652 318 281 129
Jim 293 560 356 288 270 480 672 70

Tree Map

Item Category Sales Rep Sales Amount
Hardware James Jones 10000
Hardware Nathan Adams 7000
Cables John Snoke 5000
Cables Bob Kay 3000
Software Cat Simons 2000
Software James Thorn 1000
Network Bob Kay 4000
Network Your Name 3000
Cables Your Name 1500
Hardware Your Name 1400