search for: storename

...tems...(sample output for butter is: (dataset2) CustID TripDate Store Butter 1 6-Jan-12 c 3 1 9-Jan-12 a 3 2 31-Aug-12 a 3 2 24-Sep-12 a 3 2. In same loop, create new derived variables within each dataframe for each item... like create a lag variable for TripDate, create lag variable for storename in next trip, storename in previous trip etc... and also # days between trips to each store for each customer...(an example for Butter dataframe with new derived variables would be...) Dataset needs to be sorted by CustID, TripDate, Store before creating derived variables (dataset3)Book1.xlsx Cu...

...basic predictive model. I've a number of stores in a region, for each store I know the Tot Revenue in a given year & the Tot Active Customers for that year. I want to use the Tot Active Customers as my independent variable x and Tot Revenue as my dependent variable y. So for example: StoreName | Tot Revenue | Tot Active Customers Store A | 200,000 | 120 Store B | 230,000 | 129 Store C | 220,000 | 119 The sample data has about 65 stores in total. I don't know the average transaction value or if a customer has transacted more then once. > LineBestFit = lm(TotRevenues ~ TotActiveCu...