Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The dataset is from ed - tech company which has a freemium model: 1 . Basic: You can view 2 5 answers per week for

The dataset is from ed-tech company which has a freemium model:
1. Basic: You can view 25 answers per week for free, aer reaching the limit you see the unlock
page, where you can unlock the answers by watching video ads or you sign up for a free trial of
Plus
2. Plus: Unlimited, uninterrupted access to all quesons and answers in our knowledge base
Quesons:
1. Prepare a graph with daily conversion rate to trial (1st metric) and conversion rate to viewing the
video unlock page at least once (2nd metric)- both based on users. Do you see any paerns,
relaonships between metrics? Describe them and, if possible, explain them.
2. Compare the behavior of 2 segments of users - users who converted to trial and users who didn't
convert. Look at the overall volumes and for each segment calculate the shares of users who,
during the whole analyzed period:
a. a. added at least 1 answer,
b. added at least 1 queson,
c. read 5 or more answers,
d. used OCR at least 1me.
e. got an instant answer at least 1me.
Visualize the results in a way that would make it easy to see the differences in user behavior
between the 2 segments. Describe the differences between segments. How can we interpret and
use this result?
3. Prepare a visualization of distributions of total answers read per user during their first 7 days in
the App for 2 segments: users who converted to trial vs users who didn't convert. What's the
median of answers read for each segment? How can we interpret and use the results?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions