Lab 3.1:Make a Plot

Gabriela Chajon

Looking at the dataset

   Channel Region Fresh  Milk Grocery Frozen Detergents_Paper Delicassen
1        2      3 12669  9656    7561    214             2674       1338
2        2      3  7057  9810    9568   1762             3293       1776
3        2      3  6353  8808    7684   2405             3516       7844
4        1      3 13265  1196    4221   6404              507       1788
5        2      3 22615  5410    7198   3915             1777       5185
6        2      3  9413  8259    5126    666             1795       1451
7        2      3 12126  3199    6975    480             3140        545
8        2      3  7579  4956    9426   1669             3321       2566
9        1      3  5963  3648    6192    425             1716        750
10       2      3  6006 11093   18881   1159             7425       2098
11       2      3  3366  5403   12974   4400             5977       1744
12       2      3 13146  1124    4523   1420              549        497
13       2      3 31714 12319   11757    287             3881       2931
14       2      3 21217  6208   14982   3095             6707        602

First 10 customers

   Channel Region Fresh  Milk Grocery Frozen Detergents_Paper Delicassen
1        2      3 12669  9656    7561    214             2674       1338
2        2      3  7057  9810    9568   1762             3293       1776
3        2      3  6353  8808    7684   2405             3516       7844
4        1      3 13265  1196    4221   6404              507       1788
5        2      3 22615  5410    7198   3915             1777       5185
6        2      3  9413  8259    5126    666             1795       1451
7        2      3 12126  3199    6975    480             3140        545
8        2      3  7579  4956    9426   1669             3321       2566
9        1      3  5963  3648    6192    425             1716        750
10       2      3  6006 11093   18881   1159             7425       2098

Last 10 customers

    Channel Region Fresh  Milk Grocery Frozen Detergents_Paper Delicassen
431       1      3  3097  4230   16483    575              241       2080
432       1      3  8533  5506    5160  13486             1377       1498
433       1      3 21117  1162    4754    269             1328        395
434       1      3  1982  3218    1493   1541              356       1449
435       1      3 16731  3922    7994    688             2371        838
436       1      3 29703 12051   16027  13135              182       2204
437       1      3 39228  1431     764   4510               93       2346
438       2      3 14531 15488   30243    437            14841       1867
439       1      3 10290  1981    2232   1038              168       2125
440       1      3  2787  1698    2510     65              477         52

Summary statistics

Fresh statistics

   Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
      3    3128    8504   12000   16934  112151

Grocery statistics

   Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
      3    2153    4756    7951   10656   92780

Create a table for categorical variable


  1   2   3 
 77  47 316

Create chart

Interpretation

Region 1, Lisbon, between the 3, even if it is very subtle, show a negative relation between grocery and fresh products. Region 2, Oporto, includes customers that spend more on fresh products than in grocery since the observations are more clustered to the right. These 2 observations might be because these cities are near the ocean which allow people to have more fresh products. Region 3 , has far more observations than the others and also they are more spread out which makes it harder to see a relationship. Besides that it has the highest amount of outliers, which can help us infer that the region include multiple cities and that is why the costumers’ responses have more variety.

Improvements

Thanks to the feedback I received I scaled the y-axis too instead of just the x-axis and added the dollar sign in both. I also changed the subtitle so it can represent the primary insight of my chart. Finally, I changed some pieces of my interpretation to explain better the content and give more understandable insights.

End