online sum

online sum - Data Definitions Fields cust baby pet stock1st...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Definitions Fields Definition cust Customer number (unique identifier for each customer) baby Inferred demographics of whether a baby is in the household (1 = yes, 0 = no) pet Inferred demographics of whether a pet is in the household (1 = yes, 0 = no) stock1st binary variable that indicates if a customer experienced an imperfect order on their 1st purchase (1 =yes, 0=No) days1st number of days that it took for the customers 1st order to be delivered amount1st the amount in dollars of the customers 1st order week1st the week (in company time) of the customers 1st order Weeks the number of weeks the customer is in the data at the time of the data pull cspend the customers cumulative spending Rank customer cumulative spending rank (1 = highest) Quintile Cumulative spending Quintiles (1 = highest)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Average of cspend Quintile Total 1 $1,152.14 2 $514.16 3 $303.78 4 $195.50 5 $93.44 (blank) Grand Total $446.09
Background image of page 2
data Page 3 cust baby pet stock1st days1st amount1st week1st Weeks cspend Rank Quintile 9601 1 0 0 5 58.63 15 58 2192.43 1 1 11415 0 1 1 5 26 18 56 2034.12 2 1 11331 1 1 0 5 75.88 18 55 1984.8 3 1 11784 1 0 0 4 187.73 19 54 1924.41 4 1 10636 0 1 0 6 101.09 17 58 1535.5 5 1 2760 0 1 0 6 77.62 14 59 1429.08 6 1 10835 0 1 1 4 83.73 17 57 1335.01 7 1 10940 0 1 0 3 105.39 17 57 1329.61 8 1 9372 1 1 0 6 95.32 14 60 1311.39 9 1 9446 1 0 0 6 25.83 15 58 1289.41 10 1 10756 1 0 0 5 138.22 17 56 1274.8 11 1 12930 0 1 0 4 121.66 20 53 1239.14 12 1 10721 1 0 0 6 78.56 17 56 1136.9 13 1 11548 1 1 1 4 100.98 18 55 1119.35 14 1 5672 0 0 0 6 84.45 18 56 1102.45 15 1 12075 0 1 1 6 109.97 19 55 1095.12 16 1 11866 0 1 1 6 168.15 19 54 1089.51 17 1 12590 0 1 0 5 99.27 20 54 1057.42 18 1 12020 0 1 0 6 133.26 19 56 1055.41 19 1 9354 1 0 1 4 88.67 14 59 1040.05 20 1 10890 0 0 0 4 119.81 17 56 1021.66
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/21/2011 for the course BUS 443 taught by Professor Michaellewis during the Spring '11 term at Emory.

Page1 / 3

online sum - Data Definitions Fields cust baby pet stock1st...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online