1. Lighthouse

Level 3 · A sample of 200 orders

The request

From Brian Mitchell, Finance Analyst

“Our auditors check a random sample of 200 completed orders every year instead of all of them. This year their sample average came out lower than our books. Can you show me how far a 200-order sample can land from the full figure?”

Your goal

Draw a random sample with completed.sample(n=200, random_state=7). Set result to a dict with "sample_mean" (the sample's mean order_value), "population_mean" (the mean over all of completed) and "error" (sample_mean minus population_mean), each rounded to 2 decimals. Compute the error from the unrounded means.

  • Use the orders DataFramenot done yet
  • Use the order_items DataFramenot done yet
  • Store a dict in resultnot done yet

Your code

Python

Loading the editor…

    ResultPreview of orders · press Run to see yours
    Preview of orders
    order_idcustomer_idorder_datestatuschannel
    10011252023-01-01 20:51:19completedweb
    10021562023-01-02 07:58:46completedweb
    1003222023-01-02 10:25:27completedmarketplace
    1004482023-01-02 11:21:51completedmarketplace

    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.

    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
    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
    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
    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
    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

    Population and sample

    The population is every item you care about: here, all 10,849 completed orders. A sample is the part you actually measure. When you have the whole population in a table, its mean is simply the answer. Samples exist because the population is often too big, too slow or too costly to measure: auditors checking invoices by hand, a survey of customers, an A/B test that can only run for two weeks.

    sample = completed.sample(n=200, random_state=7)
    sample["order_value"].mean()      # 515.22
    completed["order_value"].mean()   # 543.30

    random_state fixes the random draw so you (and the checker) get the same 200 rows every time.

    Sampling error is normal

    The sample mean is $28.08 below the population mean, and nothing is wrong with the sample. Each random sample gives a slightly different answer. Try other seeds:

    random_state sample mean
    2 $384.70
    5 $574.72
    7 $515.22
    8 $581.28

    Same population, same size, a spread of almost $200. That spread is sampling error: the difference between a sample’s number and the population’s number that comes only from which rows happened to be drawn.

    Why order values vary so much

    A sample of 200 orders typically includes around six orders above $2,500. Draw two or three more or fewer of those and the mean moves by tens of dollars. The more skewed and spread out a column is, the more its sample means wander. The median of the same sample ($347.46 against $268.94 for all orders) shows that every statistic you compute from a sample has its own error.

    Bigger samples wander less

    Sampling error shrinks as the sample grows, but slowly: it falls with the square root of the sample size. Four times the sample halves the typical error. The boss level puts a number on this with the standard error.

    Common mistakes

    • Treating a sample’s number as the truth. Report it as an estimate, ideally with a margin.
    • Reading sampling error as a finding. A sample that comes out lower than the books is not evidence of a problem until the gap is bigger than sampling error can explain.
    • Rounding before subtracting. Round at the end; rounding each mean first can shift the difference by a cent.
    • Sampling without a seed in an analysis others must reproduce. Without random_state, every run gives a different sample and a different answer.

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