Excel Edit View Insert Format Tools Data Window Help Q Sun Apr 9 9:29 AM AutoSave OFF N AQC ? V ... Book5 Q Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Share Calibri (Body) 12 AA ab Wrap Text v Custom Insert v ne X Delete Paste BIUV A Merge & Center v ~ % " Conditional Format Cell Sort & Find & Analyze Tasks Formatting as Table Styles Format v Filter Select Data C172 X V fx 10:51:04 AM A C D G H M N Q MyEducator Tasks X Transaction Date Transation Time order_id product_id category_code brand price Quantity user_id Customer Age Customer Ratings Revenue Cost Profit W N 1/5/20 3:40:44 5502 47622 Skateboard WiiSham 41.99 9E+06 73 3 $41.99 $33.00 $8.99 11 The operation manager W .15/20 :44:58 2710 22830 Bungee Band Trainer Movemint :49.99 9E+0 27 $49.99 $59.00 -$9.01 1/5/20 4:46:13 9652 47622 Skateboard WiiSham $41.99 2E+06 $41.99 $33.00 $8.99 asks you to see if they can 1/5/20 5:22:47 179 15622 Climbing Carabiners Favofit 19.99 1 E+06 80 $19.99 $23.00 -$3.01 1/5/20 5:24:22 3684 15611 neoprene diving suit dive & sail $52.99 9E+06 73 $52.99 $39.45 $13.54 focus on customers rating on 1/5/20 5:26:40 8980 47622 Skateboard WiiSham $41.99 2E+06 77 $41.99 $33.00 $8.99 1/5/20 5:30:43 596 47622 Skateboard WiiSham $41.99 5E+06 74 WUT W W W W UT - W $41.99 $33.00 $8.99 certain product categories 1/5/20 :30:4 596 47622 Skateboard WiiSham $41.99 4E+06 54 $41.99 $33.00 $8.99 1/3/20 5:30:43 596 47622 Skateboard WiiShan $41.99 7E+06 79 $41.99 $8.99 from those top four brands to 1/5/20 5:35:13 164 35622 apparel.glove Hestra $154.95 530506 50 $154.95 $123.00 $31.95 1/5/20 5:38:23 2283 47622 Skateboard WiiSham $41.99 3E+06 70 $41.99 $33.00 $8.99 better assess profitability. You 1/7/20 4:55:42 2696 47622 skateboard WiiSham $41.99 8E+06 58 $41.99 $33.00 $8.99 1/7/20 4:55:42 2696 47622 skateboard WiiSham 41.99 933716 71 $41.99 $8.99 decided to develop a model 1/7/20 4:55:42 2696 47622 Skateboard WiiSham $41.99 8E+06 56 w w w w w w w $41.99 $33.00 $8.99 based on customer age and 1/7/20 4:56:01 6181 47622 Skateboard WiiSham $41.99 9E +06 74 $41.99 $33.00 $8.99 1//720 :56:01 6181 47622 Skateboard WiiSham $41.99 5E+06 57 $41.99 $8.99 customer rating for 1/7/20 5:11:36 869 47622 Skateboard WiiSham $41.99 6E+06 68 $41.99 $33.00 $8.99 1/7/20 5:12:49 8437 47622 skateboard WiiSham $41.99 6E+06 44 $41.99 $33.00 $8.99 profitability by choosing only 1/7/20 5:12:49 8437 47622 Skateboard WiiSham $41.99 5E+06 65 $41.99 $33.00 $8.99 ./7/20 5:12:49 8437 47622 skateboard WiiSham 41.99 4E+0 21 $41.99 $33.00 $8.99 the top two product 1/8/20 4:23:02 9254 22831 Bungee Resistance Band Dasking $121.09 2E+06 44 121.09 $112.00 $9.09 1/8/20 5:07:13 9874 22831 Bungee Resistance Band Dasking $121.09 8E+06 68 $121.09 $112.00 $9.09 categories from those top 1/8/20 5:10:26 1075 22831 Bungee Resistance Band Daskin $121.09 7E+06 40 $121.09 $112.00 $9.09 1/8/20 5:15:01 1336 22831 Bungee Resistance Band Dasking $121.09 7E+0 32 $121.09 $112.00 $9.09 four brands that the company 1/8/20 5:21:50 2861 22831 istance Band Dasking $121.09 6E+06 59 $121.09 $112.00 $9.09 sold to their customers. After 1/8/20 5:30:23 9316 22831 Bungee Resistance Band Dasking $121.09 5E+06 23 $121.09 $112.00 $9.09 1/8/20 9:04:47 3096 22831 Bungee Resistance Band Dasking $121.09 7E+06 50 . A U U D UT W W W W W W W W W $121.09 $112.00 $9.09 removing all the insignificant 1/8/20 1:53:56 7326 22831 Bungee Resistance Band Dasking $121.09 3E+06 26 121.09 $112.00 $9.09 1/9/20 14:12:22 6986 35622 apparel.glove Hestra $154.95 4E+06 44 $154.95 $123.00 $31.95 variables in the model, which 1/12/2 6:37:49 3462 15699 Mountain Bike Schwinn $439.00 2E+06 49 $439.00 $428.00 $11.00 1/12/20 6:40:42 1176 15611 neoprene diving suit dive & sail $52.99 8E+06 58 $52.99 $39.45 $13.54 of the following statements is 1/12/20 6:59:10 8287 35622 apparel.glove Hestra $154.95 8E+06 51 $154.95 $123.00 $31.95 ./12/20 7:00:14 3926 15699 Mountain Bike Schwinn $439.00 4E+06 45 $439.00 $428.00 $11.00 false about the results 1/12/20 :13:20 2904 15699 Mountain Bike Schwinn $439.00 9E+06 52 $439.00 $428.00 $11.00 1/12/20 7:14:13 92 22831 Bungee Resistance Band Dasking $121.09 2E+06 68 $121.09 $112.00 $9.09 obtained from your analysis. 1/12/20 7:14:13 92 22831 Bungee Resistance Band Dasking $121.09 9E+06 80 $121.09 $112.00 $ ./12/2 :16:20 3798 15699 Mountain Bike Schwinn $439.00 9E+06 40 $439.00 $428.00 $11.00 1/12/20 7:22:41 5275 35622 apparel.glove Hestra $154.95 47274 21 $154.95 $123.00 $31.95 O The prediction equation 1/12/20 8:41:04 3789 22831 Bungee Resistance Band Dasking $121.09 3E+06 39 W W W W UT A W $121.09 $112.00 $9.09 1/12/20 8:42:26 8057 22831 Bungee Resistance Band Dasking $121.09 4E+06 35 $121.09 $112.00 $9.09 for the top two product /12/2 8:56:51 459 22831 Bungee Resistance Band Dasking $121.09 9E+06 25 $121.09 $112.00 $9.09 1/12/20 9:00:26 4823 22831 Bungee Resistance Band Dasking $121.09 8E+06 50 $121.09 $112.00 $9.09 category is: Profit = -29.22 + 1/12/20 9:01:39 8209 15611 neoprene diving suit dive & sail $52.99 9E+06 18 $52.99 19 $39.45 $13.54 11.76 * customer ratings /12/2 9:04:43 4593 22831 Bungee Resistance Band Dasking $121.09 6E+06 62 $121.09 $112.00 $9.09 1/12/20 9:08:34 7140 22831 ungee Resistance Band Dasking $121.09 266987 33 121.09 $112.00 $9.09 The coefficient of Transactions Data Dictionary + determination for the Ready Accessibility: Good to go 75% 11,213 X W 490 APR C 9 4 zoomExcel Edit View Insert Format Tools Data Window Help Q Sun Apr 9 9:30 AM AutoSave OFF N AQC ? V ... Book5 Q Home Insert Draw Page Layout Formulas Data Review View Tell me Comments Share Calibri (Body) 12 AA ab Wrap Text v Custom Insert v ne X Delete v Paste BIU v A Merge & Center v ~ % " Conditional Format Cell Sort & Find & Analyze Tasks Formatting as Table Styles Format v Filter Select Data C172 X V fx 10:51:04 AM A C D G H M N Q S MyEducator Tasks Transaction Date Transation Time order_id product_id category_code brand X price Quantity user_id Customer Age Customer Ratings Revenue Cost Profit W N 1/5/20 3:40:44 5502 47622 Skateboard WiiSham 41.99 9E+06 73 3 $41.99 $33.00 $8.99 .15/20 :44:58 2710 22830 Bungee Band Trainer Movemint :49.99 9E+0 27 $49.99 $59.00 -$9.01 1/5/20 4:46:13 47622 Skateboard WiiSham $41.99 $33.00 $8.99 sold to their customers. After i 9652 2E+06 $41.99 1/5/20 5:22:47 179 15622 Climbing Carabiners Favofit 19.99 1 E+06 80 $19.99 $23.00 -$3.01 removing all the insignificant 1/5/20 5:24:22 3684 15611 neoprene diving suit dive & sail $52.99 9E+06 73 $52.99 $39.45 $13.54 1/5/20 5:26:40 8980 47622 Skateboard WiiSham $41.99 2E+06 77 $41.99 $33.00 $8.99 variables in the model, which 1/5/20 5:30:43 596 47622 Skateboard WiiSham $41.99 5E+06 74 WUT W W W W UT - W $41.99 $33.00 $8.99 1/5/20 :30:4 596 47622 Skateboard WiiSham $41.99 4E+06 54 $41.99 $33.00 $8.99 of the following statements is 1/3/20 5:30:43 596 47622 Skateboard WiiShan $41.99 7E+06 79 $41.99 $8.99 1/5/20 5:35:13 164 35622 apparel.glove Hestra $154.95 530506 50 $154.95 $123.00 $31.95 false about the results 1/5/20 5:38:23 2283 47622 Skateboard WiiSham $41.99 3E+06 70 $41.99 $33.00 $8.99 1/7/20 4:55:42 2696 47622 skateboard WiiSham $41.99 8E+06 58 $41.99 $33.00 $8.99 obtained from your analysis. 1/7/20 4:55:42 2696 47622 skateboard WiiSham 41.99 933716 71 $41.99 $8.99 1/7/20 4:55:42 2696 47622 Skateboard WiiSham $41.99 8E+06 56 w w w w w w w $41.99 $33.00 $8.99 1/7/20 4:56:01 6181 47622 Skateboard WiiSham $41.99 9E +06 74 $41.99 $33.00 $8.99 The prediction equation 1//720 :56:01 6181 47622 Skateboard WiiSham $41.99 5E+06 57 $41.99 $8.99 1/7/20 5:11:36 869 47622 Skateboard WiiSham $41.99 6E+06 68 $41.99 $33.00 $8.99 for the top two product 1/7/20 5:12:49 8437 47622 skateboard WiiSham $41.99 6E+06 44 $41.99 $33.00 $8.99 1/7/20 5:12:49 8437 47622 Skateboard WiiSham $41.99 5E+06 65 $41.99 $33.00 $8.99 category is: Profit = -29.22 + ./7/20 5:12:49 8437 47622 skateboard WiiSham 41.99 4E+0 21 $41.99 $33.00 $8.99 1/8/20 4:23:02 9254 22831 Bungee Resistance Band Dasking $121.09 2E+06 44 121.09 $112.00 $9.09 11.76 * customer ratings 1/8/20 5:07:13 9874 22831 Bungee Resistance Band Dasking $121.09 8E+06 68 $121.09 $112.00 $9.09 1/8/20 5:10:26 1075 22831 Bungee Resistance Band Daskin $121.09 7E+06 40 $121.09 $112.00 $9.09 The coefficient of 1/8/20 5:15:01 1336 22831 Bungee Resistance Band Dasking $121.09 7E+0 32 $121.09 $112.00 $9.09 1/8/20 5:21:50 2861 22831 istance Band Dasking $121.09 6E+06 59 $121.09 $112.00 $9.09 determination for the 1/8/20 5:30:23 9316 22831 Bungee Resistance Band Dasking $121.09 5E+06 23 $121.09 $112.00 $9.09 1/8/20 9:04:47 Dasking $121.09 predictive model is 0.80 Bungee Resistance Band 7E+06 50 . A U U D UT W W W W W W W W W 3096 22831 $121.09 $112.00 $9.09 1/8/20 1:53:56 7326 22831 Bungee Resistance Band Dasking $121.09 3E+06 26 121.09 $112.00 $9.09 1/9/20 14:12:22 6986 35622 apparel.glove Hestra $154.95 4E+06 44 $154.95 $123.00 $31.95 O Customers' rating is a 1/12/2 6:37:49 3462 15699 Mountain Bike Schwinn $439.00 2E+06 49 $439.00 $428.00 $11.00 1/12/20 6:40:42 1176 15611 neoprene diving suit dive & sail $52.99 8E+06 58 $52.99 $39.45 $13.54 significant predictor of 1/12/20 6:59:10 8287 35622 apparel.glove Hestra $154.95 8E+06 51 $154.95 $123.00 $31.95 ./12/20 7:00:14 3926 15699 Mountain Bike $439.00 $428.00 $11.00 profitability Schwinn $439.00 4E+06 45 1/12/20 :13:20 2904 15699 Mountain Bike Schwinn $439.00 9E+06 52 $439.00 $428.00 $11.00 1/12/20 7:14:13 92 22831 Bungee Resistance Band Dasking $121.09 2E+06 68 $121.09 $112.00 $9.09 O Customers' age is a 1/12/20 7:14:13 92 22831 Bungee Resistance Band Dasking $121.09 9E+06 80 $121.09 $112.00 $ ./12/2 15699 Mountain Bike $439.00 40 $439.00 $428.00 $11.00 significant predictor of :16:20 3798 Schwinn 9E+06 1/12/20 7:22:41 5275 35622 apparel.glove Hestra $154.95 47274 21 $154.95 $123.00 $31.95 1/12/20 profitability 8:41:04 3789 22831 Bungee Resistance Band Dasking $121.09 3E+06 39 W W W W UT A W $121.09 $112.00 $9.09 1/12/20 8:42:26 8057 22831 Bungee Resistance Band Dasking $121.09 4E+06 35 $121.09 $112.00 $9.09 /12/2 8:56:51 459 22831 Bungee Resistance Band Dasking $121.09 9E+06 25 $121.09 $112.00 $9.09 1/12/20 9:00:26 4823 22831 Bungee Resistance Band Dasking $121.09 8E+06 50 $121.09 $112.00 $9.09 1/12/20 9:01:39 8209 15611 neoprene diving suit dive & sail $52.99 9E+06 18 $52.99 19 $39.45 $13.54 /12/2 9:04:43 4593 22831 Bungee Resistance Band Dasking $121.09 6E+06 62 $121.09 $112.00 $9.09 1/12/20 9:08:34 7140 22831 ungee Resistance Band Dasking $121.09 266987 33 121.09 $112.00 $9.09 Next > Transactions Data Dictionary + Ready Accessibility: Good to go 75% 11,213 X W 490 APR C 9 4 zoom