1. Lighthouse

Level 2 · How sure is the mobile rate?

The request

From Daniel Foster, Mobile Product Manager

“Thanks for the rates. Finance will ask how precise the mobile number is before they fund a redesign. Can you give me the mobile conversion rate with a 95% range around it?”

Your goal

For mobile sessions only, set result to a dict with "rate" (the conversion rate), "low" and "high": the 95% confidence interval rate ± 1.96 × √(rate × (1 − rate) / n), where n is the number of mobile sessions. Compute with unrounded values, then round all three to 4 decimals.

  • Use the web_sessions DataFramenot done yet
  • Store a dict in resultnot done yet
Conversion rate by device, all sessions
Conversion rate by device, all sessions0%1%2%3%4%desktop: 3.9%3.9%desktopmobile: 2.4%2.4%mobiletablet: 2.8%2.8%tabletDeviceConversion rate
Conversion rate by device, all sessions0%1%2%3%4%desktop: 3.9%3.9%desktopmobile: 2.4%2.4%mobiletablet: 2.8%2.8%tabletDeviceConversion rate

Desktop 14,541 sessions, mobile 21,549, tablet 3,910. The bars show the rates, not how sure each one is: that is what the interval adds.

Show the numbers
DeviceConversion rate
desktop3.9%
mobile2.4%
tablet2.8%

Your code

Python

