Data Analysis - Product User Trend Calculation

Project Description

Keurig has a data set of coffee brewing activity of a consumer research panel.  We need help analyzing these individual brew histories of ~1,000 Keurig users over an ~6 month period to determine the average “calibration period” (# of days of brewing data) needed to accurately predict long-term brewing frequency (avg. # of pods brewed per day over the entire 6-month period) with high-levels of confidence (90%+).

In total, there are 250,000-300,000 data points across these 1,000 users and the data is housed in an Excel file.

We need the results in 1 week from the start of the project.