{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Contents","Sheet1 (2)","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["PERCENTILE Function"]
[null,"automateexcel.com/functions/percentile-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Sheet1 (2)",null,null,null,"Excel Formulas w/Examples"]
[null,"Sheet1",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,null,null,null,null,"Excel Functions & Formulas Tutorial"]
[]
[]
[]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Sheet1 (2)","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Person","Height (cm)",null,"K","Result"]
["Rachel",164,null,0,{"$f":"PERCENTILE($B$2:$B$8,D2)","v":164}]
["Monica",165,null,0.2,{"$f":"PERCENTILE($B$2:$B$8,D3)","v":166.6}]
["Phoebe",173,null,0.33329999999999999,{"$f":"PERCENTILE($B$2:$B$8,D4)","v":172.9984}]
["Chandler",183,null,0.5,178]
["Joey",178,null,0.66659999999999997,179.9992]
["Ross",185,null,1,185]
["Gunther",180]
[]
[null,"automateexcel.com/functions/percentile-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sheet1","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PERCENTILE",null,"=PERCENTILE (array, k)"]
[]
[null,"The Excel PERCENTILE function calculates the \"kth percentile\" for a set of data."]
[]
[null,"Person","Height (cm)",null,"K","Result"]
[null,"Rachel",164,null,0,{"$f":"PERCENTILE($C$7:$C$13,E7)","v":164}]
[null,"Monica",165,null,0.2,{"$f":"PERCENTILE($C$7:$C$13,E8)","v":166.6}]
[null,"Phoebe",173,null,0.33329999999999999,172.9984]
[null,"Chandler",183,null,0.5,178]
[null,"Joey",178,null,0.66659999999999997,179.9992]
[null,"Ross",185,null,1,185]
[null,"Gunther",180]
[]
[null,"automateexcel.com/functions/percentile-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]