Loading the editor…

    ResultPreview of web_sessions · press Run to see yours
    Preview of web_sessions
    session_idcustomer_idstarted_atdevicesource
    1NaN2023-01-01 23:02:24mobilepaid
    2182023-01-01 15:07:49desktoppaid
    3NaN2023-01-01 16:55:46desktopdirect
    4NaN2023-01-01 12:43:28mobileorganic

    Mote checks your result

    Press Run. Each row that matches the goal becomes a firefly in your lantern.

    DataFrames

    Loaded for you as pandas DataFrames, plus pd and np.

    web_sessions40,000 rows · 7 columns
    • session_idinteger
    • customer_idinteger
    • started_attimestamp
    • devicevarchar
    • sourcevarchar
    • pages_viewedinteger
    • convertedboolean
    First 5 rows of web_sessions
    session_idcustomer_idstarted_atdevicesourcepages_viewedconverted
    1NaN2023-01-01 23:02:24mobilepaid1false
    2182023-01-01 15:07:49desktoppaid1false
    3NaN2023-01-01 16:55:46desktopdirect7false
    4NaN2023-01-01 12:43:28mobileorganic3false
    5NaN2023-01-01 13:06:21mobilesocial2false
    customers2,018 rows · 9 columns
    • customer_idinteger
    • first_namevarchar
    • last_namevarchar
    • emailvarchar
    • cityvarchar
    • statevarchar
    • signup_datedate
    • segmentvarchar
    • referral_sourcevarchar
    First 5 rows of customers
    customer_idfirst_namelast_nameemailcitystatesignup_datesegmentreferral_source
    1OwenHudsonowen.hudson@icloud.comSan FranciscoCA2022-06-02consumersearch
    2DouglasMendozadmendoza69@gmail.comAtlantaGA2022-06-02consumerNaN
    3HenryBrookshbrooks@lakesidecafe.comLos AngelesCA2022-06-04businessNaN
    4BrianGrahambgraham@bluecedarhomes.comSeattleWA2022-06-06businesspinterest
    5KyleJimenezkjimenez27@yahoo.comIndianapolisIN2022-06-07consumerNaN
    products120 rows · 8 columns
    • product_idinteger
    • namevarchar
    • categoryvarchar
    • subcategoryvarchar
    • unit_pricedecimal
    • unit_costdecimal
    • launched_ondate
    • is_activeboolean
    First 5 rows of products
    product_idnamecategorysubcategoryunit_priceunit_costlaunched_onis_active
    101Vale Velvet LoveseatFurnitureSofas1659.00NaN2023-09-11true
    102Alder Oak Coffee TableFurnitureTables919.00503.502024-05-16true
    103Orchard Rattan Dining ChairFurnitureChairs789.00429.872023-05-27true
    104Upland Oak BookcaseFurnitureStorage429.00214.702022-12-20true
    105Avery Leather Bed FrameFurnitureBeds449.00232.702021-08-31true
    orders12,000 rows · 7 columns
    • order_idinteger
    • customer_idinteger
    • order_datetimestamp
    • statusvarchar
    • channelvarchar
    • shipping_feedecimal
    • coupon_codevarchar
    First 5 rows of orders
    order_idcustomer_idorder_datestatuschannelshipping_feecoupon_code
    10011252023-01-01 20:51:19completedweb0.00NaN
    10021562023-01-02 07:58:46completedweb0.00NaN
    1003222023-01-02 10:25:27completedmarketplace4.99WELCOME10
    1004482023-01-02 11:21:51completedmarketplace4.99WELCOME10
    1005822023-01-02 11:43:36completedweb0.00WELCOME10
    order_items30,338 rows · 6 columns
    • order_item_idinteger
    • order_idinteger
    • product_idinteger
    • quantityinteger
    • unit_pricedecimal
    • discount_pctdecimal
    First 5 rows of order_items
    order_item_idorder_idproduct_idquantityunit_pricediscount_pct
    11001121931.990.00
    21001154311.990.00
    31002154411.990.00
    410021941149.000.00
    51002193219.990.00
    returns1,673 rows · 5 columns
    • return_idinteger
    • order_item_idinteger
    • returned_ondate
    • reasonvarchar
    • refund_amountdecimal
    First 5 rows of returns
    return_idorder_item_idreturned_onreasonrefund_amount
    1142023-01-10damaged83.69
    2422023-01-10wrong_item19.99
    31052023-01-14wrong_item10.99
    4242023-01-16changed_mind26.99
    51262023-01-16late20.99
    employees60 rows · 8 columns
    • employee_idinteger
    • first_namevarchar
    • last_namevarchar
    • departmentvarchar
    • titlevarchar
    • manager_idinteger
    • hire_datedate
    • salaryinteger
    First 5 rows of employees
    employee_idfirst_namelast_namedepartmenttitlemanager_idhire_datesalary
    1CatherineHaleExecutiveChief Executive OfficerNaN2016-03-01285000
    2RobertKimExecutiveChief Operating Officer12017-01-09235000
    3MeganCollinsSalesHead of Sales12018-04-16172000
    4ChloeGutierrezSalesAccount Executive32020-01-2172000
    5FrankBellSalesAccount Executive32023-05-2173000
    marketing_spend3,276 rows · 3 columns
    • spend_datedate
    • channelvarchar
    • amountdecimal
    First 5 rows of marketing_spend
    spend_datechannelamount
    2023-01-01paid492.99
    2023-01-01email37.38
    2023-01-01social200.53
    2023-01-02paid709.13
    2023-01-02email64.13

    The lesson

    A rate is an estimate

    The 21,549 mobile sessions are a sample of all the mobile visits Harbor & Pine will ever get. Run the same three years again and you would not get exactly 2.41% again: a few orders would land differently. A confidence interval says how far the estimate could plausibly be from the true rate, given how much data you have.

    The standard error of a rate

    For a share p measured on n independent visits, the spread of the estimate is its standard error:

    se = math.sqrt(p * (1 - p) / n)

    Two things make it small: lots of data (n is under a square root, so 4× the sessions halves the error) and rates far from 50%. For mobile, p = 0.0241 and n = 21,549, so se ≈ 0.00105, about a tenth of a percentage point.

    The 95% interval

    Estimates of a rate on large samples follow a normal curve, and 95% of a normal curve lies within 1.96 standard errors of its centre. So:

    low, high = p - 1.96 * se, p + 1.96 * se    # 0.0221, 0.0262

    Mobile converts at 2.41%, 95% CI 2.21% to 2.62%. Compare tablet: a similar rate, 2.81%, but only 3,910 sessions, so its interval is two and a half times as wide, 2.30% to 3.33%. Same kind of number, much less certainty. The bars in the chart look equally solid; the intervals show they are not.

    What the interval means

    The honest reading: if you repeated the whole data collection many times and built an interval each time, 95% of those intervals would contain the true rate. In practice analysts say “the data are consistent with a mobile rate between 2.2% and 2.6%”, which is fine. What it does not mean is that 95% of mobile visitors convert in that range, or that a future month will land inside it. A single month has far fewer sessions and a wider interval of its own.

    Common mistakes

    • Wrong n. n is the number of sessions, not the number of conversions.
    • Tiny samples. The normal approximation needs enough successes and failures, roughly at least 10 of each. With 3 conversions in 40 sessions, use an exact or Wilson interval instead.
    • Overlap as a test. Two intervals that overlap slightly can still differ significantly. To compare two rates, test the difference directly (level 4).
    • Treating sessions as independent when they aren’t. One shopper with ten visits is not ten independent coin flips. Real tests often count users, not sessions, for this reason.

    Pick what may run on this site. You can change this any time from "Cookie settings" at the bottom of every page.