{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["C(1)","C(2)","C(3)","C(4)","C(5)","C(6)","C(7)","C(8)","C(9)"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"C(1)","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Funding for City","Amount"]
["Sales Tax",133947]
["Income Tax",179193]
["Property Tax",102512.5]
["Other",98847.5]
["Total",{"$f":"SUM(B2:B5)","v":514500}]

{"sheet":"C(2)","index":1,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Into The Wind Sales"]
[null,"Jan","Feb","Mar","Total"]
["Toys",500,2150,8893,{"$f":"SUM(B3:D3)","v":11543}]
["Boomerangs",4000,6933,9545,{"$f":"SUM(B4:D4)","v":20478}]
["Kites",9721,5367,15064,{"$f":"SUM(B5:D5)","v":30152}]
["Total",{"$f":"SUM(B3:B5)","v":14221},{"$f":"SUM(C3:C5)","v":14450},{"$f":"SUM(D3:D5)","v":33502},{"$f":"SUM(B6:D6)","v":62173}]

{"sheet":"C(3)","index":2,"n_rows":97,"n_cols":19,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Histogram For Class Scores",null,null,null,null,null,null,null,null,null,null,null,"Assumptions"]
["Test Scores",null,"Lower","Upper",null,"Grouped Number Categories","How Many Students Got A Score In Each Category",null,null,null,null,null,null,null,null,null,null,"Start","Range"]
[81.75,null,{"$f":"R3","v":0},{"$f":"C3+$S$3","v":10},null,{"$f":"IF(C3=0,\"00\",C3)&\" up to \"&D3","v":"00 up to 10"},null,null,null,null,null,null,null,null,null,null,null,0,10]
[33,null,{"$f":"D3","v":10},20,null,{"$f":"IF(C4=0,\"00\",C4)&\" up to \"&D4","v":"10 up to 20"}]
[76,null,{"$f":"D4","v":20},30,null,"20 up to 30"]
[38.5,null,30,40,null,"30 up to 40"]
[98,null,40,50,null,"40 up to 50"]
[84.5,null,50,60,null,"50 up to 60"]
[72,null,60,70,null,"60 up to 70"]
[89.75,null,70,80,null,"70 up to 80"]
[99,null,80,90,null,"80 up to 90"]
[78,null,90,100,null,"90 up to 100"]
[47.75]
[58,null,null,null,null,"Min",{"$f":"MIN($A$3:$A$97)","v":1.25}]
[53.75,null,null,null,null,"Max",{"$f":"MAX($A$3:$A$97)","v":99.5}]
[55]
[4.5]
[75]
[73.75]
[80.75]
[67]
[36.25]
[38]
[42]
[68.25]
[73.5]
[68]
[84.25]
[56]
[61.75]
[36.5]
[63.5]
[78]
[81]
[67.25]
[93.25]
[62.5]
[41.75]
[80.25]
[47]
[91.5]
[52.75,null,"check","check"]
[2,null,"Frequency","Frequency"]
[88.25,null,{"$f":"COUNTIF($A$3:$A$97,\"<\"&D3)-COUNTIF($A$3:$A$97,\"<\"&C3)","v":5},{"$f":"SUMPRODUCT(--($A$3:$A$97>=C3),--($A$3:$A$97<D3))","v":5}]
[56,null,1,1]
[65,null,0,0]
[60.75,null,7,7]
[95.5,null,8,8]
[1.25,null,12,12]
[67.75,null,20,20]
[59,null,15,15]
[33.25,null,17,17]
[75,null,10,10]
[96.5]
[93.25]
[64.25]
[40.25]
[61]
[99.5]
[80.75]
[62.75]
[83.5]
[98.25]
[32]
[73]
[9.75]
[76]
[76]
[69]
[68.5]
[68]
[89.5]
[60.5]
[71]
[72]
[57.75]
[86.25]
[59]
[41.5]
[84.75]
[58]
[66.5]
[47.25]
[65.75]
[82.25]
[19.5]
[60.25]
[73]
[96.5]
[85]
[86.25]
[43]
[52.5]
[86.75]
[54]
[2]
[73.25]

{"sheet":"C(4)","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Into The Wind Sales"]
[null,"Jan","Feb","Mar","Total"]
["Toys",500,2150,8893,{"$f":"SUM(B3:D3)","v":11543}]
["Boomerangs",4000,6933,9545,{"$f":"SUM(B4:D4)","v":20478}]
["Kites",9721,5367,15064,{"$f":"SUM(B5:D5)","v":30152}]
["Total",{"$f":"SUM(B3:B5)","v":14221},{"$f":"SUM(C3:C5)","v":14450},{"$f":"SUM(D3:D5)","v":33502},{"$f":"SUM(B6:D6)","v":62173}]

{"sheet":"C(5)","index":4,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Into The Wind Sales \"&B2&\" to \"&I2","v":"Into The Wind Sales 2005 to 2012"}]
[null,2005,2006,2007,2008,2009,2010,2011,2012]
["Toys",5645,4382,6200,2155,1902,3544,6874,6710]
["Boomerangs",6000,6626,5487,5011,4480,6511,8004,7851]
["Kites",23438,20393,24863,9753,10547,9510,12548,21547]

{"sheet":"C(6)","index":5,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Do Hours Studied Predict Final Score On Test? Is there a relationship?",null,null,null,null,null,null,"y intercept","slope","correlation Coefficient","Coefficient of Determination"]
["Hours Studied - X","Student Scores On Final - Y",null,null,null,null,null,"Where line crosses y-axis","For 1 unit out x-axis, how far up the y-axis do you go?","Strength and direction of line (not causation)","The amount of influence x has on y (not causation)"]
[5,88,null,null,null,null,null,"b","m","r","r^2"]
[4,82,null,null,null,null,null,{"$f":"INTERCEPT($B$3:$B$40,$A$3:$A$40)","v":48.451817860924805},{"$f":"SLOPE($B$3:$B$40,$A$3:$A$40)","v":4.8348040945993658},{"$f":"PEARSON($A$3:$A$40,$B$3:$B$40)","v":0.7815613775517013},{"$f":"RSQ($B$3:$B$40,$A$3:$A$40)","v":0.61083818688051295}]
[2,61]
[4,78]
[8,81]
[1,17]
[11,89]
[11,99]
[2,46]
[7,89]
[2,54]
[5,83]
[7,84]
[3,59]
[6,91]
[5,78]
[10,100]
[6,79]
[4,75]
[6,86]
[7,85]
[10,96]
[9,94]
[4,55]
[14,97]
[3,44]
[4,79]
[6,91]
[7,93]
[3,67]
[5,93]
[10,95]
[2,41]
[3,68]
[12,93]
[4,47]
[5,75]
[8,97]

{"sheet":"C(7)","index":6,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Units","Sales","Total Costs","Fixed Cost","Net Income"]
[{"$f":"B17","v":0},{"$f":"A2*B$13","v":0},{"$f":"B2*B$15+D2","v":171562.49999999997},{"$f":"B$16","v":171562.49999999997},{"$f":"B2-C2","v":-171562.49999999997}]
[{"$f":"A2+B$18","v":3500},87500,{"$f":"B3*B$15+D3","v":219687.49999999997},171562.49999999997,{"$f":"B3-C3","v":-132187.49999999997}]
[{"$f":"A3+B$18","v":7000},175000,267812.5,171562.49999999997,-92812.5]
[10500,262500,315937.5,171562.49999999997,-53437.5]
[14000,350000,364062.5,171562.49999999997,-14062.5]
[17500,437500,412187.5,171562.49999999997,25312.5]
[21000,525000,460312.5,171562.49999999997,64687.5]
[24500,612500,508437.5,171562.49999999997,104062.5]
[28000,700000,556562.5,171562.49999999997,143437.5]
[]
["Assumptions Tables"]
["Sell Price of Boomerang",25]
["Units Sold",15250]
["Manufacturing Cost of Boomerang as a % of Sell Price",0.55000000000000004]
["Total Fixed Cost for Rest Of Operations",{"$f":"(B13*B14)*(1-B15)","v":171562.49999999997}]
["Table Start Unit Number",0]
["Table Unit Increment",3500]

{"sheet":"C(8)","index":7,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Month","Sales","Expenses"]
["Jan",100,75]
["Feb",150,105]
["Mar",210,150]
["Apr",190,140]
["May",150,110]
["Jun",230,180]

{"sheet":"C(9)","index":8,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Bellen","Carlota","Sunshine","Aspen","Sunset","Quad"]
["Day 1",141,179,188,196,200,174]
["Day 2",174,155,129,123,129,189]
["Day 3",177,163,160,136,178,190]
["Day 4",168,182,121,175,171,168]
["Day 5",121,178,197,175,194,144]
[]
[]
[null,"Bellen","Carlota","Sunshine","Aspen","Sunset","Quad"]
["Day 1",141,179,188,196,200,174]
["Day 2",174,155,129,123,129,189]
["Day 3",177,163,160,136,178,190]
["Day 4",168,182,121,175,171,168]
["Day 5",121,178,197,175,194,144]