{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Functions"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Functions","index":0,"n_rows":78,"n_cols":9,"rows_kept":78,"cut":false,"hidden":false,"merged":[[15,1,15,2],[15,3,15,4]]}
[{"$f":"\"PRICES FOR \"&B2&\" AND \"&C2","v":"PRICES FOR AAPL AND Google"},null,null,{"$f":"getformula(A1)","v":"<--  =\"PRICES FOR \"&B2&\" AND \"&C2"}]
[null,"AAPL","Google"]
["Mean",{"$f":"AVERAGE(Price1)","v":253.60524590163931},{"$f":"AVERAGE(Price2)","v":511.57475409836081},{"$f":"getformula(C3)","v":"<--  =AVERAGE(Price2)"}]
["Median",{"$f":"MEDIAN(Price1)","v":199.91},{"$f":"MEDIAN(Price2)","v":522.70000000000005},{"$f":"getformula(C4)","v":"<--  =MEDIAN(Price2)"}]
["Variance",{"$f":"_xlfn.VAR.S(Price1)","v":18969.305338688551},{"$f":"_xlfn.VAR.S(Price2)","v":8494.7186620218054},{"$f":"getformula(C5)","v":"<--  =VAR.S(Price2)"}]
["Standard deviation",{"$f":"_xlfn.STDEV.S(Price1)","v":137.72910127742992},{"$f":"_xlfn.STDEV.S(Price2)","v":92.166798045835378},{"$f":"getformula(C6)","v":"<--  =STDEV.S(Price2)"}]
["Highest",{"$f":"MAX(Price1)","v":599.54999999999995},{"$f":"MAX(Price2)","v":707},{"$f":"getformula(C7)","v":"<--  =MAX(Price2)"}]
["Second highest",{"$f":"LARGE(Price1,2)","v":584},{"$f":"LARGE(Price2,2)","v":693},{"$f":"getformula(C8)","v":"<--  =LARGE(Price2,2)"}]
["Second lowest",{"$f":"SMALL(Price1,2)","v":89.31},{"$f":"SMALL(Price2,2)","v":307.64999999999998},"<--  =SMALL(Price2,2)"]
["Lowest",{"$f":"MIN(Price1)","v":85.35},{"$f":"MIN(Price2)","v":292.95999999999998},"<--  =MIN(Price2)"]
["Number",{"$f":"COUNT(Price1)","v":61},{"$f":"COUNT(Price2)","v":61},"<--  =COUNT(Price2)"]
["Number above mean",{"$f":"COUNTIF(Price1,\">\"&B3)","v":25},{"$f":"COUNTIF(Price2,\">\"&C3)","v":33},"<--  =COUNTIF(Price2,\">\"&C3)"]
["Average above mean",{"$f":"AVERAGEIF(Price1,\">\"&FIXED(B3,6))","v":390.44479999999999},{"$f":"AVERAGEIF(Price2,\">\"&FIXED(C3,6))","v":578.08212121212125},"<--  =AVERAGEIF(Price2,\">\"&FIXED(C3,6))"]
[]
[null,{"$f":"ggetformula(B16)","v":"=FIXED(B11,0)&\" PRICES\""}]
[null,{"$f":"FIXED(B11,0)&\" PRICES\"","v":"61 PRICES"},null,"Ranks"]
["Date",{"$f":"B2","v":"AAPL"},{"$f":"C2","v":"Google"},{"$f":"B2","v":"AAPL"},{"$f":"C2","v":"Google"}]
["2007-06-01",122.04,580.11,{"$f":"RANK(B18,Price1,0)","v":54},{"$f":"RANK(C18,Price2,0)","v":16},{"$f":"getformula(E18)","v":"<--  =RANK(C18,Price2,0)"}]
["2007-07-02",131.76,645.9,51,4,"<--  =RANK(C19,Price2,0)"]
["2007-08-01",138.47999999999999,599.39,48,10,"<--  =RANK(C20,Price2,0)",null,null,"Hidden Rows!!"]
["2007-09-04",153.47,592.64,45,12,"<--  =RANK(C21,Price2,0)"]
["2007-10-01",189.95,515.04,34,33,"<--  =RANK(C22,Price2,0)"]
["2007-11-01",182.22,540.96,38,23,"<--  =RANK(C23,Price2,0)"]
["2007-12-03",198.08,603.69000000000005,32,8,"<--  =RANK(C24,Price2,0)"]
["2008-01-02",135.36000000000001,506.38,50,35,"<--  =RANK(C25,Price2,0)"]
["2008-02-01",125.02,529.02,53,26,"<--  =RANK(C26,Price2,0)"]
["2008-03-03",143.5,544.1,46,22,"<--  =RANK(C27,Price2,0)"]
["2008-04-01",173.95,586.76,39,13,"<--  =RANK(C28,Price2,0)"]
["2008-05-01",188.75,613.4,35,7,"<--  =RANK(C29,Price2,0)"]
["2008-06-02",167.44,600.36,42,9,"<--  =RANK(C30,Price2,0)"]
["2008-07-01",158.94999999999999,593.97,44,11,"<--  =RANK(C31,Price2,0)"]
["2008-08-01",169.53,555.71,40,21,"<--  =RANK(C32,Price2,0)"]
["2008-09-02",113.66,613.70000000000005,55,6,"<--  =RANK(C33,Price2,0)"]
["2008-10-01",107.59,525.79,56,29,"<--  =RANK(C34,Price2,0)"]
["2008-11-03",92.67,450.02,58,47,"<--  =RANK(C35,Price2,0)"]
["2008-12-01",85.35,484.85,61,40,"<--  =RANK(C36,Price2,0)"]
["2009-01-02",90.13,444.95,59,49,"<--  =RANK(C37,Price2,0)"]
["2009-02-02",89.31,485.63,60,39,"<--  =RANK(C38,Price2,0)"]
["2009-03-02",105.12,525.70000000000005,57,30,"<--  =RANK(C39,Price2,0)"]
["2009-04-01",125.83,567.12,52,19,"<--  =RANK(C40,Price2,0)"]
["2009-05-01",135.81,526.79999999999995,49,27,"<--  =RANK(C41,Price2,0)"]
["2009-06-01",142.43,529.94000000000005,47,25,"<--  =RANK(C42,Price2,0)"]
["2009-07-01",163.38999999999999,619.98,43,5,"<--  =RANK(C43,Price2,0)"]
["2009-08-03",168.21,583,41,15,"<--  =RANK(C44,Price2,0)"]
["2009-09-01",185.35,536.12,37,24,"<--  =RANK(C45,Price2,0)"]
["2009-10-01",188.5,495.85,36,38,"<--  =RANK(C46,Price2,0)"]
["2009-11-02",199.91,461.67,31,45,"<--  =RANK(C47,Price2,0)"]
["2009-12-01",210.73,443.05,29,50,"<--  =RANK(C48,Price2,0)"]
["2010-01-04",192.06,421.59,33,52,"<--  =RANK(C49,Price2,0)"]
["2010-02-01",204.62,417.23,{"$f":"RANK(B50,Price1,0)","v":30},{"$f":"RANK(C50,Price2,0)","v":53},"<--  =RANK(C50,Price2,0)"]
["2010-03-01",235,395.97,28,55,"<--  =RANK(C51,Price2,0)"]
["2010-04-01",261.08999999999997,348.06,23,57,"<--  =RANK(C52,Price2,0)"]
["2010-05-03",256.88,337.99,25,59,"<--  =RANK(C53,Price2,0)"]
["2010-06-01",251.53,338.53,26,58,"<--  =RANK(C54,Price2,0)"]
["2010-07-01",257.25,307.64999999999998,24,60,"<--  =RANK(C55,Price2,0)"]
["2010-08-02",243.1,292.95999999999998,27,61,"<--  =RANK(C56,Price2,0)"]
["2010-09-01",283.75,359.36,22,56,"<--  =RANK(C57,Price2,0)"]
["2010-10-01",300.98,400.52,21,54,"<--  =RANK(C58,Price2,0)"]
["2010-11-01",311.14999999999998,463.29,20,44,"<--  =RANK(C59,Price2,0)"]
["2010-12-01",322.56,473.75,19,41,"<--  =RANK(C60,Price2,0)"]
["2011-01-03",339.32,526.41999999999996,17,28,"<--  =RANK(C61,Price2,0)"]
["2011-02-01",353.21,585.79999999999995,13,14,"<--  =RANK(C62,Price2,0)"]
["2011-03-01",348.51,574.29,15,17,"<--  =RANK(C63,Price2,0)"]
["2011-04-01",350.13,440.47,14,51,"<--  =RANK(C64,Price2,0)"]
["2011-05-02",347.83,471.18,16,43,"<--  =RANK(C65,Price2,0)"]
["2011-06-01",335.67,564.29999999999995,18,20,"<--  =RANK(C66,Price2,0)"]
["2011-07-01",390.48,691.48,9,3,"<--  =RANK(C67,Price2,0)"]
["2011-08-01",384.83,693,10,2,"<--  =RANK(C68,Price2,0)"]
["2011-09-01",381.32,707,12,1,"<--  =RANK(C69,Price2,0)"]
["2011-10-03",404.78,567.27,8,18,"<--  =RANK(C70,Price2,0)"]
["2011-11-01",382.2,515.25,11,32,"<--  =RANK(C71,Price2,0)"]
["2011-12-01",405,510,7,34,"<--  =RANK(C72,Price2,0)"]
["2012-01-03",456.48,522.70000000000005,6,31,"<--  =RANK(C73,Price2,0)",null,null,"Rows!!!"]
["2012-02-01",542.44000000000005,497.91,5,37,"<--  =RANK(C74,Price2,0)"]
["2012-03-01",599.54999999999995,471.38,1,42,"<--  =RANK(C75,Price2,0)"]
["2012-04-02",583.98,458.16,3,46,"<--  =RANK(C76,Price2,0)"]
["2012-05-01",577.73,449.45,4,48,"<--  =RANK(C77,Price2,0)"]
["2012-06-01",584,501.5,2,36,"<--  =RANK(C78,Price2,0)"]