{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":12,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,1,16]],"flags":["formulas_cached_only"]}
["Example Data Set: Collected by Mineralogy Class, Montana State University, spring term 2010. 12 groups reported data according to the instructions in the exercise; Raw numbers are reported in the table below, including averages and standard deviations.  Raw data for pennies, nickels and the sum of both are plotted in the first column of graphs; the middle column of graphs plots the averages of pennies, nickels and their sums based on the raw data and also as a % of the total surface area.  Trend lines for these graphs are calculated as an exponential function in Excel.  The third column of graphs are log-log plots of the averaged data for pennies, nickels and their sums, and the trend lines are calculated as a power function in Excel."]
[]
["Group ",null,"P-Random","N-Random","P-10","N-10","P-20","N-20","P30","N-30","P-40","N-40","P-50","N-50","P-100","N-100","# to achieve ordered structure",null,null,"moves","Ave pennies","Ave Nickels","Ave All Data"]
["Wed 1",null,40,41,25,31,21,22,19,18,17,19,15,17,14,13,null,null,null,0,43.2,42.5,42.85]
["Wed 2",null,48,42,29,21,22,19,23,17,17,19,14,14,8,8,null,null,null,10,32.5,32.4,32.45]
["Wed 3",null,44,32,29,29,25,30,32,26,26,26,22,20,16,14,null,null,null,20,28.5,28.2,28.35]
["Wed 4",null,40,45,37,31,33,31,24,25,19,21,15,19,10,10,null,null,null,30,25.4,22.4,23.9]
["Wed 5",null,35,33,32,30,35,30,36,26,32,26,21,22,20,11,null,null,null,40,20.9,20.2,20.549999999999997]
["Thurs 1",null,44,49,34,38,35,31,27,27,21,24,18,22,8,8,97,null,null,50,17.1,16.8,16.950000000000003]
["Thurs 2",null,43,48,37,29,26,26,18,17,16,15,15,12,8,8,81,null,null,100,10.9,10.2,10.55]
["Thurs 3",null,44,51,27,39,28,25,22,23,21,17,18,11,8,8,98]
["Thurs 4",null,52,51,43,42,38,35,30,22,27,18,22,18,15,18,{"$nulls":4},"% of total surface area"]
["Thurs 5",null,45,42,27,37,22,28,20,17,14,16,9,15,8,8,90,null,null,0,0.5142857142857143,0.5059523809523809,0.5101190476190476]
["Thurs 6",null,44,40,41,38,35,38,31,32,29,24,24,21,8,8,85,null,null,10,0.3869047619047619,0.3857142857142857,0.3863095238095238]
[7,null,39,36,29,24,22,23,23,19,12,17,12,10,8,8,76,null,null,20,0.3392857142857143,0.3357142857142857,0.3375]
[null,"Average",43.166666666666664,42.5,32.5,32.416666666666664,28.5,28.166666666666668,25.416666666666668,22.416666666666668,20.916666666666668,20.166666666666668,17.083333333333332,16.75,10.916666666666666,10.166666666666666,null,null,null,30,0.30238095238095236,0.26666666666666666,0.2845238095238095]
[null,"St Dev",4.386618771038162,6.571287406727709,5.869799439039246,6.4167158597091065,6.317364237487887,5.474458600601243,5.728054299725701,4.907477288111822,6.302356461649643,3.9273709303097983,4.541892543729746,4.287932326467343,4.20947704230549,3.2706222186259457,null,null,null,40,0.24880952380952379,0.24047619047619045,0.2446428571428571]
[{"$nulls":19},50,0.2035714285714286,0.2,0.20178571428571432]
[{"$nulls":19},100,0.12976190476190477,0.12142857142857141,0.1255952380952381]
[null,"#","pennies","nickels","sum",null,"Norm to total Surface Area-Pennies","Norm to total Surface Area--Nickels"]
[null,0,40,41,81,null,0.47619047619047616,0.4880952380952381]
[null,0,48,42,90,null,0.5714285714285714,0.5]
[null,0,44,32,76,null,0.5238095238095238,0.38095238095238093]
[null,0,40,45,85,null,0.47619047619047616,0.5357142857142857]
[null,0,35,33,68,null,0.4166666666666667,0.39285714285714285]
[null,0,44,49,93,null,0.5238095238095238,0.5833333333333334]
[null,0,43,48,91,null,0.5119047619047619,0.5714285714285714]
[null,0,44,51,95,null,0.5238095238095238,0.6071428571428571]
[null,0,52,51,103,null,0.6190476190476191,0.6071428571428571]
[null,0,45,42,87,null,0.5357142857142857,0.5]
[null,0,44,40,84,null,0.5238095238095238,0.47619047619047616]
[null,0,39,36,75,null,0.4642857142857143,0.42857142857142855]
[null,10,25,31,56,null,0.2976190476190476,0.36904761904761907]
[null,10,29,21,50,null,0.34523809523809523,0.25]
[null,10,29,29,58,null,0.34523809523809523,0.34523809523809523]
[null,10,37,31,68,null,0.44047619047619047,0.36904761904761907]
[null,10,32,30,62,null,0.38095238095238093,0.35714285714285715]
[null,10,34,38,72,null,0.40476190476190477,0.4523809523809524]
[null,10,37,29,66,null,0.44047619047619047,0.34523809523809523]
[null,10,27,39,66,null,0.32142857142857145,0.4642857142857143]
[null,10,43,42,85,null,0.5119047619047619,0.5]
[null,10,27,37,64,null,0.32142857142857145,0.44047619047619047]
[null,10,41,38,79,null,0.4880952380952381,0.4523809523809524]
[null,10,29,24,53,null,0.34523809523809523,0.2857142857142857]
[null,20,21,22,43,null,0.25,0.2619047619047619]
[null,20,22,19,41,null,0.2619047619047619,0.2261904761904762]
[null,20,25,30,55,null,0.2976190476190476,0.35714285714285715]
[null,20,33,31,64,null,0.39285714285714285,0.36904761904761907]
[null,20,35,30,65,null,0.4166666666666667,0.35714285714285715]
[null,20,35,31,66,null,0.4166666666666667,0.36904761904761907]
[null,20,26,26,52,null,0.30952380952380953,0.30952380952380953]
[null,20,28,25,53,null,0.3333333333333333,0.2976190476190476]
[null,20,38,35,73,null,0.4523809523809524,0.4166666666666667]
[null,20,22,28,50,null,0.2619047619047619,0.3333333333333333]
[null,20,35,38,73,null,0.4166666666666667,0.4523809523809524]
[null,20,22,23,45,null,0.2619047619047619,0.27380952380952384]
[null,30,19,18,37,null,0.2261904761904762,0.21428571428571427]
[null,30,23,17,40,null,0.27380952380952384,0.20238095238095238]
[null,30,32,26,58,null,0.38095238095238093,0.30952380952380953]
[null,30,24,25,49,null,0.2857142857142857,0.2976190476190476]
[null,30,36,26,62,null,0.42857142857142855,0.30952380952380953]
[null,30,27,27,54,null,0.32142857142857145,0.32142857142857145]
[null,30,18,17,35,null,0.21428571428571427,0.20238095238095238]
[null,30,22,23,45,null,0.2619047619047619,0.27380952380952384]
[null,30,30,22,52,null,0.35714285714285715,0.2619047619047619]
[null,30,20,17,37,null,0.23809523809523808,0.20238095238095238]
[null,30,31,32,63,null,0.36904761904761907,0.38095238095238093]
[null,30,23,19,42,null,0.27380952380952384,0.2261904761904762]
[null,40,17,19,36,null,0.20238095238095238,0.2261904761904762]
[null,40,17,19,36,null,0.20238095238095238,0.2261904761904762]
[null,40,26,26,52,null,0.30952380952380953,0.30952380952380953]
[null,40,19,21,40,null,0.2261904761904762,0.25]
[null,40,32,26,58,null,0.38095238095238093,0.30952380952380953]
[null,40,21,24,45,null,0.25,0.2857142857142857]
[null,40,16,15,31,null,0.19047619047619047,0.17857142857142858]
[null,40,21,17,38,null,0.25,0.20238095238095238]
[null,40,27,18,45,null,0.32142857142857145,0.21428571428571427]
[null,40,14,16,30,null,0.16666666666666666,0.19047619047619047]
[null,40,29,24,53,null,0.34523809523809523,0.2857142857142857]
[null,40,12,17,29,null,0.14285714285714285,0.20238095238095238]
[null,50,15,17,32,null,0.17857142857142858,0.20238095238095238]
[null,50,14,14,28,null,0.16666666666666666,0.16666666666666666]
[null,50,22,20,42,null,0.2619047619047619,0.23809523809523808]
[null,50,15,19,34,null,0.17857142857142858,0.2261904761904762]
[null,50,21,22,43,null,0.25,0.2619047619047619]
[null,50,18,22,40,null,0.21428571428571427,0.2619047619047619]
[null,50,15,12,27,null,0.17857142857142858,0.14285714285714285]
[null,50,18,11,29,null,0.21428571428571427,0.13095238095238096]
[null,50,22,18,40,null,0.2619047619047619,0.21428571428571427]
[null,50,9,15,24,null,0.10714285714285714,0.17857142857142858]
[null,50,24,21,45,null,0.2857142857142857,0.25]
[null,50,12,10,22,null,0.14285714285714285,0.11904761904761904]
[null,100,14,13,27,null,0.16666666666666666,0.15476190476190477]
[null,100,8,8,16,null,0.09523809523809523,0.09523809523809523]
[null,100,16,14,30,null,0.19047619047619047,0.16666666666666666]
[null,100,10,10,20,null,0.11904761904761904,0.11904761904761904]
[null,100,20,11,31,null,0.23809523809523808,0.13095238095238096]
[null,97,8,8,16,null,0.09523809523809523,0.09523809523809523]
[null,81,8,8,16,null,0.09523809523809523,0.09523809523809523]
[null,98,8,8,16,null,0.09523809523809523,0.09523809523809523]
[null,100,15,18,33,null,0.17857142857142858,0.21428571428571427]
[null,90,8,8,16,null,0.09523809523809523,0.09523809523809523]
[null,85,8,8,16,null,0.09523809523809523,0.09523809523809523]
[null,76,8,8,16,null,0.09523809523809523,0.09523809523809523]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}