Question

1 Approved Answer

Posted on Oct 03, 2024

It is important to recognize the difference between data and information. Data is raw fact, while information is useful (and understandable) processed data. Think of

It is important to recognize the difference between data and information. Data is raw fact, while information is useful (and understandable) processed data. Think of data as the mountain and information as the diamond within. Were looking forward to chatting through your process and results Good Luck! Questions: 1. Its helpful to visualize the LTV curve, or rate of change in revenue over the lifetime of a user. Graph the Revenue per User over the days from install for the example data set. What conclusions/information can we ascertain from this graph? If the graph becomes too crowded, it may become difficult to draw conclusions from the data, and may be helpful to group the users in some way. 2. Assuming a $0.75 cost per acquisition, on average, how long does it take for the users to pay back their acquisition cost? Are any groups better than others? 3. Predicting the future based on the past and present will be a part of your daily life. What is the average value of a user at 30 days? 90 days? 180 days? 365 days? Are any groups of users better than others? 4. Now that youve gone through the data, pick the most informative pieces and present a brief summary explaining what youve found. Remember, at this point were looking for information backed up by data.

image text in transcribed

2 3 " 8,021" " 7,869" 1 1 261 5 $82.38 $33.22 8 8 9 9 10 10 #NUM! 0 1 2 3 11 207 5 32,613" "11,998 " " 11,455" " 11,471" 11,529 FI 1 11 $259.00 $121.38 $140.39 $81.31 $111.87 $83.26 $57.58 $103.07 $48.03 " 11,574 1 " 11,589" " 9,010" 8,802 - 854 3 284 3 " 7,574" 11 24,229 - $162.03 $43.78 $87.35 " 9,671" 30 1 7 " 9,701 " 9,741" 3 5 11 $106.01 $81.52 FI " 9,718 $92.89 3 1 TE 5 9,716 1 $97.46 2 - 1 1 " 9,940 $72.67 17 4 5 6 7 8 9 #NUM! 0 0 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 #NUM! 0 1 2 3 4 5 6 7 #NUM! 0 0 1 1 2 2 3 3 4 $78.47 7,819 147 1/26/2015 1/26/2015 1/27/2015 1/27/2015 1/28/2015 1/28/2015 1/18/2015 1/19/2015 1/20/2015 1/21/2015 1/22/2015 1/23/2015 1/24/2015 1/25/2015 1/26/2015 1/27/2015 1/28/2015 1/19/2015 1/20/2015 1/20/2015 1/21/2015 1/21/2015 1/22/2015 1/22/2015 1/23/2015 1/23/2015 1/24/2015 1/24/2015 1/25/2015 1/25/2015 1/26/2015 1/26/2015 1/27/2015 1/27/2015 1/28/2015 1/28/2015 1/20/2015 1/21/2015 1/22/2015 1/23/2015 1/24/2015 1/25/2015 1/26/2015 1/27/2015 1/28/2015 1/21/2015 1/22/2015 1/22/2015 1/23/2015 1/23/2015 1/24/2015 1/24/2015 1/25/2015 1/25/2015 1/26/2015 1/26/2015 1/27/2015 1/27/2015 1/28/2015 1/28/2015 1/22/2015 1/23/2015 1/24/2015 1/25/2015 1/26/2015 1/27/2015 1/28/2015 1/23/2015 1/24/2015 1/24/2015 1/25/2015 1/25/2015 1/26/2015 9 1/18/2015 1/18/2015 1/18/2015 1/18/2015 1/18/2015 1/18/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/23/2015 1/23/2015 1/23/2015 1/23/2015 1/23/2015 1/23/2015 1/23/2015 1/24/2015 1/24/2015 1/24/2015 1/24/2015 1/24/2015 1/24/2015 red blue blue red blue red red red red red red red red red red red red blue blue red blue red red blue blue red blue red blue red red blue red blue blue red red red red red red red red red red blue blue red red blue blue red blue red blue red red blue red blue red red red red red red red blue red blue blue red blue $1.09 43 19 $0.07 $6.50 $- $74.65 81 61 47 44 42 57 56 57 47 $12.03 $67.92 20 74 22 $16.83 $3.75 21 20 $2.94 40 $0.85 39 $1.47 $0.36 60 $- 36 $8.98 $- $33.30 81 80 58 48 57 55 66 $20.50 $- 18 44 $16.06 37 42 $2.72 41 $2.36 51 $0.94 $- 61 $0.25 $9.36 $25.86 82 77 56 84 55 $3.00 $34.99 61 52 57 $7.67 56 1. $159.33 $163.08 $110.17 $63.98 $62.27 $89.32 $86.34 1+ 11 263 6 31,613" " 10,332 " " 10, 247" " 10,227" 10,096 " 10, 341" 10,403" 292 8 51 " 5,221" " 24,309" 3 31 " 9,352 "9,179" 9 " 9,040" 2 3 " 9,129 1 3 11 $99.21 $17.19 $183.81 $105.26 $112.11 11 $85.04 1 " 9,140 $76.71 4 5 5 6 6 #NUM! 1 6 147 176 3 " 30,629 FI 11 - 1 2 3 4 5 #NUM! $177.64 $161.41 $83.55 $112.76 $46.37 " 8,161 8,012 " 8,126" " 7,981" 155 8 260 5 " 24,454 " 8,254" " 10,638" 1 22 " 10,715 1 $39.33 $255.73 $135.58 0 1 1 2 1 $134.71 2 3 " 8,021" " 7,869" 1 1 261 5 $82.38 $33.22 8 8 9 9 10 10 #NUM! 0 1 2 3 11 207 5 32,613" "11,998 " " 11,455" " 11,471" 11,529 FI 1 11 $259.00 $121.38 $140.39 $81.31 $111.87 $83.26 $57.58 $103.07 $48.03 " 11,574 1 " 11,589" " 9,010" 8,802 - 854 3 284 3 " 7,574" 11 24,229 - $162.03 $43.78 $87.35 " 9,671" 30 1 7 " 9,701 " 9,741" 3 5 11 $106.01 $81.52 FI " 9,718 $92.89 3 1 TE 5 9,716 1 $97.46 2 - 1 1 " 9,940 $72.67 17 4 5 6 7 8 9 #NUM! 0 0 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 #NUM! 0 1 2 3 4 5 6 7 #NUM! 0 0 1 1 2 2 3 3 4 $78.47 7,819 147 1/26/2015 1/26/2015 1/27/2015 1/27/2015 1/28/2015 1/28/2015 1/18/2015 1/19/2015 1/20/2015 1/21/2015 1/22/2015 1/23/2015 1/24/2015 1/25/2015 1/26/2015 1/27/2015 1/28/2015 1/19/2015 1/20/2015 1/20/2015 1/21/2015 1/21/2015 1/22/2015 1/22/2015 1/23/2015 1/23/2015 1/24/2015 1/24/2015 1/25/2015 1/25/2015 1/26/2015 1/26/2015 1/27/2015 1/27/2015 1/28/2015 1/28/2015 1/20/2015 1/21/2015 1/22/2015 1/23/2015 1/24/2015 1/25/2015 1/26/2015 1/27/2015 1/28/2015 1/21/2015 1/22/2015 1/22/2015 1/23/2015 1/23/2015 1/24/2015 1/24/2015 1/25/2015 1/25/2015 1/26/2015 1/26/2015 1/27/2015 1/27/2015 1/28/2015 1/28/2015 1/22/2015 1/23/2015 1/24/2015 1/25/2015 1/26/2015 1/27/2015 1/28/2015 1/23/2015 1/24/2015 1/24/2015 1/25/2015 1/25/2015 1/26/2015 9 1/18/2015 1/18/2015 1/18/2015 1/18/2015 1/18/2015 1/18/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/19/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/20/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/21/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/22/2015 1/23/2015 1/23/2015 1/23/2015 1/23/2015 1/23/2015 1/23/2015 1/23/2015 1/24/2015 1/24/2015 1/24/2015 1/24/2015 1/24/2015 1/24/2015 red blue blue red blue red red red red red red red red red red red red blue blue red blue red red blue blue red blue red blue red red blue red blue blue red red red red red red red red red red blue blue red red blue blue red blue red blue red red blue red blue red red red red red red red blue red blue blue red blue $1.09 43 19 $0.07 $6.50 $- $74.65 81 61 47 44 42 57 56 57 47 $12.03 $67.92 20 74 22 $16.83 $3.75 21 20 $2.94 40 $0.85 39 $1.47 $0.36 60 $- 36 $8.98 $- $33.30 81 80 58 48 57 55 66 $20.50 $- 18 44 $16.06 37 42 $2.72 41 $2.36 51 $0.94 $- 61 $0.25 $9.36 $25.86 82 77 56 84 55 $3.00 $34.99 61 52 57 $7.67 56 1. $159.33 $163.08 $110.17 $63.98 $62.27 $89.32 $86.34 1+ 11 263 6 31,613" " 10,332 " " 10, 247" " 10,227" 10,096 " 10, 341" 10,403" 292 8 51 " 5,221" " 24,309" 3 31 " 9,352 "9,179" 9 " 9,040" 2 3 " 9,129 1 3 11 $99.21 $17.19 $183.81 $105.26 $112.11 11 $85.04 1 " 9,140 $76.71 4 5 5 6 6 #NUM! 1 6 147 176 3 " 30,629 FI 11 - 1 2 3 4 5 #NUM! $177.64 $161.41 $83.55 $112.76 $46.37 " 8,161 8,012 " 8,126" " 7,981" 155 8 260 5 " 24,454 " 8,254" " 10,638" 1 22 " 10,715 1 $39.33 $255.73 $135.58 0 1 1 2 1 $134.71