Orange Juice Sales

Anthony Tranchina

2025-09-14

Introduction

Basic summary statistics

## OJ 
## 
##  6  Variables      1070  Observations
## --------------------------------------------------------------------------------
## Purchase 
##        n  missing distinct 
##     1070        0        2 
##                     
## Value        CH   MM
## Frequency   653  417
## Proportion 0.61 0.39
## --------------------------------------------------------------------------------
## WeekofPurchase 
##        n  missing distinct     Info     Mean  pMedian      Gmd      .05 
##     1070        0       52        1    254.4    254.5    17.88      229 
##      .10      .25      .50      .75      .90      .95 
##      232      240      257      268      274      276 
## 
## lowest : 227 228 229 230 231, highest: 274 275 276 277 278
## --------------------------------------------------------------------------------
## StoreID 
##        n  missing distinct     Info     Mean  pMedian      Gmd 
##     1070        0        5    0.943     3.96        4     2.54 
##                                         
## Value          1     2     3     4     7
## Frequency    157   222   196   139   356
## Proportion 0.147 0.207 0.183 0.130 0.333
## 
## For the frequency table, variable is rounded to the nearest 0
## --------------------------------------------------------------------------------
## PriceCH 
##        n  missing distinct     Info     Mean  pMedian      Gmd      .05 
##     1070        0       10     0.94    1.867     1.86   0.1132     1.69 
##      .10      .25      .50      .75      .90      .95 
##     1.75     1.79     1.86     1.99     1.99     1.99 
##                                                                       
## Value       1.69  1.75  1.76  1.79  1.86  1.89  1.96  1.99  2.06  2.09
## Frequency     94    95    40   101   376    42    29   259     7    27
## Proportion 0.088 0.089 0.037 0.094 0.351 0.039 0.027 0.242 0.007 0.025
## 
## For the frequency table, variable is rounded to the nearest 0
## --------------------------------------------------------------------------------
## PriceMM 
##        n  missing distinct     Info     Mean  pMedian      Gmd 
##     1070        0        8    0.965    2.085     2.11   0.1356 
##                                                           
## Value       1.69  1.79  1.99  2.09  2.13  2.18  2.23  2.29
## Frequency     57    35   179   273   197   201    88    40
## Proportion 0.053 0.033 0.167 0.255 0.184 0.188 0.082 0.037
## 
## For the frequency table, variable is rounded to the nearest 0
## --------------------------------------------------------------------------------
## DiscCH 
##        n  missing distinct     Info     Mean  pMedian      Gmd      .05 
##     1070        0       12    0.519  0.05186        0  0.08845     0.00 
##      .10      .25      .50      .75      .90      .95 
##     0.00     0.00     0.00     0.00     0.24     0.37 
##                                                                             
## Value       0.00  0.10  0.13  0.16  0.17  0.20  0.24  0.27  0.30  0.37  0.47
## Frequency    838    74    21     5     2    21     5    29     6    36    21
## Proportion 0.783 0.069 0.020 0.005 0.002 0.020 0.005 0.027 0.006 0.034 0.020
##                 
## Value       0.50
## Frequency     12
## Proportion 0.011
## 
## For the frequency table, variable is rounded to the nearest 0
## --------------------------------------------------------------------------------

Sales and Market Share

CH captures a dominant 61% of the market, outpacing MM.

##   Brand Sales SharePercent
## 1    CH   653           61
## 2    MM   417           39

Pricing Summary Statistics

Citrus Hall competes primarily on lower average pricing relative to Minute Maid.

##   Variable Mean Median  Min  Max
## 1  PriceCH 1.87   1.86 1.69 2.09
## 2  PriceMM 2.00   2.09 1.69 2.29

Trended Sales by Brand

Both brands had ~50% market share until week 20. After week 20, Citrus Hall pulled ahead of Minute Maid.

Further Research