{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Intro","Intro (an)","Calculations","Calculations (an)","Number Formatting","Number Formatting (an)","DataSets","Data Analysis(1)","Data Analysis(2)","PT(1an)","PT(2an)","PT(4)","Data Analysis(3)","PT(3an)","Charts(3)","Charts(3an)","Charts(4)","Charts(4an)","Cell References","Cell References (an)","Prop Prob Perc","Prop Prob Perc (an)"],"not_rendered":{"charts":11,"images":3,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":4},"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":"Intro","index":0,"n_rows":188,"n_cols":10,"rows_kept":188,"cut":false,"hidden":false,"merged":[]}
["Excel 2010 = Statistical Functions and PivotTables are totally different (MUCH BETTER!)",null,"Sales",null,"Date","AutoSold","Sales",null,"Rank"," <<== Example of 2010 New Function"]
["Windows 7 = Operating System",null,7,null,"2011-06-13","Honda",15546,null,{"$f":"_xlfn.RANK.AVG(G2,$G$2:$G$9,0)","v":8}]
["Column Headers",null,26,null,"2011-06-14","Honda",25857,null,{"$f":"_xlfn.RANK.AVG(G3,$G$2:$G$9,0)","v":3}]
["Row Headers",null,9,null,"2011-06-15","Honda",22494,null,4]
["Cells",null,1,null,"2011-06-16","Toyota",22479,null,5]
["Scroll Bars = Expose more of the workbook",null,4,null,"2011-06-17","Toyota",30664,null,1]
["Worksheets = All The Cells",null,6,null,"2011-06-18","Ford",{"$f":"G9","v":15996},null,6.5]
["Sheet Tab Names = Name of Worksheet",null,10,null,"2011-06-19","Toyota",26478,null,2]
["Workbooks = All Worksheets",null,4,null,"2011-06-20","Toyota",15996,null,6.5]
["File = Workbook"]
["File Extensions",null,null,null,"AutoSold","Frequency (Count)"]
["Ribbon Tabs",null,null,null,"Honda",{"$f":"COUNTIF($F$2:$F$9,E12)","v":3}]
["QAT - Quick Access Toolbar",null,null,null,"Toyota",{"$f":"COUNTIF($F$2:$F$9,E13)","v":4}]
["Data Analysis Add-in",null,null,null,"Ford",1]
["Excel does 4 things:\n   1) Store Raw Data\n   2) Make Calculations\n   3)Data Analysis (Convert Raw Data Into Useful Information)\n   4)Charts"]
["Keyboard Shortcuts"]
["Move Through Sheets = Ctrl + PageUp/PageDown"]
["Show File extensions: Folder Options, View Tab, Uncheck \"Hide Extensions for Known File Types\""]
["Undo = Ctrl + Z"]
[]
["Average Score","Standard Deviation = Tells You How Reliable Your Average Is."]
["Same in all versions","Excel 2010","Excel 2007"]
[{"$f":"AVERAGE(A26:A188)","v":62.840490797546011},{"$f":"_xlfn.STDEV.P(A26:A188)","v":18.424086122583375},{"$f":"STDEVP(A26:A188)","v":18.424086122583375}]
[]
["Scores","Deviations2"]
[57,{"$f":"(A26-$A$23)^2","v":34.111332756219632},null,"Sum of Deviations Squared",{"$f":"SUM(B26:B188)","v":55329.852760736183}]
[51,{"$f":"(A27-$A$23)^2","v":140.19722232677177},null,"Divide by count",{"$f":"E26/COUNT(A26:A188)","v":339.44694945236921}]
[6,3230.8413941059125,null,"Square Root",{"$f":"SQRT(E27)","v":18.424086122583372}]
[57,34.111332756219632]
[47,250.92114870713985]
[92,850.27697692799893]
[58,23.430351161127614]
[61,3.3874063758515498]
[63,2.5443185667507803E-2]
[64,1.3444615905754866]
[56,46.792314351311653]
[68,26.620535210207404]
[98,1236.1910873574468]
[62,0.70642478075952886]
[57,34.111332756219632]
[87,583.68188490345904]
[0,3948.9272836764649]
[54,78.154277541495702]
[48,220.24016711204783]
[62,0.70642478075952886]
[61,3.3874063758515498]
[66,9.9824984003914441]
[80,294.44875606910313]
[89,684.31992171327499]
[90,737.63894011818297]
[65,4.663479995483466]
[56,46.792314351311653]
[64,1.3444615905754866]
[94,970.91501373781489]
[62,0.70642478075952886]
[46,283.60213030223184]
[56,46.792314351311653]
[85,491.04384809364302]
[57,34.111332756219632]
[51,140.19722232677177]
[42,434.32605668259993]
[48,220.24016711204783]
[55,61.473295946403674]
[3,3580.8843388911887]
[64,1.3444615905754866]
[58,23.430351161127614]
[64,1.3444615905754866]
[70,51.258572020023358]
[76,173.17268244947124]
[95,1034.2340321427228]
[48,220.24016711204783]
[61,3.3874063758515498]
[69,37.939553615115379]
[66,9.9824984003914441]
[65,4.663479995483466]
[62,0.70642478075952886]
[53,96.835259136587723]
[65,4.663479995483466]
[99,1307.5101057623547]
[59,14.749369566035591]
[84,447.72482968873504]
[51,140.19722232677177]
[67,17.301516805299425]
[76,173.17268244947124]
[56,46.792314351311653]
[60,8.0683879709435704]
[71,66.577590424931344]
[75,147.85366404456326]
[99,1307.5101057623547]
[70,51.258572020023358]
[41,{"$f":"(A91-$A$23)^2","v":477.00703827769195}]
[66,9.9824984003914441]
[67,17.301516805299425]
[50,164.87820392186379]
[69,37.939553615115379]
[49,191.55918551695581]
[78,229.8107192592872]
[63,2.5443185667507803E-2]
[69,37.939553615115379]
[61,3.3874063758515498]
[64,1.3444615905754866]
[59,14.749369566035591]
[61,3.3874063758515498]
[79,261.12973766419515]
[64,1.3444615905754866]
[99,1307.5101057623547]
[1,3824.246302081373]
[50,164.87820392186379]
[80,294.44875606910313]
[96,1099.5530505476308]
[56,46.792314351311653]
[59,14.749369566035591]
[96,1099.5530505476308]
[47,250.92114870713985]
[56,46.792314351311653]
[76,173.17268244947124]
[65,4.663479995483466]
[10,2792.1174677255444]
[59,14.749369566035591]
[61,3.3874063758515498]
[67,17.301516805299425]
[66,9.9824984003914441]
[56,46.792314351311653]
[62,0.70642478075952886]
[51,140.19722232677177]
[57,34.111332756219632]
[45,318.28311189732386]
[57,34.111332756219632]
[57,34.111332756219632]
[59,14.749369566035591]
[78,229.8107192592872]
[61,3.3874063758515498]
[52,117.51624073167974]
[89,684.31992171327499]
[89,684.31992171327499]
[56,46.792314351311653]
[11,2687.4364861304525]
[63,2.5443185667507803E-2]
[57,34.111332756219632]
[60,8.0683879709435704]
[43,393.64507508750791]
[27,1284.5407806089802]
[70,51.258572020023358]
[83,406.40581128382706]
[73,103.2156272347473]
[58,23.430351161127614]
[65,4.663479995483466]
[96,1099.5530505476308]
[63,2.5443185667507803E-2]
[55,61.473295946403674]
[69,37.939553615115379]
[63,2.5443185667507803E-2]
[45,318.28311189732386]
[53,96.835259136587723]
[61,{"$f":"(A155-$A$23)^2","v":3.3874063758515498}]
[58,23.430351161127614]
[68,26.620535210207404]
[57,34.111332756219632]
[92,850.27697692799893]
[57,34.111332756219632]
[95,1034.2340321427228]
[63,2.5443185667507803E-2]
[67,17.301516805299425]
[53,96.835259136587723]
[61,3.3874063758515498]
[59,14.749369566035591]
[56,46.792314351311653]
[65,4.663479995483466]
[58,23.430351161127614]
[61,3.3874063758515498]
[90,737.63894011818297]
[40,521.68801987278403]
[59,14.749369566035591]
[86,536.36286649855106]
[52,117.51624073167974]
[86,536.36286649855106]
[64,1.3444615905754866]
[94,970.91501373781489]
[66,9.9824984003914441]
[75,147.85366404456326]
[12,2584.7555045353606]
[68,26.620535210207404]
[60,8.0683879709435704]
[68,26.620535210207404]
[90,737.63894011818297]
[50,164.87820392186379]
[71,66.577590424931344]
[73,103.2156272347473]

{"sheet":"Intro (an)","index":1,"n_rows":188,"n_cols":10,"rows_kept":188,"cut":false,"hidden":false,"merged":[]}
["Excel 2010 = Statistical Functions and PivotTables are totally different (MUCH BETTER!)",null,"Sales",null,"Date","AutoSold","Sales",null,"Rank"," <<== Example of 2010 New Function"]
["Windows 7 = Operating System",null,7,null,"2011-06-13","Honda",15546,null,{"$f":"_xlfn.RANK.AVG(G2,$G$2:$G$9,0)","v":8}]
["Column Headers",null,26,null,"2011-06-14","Honda",25857,null,{"$f":"_xlfn.RANK.AVG(G3,$G$2:$G$9,0)","v":3}]
["Row Headers",null,9,null,"2011-06-15","Honda",22494,null,4]
["Cells",null,1,null,"2011-06-16","Toyota",22479,null,5]
["Scroll Bars = Expose more of the workbook",null,4,null,"2011-06-17","Toyota",30664,null,1]
["Worksheets = All The Cells",null,6,null,"2011-06-18","Ford",{"$f":"G9","v":15996},null,6.5]
["Sheet Tab Names = Name of Worksheet",null,10,null,"2011-06-19","Toyota",26478,null,2]
["Workbooks = All Worksheets",null,4,null,"2011-06-20","Toyota",15996,null,6.5]
["File = Workbook",null,{"$f":"SUM(C2:C9)","v":67}]
["File Extensions",null,null,null,"AutoSold","Frequency (Count)"]
["Ribbon Tabs",null,null,null,"Honda",{"$f":"COUNTIF($F$2:$F$9,E12)","v":3}]
["QAT - Quick Access Toolbar",null,null,null,"Toyota",{"$f":"COUNTIF($F$2:$F$9,E13)","v":4}]
["Data Analysis Add-in",null,null,null,"Ford",1]
["Excel does 4 things:\n   1) Store Raw Data\n   2) Make Calculations\n   3)Data Analysis (Convert Raw Data Into Useful Information)\n   4)Charts"]
["Keyboard Shortcuts"]
["Move Through Sheets = Ctrl + PageUp/PageDown"]
["Show File extensions: Folder Options, View Tab, Uncheck \"Hide Extensions for Known File Types\""]
["Undo = Ctrl + Z"]
[]
["Average Score","Standard Deviation = Tells You How Reliable Your Average Is."]
["Same in all versions","Excel 2010","Excel 2007"]
[{"$f":"AVERAGE(A26:A188)","v":62.840490797546011},{"$f":"_xlfn.STDEV.P(A26:A188)","v":18.424086122583375},{"$f":"STDEVP(A26:A188)","v":18.424086122583375}]
[]
["Scores","Deviations2"]
[57,{"$f":"(A26-$A$23)^2","v":34.111332756219632},null,"Sum of Deviations Squared",{"$f":"SUM(B26:B188)","v":55329.852760736183}]
[51,{"$f":"(A27-$A$23)^2","v":140.19722232677177},null,"Divide by count",{"$f":"E26/COUNT(A26:A188)","v":339.44694945236921}]
[6,3230.8413941059125,null,"Square Root",{"$f":"SQRT(E27)","v":18.424086122583372}]
[57,34.111332756219632]
[47,250.92114870713985]
[92,850.27697692799893]
[58,23.430351161127614]
[61,3.3874063758515498]
[63,2.5443185667507803E-2]
[64,1.3444615905754866]
[56,46.792314351311653]
[68,26.620535210207404]
[98,1236.1910873574468]
[62,0.70642478075952886]
[57,34.111332756219632]
[87,583.68188490345904]
[0,3948.9272836764649]
[54,78.154277541495702]
[48,220.24016711204783]
[62,0.70642478075952886]
[61,3.3874063758515498]
[66,9.9824984003914441]
[80,294.44875606910313]
[89,684.31992171327499]
[90,737.63894011818297]
[65,4.663479995483466]
[56,46.792314351311653]
[64,1.3444615905754866]
[94,970.91501373781489]
[62,0.70642478075952886]
[46,283.60213030223184]
[56,46.792314351311653]
[85,491.04384809364302]
[57,34.111332756219632]
[51,140.19722232677177]
[42,434.32605668259993]
[48,220.24016711204783]
[55,61.473295946403674]
[3,3580.8843388911887]
[64,1.3444615905754866]
[58,23.430351161127614]
[64,1.3444615905754866]
[70,51.258572020023358]
[76,173.17268244947124]
[95,1034.2340321427228]
[48,220.24016711204783]
[61,3.3874063758515498]
[69,37.939553615115379]
[66,9.9824984003914441]
[65,4.663479995483466]
[62,0.70642478075952886]
[53,96.835259136587723]
[65,4.663479995483466]
[99,1307.5101057623547]
[59,14.749369566035591]
[84,447.72482968873504]
[51,140.19722232677177]
[67,17.301516805299425]
[76,173.17268244947124]
[56,46.792314351311653]
[60,8.0683879709435704]
[71,66.577590424931344]
[75,147.85366404456326]
[99,1307.5101057623547]
[70,51.258572020023358]
[41,{"$f":"(A91-$A$23)^2","v":477.00703827769195}]
[66,9.9824984003914441]
[67,17.301516805299425]
[50,164.87820392186379]
[69,37.939553615115379]
[49,191.55918551695581]
[78,229.8107192592872]
[63,2.5443185667507803E-2]
[69,37.939553615115379]
[61,3.3874063758515498]
[64,1.3444615905754866]
[59,14.749369566035591]
[61,3.3874063758515498]
[79,261.12973766419515]
[64,1.3444615905754866]
[99,1307.5101057623547]
[1,3824.246302081373]
[50,164.87820392186379]
[80,294.44875606910313]
[96,1099.5530505476308]
[56,46.792314351311653]
[59,14.749369566035591]
[96,1099.5530505476308]
[47,250.92114870713985]
[56,46.792314351311653]
[76,173.17268244947124]
[65,4.663479995483466]
[10,2792.1174677255444]
[59,14.749369566035591]
[61,3.3874063758515498]
[67,17.301516805299425]
[66,9.9824984003914441]
[56,46.792314351311653]
[62,0.70642478075952886]
[51,140.19722232677177]
[57,34.111332756219632]
[45,318.28311189732386]
[57,34.111332756219632]
[57,34.111332756219632]
[59,14.749369566035591]
[78,229.8107192592872]
[61,3.3874063758515498]
[52,117.51624073167974]
[89,684.31992171327499]
[89,684.31992171327499]
[56,46.792314351311653]
[11,2687.4364861304525]
[63,2.5443185667507803E-2]
[57,34.111332756219632]
[60,8.0683879709435704]
[43,393.64507508750791]
[27,1284.5407806089802]
[70,51.258572020023358]
[83,406.40581128382706]
[73,103.2156272347473]
[58,23.430351161127614]
[65,4.663479995483466]
[96,1099.5530505476308]
[63,2.5443185667507803E-2]
[55,61.473295946403674]
[69,37.939553615115379]
[63,2.5443185667507803E-2]
[45,318.28311189732386]
[53,96.835259136587723]
[61,{"$f":"(A155-$A$23)^2","v":3.3874063758515498}]
[58,23.430351161127614]
[68,26.620535210207404]
[57,34.111332756219632]
[92,850.27697692799893]
[57,34.111332756219632]
[95,1034.2340321427228]
[63,2.5443185667507803E-2]
[67,17.301516805299425]
[53,96.835259136587723]
[61,3.3874063758515498]
[59,14.749369566035591]
[56,46.792314351311653]
[65,4.663479995483466]
[58,23.430351161127614]
[61,3.3874063758515498]
[90,737.63894011818297]
[40,521.68801987278403]
[59,14.749369566035591]
[86,536.36286649855106]
[52,117.51624073167974]
[86,536.36286649855106]
[64,1.3444615905754866]
[94,970.91501373781489]
[66,9.9824984003914441]
[75,147.85366404456326]
[12,2584.7555045353606]
[68,26.620535210207404]
[60,8.0683879709435704]
[68,26.620535210207404]
[90,737.63894011818297]
[50,164.87820392186379]
[71,66.577590424931344]
[73,103.2156272347473]

{"sheet":"Calculations","index":2,"n_rows":641,"n_cols":8,"rows_kept":641,"cut":false,"hidden":false,"merged":[]}
["You already know the order of operations (left to right): Parenthesis, Exponents, Multiply/Divide, Add/Subtract"]
["You must learn Excel's Operation Symbols"]
["Parenthesis"," ( )","Shift + 9 and Shift + 0","Math Operators"]
["Exponents"," ^","Shift + 6","Math Operators"]
["Multiply"," *","Number pad","Math Operators"]
["Divide"," /","Number pad","Math Operators"]
["Add"," +","Number pad","Math Operators"]
["Subtract"," -","Number pad","Math Operators"]
["Join"," &","Shift + 7","Join Symbol - Ampersand"]
["Text in formulas","\" \"","Shift + \"","Text in formulas must be in Double Quotes, like \"The average is \""]
["Equal"," =","Left of Backspace","Comparative Operators"]
["Greater than"," >","Shift + .","Comparative Operators"]
["Greater than or equal to"," >=","2 characters next to each other","Comparative Operators"]
["Less than"," <","Shift + ,","Comparative Operators"]
["Less than or equal to"," <=","2 characters next to each other","Comparative Operators"]
["Not"," <>","2 characters next to each other","Comparative Operators"]
[]
["When you make calculations, you can use Formulas"]
["Formulas Start with the Equal Sign"]
[]
["Formula for arithmetic",null,"Formula that uses Function"]
["X",null,"Scores"]
[8.75,null,100]
["Average",null,88]
[10.5,null,43]
["(X-Average)^2",null,95,null,null,null,null,"Formula Notes:"]
[null,null,88,null,null,null,null,"To Create a Formula, type an equal sign as the first character in the cell"]
[null,null,"Add = SUM",null,null,null,null,"Put formula inputs (numbers etc.) in cells and refer to numbers with cell references"]
[null,null,"Mean = AVERAGE =",null,null,"Older",null,"Put cell references in formulas with Mouse or Arrow Keys"]
[null,null,"MODE = MODE.SNGL",null,null,{"$f":"MODE(C23:C27)","v":88},null,"Put cell in edit mode = F2"]
[null,null,"Standard Deviation = STDEV.S",null,null,{"$f":"STDEV(C23:C27)","v":22.818851855428676},null,"Esc Key = revert back to what was in cell before you put cell in edit mode"]
[null,null,"Criteria",90,null,null,null,"To search for functions, use the fx button on the Formula Bar"]
[null,null,{"$f":"\"Count # >= \"&D32","v":"Count # >= 90"},null,null,null,null,"When creating COUNTIF or COUNTIFS functions put comparative operators in"]
[null,null,"Criteria 1",50,null,null,null,"Double Quotes, like:  \">=\", and use Join Symbol (&) to join comparative operator"]
[null,null,"Criteria 2",100,null,null,null,"and number."]
[null,null,{"$f":"\"Counting Values Between \"&D34&\" and \"&D35&\" (inclusive)\"","v":"Counting Values Between 50 and 100 (inclusive)"},null,null,null,null,"Types of Formulas: Calculating, Text, Logical"]
[null,null,"Revenue",1000,null,null,null,"Keyboard shortcut for Auto Sum: Alt + ="]
[null,null,"Expense 1",250,null,null,null,"Keyboard shortcut to jump to bottom of a column: Ctrl + Arrow"]
[null,null,"Expense 2",100,null,null,null,"Keyboard shortcut for highlighting a column: Ctrl + Shift + Arrow"]
[null,null,"Expense 3",395]
[null,null,"Net Income"]
[]
[null,null,"All formulas so far have been \"Calculating Formulas\""]
[]
[null,null,"Text Formula"]
[]
[]
[null,null,"TRUE/FALSE formula: Logical Formulas"]
[null,null,null,"Is Mode greater than Average: TRUE or FALSE?"]
[]
[]
[null,null,"Sales","Total"]
[null,null,95]
[null,null,100]
[null,null,40]
[null,null,65]
[null,null,89]
[null,null,75]
[null,null,94]
[null,null,81]
[null,null,43]
[null,null,50]
[null,null,10]
[null,null,74]
[null,null,59]
[null,null,20]
[null,null,84]
[null,null,91]
[null,null,60]
[null,null,43]
[null,null,18]
[null,null,31]
[null,null,86]
[null,null,13]
[null,null,44]
[null,null,100]
[null,null,61]
[null,null,84]
[null,null,70]
[null,null,92]
[null,null,18]
[null,null,97]
[null,null,88]
[null,null,43]
[null,null,53]
[null,null,49]
[null,null,48]
[null,null,43]
[null,null,34]
[null,null,14]
[null,null,85]
[null,null,39]
[null,null,16]
[null,null,33]
[null,null,22]
[null,null,63]
[null,null,49]
[null,null,100]
[null,null,69]
[null,null,37]
[null,null,89]
[null,null,80]
[null,null,55]
[null,null,87]
[null,null,38]
[null,null,50]
[null,null,19]
[null,null,56]
[null,null,35]
[null,null,71]
[null,null,41]
[null,null,39]
[null,null,71]
[null,null,60]
[null,null,39]
[null,null,48]
[null,null,75]
[null,null,40]
[null,null,12]
[null,null,69]
[null,null,53]
[null,null,29]
[null,null,30]
[null,null,10]
[null,null,78]
[null,null,74]
[null,null,56]
[null,null,65]
[null,null,62]
[null,null,66]
[null,null,26]
[null,null,34]
[null,null,88]
[null,null,12]
[null,null,38]
[null,null,46]
[null,null,59]
[null,null,95]
[null,null,52]
[null,null,64]
[null,null,76]
[null,null,36]
[null,null,38]
[null,null,58]
[null,null,90]
[null,null,59]
[null,null,17]
[null,null,33]
[null,null,99]
[null,null,76]
[null,null,61]
[null,null,43]
[null,null,54]
[null,null,18]
[null,null,54]
[null,null,48]
[null,null,52]
[null,null,84]
[null,null,44]
[null,null,36]
[null,null,14]
[null,null,25]
[null,null,77]
[null,null,73]
[null,null,90]
[null,null,68]
[null,null,13]
[null,null,14]
[null,null,89]
[null,null,14]
[null,null,65]
[null,null,23]
[null,null,14]
[null,null,63]
[null,null,88]
[null,null,82]
[null,null,62]
[null,null,26]
[null,null,100]
[null,null,30]
[null,null,84]
[null,null,24]
[null,null,25]
[null,null,57]
[null,null,40]
[null,null,52]
[null,null,45]
[null,null,59]
[null,null,13]
[null,null,98]
[null,null,86]
[null,null,36]
[null,null,33]
[null,null,93]
[null,null,73]
[null,null,59]
[null,null,28]
[null,null,39]
[null,null,90]
[null,null,31]
[null,null,82]
[null,null,53]
[null,null,72]
[null,null,25]
[null,null,93]
[null,null,44]
[null,null,92]
[null,null,77]
[null,null,41]
[null,null,15]
[null,null,32]
[null,null,66]
[null,null,20]
[null,null,44]
[null,null,64]
[null,null,23]
[null,null,70]
[null,null,54]
[null,null,28]
[null,null,30]
[null,null,29]
[null,null,75]
[null,null,42]
[null,null,83]
[null,null,79]
[null,null,51]
[null,null,81]
[null,null,46]
[null,null,65]
[null,null,93]
[null,null,27]
[null,null,75]
[null,null,37]
[null,null,78]
[null,null,61]
[null,null,54]
[null,null,52]
[null,null,61]
[null,null,93]
[null,null,23]
[null,null,14]
[null,null,34]
[null,null,86]
[null,null,56]
[null,null,50]
[null,null,71]
[null,null,85]
[null,null,94]
[null,null,25]
[null,null,35]
[null,null,87]
[null,null,28]
[null,null,24]
[null,null,69]
[null,null,36]
[null,null,75]
[null,null,70]
[null,null,71]
[null,null,38]
[null,null,48]
[null,null,80]
[null,null,37]
[null,null,54]
[null,null,92]
[null,null,57]
[null,null,88]
[null,null,100]
[null,null,54]
[null,null,27]
[null,null,65]
[null,null,89]
[null,null,42]
[null,null,61]
[null,null,55]
[null,null,45]
[null,null,42]
[null,null,49]
[null,null,76]
[null,null,57]
[null,null,41]
[null,null,68]
[null,null,91]
[null,null,29]
[null,null,42]
[null,null,15]
[null,null,89]
[null,null,36]
[null,null,23]
[null,null,93]
[null,null,35]
[null,null,31]
[null,null,81]
[null,null,14]
[null,null,97]
[null,null,53]
[null,null,56]
[null,null,21]
[null,null,60]
[null,null,42]
[null,null,13]
[null,null,49]
[null,null,40]
[null,null,18]
[null,null,85]
[null,null,26]
[null,null,35]
[null,null,87]
[null,null,47]
[null,null,47]
[null,null,12]
[null,null,61]
[null,null,55]
[null,null,81]
[null,null,97]
[null,null,58]
[null,null,64]
[null,null,57]
[null,null,64]
[null,null,26]
[null,null,56]
[null,null,82]
[null,null,32]
[null,null,53]
[null,null,84]
[null,null,87]
[null,null,81]
[null,null,90]
[null,null,23]
[null,null,48]
[null,null,27]
[null,null,31]
[null,null,63]
[null,null,46]
[null,null,100]
[null,null,33]
[null,null,22]
[null,null,31]
[null,null,40]
[null,null,61]
[null,null,36]
[null,null,11]
[null,null,39]
[null,null,70]
[null,null,33]
[null,null,10]
[null,null,51]
[null,null,65]
[null,null,15]
[null,null,57]
[null,null,46]
[null,null,23]
[null,null,80]
[null,null,23]
[null,null,69]
[null,null,28]
[null,null,33]
[null,null,81]
[null,null,95]
[null,null,18]
[null,null,41]
[null,null,98]
[null,null,12]
[null,null,30]
[null,null,72]
[null,null,16]
[null,null,30]
[null,null,79]
[null,null,63]
[null,null,65]
[null,null,99]
[null,null,39]
[null,null,59]
[null,null,12]
[null,null,11]
[null,null,26]
[null,null,67]
[null,null,32]
[null,null,28]
[null,null,15]
[null,null,87]
[null,null,11]
[null,null,50]
[null,null,54]
[null,null,72]
[null,null,77]
[null,null,38]
[null,null,36]
[null,null,100]
[null,null,13]
[null,null,86]
[null,null,75]
[null,null,30]
[null,null,22]
[null,null,21]
[null,null,44]
[null,null,60]
[null,null,63]
[null,null,95]
[null,null,36]
[null,null,14]
[null,null,92]
[null,null,55]
[null,null,13]
[null,null,38]
[null,null,10]
[null,null,85]
[null,null,34]
[null,null,98]
[null,null,59]
[null,null,88]
[null,null,43]
[null,null,83]
[null,null,29]
[null,null,79]
[null,null,34]
[null,null,80]
[null,null,75]
[null,null,49]
[null,null,61]
[null,null,70]
[null,null,86]
[null,null,12]
[null,null,39]
[null,null,64]
[null,null,68]
[null,null,92]
[null,null,14]
[null,null,42]
[null,null,27]
[null,null,89]
[null,null,82]
[null,null,39]
[null,null,32]
[null,null,69]
[null,null,94]
[null,null,48]
[null,null,93]
[null,null,22]
[null,null,73]
[null,null,82]
[null,null,44]
[null,null,85]
[null,null,77]
[null,null,73]
[null,null,73]
[null,null,11]
[null,null,18]
[null,null,20]
[null,null,75]
[null,null,56]
[null,null,50]
[null,null,69]
[null,null,37]
[null,null,29]
[null,null,70]
[null,null,70]
[null,null,69]
[null,null,65]
[null,null,83]
[null,null,17]
[null,null,93]
[null,null,38]
[null,null,81]
[null,null,78]
[null,null,42]
[null,null,60]
[null,null,12]
[null,null,27]
[null,null,32]
[null,null,98]
[null,null,66]
[null,null,78]
[null,null,43]
[null,null,87]
[null,null,96]
[null,null,40]
[null,null,45]
[null,null,82]
[null,null,98]
[null,null,49]
[null,null,83]
[null,null,96]
[null,null,38]
[null,null,80]
[null,null,12]
[null,null,51]
[null,null,97]
[null,null,81]
[null,null,55]
[null,null,60]
[null,null,18]
[null,null,78]
[null,null,63]
[null,null,75]
[null,null,73]
[null,null,66]
[null,null,86]
[null,null,49]
[null,null,86]
[null,null,72]
[null,null,93]
[null,null,47]
[null,null,73]
[null,null,31]
[null,null,31]
[null,null,45]
[null,null,45]
[null,null,26]
[null,null,53]
[null,null,27]
[null,null,94]
[null,null,35]
[null,null,46]
[null,null,93]
[null,null,71]
[null,null,24]
[null,null,83]
[null,null,22]
[null,null,67]
[null,null,27]
[null,null,13]
[null,null,20]
[null,null,12]
[null,null,63]
[null,null,50]
[null,null,58]
[null,null,68]
[null,null,56]
[null,null,73]
[null,null,83]
[null,null,62]
[null,null,75]
[null,null,86]
[null,null,100]
[null,null,85]
[null,null,27]
[null,null,20]
[null,null,24]
[null,null,93]
[null,null,46]
[null,null,88]
[null,null,20]
[null,null,80]
[null,null,17]
[null,null,37]
[null,null,56]
[null,null,87]
[null,null,30]
[null,null,13]
[null,null,79]
[null,null,88]
[null,null,51]
[null,null,53]
[null,null,34]
[null,null,25]
[null,null,35]
[null,null,100]
[null,null,98]
[null,null,51]
[null,null,43]
[null,null,67]
[null,null,86]
[null,null,53]
[null,null,83]
[null,null,70]
[null,null,32]
[null,null,18]
[null,null,74]
[null,null,23]
[null,null,31]
[null,null,48]
[null,null,65]
[null,null,90]
[null,null,51]
[null,null,99]
[null,null,25]
[null,null,26]
[null,null,41]
[null,null,86]
[null,null,94]
[null,null,28]
[null,null,21]
[null,null,63]
[null,null,82]
[null,null,72]
[null,null,42]
[null,null,66]
[null,null,70]
[null,null,85]
[null,null,56]
[null,null,24]
[null,null,45]
[null,null,81]
[null,null,29]
[null,null,62]
[null,null,13]
[null,null,29]
[null,null,51]
[null,null,31]
[null,null,63]
[null,null,13]
[null,null,42]
[null,null,43]
[null,null,46]
[null,null,91]
[null,null,31]
[null,null,42]
[null,null,46]
[null,null,48]
[null,null,72]
[null,null,11]
[null,null,86]
[null,null,78]
[null,null,47]
[null,null,70]
[null,null,81]
[null,null,42]
[null,null,73]
[null,null,56]
[null,null,23]
[null,null,98]
[null,null,98]
[null,null,51]
[null,null,21]
[null,null,28]
[null,null,45]
[null,null,53]
[null,null,92]
[null,null,80]
[null,null,48]
[null,null,25]
[null,null,90]
[null,null,23]
[null,null,57]
[null,null,32]
[null,null,57]
[null,null,93]
[null,null,85]
[null,null,80]
[null,null,45]
[null,null,14]

{"sheet":"Calculations (an)","index":3,"n_rows":641,"n_cols":8,"rows_kept":641,"cut":false,"hidden":false,"merged":[]}
["You already know the order of operations (left to right): Parenthesis, Exponents, Multiply/Divide, Add/Subtract"]
["You must learn Excel's Operation Symbols"]
["Parenthesis"," ( )","Shift + 9 and Shift + 0","Math Operators"]
["Exponents"," ^","Shift + 6","Math Operators"]
["Multiply"," *","Number pad","Math Operators"]
["Divide"," /","Number pad","Math Operators"]
["Add"," +","Number pad","Math Operators"]
["Subtract"," -","Number pad","Math Operators"]
["Join"," &","Shift + 7","Join Symbol - Ampersand"]
["Text in formulas","\" \"","Shift + \"","Text in formulas must be in Double Quotes, like \"The average is \""]
["Equal"," =","Left of Backspace","Comparative Operators"]
["Greater than"," >","Shift + .","Comparative Operators"]
["Greater than or equal to"," >=","2 characters next to each other","Comparative Operators"]
["Less than"," <","Shift + ,","Comparative Operators"]
["Less than or equal to"," <=","2 characters next to each other","Comparative Operators"]
["Not"," <>","2 characters next to each other","Comparative Operators"]
[]
["When you make calculations, you can use Formulas"]
["Formulas Start with the Equal Sign"]
[]
["Formula for arithmetic",null,"Formula that uses Function"]
["X",null,"Scores"]
[8.75,null,100]
["Average",null,88]
[10.5,null,43]
["(X-Average)^2",null,95,{"$f":"100+88+43+95+88","v":414},null,null,null,"Formula Notes:"]
[{"$f":"(A23-A25)^2","v":3.0625},null,88,{"$f":"C23+C24+C25+C26+C27","v":414},null,null,null,"To Create a Formula, type an equal sign as the first character in the cell"]
[null,null,"Add = SUM",{"$f":"SUM(C23:C27)","v":414},null,null,null,"Put formula inputs (numbers etc.) in cells and refer to numbers with cell references"]
[null,null,"Mean = AVERAGE =",{"$f":"AVERAGE(C23:C27)","v":82.8},null,"Older",null,"Put cell references in formulas with Mouse or Arrow Keys"]
[null,null,"MODE = MODE.SNGL",{"$f":"_xlfn.MODE.SNGL(C23:C27)","v":88},null,{"$f":"MODE(C23:C27)","v":88},null,"Put cell in edit mode = F2"]
[null,null,"Standard Deviation = STDEV.S",{"$f":"_xlfn.STDEV.S(C23:C27)","v":22.818851855428676},null,{"$f":"STDEV(C23:C27)","v":22.818851855428676},null,"Esc Key = revert back to what was in cell before you put cell in edit mode"]
[null,null,"Criteria",90,null,null,null,"To search for functions, use the fx button on the Formula Bar"]
[null,null,{"$f":"\"Count # >= \"&D32","v":"Count # >= 90"},{"$f":"COUNTIF(C23:C27,\">=\"&D32)","v":2},null,null,null,"When creating COUNTIF or COUNTIFS functions put comparative operators in"]
[null,null,"Criteria 1",50,null,null,null,"Double Quotes, like:  \">=\", and use Join Symbol (&) to join comparative operator"]
[null,null,"Criteria 2",100,null,null,null,"and number."]
[null,null,{"$f":"\"Counting Values Between \"&D34&\" and \"&D35&\" (inclusive)\"","v":"Counting Values Between 50 and 100 (inclusive)"},{"$f":"COUNTIFS(C23:C27,\">=\"&D34,C23:C27,\"<=\"&D35)","v":4},null,null,null,"Types of Formulas: Calculating, Text, Logical"]
[null,null,"Revenue",1000,null,null,null,"Keyboard shortcut for Auto Sum: Alt + ="]
[null,null,"Expense 1",250,null,null,null,"Keyboard shortcut to jump to bottom of a column: Ctrl + Arrow"]
[null,null,"Expense 2",100,null,null,null,"Keyboard shortcut for highlighting a column: Ctrl + Shift + Arrow"]
[null,null,"Expense 3",395]
[null,null,"Net Income",{"$f":"D37-SUM(D38:D40)","v":255}]
[]
[null,null,"All formulas so far have been \"Calculating Formulas\""]
[]
[null,null,"Text Formula"]
[null,null,{"$f":"\"The average is \"&D29","v":"The average is 82.8"}]
[]
[null,null,"TRUE/FALSE formula: Logical Formulas"]
[null,null,{"$f":"D30>D29","v":true},"Is Mode greater than Average: TRUE or FALSE?"]
[]
[]
[null,null,"Sales","Total"]
[null,null,95,{"$f":"SUM(C53:C641)","v":32200}]
[null,null,100]
[null,null,40]
[null,null,65]
[null,null,89]
[null,null,75]
[null,null,94]
[null,null,81]
[null,null,43]
[null,null,50]
[null,null,10]
[null,null,74]
[null,null,59]
[null,null,20]
[null,null,84]
[null,null,91]
[null,null,60]
[null,null,43]
[null,null,18]
[null,null,31]
[null,null,86]
[null,null,13]
[null,null,44]
[null,null,100]
[null,null,61]
[null,null,84]
[null,null,70]
[null,null,92]
[null,null,18]
[null,null,97]
[null,null,88]
[null,null,43]
[null,null,53]
[null,null,49]
[null,null,48]
[null,null,43]
[null,null,34]
[null,null,14]
[null,null,85]
[null,null,39]
[null,null,16]
[null,null,33]
[null,null,22]
[null,null,63]
[null,null,49]
[null,null,100]
[null,null,69]
[null,null,37]
[null,null,89]
[null,null,80]
[null,null,55]
[null,null,87]
[null,null,38]
[null,null,50]
[null,null,19]
[null,null,56]
[null,null,35]
[null,null,71]
[null,null,41]
[null,null,39]
[null,null,71]
[null,null,60]
[null,null,39]
[null,null,48]
[null,null,75]
[null,null,40]
[null,null,12]
[null,null,69]
[null,null,53]
[null,null,29]
[null,null,30]
[null,null,10]
[null,null,78]
[null,null,74]
[null,null,56]
[null,null,65]
[null,null,62]
[null,null,66]
[null,null,26]
[null,null,34]
[null,null,88]
[null,null,12]
[null,null,38]
[null,null,46]
[null,null,59]
[null,null,95]
[null,null,52]
[null,null,64]
[null,null,76]
[null,null,36]
[null,null,38]
[null,null,58]
[null,null,90]
[null,null,59]
[null,null,17]
[null,null,33]
[null,null,99]
[null,null,76]
[null,null,61]
[null,null,43]
[null,null,54]
[null,null,18]
[null,null,54]
[null,null,48]
[null,null,52]
[null,null,84]
[null,null,44]
[null,null,36]
[null,null,14]
[null,null,25]
[null,null,77]
[null,null,73]
[null,null,90]
[null,null,68]
[null,null,13]
[null,null,14]
[null,null,89]
[null,null,14]
[null,null,65]
[null,null,23]
[null,null,14]
[null,null,63]
[null,null,88]
[null,null,82]
[null,null,62]
[null,null,26]
[null,null,100]
[null,null,30]
[null,null,84]
[null,null,24]
[null,null,25]
[null,null,57]
[null,null,40]
[null,null,52]
[null,null,45]
[null,null,59]
[null,null,13]
[null,null,98]
[null,null,86]
[null,null,36]
[null,null,33]
[null,null,93]
[null,null,73]
[null,null,59]
[null,null,28]
[null,null,39]
[null,null,90]
[null,null,31]
[null,null,82]
[null,null,53]
[null,null,72]
[null,null,25]
[null,null,93]
[null,null,44]
[null,null,92]
[null,null,77]
[null,null,41]
[null,null,15]
[null,null,32]
[null,null,66]
[null,null,20]
[null,null,44]
[null,null,64]
[null,null,23]
[null,null,70]
[null,null,54]
[null,null,28]
[null,null,30]
[null,null,29]
[null,null,75]
[null,null,42]
[null,null,83]
[null,null,79]
[null,null,51]
[null,null,81]
[null,null,46]
[null,null,65]
[null,null,93]
[null,null,27]
[null,null,75]
[null,null,37]
[null,null,78]
[null,null,61]
[null,null,54]
[null,null,52]
[null,null,61]
[null,null,93]
[null,null,23]
[null,null,14]
[null,null,34]
[null,null,86]
[null,null,56]
[null,null,50]
[null,null,71]
[null,null,85]
[null,null,94]
[null,null,25]
[null,null,35]
[null,null,87]
[null,null,28]
[null,null,24]
[null,null,69]
[null,null,36]
[null,null,75]
[null,null,70]
[null,null,71]
[null,null,38]
[null,null,48]
[null,null,80]
[null,null,37]
[null,null,54]
[null,null,92]
[null,null,57]
[null,null,88]
[null,null,100]
[null,null,54]
[null,null,27]
[null,null,65]
[null,null,89]
[null,null,42]
[null,null,61]
[null,null,55]
[null,null,45]
[null,null,42]
[null,null,49]
[null,null,76]
[null,null,57]
[null,null,41]
[null,null,68]
[null,null,91]
[null,null,29]
[null,null,42]
[null,null,15]
[null,null,89]
[null,null,36]
[null,null,23]
[null,null,93]
[null,null,35]
[null,null,31]
[null,null,81]
[null,null,14]
[null,null,97]
[null,null,53]
[null,null,56]
[null,null,21]
[null,null,60]
[null,null,42]
[null,null,13]
[null,null,49]
[null,null,40]
[null,null,18]
[null,null,85]
[null,null,26]
[null,null,35]
[null,null,87]
[null,null,47]
[null,null,47]
[null,null,12]
[null,null,61]
[null,null,55]
[null,null,81]
[null,null,97]
[null,null,58]
[null,null,64]
[null,null,57]
[null,null,64]
[null,null,26]
[null,null,56]
[null,null,82]
[null,null,32]
[null,null,53]
[null,null,84]
[null,null,87]
[null,null,81]
[null,null,90]
[null,null,23]
[null,null,48]
[null,null,27]
[null,null,31]
[null,null,63]
[null,null,46]
[null,null,100]
[null,null,33]
[null,null,22]
[null,null,31]
[null,null,40]
[null,null,61]
[null,null,36]
[null,null,11]
[null,null,39]
[null,null,70]
[null,null,33]
[null,null,10]
[null,null,51]
[null,null,65]
[null,null,15]
[null,null,57]
[null,null,46]
[null,null,23]
[null,null,80]
[null,null,23]
[null,null,69]
[null,null,28]
[null,null,33]
[null,null,81]
[null,null,95]
[null,null,18]
[null,null,41]
[null,null,98]
[null,null,12]
[null,null,30]
[null,null,72]
[null,null,16]
[null,null,30]
[null,null,79]
[null,null,63]
[null,null,65]
[null,null,99]
[null,null,39]
[null,null,59]
[null,null,12]
[null,null,11]
[null,null,26]
[null,null,67]
[null,null,32]
[null,null,28]
[null,null,15]
[null,null,87]
[null,null,11]
[null,null,50]
[null,null,54]
[null,null,72]
[null,null,77]
[null,null,38]
[null,null,36]
[null,null,100]
[null,null,13]
[null,null,86]
[null,null,75]
[null,null,30]
[null,null,22]
[null,null,21]
[null,null,44]
[null,null,60]
[null,null,63]
[null,null,95]
[null,null,36]
[null,null,14]
[null,null,92]
[null,null,55]
[null,null,13]
[null,null,38]
[null,null,10]
[null,null,85]
[null,null,34]
[null,null,98]
[null,null,59]
[null,null,88]
[null,null,43]
[null,null,83]
[null,null,29]
[null,null,79]
[null,null,34]
[null,null,80]
[null,null,75]
[null,null,49]
[null,null,61]
[null,null,70]
[null,null,86]
[null,null,12]
[null,null,39]
[null,null,64]
[null,null,68]
[null,null,92]
[null,null,14]
[null,null,42]
[null,null,27]
[null,null,89]
[null,null,82]
[null,null,39]
[null,null,32]
[null,null,69]
[null,null,94]
[null,null,48]
[null,null,93]
[null,null,22]
[null,null,73]
[null,null,82]
[null,null,44]
[null,null,85]
[null,null,77]
[null,null,73]
[null,null,73]
[null,null,11]
[null,null,18]
[null,null,20]
[null,null,75]
[null,null,56]
[null,null,50]
[null,null,69]
[null,null,37]
[null,null,29]
[null,null,70]
[null,null,70]
[null,null,69]
[null,null,65]
[null,null,83]
[null,null,17]
[null,null,93]
[null,null,38]
[null,null,81]
[null,null,78]
[null,null,42]
[null,null,60]
[null,null,12]
[null,null,27]
[null,null,32]
[null,null,98]
[null,null,66]
[null,null,78]
[null,null,43]
[null,null,87]
[null,null,96]
[null,null,40]
[null,null,45]
[null,null,82]
[null,null,98]
[null,null,49]
[null,null,83]
[null,null,96]
[null,null,38]
[null,null,80]
[null,null,12]
[null,null,51]
[null,null,97]
[null,null,81]
[null,null,55]
[null,null,60]
[null,null,18]
[null,null,78]
[null,null,63]
[null,null,75]
[null,null,73]
[null,null,66]
[null,null,86]
[null,null,49]
[null,null,86]
[null,null,72]
[null,null,93]
[null,null,47]
[null,null,73]
[null,null,31]
[null,null,31]
[null,null,45]
[null,null,45]
[null,null,26]
[null,null,53]
[null,null,27]
[null,null,94]
[null,null,35]
[null,null,46]
[null,null,93]
[null,null,71]
[null,null,24]
[null,null,83]
[null,null,22]
[null,null,67]
[null,null,27]
[null,null,13]
[null,null,20]
[null,null,12]
[null,null,63]
[null,null,50]
[null,null,58]
[null,null,68]
[null,null,56]
[null,null,73]
[null,null,83]
[null,null,62]
[null,null,75]
[null,null,86]
[null,null,100]
[null,null,85]
[null,null,27]
[null,null,20]
[null,null,24]
[null,null,93]
[null,null,46]
[null,null,88]
[null,null,20]
[null,null,80]
[null,null,17]
[null,null,37]
[null,null,56]
[null,null,87]
[null,null,30]
[null,null,13]
[null,null,79]
[null,null,88]
[null,null,51]
[null,null,53]
[null,null,34]
[null,null,25]
[null,null,35]
[null,null,100]
[null,null,98]
[null,null,51]
[null,null,43]
[null,null,67]
[null,null,86]
[null,null,53]
[null,null,83]
[null,null,70]
[null,null,32]
[null,null,18]
[null,null,74]
[null,null,23]
[null,null,31]
[null,null,48]
[null,null,65]
[null,null,90]
[null,null,51]
[null,null,99]
[null,null,25]
[null,null,26]
[null,null,41]
[null,null,86]
[null,null,94]
[null,null,28]
[null,null,21]
[null,null,63]
[null,null,82]
[null,null,72]
[null,null,42]
[null,null,66]
[null,null,70]
[null,null,85]
[null,null,56]
[null,null,24]
[null,null,45]
[null,null,81]
[null,null,29]
[null,null,62]
[null,null,13]
[null,null,29]
[null,null,51]
[null,null,31]
[null,null,63]
[null,null,13]
[null,null,42]
[null,null,43]
[null,null,46]
[null,null,91]
[null,null,31]
[null,null,42]
[null,null,46]
[null,null,48]
[null,null,72]
[null,null,11]
[null,null,86]
[null,null,78]
[null,null,47]
[null,null,70]
[null,null,81]
[null,null,42]
[null,null,73]
[null,null,56]
[null,null,23]
[null,null,98]
[null,null,98]
[null,null,51]
[null,null,21]
[null,null,28]
[null,null,45]
[null,null,53]
[null,null,92]
[null,null,80]
[null,null,48]
[null,null,25]
[null,null,90]
[null,null,23]
[null,null,57]
[null,null,32]
[null,null,57]
[null,null,93]
[null,null,85]
[null,null,80]
[null,null,45]
[null,null,14]

{"sheet":"Number Formatting","index":4,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Formatting is a Façade. It sits on top of the value or text that is entered into the cell."]
["Don't get tricked by formatting. When in doubt apply the General Format in the Number tab and see what is really in the cell."]
["Format Cells Dialog Box keyboard shortcut: Ctrl + 1."]
["The Number tab in the Format Dialog Box controls what Number format is applied."]
[]
[]
["Accounting Number format",null,"Percentages"]
[4.125,null,"Step 0",0.03]
[5.1257999999999999,null,"Step 1",".03*100 = 3"]
[5.9799999999999999E-2,null,"Step 2","3%"]
[]
["Comma Number format",null,"Percentage Number format"]
[4.125,null,"Situation 1:","Type .03 in cell, then add % format"]
[5.1257999999999999,null,"Situation 2:","Type 3 in cell, then add % format"]
[5.9799999999999999E-2,null,"Situation 3:","Add % format, then type 3, Enter"]
[null,null,"Situation 4:","Add % format, then type .03, Enter"]
["Currency Number format",null,"Situation 5:","Add % format as you type"]
[4.125,null,"Situation 6:","Type .025, then add % from ribbon"]
[5.1257999999999999]
[5.9799999999999999E-2,null,"To See Proportions or Probabilities without Percentage Number Format, Apply General Number format or Increase Decimals."]
[null,null,null,"Percentage with No Decimals are showing",0.12589]
[null,null,null,"Percentage with Two Decimal Showing",0.25580000000000003]
[null,null,null,"Two Decimal Showing",1.2454E-2]
[null,null,null,"No Decimal Showing",0.49,null,3,"All"]
[null,null,null,"The proportion of students in past who received a 3.0",null,null,42,1255]
[null,null,null,"Based on last quarters class the probability that you will get a 3.0 is:",null,null,4,32]

{"sheet":"Number Formatting (an)","index":5,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Formatting is a Façade. It sits on top of the value or text that is entered into the cell."]
["Don't get tricked by formatting. When in doubt apply the General Format in the Number tab and see what is really in the cell."]
["Format Cells Dialog Box keyboard shortcut: Ctrl + 1."]
["The Number tab in the Format Dialog Box controls what Number format is applied."]
[]
[]
["Accounting Number format",null,"Percentages"]
[4.125,null,"Step 0",0.03]
[5.1257999999999999,null,"Step 1",".03*100 = 3"]
[5.9799999999999999E-2,null,"Step 2","3%"]
[]
["Comma Number format",null,"Percentage Number format"]
[4.125,null,"Situation 1:","Type .03 in cell, then add % format",0.03]
[5.1257999999999999,null,"Situation 2:","Type 3 in cell, then add % format",3]
[5.9799999999999999E-2,null,"Situation 3:","Add % format, then type 3, Enter",0.03]
[null,null,"Situation 4:","Add % format, then type .03, Enter",0.03]
["Currency Number format",null,"Situation 5:","Add % format as you type",0.03]
[4.125,null,"Situation 6:","Type .025, then add % from ribbon",2.5000000000000001E-2]
[5.1257999999999999]
[5.9799999999999999E-2,null,"To See Proportions or Probabilities without Percentage Number Format, Apply General Number format or Increase Decimals."]
[null,null,null,"Percentage with No Decimals are showing",0.12589]
[null,null,null,"Percentage with Two Decimal Showing",0.25580000000000003,null,"General Number Format = Ctrl + Shift + ~"]
[null,null,null,"Two Decimal Showing",1.2454E-2]
[null,null,null,"No Decimal Showing",0.49,null,3,"All"]
[null,null,null,"The proportion of students in past who received a 3.0",{"$f":"G25/H25","v":3.3466135458167331E-2},null,42,1255]
[null,null,null,"Based on last quarters class the probability that you will get a 3.0 is:",{"$f":"G26/H26","v":0.125},null,4,32]
[]
[null,null,null,null,{"$f":"100*E25","v":3.3466135458167332}]

{"sheet":"DataSets","index":6,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Data Sets Must Follow These Rules:"]
[]
["Date","AutoSold","Sales",null,1,"<<== Column Headers, Column Labels, Field Names, Variables"]
["2011-06-13","Honda",15546,null,2," <<== Each row is called a Record or Observation"]
["2011-06-14","Honda",25857,null,null," <<== Each row is called a Record or Observation"]
["2011-06-15","Honda",22494,null,null," <<== Each row is called a Record or Observation"]
["2011-06-16","Toyota",22479,null,null," <<== Each row is called a Record or Observation"]
["2011-06-17","Toyota",30664,null,null," <<== Each row is called a Record or Observation"]
["2011-06-18","Ford",19252,null,null," <<== Each row is called a Record or Observation"]
["2011-06-19","Toyota",26478,null,null," <<== Each row is called a Record or Observation"]
["2011-06-20","Toyota",15996,null,null," <<== Each row is called a Record or Observation"]
[]
["AutoSold","Frequency (Count)",null,null,3,"Blank cells, Excel Row Headers (Numbers), or Excel Column"]
["Honda",null,null,null,null,"Headers (Letters) must surround data set"]
["Toyota"]
["Ford",null,null,null,4,"No blank field names, and try not to have blanks in data set."]
[]
[]
[]
[5,"Elements = Primary Key (Unique Identifier) = Unique List = Listing of each"]
[null,"items of interest only once so you can make some summary calculation."]

{"sheet":"Data Analysis(1)","index":7,"n_rows":593,"n_cols":8,"rows_kept":593,"cut":false,"hidden":false,"merged":[]}
["Sorting can be done with the A to Z or Z to A buttons on the Data Ribbon: BE SURE TO ONLY HAVE ONE CELL SELECTED IN THE COLUMNS THAT YOU WANT TO SORT UPON."]
[]
["Date","Sales Rep","Customer","Sales","COGS","Region",null,"Don’T Worry"]
["2007-06-06","Chin","PCC",138,67.62,"East",null,"If Your Data"]
["2007-11-17","Sioux","Safeway",230,165.6,"NorthEast",null,"Set Is Not In"]
["2005-07-06","Tina","Safeway",130,62.4,"NorthWest",null,"The Same"]
["2006-11-06","Joy","Coop",188,112.8,"NorthWest",null,"Order When"]
["2008-03-21","Chin","Coop",203,158.34,"NorthWest",null,"You Start"]
["2005-06-16","Sioux","Safeway",1656,1275.1199999999999,"MidWest",null,"Watching"]
["2006-03-12","Sioux","Fred Myer",156,84.24,"West",null,"The Video."]
["2006-08-08","Sioux","Whole Foods",177,83.19,"NorthEast",null,"After You"]
["2007-09-10","Tina","Coop",53,32.86,"West",null,"Sort You Will"]
["2007-11-16","Sioux","Coop",998,658.68,"East",null,"See The"]
["2006-12-06","Joy","PCC",186,81.84,"NorthEast",null,"Same Thing."]
["2006-03-18","Sioux","Fred Myer",87,34.799999999999997,"East"]
["2007-12-03","Joy","PCC",1028,771,"East"]
["2006-01-07","Sioux","Coop",93,60.45,"NorthEast"]
["2005-09-20","Sioux","Coop",70,42.7,"NorthEast"]
["2006-10-18","Tom","Coop",80,48.8,"East"]
["2006-10-02","Tom","Whole Foods",219,109.5,"East"]
["2006-07-17","Chin","PCC",88,37.840000000000003,"East"]
["2006-05-21","Joy","Fred Myer",103,67.98,"MidWest"]
["2007-12-25","Tina","PCC",131,79.91,"MidWest"]
["2008-06-14","Sioux","Whole Foods",125,55,"NorthEast"]
["2007-05-06","Chin","PCC",1940,931.2,"West"]
["2008-06-22","Tom","PCC",225,153,"MidWest"]
["2005-08-23","Tom","Whole Foods",178,115.7,"NorthWest"]
["2007-04-16","Tom","Safeway",159,116.07,"NorthEast"]
["2008-02-10","Sioux","Safeway",183,115.29,"West"]
["2007-12-11","Sioux","Whole Foods",1680,705.6,"West"]
["2006-12-18","Tina","Fred Myer",231,106.26,"NorthEast"]
["2008-04-20","Sioux","Fred Myer",1399,1077.23,"NorthEast"]
["2007-01-18","Sioux","Fred Myer",233,132.81,"West"]
["2005-08-22","Tom","Fred Myer",250,145,"MidWest"]
["2008-05-27","Chin","Whole Foods",193,140.88999999999999,"East"]
["2005-11-25","Joy","Fred Myer",183,78.69,"MidWest"]
["2007-02-20","Joy","Fred Myer",750,502.5,"NorthWest"]
["2006-12-30","Tom","Whole Foods",1928,867.6,"East"]
["2006-06-26","Chin","PCC",136,108.8,"East"]
["2008-03-30","Sioux","PCC",63,30.24,"MidWest"]
["2007-01-19","Joy","Fred Myer",171,104.31,"West"]
["2007-04-18","Joy","PCC",191,116.51,"East"]
["2007-02-09","Sioux","Whole Foods",1276,714.56,"MidWest"]
["2007-03-27","Sioux","Coop",1450,1116.5,"NorthEast"]
["2006-12-31","Chin","PCC",216,155.52000000000001,"NorthWest"]
["2005-12-08","Sioux","PCC",214,162.63999999999999,"NorthWest"]
["2005-08-03","Tom","PCC",232,160.08000000000001,"West"]
["2007-04-28","Chin","PCC",104,72.8,"NorthEast"]
["2008-05-22","Sioux","Fred Myer",72,55.44,"West"]
["2007-03-04","Tina","PCC",1061,583.54999999999995,"West"]
["2006-01-05","Chin","Whole Foods",151,64.930000000000007,"MidWest"]
["2006-05-20","Sioux","Safeway",131,104.8,"NorthEast"]
["2005-08-01","Sioux","Whole Foods",949,740.22,"East"]
["2008-03-02","Joy","Fred Myer",129,81.27,"MidWest"]
["2007-12-27","Sioux","Fred Myer",244,185.44,"East"]
["2005-09-19","Joy","PCC",83,60.59,"East"]
["2007-07-09","Chin","Whole Foods",123,63.96,"MidWest"]
["2008-01-29","Sioux","Safeway",160,91.2,"NorthEast"]
["2007-12-07","Chin","Coop",763,480.69,"East"]
["2006-05-18","Tina","Safeway",115,57.5,"NorthWest"]
["2007-03-16","Joy","PCC",82,52.48,"MidWest"]
["2005-10-03","Chin","Fred Myer",223,115.96,"NorthWest"]
["2007-02-02","Chin","Coop",1104,805.92,"East"]
["2008-05-23","Sioux","Safeway",96,50.88,"West"]
["2006-11-26","Tina","PCC",88,37.840000000000003,"NorthEast"]
["2008-03-02","Chin","Safeway",77,31.57,"NorthWest"]
["2005-06-13","Chin","PCC",130,85.8,"NorthWest"]
["2008-03-18","Chin","Fred Myer",61,45.75,"East"]
["2007-04-28","Sioux","Fred Myer",1746,1187.28,"West"]
["2006-09-26","Tina","Whole Foods",760,342,"NorthWest"]
["2006-11-28","Tom","Fred Myer",208,160.16,"NorthWest"]
["2007-07-17","Joy","Safeway",243,182.25,"East"]
["2005-08-06","Tom","PCC",157,108.33,"NorthEast"]
["2006-12-29","Sioux","Coop",232,120.64,"NorthEast"]
["2007-09-07","Chin","PCC",170,136,"NorthWest"]
["2007-05-31","Joy","Coop",1223,758.26,"West"]
["2007-01-30","Joy","Whole Foods",237,123.24,"West"]
["2005-10-14","Joy","PCC",1386,1108.8,"NorthWest"]
["2006-08-16","Chin","Safeway",114,64.98,"East"]
["2007-12-15","Sioux","Whole Foods",250,110,"NorthWest"]
["2007-12-03","Chin","Fred Myer",80,40.799999999999997,"MidWest"]
["2006-01-25","Tina","Safeway",188,75.2,"NorthEast"]
["2008-03-16","Chin","Fred Myer",190,98.8,"MidWest"]
["2006-10-29","Chin","Fred Myer",195,78,"West"]
["2008-02-10","Tom","Safeway",78,44.46,"NorthEast"]
["2007-07-17","Joy","Safeway",815,448.25,"NorthEast"]
["2007-12-27","Sioux","Coop",131,55.02,"NorthWest"]
["2007-11-07","Tom","Fred Myer",814,407,"NorthEast"]
["2008-01-24","Tina","Fred Myer",154,120.12,"West"]
["2008-05-14","Chin","Fred Myer",177,79.650000000000006,"NorthEast"]
["2006-11-08","Chin","Fred Myer",1023,470.58,"NorthWest"]
["2005-12-21","Joy","Safeway",194,147.44,"MidWest"]
["2005-10-01","Sioux","Fred Myer",113,83.62,"West"]
["2005-08-08","Joy","Fred Myer",224,145.6,"NorthWest"]
["2008-01-30","Chin","Coop",248,181.04,"East"]
["2007-01-22","Sioux","Fred Myer",810,380.7,"MidWest"]
["2007-02-07","Tina","Safeway",57,40.47,"West"]
["2007-08-10","Tom","Safeway",236,167.56,"West"]
["2006-11-04","Joy","PCC",159,71.55,"NorthEast"]
["2007-03-01","Chin","Fred Myer",241,161.47,"NorthEast"]
["2006-03-15","Chin","Fred Myer",224,100.8,"East"]
["2007-04-30","Joy","PCC",190,104.5,"MidWest"]
["2007-04-03","Chin","PCC",696,542.88,"MidWest"]
["2007-01-06","Joy","PCC",88,40.479999999999997,"West"]
["2007-01-08","Chin","Whole Foods",137,79.459999999999994,"NorthEast"]
["2008-05-06","Chin","Fred Myer",1945,1108.6500000000001,"NorthEast"]
["2006-10-10","Joy","PCC",77,46.97,"East"]
["2005-12-04","Chin","Safeway",93,61.38,"NorthWest"]
["2005-12-04","Sioux","PCC",157,73.790000000000006,"West"]
["2005-10-24","Tina","Whole Foods",119,84.49,"NorthEast"]
["2006-10-28","Chin","Fred Myer",152,95.76,"East"]
["2007-08-28","Tom","Whole Foods",239,160.13,"NorthEast"]
["2007-06-08","Joy","Whole Foods",191,135.61000000000001,"West"]
["2006-04-17","Sioux","PCC",1983,1110.48,"NorthEast"]
["2006-02-23","Tina","Fred Myer",127,85.09,"NorthWest"]
["2007-07-05","Tina","Fred Myer",167,93.52,"NorthEast"]
["2007-06-27","Tina","Fred Myer",1947,1343.43,"East"]
["2007-12-03","Joy","Coop",139,65.33,"NorthEast"]
["2006-04-30","Chin","Safeway",217,171.43,"NorthEast"]
["2008-06-13","Joy","Coop",53,24.38,"NorthWest"]
["2006-06-13","Joy","Safeway",51,26.52,"East"]
["2006-10-04","Sioux","PCC",72,32.4,"East"]
["2008-06-24","Joy","Whole Foods",78,59.28,"MidWest"]
["2008-02-06","Joy","PCC",151,95.13,"NorthEast"]
["2006-01-10","Joy","Safeway",189,143.63999999999999,"MidWest"]
["2008-05-08","Tina","Whole Foods",110,86.9,"West"]
["2007-02-10","Sioux","Coop",173,115.91,"NorthWest"]
["2006-01-20","Joy","PCC",153,81.09,"MidWest"]
["2008-04-12","Tom","PCC",55,42.35,"NorthEast"]
["2008-03-27","Tina","Fred Myer",220,107.8,"East"]
["2007-06-23","Tom","PCC",191,108.87,"MidWest"]
["2006-04-17","Sioux","Safeway",1062,626.58000000000004,"East"]
["2006-02-02","Tina","Fred Myer",77,30.8,"West"]
["2007-03-19","Joy","Safeway",191,78.31,"NorthEast"]
["2007-02-17","Joy","Coop",139,98.69,"MidWest"]
["2008-06-03","Sioux","Fred Myer",220,149.6,"West"]
["2008-05-12","Sioux","Safeway",82,59.86,"MidWest"]
["2005-11-03","Tina","Coop",130,75.400000000000006,"MidWest"]
["2008-02-26","Tom","Whole Foods",237,158.79,"MidWest"]
["2006-11-29","Joy","Fred Myer",65,48.75,"East"]
["2005-11-01","Joy","PCC",145,105.85,"West"]
["2006-03-14","Sioux","Fred Myer",203,83.23,"NorthEast"]
["2006-04-01","Joy","PCC",186,122.76,"NorthWest"]
["2007-11-18","Joy","Coop",1541,1063.29,"NorthEast"]
["2005-08-31","Joy","Safeway",171,88.92,"MidWest"]
["2007-11-26","Joy","PCC",869,521.4,"NorthEast"]
["2007-08-06","Chin","Coop",107,62.06,"West"]
["2007-12-01","Tom","Coop",158,71.099999999999994,"West"]
["2007-07-29","Tom","Whole Foods",137,60.28,"MidWest"]
["2008-02-27","Joy","Coop",240,151.19999999999999,"NorthEast"]
["2005-12-21","Chin","Safeway",1151,563.99,"West"]
["2007-06-19","Sioux","Fred Myer",93,68.819999999999993,"East"]
["2007-03-13","Chin","Whole Foods",161,78.89,"MidWest"]
["2006-10-07","Sioux","Fred Myer",209,100.32,"NorthWest"]
["2006-05-30","Chin","Whole Foods",97,50.44,"NorthWest"]
["2008-04-02","Chin","Fred Myer",189,75.599999999999994,"MidWest"]
["2006-08-11","Tina","Fred Myer",235,157.44999999999999,"East"]
["2005-11-17","Tom","Coop",214,136.96,"West"]
["2005-08-08","Tina","Fred Myer",144,67.680000000000007,"NorthWest"]
["2007-03-09","Tom","PCC",61,45.14,"NorthEast"]
["2007-11-26","Tom","Whole Foods",160,86.4,"West"]
["2007-03-13","Tina","Whole Foods",102,61.2,"West"]
["2005-08-05","Joy","Coop",89,51.62,"West"]
["2007-03-16","Chin","Whole Foods",137,105.49,"MidWest"]
["2008-04-18","Tom","Fred Myer",183,78.69,"NorthEast"]
["2006-07-17","Tom","Fred Myer",188,82.72,"NorthEast"]
["2006-04-11","Tom","Fred Myer",1779,1298.67,"East"]
["2007-12-11","Chin","Safeway",219,168.63,"NorthEast"]
["2006-04-22","Tina","Whole Foods",216,110.16,"West"]
["2005-09-06","Chin","PCC",1158,509.52,"East"]
["2007-12-07","Chin","PCC",75,47.25,"NorthEast"]
["2006-11-06","Tom","Safeway",240,100.8,"East"]
["2007-08-07","Tom","Safeway",55,37.4,"NorthEast"]
["2008-06-18","Chin","Safeway",86,55.04,"East"]
["2008-06-05","Sioux","Coop",181,86.88,"West"]
["2008-05-07","Chin","PCC",126,75.599999999999994,"MidWest"]
["2007-09-16","Sioux","Fred Myer",206,115.36,"East"]
["2008-06-22","Sioux","PCC",166,132.80000000000001,"MidWest"]
["2008-06-22","Joy","Safeway",1407,830.13,"East"]
["2007-09-22","Tina","Coop",181,139.37,"MidWest"]
["2008-01-25","Tom","PCC",157,120.89,"MidWest"]
["2006-10-12","Tom","PCC",234,102.96,"East"]
["2006-08-11","Tina","Safeway",238,166.6,"West"]
["2007-01-14","Tom","Safeway",203,87.29,"East"]
["2008-03-27","Chin","Safeway",160,108.8,"East"]
["2007-10-07","Joy","Fred Myer",186,126.48,"West"]
["2006-02-28","Tina","Coop",628,263.76,"East"]
["2007-02-03","Chin","Fred Myer",63,27.09,"East"]
["2007-10-09","Tom","Coop",199,95.52,"East"]
["2006-09-17","Tina","Safeway",94,47,"NorthEast"]
["2006-06-20","Chin","Whole Foods",1622,713.68,"West"]
["2005-08-13","Sioux","Safeway",151,102.68,"MidWest"]
["2005-09-02","Chin","Coop",52,35.880000000000003,"NorthEast"]
["2005-12-31","Tom","Safeway",66,34.979999999999997,"East"]
["2007-12-08","Chin","Fred Myer",60,27.6,"MidWest"]
["2006-07-23","Tom","Fred Myer",66,31.02,"West"]
["2007-07-17","Tina","Whole Foods",58,24.36,"West"]
["2007-07-18","Joy","Safeway",81,50.22,"East"]
["2005-10-31","Tina","Whole Foods",73,34.31,"West"]
["2006-03-30","Chin","PCC",55,22,"East"]
["2007-06-25","Joy","Coop",249,179.28,"West"]
["2005-11-09","Chin","Coop",1399,1077.23,"East"]
["2008-05-16","Tina","Fred Myer",222,168.72,"MidWest"]
["2007-02-28","Chin","Whole Foods",751,570.76,"NorthEast"]
["2006-10-11","Tina","Fred Myer",237,137.46,"MidWest"]
["2008-01-12","Sioux","Coop",141,83.19,"NorthWest"]
["2007-04-30","Chin","Coop",81,34.020000000000003,"NorthEast"]
["2005-11-07","Tom","Fred Myer",85,40.799999999999997,"West"]
["2007-06-27","Sioux","Coop",205,139.4,"West"]
["2006-01-07","Sioux","PCC",1435,574,"West"]
["2005-06-22","Chin","Whole Foods",1154,484.68,"West"]
["2005-06-07","Tom","Whole Foods",242,179.08,"West"]
["2006-05-16","Sioux","Coop",73,48.91,"West"]
["2006-11-22","Sioux","Safeway",242,166.98,"NorthWest"]
["2007-03-03","Joy","PCC",213,108.63,"West"]
["2007-06-09","Sioux","Whole Foods",220,99,"MidWest"]
["2005-05-31","Sioux","Safeway",169,89.57,"NorthWest"]
["2005-06-30","Tina","Coop",197,98.5,"East"]
["2007-06-15","Chin","Whole Foods",107,66.34,"MidWest"]
["2007-08-30","Tom","Fred Myer",55,29.7,"NorthEast"]
["2007-05-14","Tom","Coop",104,61.36,"NorthWest"]
["2007-02-24","Sioux","Whole Foods",90,36.9,"MidWest"]
["2006-05-11","Joy","Fred Myer",1917,996.84,"East"]
["2008-02-04","Joy","Fred Myer",228,180.12,"NorthEast"]
["2006-09-04","Chin","Fred Myer",204,95.88,"NorthEast"]
["2006-03-12","Sioux","PCC",133,54.53,"East"]
["2006-03-14","Tom","Fred Myer",206,140.08000000000001,"NorthWest"]
["2006-12-20","Chin","Safeway",96,44.16,"NorthWest"]
["2006-10-16","Sioux","PCC",182,120.12,"MidWest"]
["2008-02-12","Joy","Coop",1095,558.45000000000005,"MidWest"]
["2007-12-08","Tom","PCC",69,54.51,"East"]
["2006-05-30","Sioux","PCC",124,79.36,"NorthEast"]
["2006-05-14","Tina","Fred Myer",221,121.55,"NorthWest"]
["2007-09-07","Chin","Fred Myer",1430,672.1,"West"]
["2006-12-18","Sioux","Fred Myer",144,105.12,"NorthWest"]
["2008-05-31","Joy","PCC",870,495.9,"East"]
["2007-01-20","Tina","Whole Foods",204,116.28,"NorthWest"]
["2007-04-07","Tom","PCC",119,69.02,"NorthWest"]
["2007-12-10","Tina","Coop",182,96.46,"East"]
["2005-08-05","Sioux","Safeway",140,107.8,"MidWest"]
["2006-11-27","Tom","Whole Foods",122,92.72,"East"]
["2007-10-08","Chin","PCC",1923,1519.17,"NorthWest"]
["2005-10-06","Tom","Safeway",208,122.72,"NorthWest"]
["2007-05-13","Sioux","PCC",235,152.75,"NorthWest"]
["2007-11-20","Chin","Fred Myer",576,328.32,"West"]
["2007-03-18","Sioux","PCC",132,76.56,"MidWest"]
["2007-11-21","Joy","PCC",536,225.12,"NorthEast"]
["2007-07-29","Joy","Coop",106,61.48,"West"]
["2008-06-30","Joy","Whole Foods",175,105,"NorthWest"]
["2007-09-28","Joy","PCC",209,133.76,"NorthWest"]
["2006-07-12","Tina","PCC",63,30.87,"West"]
["2007-05-27","Tom","PCC",1402,686.98,"MidWest"]
["2008-03-01","Sioux","Fred Myer",222,106.56,"East"]
["2006-11-09","Joy","Whole Foods",155,75.95,"West"]
["2007-06-01","Tina","Fred Myer",91,50.05,"NorthEast"]
["2007-06-10","Chin","Whole Foods",519,285.45,"NorthWest"]
["2005-07-21","Tom","Coop",1436,1019.56,"West"]
["2007-10-17","Chin","Safeway",698,488.6,"NorthEast"]
["2007-05-14","Tom","Safeway",143,98.67,"MidWest"]
["2007-06-20","Tom","Whole Foods",191,95.5,"East"]
["2008-06-28","Sioux","PCC",184,141.68,"MidWest"]
["2006-01-03","Tom","Fred Myer",162,69.66,"West"]
["2005-11-14","Sioux","Coop",79,55.3,"NorthWest"]
["2006-08-29","Tom","PCC",63,37.17,"West"]
["2006-03-13","Chin","Fred Myer",1550,868,"West"]
["2008-02-12","Joy","Fred Myer",132,80.52,"MidWest"]
["2006-01-17","Tom","Fred Myer",170,132.6,"NorthWest"]
["2007-03-01","Sioux","Fred Myer",84,59.64,"MidWest"]
["2005-08-08","Tom","PCC",180,79.2,"NorthEast"]
["2007-10-22","Joy","Safeway",961,643.87,"West"]
["2008-05-03","Tom","Coop",241,185.57,"NorthWest"]
["2005-10-13","Tina","Safeway",114,69.540000000000006,"West"]
["2005-08-29","Joy","Safeway",239,174.47,"NorthWest"]
["2006-10-27","Chin","Coop",73,37.229999999999997,"East"]
["2007-06-09","Chin","Safeway",171,92.34,"NorthWest"]
["2007-05-23","Tina","Safeway",140,75.599999999999994,"West"]
["2008-02-09","Joy","Safeway",103,69.010000000000005,"MidWest"]
["2005-12-05","Joy","PCC",142,92.3,"East"]
["2006-08-18","Joy","Whole Foods",203,154.28,"NorthEast"]
["2008-02-17","Sioux","Safeway",193,108.08,"East"]
["2005-11-16","Sioux","Fred Myer",209,154.66,"NorthWest"]
["2006-05-18","Tina","Fred Myer",54,40.5,"East"]
["2007-07-13","Tom","Fred Myer",113,76.84,"MidWest"]
["2006-10-19","Tom","Whole Foods",205,145.55000000000001,"West"]
["2006-01-13","Tom","Safeway",70,51.8,"NorthWest"]
["2005-10-25","Sioux","Whole Foods",74,48.84,"MidWest"]
["2007-09-15","Tom","PCC",853,562.98,"West"]
["2006-10-05","Tom","PCC",55,28.6,"MidWest"]
["2007-10-23","Sioux","Coop",124,80.599999999999994,"NorthEast"]
["2006-04-10","Sioux","PCC",90,38.700000000000003,"MidWest"]
["2006-10-29","Tina","Safeway",110,75.900000000000006,"MidWest"]
["2007-10-15","Tom","Coop",68,31.28,"West"]
["2006-08-14","Sioux","Fred Myer",74,59.2,"MidWest"]
["2005-06-12","Tina","Safeway",86,59.34,"NorthWest"]
["2006-06-16","Joy","Fred Myer",200,158,"NorthEast"]
["2005-07-18","Tina","PCC",64,43.52,"East"]
["2007-07-12","Chin","Coop",1051,756.72,"NorthWest"]
["2005-10-30","Joy","Fred Myer",1756,965.8,"West"]
["2006-06-30","Chin","Fred Myer",204,153,"MidWest"]
["2007-07-12","Tina","Whole Foods",226,97.18,"NorthEast"]
["2006-04-24","Sioux","PCC",185,138.75,"NorthEast"]
["2006-05-23","Chin","Safeway",141,105.75,"MidWest"]
["2007-05-03","Tina","Fred Myer",228,114,"NorthWest"]
["2007-04-30","Joy","PCC",125,77.5,"MidWest"]
["2006-04-12","Tina","PCC",53,29.68,"NorthWest"]
["2006-09-04","Joy","PCC",61,35.380000000000003,"West"]
["2007-10-23","Tina","Whole Foods",166,129.47999999999999,"MidWest"]
["2006-07-26","Tina","Coop",119,51.17,"West"]
["2008-07-01","Tina","Whole Foods",112,62.72,"NorthEast"]
["2006-01-24","Joy","PCC",178,133.5,"NorthWest"]
["2007-03-18","Joy","Coop",114,52.44,"West"]
["2007-03-08","Tina","PCC",212,125.08,"West"]
["2006-10-01","Tom","Whole Foods",87,62.64,"NorthEast"]
["2008-01-23","Tina","Fred Myer",510,280.5,"MidWest"]
["2007-06-17","Joy","PCC",69,54.51,"NorthEast"]
["2005-08-01","Tom","Fred Myer",142,86.62,"MidWest"]
["2005-10-07","Sioux","Fred Myer",63,49.14,"East"]
["2007-05-30","Tom","Whole Foods",67,40.869999999999997,"MidWest"]
["2008-01-06","Tom","Fred Myer",245,120.05,"NorthEast"]
["2006-04-25","Sioux","PCC",96,76.8,"East"]
["2006-11-23","Tina","Coop",202,103.02,"West"]
["2006-06-16","Joy","Fred Myer",113,73.45,"East"]
["2008-06-02","Joy","Safeway",119,61.88,"East"]
["2006-01-01","Tina","Whole Foods",184,86.48,"East"]
["2006-07-22","Joy","Fred Myer",232,102.08,"East"]
["2007-10-30","Tom","Safeway",1607,1124.9000000000001,"NorthEast"]
["2007-08-22","Tina","Safeway",88,49.28,"East"]
["2006-04-06","Tina","PCC",55,26.95,"NorthEast"]
["2006-09-30","Tom","Safeway",128,61.44,"NorthWest"]
["2007-11-19","Tina","Whole Foods",210,134.4,"NorthWest"]
["2006-06-23","Sioux","Whole Foods",58,35.96,"MidWest"]
["2005-11-29","Tom","PCC",80,36,"West"]
["2005-12-25","Sioux","PCC",75,57.75,"MidWest"]
["2006-10-19","Tom","Fred Myer",163,122.25,"West"]
["2006-04-12","Tina","Coop",89,37.380000000000003,"NorthEast"]
["2008-02-25","Chin","Safeway",234,114.66,"NorthWest"]
["2006-11-19","Tom","Safeway",122,51.24,"NorthEast"]
["2006-11-08","Tina","Whole Foods",71,37.630000000000003,"NorthWest"]
["2006-12-30","Chin","Safeway",64,34.56,"NorthWest"]
["2006-05-29","Chin","Whole Foods",110,88,"NorthEast"]
["2008-03-23","Tina","Safeway",603,295.47000000000003,"MidWest"]
["2005-11-24","Chin","Whole Foods",113,67.8,"MidWest"]
["2006-05-31","Tina","PCC",122,76.86,"MidWest"]
["2005-06-09","Chin","PCC",166,112.88,"MidWest"]
["2007-05-06","Sioux","Coop",192,138.24,"MidWest"]
["2007-12-06","Tina","Fred Myer",118,93.22,"West"]
["2006-06-16","Sioux","Whole Foods",88,51.92,"MidWest"]
["2006-10-13","Tina","Fred Myer",92,65.319999999999993,"East"]
["2007-10-27","Joy","Coop",144,87.84,"NorthWest"]
["2007-12-11","Tina","Coop",1658,1094.28,"MidWest"]
["2006-12-13","Tina","Safeway",175,126,"NorthEast"]
["2007-01-02","Joy","Whole Foods",180,97.2,"East"]
["2007-07-08","Joy","Fred Myer",52,36.4,"NorthWest"]
["2006-04-21","Sioux","Whole Foods",221,154.69999999999999,"West"]
["2006-10-20","Joy","Fred Myer",77,60.83,"West"]
["2008-04-13","Joy","Whole Foods",76,32.68,"West"]
["2006-03-02","Tom","Whole Foods",1569,737.43,"NorthEast"]
["2005-07-12","Tom","PCC",183,96.99,"NorthEast"]
["2007-03-30","Joy","Whole Foods",153,122.4,"NorthEast"]
["2005-08-25","Tina","Fred Myer",238,138.04,"East"]
["2007-09-18","Tom","Fred Myer",1426,627.44000000000005,"West"]
["2005-07-02","Tina","PCC",143,81.510000000000005,"NorthEast"]
["2006-08-03","Chin","Coop",66,31.02,"NorthEast"]
["2007-09-10","Tina","Whole Foods",139,88.96,"MidWest"]
["2008-01-23","Tom","PCC",162,95.58,"East"]
["2005-12-11","Joy","PCC",169,69.290000000000006,"NorthWest"]
["2005-06-19","Tina","Fred Myer",174,113.1,"MidWest"]
["2005-10-16","Chin","Whole Foods",68,42.16,"West"]
["2008-01-18","Joy","Fred Myer",123,97.17,"West"]
["2006-12-08","Joy","Whole Foods",97,65.959999999999994,"West"]
["2006-02-18","Joy","PCC",194,147.44,"NorthWest"]
["2008-05-06","Tom","Coop",1020,479.4,"NorthWest"]
["2008-04-02","Tom","Whole Foods",206,96.82,"MidWest"]
["2007-01-09","Joy","Safeway",76,57,"MidWest"]
["2005-10-20","Sioux","Fred Myer",75,50.25,"West"]
["2008-03-08","Chin","Whole Foods",96,48.96,"MidWest"]
["2007-05-24","Tom","Whole Foods",81,46.98,"NorthEast"]
["2007-01-02","Sioux","Coop",85,61.2,"NorthWest"]
["2008-01-11","Tom","Safeway",51,31.62,"MidWest"]
["2007-07-10","Sioux","PCC",201,134.66999999999999,"NorthWest"]
["2006-12-23","Joy","Coop",1494,1150.3800000000001,"MidWest"]
["2008-01-22","Tom","Fred Myer",247,140.79,"West"]
["2006-05-17","Sioux","PCC",139,59.77,"NorthWest"]
["2006-10-30","Tina","PCC",236,146.32,"East"]
["2005-12-24","Sioux","PCC",82,50.02,"West"]
["2007-09-14","Tina","Safeway",106,58.3,"East"]
["2007-03-18","Sioux","Whole Foods",95,47.5,"NorthEast"]
["2006-12-25","Chin","Whole Foods",1369,876.16,"MidWest"]
["2006-10-14","Joy","Safeway",181,123.08,"East"]
["2008-01-04","Tina","Safeway",51,27.03,"MidWest"]
["2007-07-05","Tom","PCC",531,387.63,"MidWest"]
["2007-01-17","Chin","Whole Foods",201,106.53,"NorthWest"]
["2007-05-01","Joy","PCC",114,54.72,"East"]
["2005-10-12","Tom","Coop",135,70.2,"West"]
["2007-05-06","Sioux","Whole Foods",55,29.15,"MidWest"]
["2008-01-29","Tom","PCC",101,47.47,"East"]
["2006-08-08","Tina","Safeway",202,119.18,"East"]
["2005-10-06","Tom","Coop",1010,606,"MidWest"]
["2005-10-28","Chin","PCC",83,56.44,"NorthWest"]
["2005-10-11","Tom","Whole Foods",994,795.2,"NorthWest"]
["2006-03-04","Tina","Coop",132,91.08,"East"]
["2006-11-06","Tina","Fred Myer",161,69.23,"NorthWest"]
["2007-03-02","Sioux","Safeway",216,157.68,"East"]
["2006-08-06","Chin","Safeway",242,191.18,"NorthWest"]
["2008-03-30","Sioux","Fred Myer",79,37.92,"NorthWest"]
["2006-04-04","Tina","PCC",1908,1278.3599999999999,"NorthEast"]
["2006-03-16","Tom","Safeway",243,102.06,"NorthWest"]
["2008-01-14","Tina","PCC",70,44.1,"West"]
["2005-11-27","Chin","Whole Foods",155,88.35,"MidWest"]
["2008-01-07","Chin","Coop",114,74.099999999999994,"East"]
["2008-06-04","Chin","PCC",596,452.96,"West"]
["2007-12-17","Chin","Fred Myer",137,100.01,"NorthEast"]
["2006-09-04","Sioux","Whole Foods",102,54.06,"NorthWest"]
["2006-05-23","Joy","Safeway",83,57.27,"West"]
["2006-09-15","Joy","PCC",160,124.8,"West"]
["2008-04-13","Tina","Coop",56,38.08,"NorthWest"]
["2007-02-25","Chin","Whole Foods",191,103.14,"NorthEast"]
["2007-01-08","Tom","Fred Myer",62,47.12,"NorthEast"]
["2006-11-03","Sioux","Whole Foods",246,157.44,"MidWest"]
["2008-06-05","Tina","Safeway",79,37.92,"NorthEast"]
["2006-01-13","Chin","Whole Foods",156,106.08,"NorthWest"]
["2007-06-25","Joy","Safeway",126,60.48,"NorthEast"]
["2008-02-25","Joy","Fred Myer",131,96.94,"MidWest"]
["2007-02-15","Sioux","Coop",176,70.400000000000006,"NorthEast"]
["2007-05-05","Tina","Safeway",224,138.88,"NorthEast"]
["2007-05-24","Joy","Fred Myer",227,93.07,"West"]
["2007-12-25","Sioux","Safeway",76,37.24,"East"]
["2008-05-19","Chin","Coop",51,26.52,"NorthWest"]
["2006-06-03","Sioux","Whole Foods",201,124.62,"NorthWest"]
["2007-08-16","Tina","Whole Foods",57,24.51,"West"]
["2008-04-08","Tina","Whole Foods",134,58.96,"NorthEast"]
["2006-03-06","Tina","PCC",1098,680.76,"NorthWest"]
["2007-04-16","Tom","PCC",131,74.67,"MidWest"]
["2006-06-15","Joy","Fred Myer",1674,1138.32,"NorthWest"]
["2005-10-31","Tom","Fred Myer",1373,741.42,"West"]
["2007-01-20","Tom","Safeway",172,127.28,"MidWest"]
["2007-04-15","Tom","Fred Myer",117,69.03,"East"]
["2007-02-19","Tom","Fred Myer",192,82.56,"MidWest"]
["2006-11-10","Tina","Whole Foods",192,130.56,"East"]
["2006-02-18","Joy","Coop",114,80.94,"West"]
["2008-04-10","Tom","Safeway",184,77.28,"MidWest"]
["2007-02-01","Tom","Safeway",73,48.91,"MidWest"]
["2006-03-26","Tom","Safeway",160,123.2,"NorthEast"]
["2005-08-25","Chin","Whole Foods",105,74.55,"NorthEast"]
["2006-11-24","Joy","Whole Foods",1075,849.25,"NorthEast"]
["2007-03-30","Sioux","Fred Myer",124,65.72,"East"]
["2006-02-20","Sioux","Whole Foods",156,92.04,"West"]
["2007-12-20","Tina","Whole Foods",195,103.35,"West"]
["2006-04-02","Tom","Fred Myer",150,88.5,"East"]
["2005-08-21","Chin","Coop",222,93.24,"West"]
["2006-06-07","Chin","Coop",1621,1264.3800000000001,"NorthWest"]
["2006-04-19","Sioux","Fred Myer",97,42.68,"NorthWest"]
["2008-02-19","Sioux","Coop",85,39.1,"East"]
["2006-02-06","Tom","Coop",220,116.6,"East"]
["2005-10-25","Tina","Fred Myer",223,176.17,"NorthEast"]
["2007-12-14","Sioux","PCC",166,124.5,"East"]
["2006-08-25","Joy","Whole Foods",249,129.47999999999999,"NorthWest"]
["2005-08-18","Chin","Whole Foods",146,84.68,"NorthEast"]
["2006-12-14","Tina","Fred Myer",91,50.05,"East"]
["2007-11-22","Chin","Safeway",204,99.96,"NorthEast"]
["2007-03-14","Sioux","Coop",103,65.92,"NorthWest"]
["2006-01-02","Chin","PCC",111,56.61,"West"]
["2007-12-20","Sioux","Fred Myer",69,36.57,"NorthWest"]
["2005-07-24","Tom","Whole Foods",152,71.44,"East"]
["2007-07-01","Sioux","Fred Myer",55,23.1,"NorthEast"]
["2006-03-16","Chin","Fred Myer",80,32.799999999999997,"NorthWest"]
["2007-01-30","Joy","PCC",191,99.32,"MidWest"]
["2007-03-18","Joy","Whole Foods",109,80.66,"NorthWest"]
["2006-04-26","Chin","Coop",1960,1509.2,"NorthWest"]
["2005-07-16","Sioux","Safeway",73,32.85,"East"]
["2006-03-01","Tom","Whole Foods",90,61.2,"West"]
["2005-05-30","Sioux","Safeway",68,47.6,"MidWest"]
["2008-01-13","Tina","Coop",232,120.64,"West"]
["2007-04-17","Chin","Safeway",163,130.4,"West"]
["2008-05-23","Tom","PCC",205,84.05,"NorthWest"]
["2008-02-11","Tom","Whole Foods",727,327.14999999999998,"NorthWest"]
["2006-09-20","Tom","PCC",235,108.1,"NorthEast"]
["2008-02-16","Tina","Whole Foods",211,145.59,"MidWest"]
["2006-12-29","Joy","PCC",220,162.80000000000001,"MidWest"]
["2008-05-12","Chin","Fred Myer",234,142.74,"West"]
["2005-07-01","Tina","Whole Foods",151,80.03,"MidWest"]
["2007-11-20","Joy","Coop",214,98.44,"East"]
["2007-07-21","Tina","Whole Foods",211,128.71,"East"]
["2005-09-21","Tina","Fred Myer",75,37.5,"NorthEast"]
["2006-05-25","Joy","PCC",128,53.76,"West"]
["2007-11-06","Tom","Fred Myer",205,151.69999999999999,"NorthWest"]
["2007-12-03","Tina","PCC",156,82.68,"East"]
["2005-10-15","Tom","Whole Foods",1434,630.96,"East"]
["2005-06-18","Joy","Fred Myer",250,147.5,"NorthWest"]
["2007-03-11","Tom","Coop",108,81,"NorthEast"]
["2007-03-18","Sioux","Fred Myer",217,156.24,"West"]
["2005-06-05","Joy","Fred Myer",50,35.5,"NorthEast"]
["2005-06-30","Tina","PCC",132,71.28,"NorthEast"]
["2006-01-09","Tom","PCC",216,123.12,"East"]
["2006-10-23","Chin","PCC",141,95.88,"NorthEast"]
["2008-03-29","Joy","Whole Foods",97,61.11,"MidWest"]
["2006-12-12","Joy","PCC",232,143.84,"NorthEast"]
["2005-10-12","Tina","Safeway",73,56.21,"NorthWest"]
["2007-07-11","Chin","Whole Foods",244,173.24,"East"]
["2005-10-20","Joy","Fred Myer",72,33.840000000000003,"East"]
["2006-05-19","Tina","Whole Foods",109,73.03,"MidWest"]
["2007-10-24","Tina","Safeway",115,52.9,"NorthEast"]
["2008-04-23","Chin","Safeway",219,146.72999999999999,"East"]
["2008-01-05","Tina","PCC",135,55.35,"NorthWest"]
["2006-11-29","Tom","Whole Foods",96,39.36,"MidWest"]
["2007-04-18","Joy","Coop",60,48,"West"]
["2007-04-13","Chin","Coop",100,43,"NorthEast"]
["2007-07-20","Tom","Whole Foods",1064,734.16,"NorthWest"]
["2006-05-06","Chin","Fred Myer",120,49.2,"West"]
["2005-08-19","Tina","Safeway",184,119.6,"MidWest"]
["2008-02-18","Tom","Safeway",95,59.85,"NorthWest"]
["2006-02-04","Tina","Safeway",87,46.98,"West"]
["2005-07-25","Tina","Fred Myer",161,98.21,"West"]
["2006-04-21","Chin","Fred Myer",219,131.4,"East"]
["2008-05-15","Joy","Coop",67,40.200000000000003,"MidWest"]
["2007-09-28","Tom","Fred Myer",51,21.93,"NorthWest"]
["2006-01-15","Tina","Safeway",180,102.6,"NorthWest"]
["2006-04-23","Sioux","PCC",232,127.6,"West"]
["2006-08-17","Sioux","PCC",180,131.4,"MidWest"]
["2007-06-26","Tom","PCC",147,67.62,"NorthEast"]
["2007-12-07","Tina","PCC",187,143.99,"East"]
["2007-10-31","Chin","PCC",92,37.72,"NorthEast"]
["2008-04-10","Joy","Coop",1596,1133.1600000000001,"East"]
["2008-05-21","Chin","Whole Foods",62,29.14,"NorthEast"]
["2006-05-15","Tom","Whole Foods",222,170.94,"West"]
["2007-09-17","Chin","PCC",127,80.010000000000005,"East"]
["2006-04-20","Chin","Fred Myer",138,99.36,"NorthWest"]
["2005-10-12","Sioux","Safeway",52,38.479999999999997,"NorthWest"]
["2005-11-21","Tom","Whole Foods",135,70.2,"NorthWest"]
["2005-09-13","Chin","Fred Myer",92,59.8,"West"]
["2007-02-18","Sioux","Safeway",1855,1391.25,"West"]
["2005-06-29","Sioux","Coop",221,143.65,"MidWest"]
["2007-09-05","Joy","Whole Foods",209,112.86,"West"]
["2005-12-28","Tina","Safeway",221,172.38,"East"]
["2006-07-15","Sioux","PCC",148,91.76,"East"]
["2008-05-24","Sioux","PCC",225,105.75,"NorthWest"]
["2008-05-16","Tom","Coop",133,94.43,"East"]
["2006-12-26","Tina","PCC",1460,861.4,"West"]
["2007-01-17","Chin","Safeway",88,37.840000000000003,"MidWest"]
["2006-09-11","Chin","Whole Foods",501,310.62,"East"]
["2005-07-06","Chin","Safeway",82,41.82,"West"]
["2007-01-10","Chin","Fred Myer",128,80.64,"West"]
["2006-02-23","Chin","Whole Foods",160,94.4,"NorthWest"]
["2007-05-04","Sioux","Safeway",169,69.290000000000006,"NorthEast"]
["2007-12-03","Tom","Coop",1336,868.4,"NorthEast"]
["2007-11-05","Tom","Safeway",155,120.9,"NorthWest"]
["2007-05-05","Chin","PCC",94,38.54,"NorthWest"]
["2006-07-25","Joy","Fred Myer",88,61.6,"NorthWest"]
["2007-03-07","Tom","Safeway",73,55.48,"East"]
["2008-01-21","Sioux","Whole Foods",1297,609.59,"MidWest"]
["2008-05-13","Chin","Fred Myer",1780,1281.5999999999999,"NorthEast"]
["2007-04-06","Sioux","PCC",179,82.34,"East"]
["2008-06-03","Tina","Whole Foods",235,103.4,"West"]
["2007-03-31","Joy","Coop",196,148.96,"MidWest"]
["2005-06-14","Tina","Safeway",154,72.38,"NorthEast"]
["2007-06-22","Chin","Whole Foods",594,338.58,"NorthEast"]
["2008-01-07","Chin","Coop",109,50.14,"East"]
["2007-01-15","Tom","Safeway",139,107.03,"West"]
["2005-10-18","Sioux","Coop",97,43.65,"NorthEast"]
["2008-03-20","Joy","Coop",870,609,"MidWest"]
["2006-03-28","Joy","PCC",92,59.8,"NorthWest"]
["2006-06-11","Chin","Coop",53,28.62,"NorthWest"]
["2007-07-25","Tina","Safeway",179,112.77,"NorthEast"]
["2005-06-19","Chin","PCC",186,87.42,"NorthEast"]
["2007-12-01","Tina","Whole Foods",101,41.41,"NorthWest"]
["2008-01-06","Sioux","Whole Foods",66,38.94,"West"]
["2006-02-06","Tom","Fred Myer",185,146.15,"East"]
["2006-04-22","Tom","Whole Foods",1133,895.07,"East"]
["2006-07-28","Chin","Whole Foods",125,98.75,"NorthEast"]
["2008-02-23","Tom","Fred Myer",151,78.52,"MidWest"]
["2007-09-07","Joy","PCC",217,123.69,"West"]
["2007-12-11","Tom","Coop",84,49.56,"NorthWest"]
["2007-10-03","Tina","Fred Myer",160,70.400000000000006,"East"]
["2006-01-23","Sioux","PCC",194,135.80000000000001,"NorthEast"]
["2005-10-05","Joy","Whole Foods",218,141.69999999999999,"MidWest"]
["2007-08-02","Chin","Whole Foods",66,50.82,"West"]
["2007-08-12","Tom","PCC",62,25.42,"West"]
["2005-09-04","Joy","Whole Foods",190,100.7,"East"]
["2008-01-07","Sioux","Fred Myer",96,43.2,"West"]
["2005-06-23","Sioux","Whole Foods",207,138.69,"MidWest"]
["2007-05-29","Sioux","Whole Foods",149,119.2,"East"]
["2007-09-10","Tom","Coop",1820,746.2,"East"]
["2005-07-21","Tina","Whole Foods",248,151.28,"MidWest"]
["2007-05-12","Chin","Safeway",155,80.599999999999994,"NorthEast"]
["2007-09-30","Tina","Coop",98,43.12,"MidWest"]
["2008-03-04","Tina","Safeway",181,115.84,"NorthWest"]
["2006-07-26","Sioux","Safeway",226,119.78,"MidWest"]
["2007-03-25","Joy","Fred Myer",75,48.75,"East"]
["2007-09-12","Tom","Whole Foods",192,144,"West"]
["2008-04-04","Chin","PCC",1054,706.18,"MidWest"]
["2005-07-28","Tom","PCC",76,53.2,"MidWest"]
["2007-09-05","Joy","Whole Foods",224,98.56,"NorthEast"]
["2007-03-19","Sioux","Safeway",1907,1373.04,"West"]

{"sheet":"Data Analysis(2)","index":8,"n_rows":601,"n_cols":6,"rows_kept":601,"cut":false,"hidden":false,"merged":[]}
["PivotTables are one of the  most powerful features In Excel. They can summarize data with multiple criteria. The key to Pivot Tables is to understand Columns and Rows. "]
["To create PivotTable, drag and drop \"Fields\" in \"Field List\" to \"Row Labels\", \"Column Labels\", \"Values\" or \"Report Filter\"."]
["1st step after creating PivotTable is to change Layout to \"Tabular Layout\": 1) PivotTable Tools Design Ribbon Tab, 2) Layout Group, 3) Report Layout, 4) \"Show In Tabular Form\"."]
["To change the function (SUM, AVERAGE, etc.), Number format or formula for a Pivot Table, Right-click the \"Value\" field in the PivotTable and point to \"Value Field Settings\"."]
["Basic Formatting for a PivotTable can be done in the PivotTable Tools Ribbon Tabs or from the Home Ribbon. Number Formatting should always \"Value Field Settings\" dialog box."]
["Right-click method for changing function: \"Summarize Values by\""]
["Right-click method for changing formula: \"Show Values as\""]
["Right-click method for changing Number format \"Number Format\""]
[]
[]
["Date","Sales Rep","Customer","Sales","COGS","Region"]
["2008-02-12","Joy","Fred Myer",132,80.52,"MidWest"]
["2006-07-25","Joy","Fred Myer",88,61.6,"NorthWest"]
["2006-01-13","Tom","Safeway",70,51.8,"NorthWest"]
["2008-06-02","Joy","Safeway",119,61.88,"East"]
["2007-06-10","Chin","Whole Foods",519,285.45,"NorthWest"]
["2007-07-17","Tina","Whole Foods",58,24.36,"West"]
["2008-04-10","Tom","Safeway",184,77.28,"MidWest"]
["2006-04-26","Chin","Coop",1960,1509.2,"NorthWest"]
["2008-02-25","Joy","Fred Myer",131,96.94,"MidWest"]
["2006-08-25","Joy","Whole Foods",249,129.47999999999999,"NorthWest"]
["2006-11-06","Joy","Coop",188,112.8,"NorthWest"]
["2007-12-20","Sioux","Fred Myer",69,36.57,"NorthWest"]
["2007-07-11","Chin","Whole Foods",244,173.24,"East"]
["2005-06-19","Tina","Fred Myer",174,113.1,"MidWest"]
["2005-07-25","Tina","Fred Myer",161,98.21,"West"]
["2007-04-13","Chin","Coop",100,43,"NorthEast"]
["2006-08-11","Tina","Fred Myer",235,157.44999999999999,"East"]
["2006-02-06","Tom","Fred Myer",185,146.15,"East"]
["2005-06-16","Sioux","Safeway",1656,1275.1199999999999,"MidWest"]
["2005-12-08","Sioux","PCC",214,162.63999999999999,"NorthWest"]
["2007-05-06","Sioux","Coop",192,138.24,"MidWest"]
["2006-04-12","Tina","PCC",53,29.68,"NorthWest"]
["2006-02-28","Tina","Coop",628,263.76,"East"]
["2006-07-17","Chin","PCC",88,37.840000000000003,"East"]
["2007-12-07","Chin","PCC",75,47.25,"NorthEast"]
["2007-01-10","Chin","Fred Myer",128,80.64,"West"]
["2007-05-12","Chin","Safeway",155,80.599999999999994,"NorthEast"]
["2008-05-06","Tom","Coop",1020,479.4,"NorthWest"]
["2006-06-26","Chin","PCC",136,108.8,"East"]
["2008-01-29","Sioux","Safeway",160,91.2,"NorthEast"]
["2007-10-23","Sioux","Coop",124,80.599999999999994,"NorthEast"]
["2007-03-31","Joy","Coop",196,148.96,"MidWest"]
["2006-05-23","Chin","Safeway",141,105.75,"MidWest"]
["2005-10-03","Chin","Fred Myer",223,115.96,"NorthWest"]
["2007-01-02","Sioux","Coop",85,61.2,"NorthWest"]
["2005-07-21","Tina","Whole Foods",248,151.28,"MidWest"]
["2007-05-14","Tom","Coop",104,61.36,"NorthWest"]
["2006-03-13","Chin","Fred Myer",1550,868,"West"]
["2007-10-17","Chin","Safeway",698,488.6,"NorthEast"]
["2007-01-14","Tom","Safeway",203,87.29,"East"]
["2008-02-10","Tom","Safeway",78,44.46,"NorthEast"]
["2006-04-20","Chin","Fred Myer",138,99.36,"NorthWest"]
["2006-05-17","Sioux","PCC",139,59.77,"NorthWest"]
["2005-08-23","Tom","Whole Foods",178,115.7,"NorthWest"]
["2006-08-18","Joy","Whole Foods",203,154.28,"NorthEast"]
["2006-03-01","Tom","Whole Foods",90,61.2,"West"]
["2007-12-27","Sioux","Coop",131,55.02,"NorthWest"]
["2008-06-22","Joy","Safeway",1407,830.13,"East"]
["2006-03-26","Tom","Safeway",160,123.2,"NorthEast"]
["2006-04-06","Tina","PCC",55,26.95,"NorthEast"]
["2007-09-10","Tina","Whole Foods",139,88.96,"MidWest"]
["2007-01-30","Joy","Whole Foods",237,123.24,"West"]
["2006-04-24","Sioux","PCC",185,138.75,"NorthEast"]
["2006-05-15","Tom","Whole Foods",222,170.94,"West"]
["2008-03-02","Chin","Safeway",77,31.57,"NorthWest"]
["2007-02-20","Joy","Fred Myer",750,502.5,"NorthWest"]
["2007-05-29","Sioux","Whole Foods",149,119.2,"East"]
["2006-04-11","Tom","Fred Myer",1779,1298.67,"East"]
["2005-10-12","Sioux","Safeway",52,38.479999999999997,"NorthWest"]
["2007-11-05","Tom","Safeway",155,120.9,"NorthWest"]
["2006-09-15","Joy","PCC",160,124.8,"West"]
["2006-04-30","Chin","Safeway",217,171.43,"NorthEast"]
["2008-04-23","Chin","Safeway",219,146.72999999999999,"East"]
["2007-10-15","Tom","Coop",68,31.28,"West"]
["2007-12-03","Joy","Coop",139,65.33,"NorthEast"]
["2006-04-02","Tom","Fred Myer",150,88.5,"East"]
["2007-01-17","Chin","Safeway",88,37.840000000000003,"MidWest"]
["2007-12-03","Tom","Coop",1336,868.4,"NorthEast"]
["2007-04-17","Chin","Safeway",163,130.4,"West"]
["2006-02-06","Tom","Coop",220,116.6,"East"]
["2005-09-19","Joy","PCC",83,60.59,"East"]
["2006-10-05","Tom","PCC",55,28.6,"MidWest"]
["2007-12-03","Joy","PCC",1028,771,"East"]
["2007-02-03","Chin","Fred Myer",63,27.09,"East"]
["2005-07-02","Tina","PCC",143,81.510000000000005,"NorthEast"]
["2008-05-21","Chin","Whole Foods",62,29.14,"NorthEast"]
["2007-07-01","Sioux","Fred Myer",55,23.1,"NorthEast"]
["2006-12-25","Chin","Whole Foods",1369,876.16,"MidWest"]
["2007-04-18","Joy","Coop",60,48,"West"]
["2007-01-08","Tom","Fred Myer",62,47.12,"NorthEast"]
["2007-12-17","Chin","Fred Myer",137,100.01,"NorthEast"]
["2007-03-01","Sioux","Fred Myer",84,59.64,"MidWest"]
["2007-08-07","Tom","Safeway",55,37.4,"NorthEast"]
["2008-02-26","Tom","Whole Foods",237,158.79,"MidWest"]
["2006-02-23","Tina","Fred Myer",127,85.09,"NorthWest"]
["2008-04-18","Tom","Fred Myer",183,78.69,"NorthEast"]
["2006-05-30","Sioux","PCC",124,79.36,"NorthEast"]
["2008-02-12","Joy","Coop",1095,558.45000000000005,"MidWest"]
["2006-02-23","Chin","Whole Foods",160,94.4,"NorthWest"]
["2008-03-20","Joy","Coop",870,609,"MidWest"]
["2006-01-07","Sioux","Coop",93,60.45,"NorthEast"]
["2008-02-17","Sioux","Safeway",193,108.08,"East"]
["2007-03-08","Tina","PCC",212,125.08,"West"]
["2007-06-19","Sioux","Fred Myer",93,68.819999999999993,"East"]
["2006-10-18","Tom","Coop",80,48.8,"East"]
["2007-11-22","Chin","Safeway",204,99.96,"NorthEast"]
["2007-05-03","Tina","Fred Myer",228,114,"NorthWest"]
["2005-11-09","Chin","Coop",1399,1077.23,"East"]
["2007-12-07","Tina","PCC",187,143.99,"East"]
["2006-10-19","Tom","Fred Myer",163,122.25,"West"]
["2008-03-30","Sioux","PCC",63,30.24,"MidWest"]
["2005-06-30","Tina","Coop",197,98.5,"East"]
["2006-10-11","Tina","Fred Myer",237,137.46,"MidWest"]
["2005-08-05","Sioux","Safeway",140,107.8,"MidWest"]
["2008-01-12","Sioux","Coop",141,83.19,"NorthWest"]
["2007-09-30","Tina","Coop",98,43.12,"MidWest"]
["2008-01-23","Tina","Fred Myer",510,280.5,"MidWest"]
["2005-10-06","Tom","Coop",1010,606,"MidWest"]
["2007-05-01","Joy","PCC",114,54.72,"East"]
["2007-06-09","Sioux","Whole Foods",220,99,"MidWest"]
["2006-03-28","Joy","PCC",92,59.8,"NorthWest"]
["2005-08-08","Tom","PCC",180,79.2,"NorthEast"]
["2006-08-17","Sioux","PCC",180,131.4,"MidWest"]
["2007-04-30","Chin","Coop",81,34.020000000000003,"NorthEast"]
["2006-01-24","Joy","PCC",178,133.5,"NorthWest"]
["2005-07-16","Sioux","Safeway",73,32.85,"East"]
["2008-07-01","Tina","Whole Foods",112,62.72,"NorthEast"]
["2007-10-30","Tom","Safeway",1607,1124.9000000000001,"NorthEast"]
["2006-03-12","Sioux","PCC",133,54.53,"East"]
["2005-10-05","Joy","Whole Foods",218,141.69999999999999,"MidWest"]
["2005-09-04","Joy","Whole Foods",190,100.7,"East"]
["2007-03-13","Chin","Whole Foods",161,78.89,"MidWest"]
["2007-06-17","Joy","PCC",69,54.51,"NorthEast"]
["2007-10-22","Joy","Safeway",961,643.87,"West"]
["2007-08-10","Tom","Safeway",236,167.56,"West"]
["2006-11-26","Tina","PCC",88,37.840000000000003,"NorthEast"]
["2006-05-23","Joy","Safeway",83,57.27,"West"]
["2006-05-11","Joy","Fred Myer",1917,996.84,"East"]
["2007-02-01","Tom","Safeway",73,48.91,"MidWest"]
["2007-03-02","Sioux","Safeway",216,157.68,"East"]
["2007-07-13","Tom","Fred Myer",113,76.84,"MidWest"]
["2006-11-29","Tom","Whole Foods",96,39.36,"MidWest"]
["2007-01-19","Joy","Fred Myer",171,104.31,"West"]
["2008-05-14","Chin","Fred Myer",177,79.650000000000006,"NorthEast"]
["2007-07-05","Tina","Fred Myer",167,93.52,"NorthEast"]
["2005-10-12","Tina","Safeway",73,56.21,"NorthWest"]
["2006-10-28","Chin","Fred Myer",152,95.76,"East"]
["2007-12-11","Tina","Coop",1658,1094.28,"MidWest"]
["2007-12-20","Tina","Whole Foods",195,103.35,"West"]
["2007-08-02","Chin","Whole Foods",66,50.82,"West"]
["2005-10-11","Tom","Whole Foods",994,795.2,"NorthWest"]
["2006-11-10","Tina","Whole Foods",192,130.56,"East"]
["2008-05-12","Sioux","Safeway",82,59.86,"MidWest"]
["2005-10-20","Joy","Fred Myer",72,33.840000000000003,"East"]
["2007-12-25","Tina","PCC",131,79.91,"MidWest"]
["2007-07-09","Chin","Whole Foods",123,63.96,"MidWest"]
["2008-05-24","Sioux","PCC",225,105.75,"NorthWest"]
["2007-12-11","Sioux","Whole Foods",1680,705.6,"West"]
["2005-08-31","Joy","Safeway",171,88.92,"MidWest"]
["2005-10-20","Sioux","Fred Myer",75,50.25,"West"]
["2005-06-19","Chin","PCC",186,87.42,"NorthEast"]
["2006-05-18","Tina","Fred Myer",54,40.5,"East"]
["2007-05-04","Sioux","Safeway",169,69.290000000000006,"NorthEast"]
["2005-11-21","Tom","Whole Foods",135,70.2,"NorthWest"]
["2006-09-20","Tom","PCC",235,108.1,"NorthEast"]
["2006-11-27","Tom","Whole Foods",122,92.72,"East"]
["2006-12-29","Joy","PCC",220,162.80000000000001,"MidWest"]
["2007-06-22","Chin","Whole Foods",594,338.58,"NorthEast"]
["2008-01-06","Tom","Fred Myer",245,120.05,"NorthEast"]
["2006-07-28","Chin","Whole Foods",125,98.75,"NorthEast"]
["2008-02-04","Joy","Fred Myer",228,180.12,"NorthEast"]
["2007-01-09","Joy","Safeway",76,57,"MidWest"]
["2007-10-23","Tina","Whole Foods",166,129.47999999999999,"MidWest"]
["2006-05-20","Sioux","Safeway",131,104.8,"NorthEast"]
["2005-11-25","Joy","Fred Myer",183,78.69,"MidWest"]
["2006-11-06","Tom","Safeway",240,100.8,"East"]
["2007-03-18","Joy","Whole Foods",109,80.66,"NorthWest"]
["2007-03-19","Sioux","Safeway",1907,1373.04,"West"]
["2006-11-19","Tom","Safeway",122,51.24,"NorthEast"]
["2006-05-06","Chin","Fred Myer",120,49.2,"West"]
["2005-11-01","Joy","PCC",145,105.85,"West"]
["2006-07-15","Sioux","PCC",148,91.76,"East"]
["2008-04-13","Joy","Whole Foods",76,32.68,"West"]
["2007-04-16","Tom","PCC",131,74.67,"MidWest"]
["2007-12-07","Chin","Coop",763,480.69,"East"]
["2005-11-16","Sioux","Fred Myer",209,154.66,"NorthWest"]
["2007-03-09","Tom","PCC",61,45.14,"NorthEast"]
["2007-06-27","Tina","Fred Myer",1947,1343.43,"East"]
["2006-03-14","Tom","Fred Myer",206,140.08000000000001,"NorthWest"]
["2005-09-02","Chin","Coop",52,35.880000000000003,"NorthEast"]
["2007-03-18","Sioux","PCC",132,76.56,"MidWest"]
["2007-11-06","Tom","Fred Myer",205,151.69999999999999,"NorthWest"]
["2007-12-08","Chin","Fred Myer",60,27.6,"MidWest"]
["2007-01-08","Chin","Whole Foods",137,79.459999999999994,"NorthEast"]
["2007-04-18","Joy","PCC",191,116.51,"East"]
["2005-09-21","Tina","Fred Myer",75,37.5,"NorthEast"]
["2008-05-16","Tom","Coop",133,94.43,"East"]
["2006-06-07","Chin","Coop",1621,1264.3800000000001,"NorthWest"]
["2005-07-28","Tom","PCC",76,53.2,"MidWest"]
["2008-01-07","Sioux","Fred Myer",96,43.2,"West"]
["2007-09-22","Tina","Coop",181,139.37,"MidWest"]
["2006-11-08","Chin","Fred Myer",1023,470.58,"NorthWest"]
["2007-09-14","Tina","Safeway",106,58.3,"East"]
["2005-12-28","Tina","Safeway",221,172.38,"East"]
["2008-03-27","Tina","Fred Myer",220,107.8,"East"]
["2007-06-08","Joy","Whole Foods",191,135.61000000000001,"West"]
["2008-02-09","Joy","Safeway",103,69.010000000000005,"MidWest"]
["2008-04-10","Joy","Coop",1596,1133.1600000000001,"East"]
["2007-05-24","Tom","Whole Foods",81,46.98,"NorthEast"]
["2007-09-05","Joy","Whole Foods",209,112.86,"West"]
["2007-04-28","Chin","PCC",104,72.8,"NorthEast"]
["2005-08-08","Tina","Fred Myer",144,67.680000000000007,"NorthWest"]
["2007-12-06","Tina","Fred Myer",118,93.22,"West"]
["2005-10-31","Tina","Whole Foods",73,34.31,"West"]
["2007-11-20","Joy","Coop",214,98.44,"East"]
["2008-02-27","Joy","Coop",240,151.19999999999999,"NorthEast"]
["2007-05-30","Tom","Whole Foods",67,40.869999999999997,"MidWest"]
["2005-12-21","Chin","Safeway",1151,563.99,"West"]
["2007-02-28","Chin","Whole Foods",751,570.76,"NorthEast"]
["2006-07-17","Tom","Fred Myer",188,82.72,"NorthEast"]
["2005-12-04","Sioux","PCC",157,73.790000000000006,"West"]
["2008-04-12","Tom","PCC",55,42.35,"NorthEast"]
["2006-02-18","Joy","PCC",194,147.44,"NorthWest"]
["2006-02-20","Sioux","Whole Foods",156,92.04,"West"]
["2007-04-06","Sioux","PCC",179,82.34,"East"]
["2006-01-01","Tina","Whole Foods",184,86.48,"East"]
["2006-05-25","Joy","PCC",128,53.76,"West"]
["2005-07-21","Tom","Coop",1436,1019.56,"West"]
["2007-05-05","Tina","Safeway",224,138.88,"NorthEast"]
["2008-06-03","Sioux","Fred Myer",220,149.6,"West"]
["2008-04-02","Tom","Whole Foods",206,96.82,"MidWest"]
["2006-01-17","Tom","Fred Myer",170,132.6,"NorthWest"]
["2006-07-23","Tom","Fred Myer",66,31.02,"West"]
["2007-06-09","Chin","Safeway",171,92.34,"NorthWest"]
["2007-12-01","Tina","Whole Foods",101,41.41,"NorthWest"]
["2007-11-26","Joy","PCC",869,521.4,"NorthEast"]
["2008-02-06","Joy","PCC",151,95.13,"NorthEast"]
["2007-10-08","Chin","PCC",1923,1519.17,"NorthWest"]
["2007-07-21","Tina","Whole Foods",211,128.71,"East"]
["2007-04-16","Tom","Safeway",159,116.07,"NorthEast"]
["2005-07-06","Chin","Safeway",82,41.82,"West"]
["2005-09-20","Sioux","Coop",70,42.7,"NorthEast"]
["2007-03-30","Joy","Whole Foods",153,122.4,"NorthEast"]
["2005-08-03","Tom","PCC",232,160.08000000000001,"West"]
["2005-10-25","Tina","Fred Myer",223,176.17,"NorthEast"]
["2005-06-23","Sioux","Whole Foods",207,138.69,"MidWest"]
["2006-10-12","Tom","PCC",234,102.96,"East"]
["2005-06-22","Chin","Whole Foods",1154,484.68,"West"]
["2005-10-16","Chin","Whole Foods",68,42.16,"West"]
["2008-04-13","Tina","Coop",56,38.08,"NorthWest"]
["2007-09-28","Joy","PCC",209,133.76,"NorthWest"]
["2006-08-11","Tina","Safeway",238,166.6,"West"]
["2008-02-11","Tom","Whole Foods",727,327.14999999999998,"NorthWest"]
["2007-08-16","Tina","Whole Foods",57,24.51,"West"]
["2005-11-17","Tom","Coop",214,136.96,"West"]
["2008-06-05","Sioux","Coop",181,86.88,"West"]
["2007-06-06","Chin","PCC",138,67.62,"East"]
["2006-03-06","Tina","PCC",1098,680.76,"NorthWest"]
["2006-07-26","Sioux","Safeway",226,119.78,"MidWest"]
["2007-05-24","Joy","Fred Myer",227,93.07,"West"]
["2007-01-06","Joy","PCC",88,40.479999999999997,"West"]
["2007-06-23","Tom","PCC",191,108.87,"MidWest"]
["2008-01-18","Joy","Fred Myer",123,97.17,"West"]
["2006-05-30","Chin","Whole Foods",97,50.44,"NorthWest"]
["2008-06-22","Sioux","PCC",166,132.80000000000001,"MidWest"]
["2007-11-19","Tina","Whole Foods",210,134.4,"NorthWest"]
["2006-04-19","Sioux","Fred Myer",97,42.68,"NorthWest"]
["2005-10-30","Joy","Fred Myer",1756,965.8,"West"]
["2007-10-27","Joy","Coop",144,87.84,"NorthWest"]
["2007-07-05","Tom","PCC",531,387.63,"MidWest"]
["2007-05-06","Sioux","Whole Foods",55,29.15,"MidWest"]
["2008-06-05","Tina","Safeway",79,37.92,"NorthEast"]
["2005-12-04","Chin","Safeway",93,61.38,"NorthWest"]
["2008-01-11","Tom","Safeway",51,31.62,"MidWest"]
["2007-10-09","Tom","Coop",199,95.52,"East"]
["2007-10-03","Tina","Fred Myer",160,70.400000000000006,"East"]
["2006-01-20","Joy","PCC",153,81.09,"MidWest"]
["2006-01-07","Sioux","PCC",1435,574,"West"]
["2007-01-20","Tom","Safeway",172,127.28,"MidWest"]
["2007-03-18","Sioux","Fred Myer",217,156.24,"West"]
["2007-03-11","Tom","Coop",108,81,"NorthEast"]
["2006-06-13","Joy","Safeway",51,26.52,"East"]
["2007-11-26","Tom","Whole Foods",160,86.4,"West"]
["2006-05-29","Chin","Whole Foods",110,88,"NorthEast"]
["2005-12-21","Joy","Safeway",194,147.44,"MidWest"]
["2006-11-23","Tina","Coop",202,103.02,"West"]
["2007-03-04","Tina","PCC",1061,583.54999999999995,"West"]
["2005-10-31","Tom","Fred Myer",1373,741.42,"West"]
["2006-01-09","Tom","PCC",216,123.12,"East"]
["2005-06-13","Chin","PCC",130,85.8,"NorthWest"]
["2007-06-15","Chin","Whole Foods",107,66.34,"MidWest"]
["2006-08-29","Tom","PCC",63,37.17,"West"]
["2005-05-31","Sioux","Safeway",169,89.57,"NorthWest"]
["2005-11-24","Chin","Whole Foods",113,67.8,"MidWest"]
["2008-06-18","Chin","Safeway",86,55.04,"East"]
["2005-11-03","Tina","Coop",130,75.400000000000006,"MidWest"]
["2008-06-28","Sioux","PCC",184,141.68,"MidWest"]
["2007-03-27","Sioux","Coop",1450,1116.5,"NorthEast"]
["2007-05-23","Tina","Safeway",140,75.599999999999994,"West"]
["2008-03-30","Sioux","Fred Myer",79,37.92,"NorthWest"]
["2008-01-04","Tina","Safeway",51,27.03,"MidWest"]
["2006-11-22","Sioux","Safeway",242,166.98,"NorthWest"]
["2006-04-21","Sioux","Whole Foods",221,154.69999999999999,"West"]
["2005-09-06","Chin","PCC",1158,509.52,"East"]
["2006-11-28","Tom","Fred Myer",208,160.16,"NorthWest"]
["2008-03-02","Joy","Fred Myer",129,81.27,"MidWest"]
["2007-08-06","Chin","Coop",107,62.06,"West"]
["2006-12-23","Joy","Coop",1494,1150.3800000000001,"MidWest"]
["2005-12-25","Sioux","PCC",75,57.75,"MidWest"]
["2006-05-31","Tina","PCC",122,76.86,"MidWest"]
["2007-08-12","Tom","PCC",62,25.42,"West"]
["2005-10-25","Sioux","Whole Foods",74,48.84,"MidWest"]
["2007-01-15","Tom","Safeway",139,107.03,"West"]
["2007-08-22","Tina","Safeway",88,49.28,"East"]
["2007-03-13","Tina","Whole Foods",102,61.2,"West"]
["2007-02-24","Sioux","Whole Foods",90,36.9,"MidWest"]
["2006-02-02","Tina","Fred Myer",77,30.8,"West"]
["2006-03-02","Tom","Whole Foods",1569,737.43,"NorthEast"]
["2007-01-20","Tina","Whole Foods",204,116.28,"NorthWest"]
["2008-03-27","Chin","Safeway",160,108.8,"East"]
["2005-08-01","Sioux","Whole Foods",949,740.22,"East"]
["2008-01-13","Tina","Coop",232,120.64,"West"]
["2006-06-03","Sioux","Whole Foods",201,124.62,"NorthWest"]
["2008-06-24","Joy","Whole Foods",78,59.28,"MidWest"]
["2008-02-18","Tom","Safeway",95,59.85,"NorthWest"]
["2007-09-28","Tom","Fred Myer",51,21.93,"NorthWest"]
["2005-12-11","Joy","PCC",169,69.290000000000006,"NorthWest"]
["2007-09-07","Chin","Fred Myer",1430,672.1,"West"]
["2005-10-24","Tina","Whole Foods",119,84.49,"NorthEast"]
["2006-11-04","Joy","PCC",159,71.55,"NorthEast"]
["2006-01-15","Tina","Safeway",180,102.6,"NorthWest"]
["2005-08-25","Tina","Fred Myer",238,138.04,"East"]
["2005-10-01","Sioux","Fred Myer",113,83.62,"West"]
["2007-09-12","Tom","Whole Foods",192,144,"West"]
["2005-07-01","Tina","Whole Foods",151,80.03,"MidWest"]
["2007-09-07","Chin","PCC",170,136,"NorthWest"]
["2007-12-03","Chin","Fred Myer",80,40.799999999999997,"MidWest"]
["2007-01-22","Sioux","Fred Myer",810,380.7,"MidWest"]
["2008-06-03","Tina","Whole Foods",235,103.4,"West"]
["2008-03-29","Joy","Whole Foods",97,61.11,"MidWest"]
["2007-12-25","Sioux","Safeway",76,37.24,"East"]
["2007-03-03","Joy","PCC",213,108.63,"West"]
["2008-01-22","Tom","Fred Myer",247,140.79,"West"]
["2006-05-19","Tina","Whole Foods",109,73.03,"MidWest"]
["2006-01-02","Chin","PCC",111,56.61,"West"]
["2008-03-04","Tina","Safeway",181,115.84,"NorthWest"]
["2006-01-03","Tom","Fred Myer",162,69.66,"West"]
["2007-09-10","Tom","Coop",1820,746.2,"East"]
["2008-03-16","Chin","Fred Myer",190,98.8,"MidWest"]
["2006-12-31","Chin","PCC",216,155.52000000000001,"NorthWest"]
["2008-06-14","Sioux","Whole Foods",125,55,"NorthEast"]
["2005-08-01","Tom","Fred Myer",142,86.62,"MidWest"]
["2008-05-23","Sioux","Safeway",96,50.88,"West"]
["2006-04-01","Joy","PCC",186,122.76,"NorthWest"]
["2007-09-15","Tom","PCC",853,562.98,"West"]
["2005-08-05","Joy","Coop",89,51.62,"West"]
["2006-12-18","Tina","Fred Myer",231,106.26,"NorthEast"]
["2007-02-02","Chin","Coop",1104,805.92,"East"]
["2007-03-18","Joy","Coop",114,52.44,"West"]
["2005-08-25","Chin","Whole Foods",105,74.55,"NorthEast"]
["2007-03-14","Sioux","Coop",103,65.92,"NorthWest"]
["2008-02-10","Sioux","Safeway",183,115.29,"West"]
["2005-06-29","Sioux","Coop",221,143.65,"MidWest"]
["2005-08-18","Chin","Whole Foods",146,84.68,"NorthEast"]
["2007-02-15","Sioux","Coop",176,70.400000000000006,"NorthEast"]
["2005-06-05","Joy","Fred Myer",50,35.5,"NorthEast"]
["2007-10-07","Joy","Fred Myer",186,126.48,"West"]
["2006-04-17","Sioux","Safeway",1062,626.58000000000004,"East"]
["2007-07-25","Tina","Safeway",179,112.77,"NorthEast"]
["2007-10-31","Chin","PCC",92,37.72,"NorthEast"]
["2006-03-04","Tina","Coop",132,91.08,"East"]
["2007-04-03","Chin","PCC",696,542.88,"MidWest"]
["2008-01-14","Tina","PCC",70,44.1,"West"]
["2007-09-10","Tina","Coop",53,32.86,"West"]
["2005-11-07","Tom","Fred Myer",85,40.799999999999997,"West"]
["2005-12-05","Joy","PCC",142,92.3,"East"]
["2006-03-16","Tom","Safeway",243,102.06,"NorthWest"]
["2007-05-27","Tom","PCC",1402,686.98,"MidWest"]
["2006-11-06","Tina","Fred Myer",161,69.23,"NorthWest"]
["2006-03-12","Sioux","Fred Myer",156,84.24,"West"]
["2005-10-06","Tom","Safeway",208,122.72,"NorthWest"]
["2008-05-03","Tom","Coop",241,185.57,"NorthWest"]
["2008-05-12","Chin","Fred Myer",234,142.74,"West"]
["2007-06-26","Tom","PCC",147,67.62,"NorthEast"]
["2007-03-07","Tom","Safeway",73,55.48,"East"]
["2008-05-19","Chin","Coop",51,26.52,"NorthWest"]
["2007-06-25","Joy","Safeway",126,60.48,"NorthEast"]
["2008-01-21","Sioux","Whole Foods",1297,609.59,"MidWest"]
["2006-09-11","Chin","Whole Foods",501,310.62,"East"]
["2006-10-10","Joy","PCC",77,46.97,"East"]
["2007-02-10","Sioux","Coop",173,115.91,"NorthWest"]
["2007-12-10","Tina","Coop",182,96.46,"East"]
["2007-05-14","Tom","Safeway",143,98.67,"MidWest"]
["2007-01-30","Joy","PCC",191,99.32,"MidWest"]
["2007-09-17","Chin","PCC",127,80.010000000000005,"East"]
["2006-06-23","Sioux","Whole Foods",58,35.96,"MidWest"]
["2007-02-25","Chin","Whole Foods",191,103.14,"NorthEast"]
["2007-05-06","Chin","PCC",1940,931.2,"West"]
["2005-11-29","Tom","PCC",80,36,"West"]
["2008-05-22","Sioux","Fred Myer",72,55.44,"West"]
["2007-12-15","Sioux","Whole Foods",250,110,"NorthWest"]
["2006-10-02","Tom","Whole Foods",219,109.5,"East"]
["2007-12-11","Chin","Safeway",219,168.63,"NorthEast"]
["2008-02-19","Sioux","Coop",85,39.1,"East"]
["2007-10-24","Tina","Safeway",115,52.9,"NorthEast"]
["2008-05-31","Joy","PCC",870,495.9,"East"]
["2007-03-30","Sioux","Fred Myer",124,65.72,"East"]
["2006-12-26","Tina","PCC",1460,861.4,"West"]
["2007-12-27","Sioux","Fred Myer",244,185.44,"East"]
["2007-03-25","Joy","Fred Myer",75,48.75,"East"]
["2006-10-29","Chin","Fred Myer",195,78,"West"]
["2008-01-30","Chin","Coop",248,181.04,"East"]
["2005-07-12","Tom","PCC",183,96.99,"NorthEast"]
["2006-06-16","Sioux","Whole Foods",88,51.92,"MidWest"]
["2008-05-27","Chin","Whole Foods",193,140.88999999999999,"East"]
["2005-11-27","Chin","Whole Foods",155,88.35,"MidWest"]
["2006-08-08","Tina","Safeway",202,119.18,"East"]
["2006-04-04","Tina","PCC",1908,1278.3599999999999,"NorthEast"]
["2008-05-07","Chin","PCC",126,75.599999999999994,"MidWest"]
["2006-12-08","Joy","Whole Foods",97,65.959999999999994,"West"]
["2007-01-02","Joy","Whole Foods",180,97.2,"East"]
["2008-05-15","Joy","Coop",67,40.200000000000003,"MidWest"]
["2007-11-20","Chin","Fred Myer",576,328.32,"West"]
["2007-11-17","Sioux","Safeway",230,165.6,"NorthEast"]
["2005-06-12","Tina","Safeway",86,59.34,"NorthWest"]
["2007-04-30","Joy","PCC",125,77.5,"MidWest"]
["2006-06-16","Joy","Fred Myer",113,73.45,"East"]
["2008-04-20","Sioux","Fred Myer",1399,1077.23,"NorthEast"]
["2007-01-17","Chin","Whole Foods",201,106.53,"NorthWest"]
["2007-03-16","Joy","PCC",82,52.48,"MidWest"]
["2007-07-10","Sioux","PCC",201,134.66999999999999,"NorthWest"]
["2006-04-10","Sioux","PCC",90,38.700000000000003,"MidWest"]
["2007-06-20","Tom","Whole Foods",191,95.5,"East"]
["2006-11-08","Tina","Whole Foods",71,37.630000000000003,"NorthWest"]
["2006-10-07","Sioux","Fred Myer",209,100.32,"NorthWest"]
["2008-05-23","Tom","PCC",205,84.05,"NorthWest"]
["2008-01-29","Tom","PCC",101,47.47,"East"]
["2006-12-30","Tom","Whole Foods",1928,867.6,"East"]
["2006-01-10","Joy","Safeway",189,143.63999999999999,"MidWest"]
["2008-06-04","Chin","PCC",596,452.96,"West"]
["2006-03-15","Chin","Fred Myer",224,100.8,"East"]
["2008-05-08","Tina","Whole Foods",110,86.9,"West"]
["2006-01-25","Tina","Safeway",188,75.2,"NorthEast"]
["2005-08-08","Joy","Fred Myer",224,145.6,"NorthWest"]
["2006-11-09","Joy","Whole Foods",155,75.95,"West"]
["2005-10-07","Sioux","Fred Myer",63,49.14,"East"]
["2007-08-30","Tom","Fred Myer",55,29.7,"NorthEast"]
["2005-10-14","Joy","PCC",1386,1108.8,"NorthWest"]
["2005-06-30","Tina","PCC",132,71.28,"NorthEast"]
["2006-05-14","Tina","Fred Myer",221,121.55,"NorthWest"]
["2006-10-30","Tina","PCC",236,146.32,"East"]
["2007-12-11","Tom","Coop",84,49.56,"NorthWest"]
["2006-03-30","Chin","PCC",55,22,"East"]
["2006-06-30","Chin","Fred Myer",204,153,"MidWest"]
["2007-07-12","Tina","Whole Foods",226,97.18,"NorthEast"]
["2006-10-04","Sioux","PCC",72,32.4,"East"]
["2006-09-26","Tina","Whole Foods",760,342,"NorthWest"]
["2007-07-20","Tom","Whole Foods",1064,734.16,"NorthWest"]
["2005-12-31","Tom","Safeway",66,34.979999999999997,"East"]
["2006-10-14","Joy","Safeway",181,123.08,"East"]
["2007-06-27","Sioux","Coop",205,139.4,"West"]
["2006-09-17","Tina","Safeway",94,47,"NorthEast"]
["2007-04-30","Joy","PCC",190,104.5,"MidWest"]
["2007-12-08","Tom","PCC",69,54.51,"East"]
["2007-12-01","Tom","Coop",158,71.099999999999994,"West"]
["2006-03-18","Sioux","Fred Myer",87,34.799999999999997,"East"]
["2007-02-17","Joy","Coop",139,98.69,"MidWest"]
["2008-05-13","Chin","Fred Myer",1780,1281.5999999999999,"NorthEast"]
["2005-06-07","Tom","Whole Foods",242,179.08,"West"]
["2006-07-22","Joy","Fred Myer",232,102.08,"East"]
["2005-11-14","Sioux","Coop",79,55.3,"NorthWest"]
["2007-07-08","Joy","Fred Myer",52,36.4,"NorthWest"]
["2005-10-13","Tina","Safeway",114,69.540000000000006,"West"]
["2007-11-16","Sioux","Coop",998,658.68,"East"]
["2005-05-30","Sioux","Safeway",68,47.6,"MidWest"]
["2005-08-06","Tom","PCC",157,108.33,"NorthEast"]
["2007-03-16","Chin","Whole Foods",137,105.49,"MidWest"]
["2006-04-17","Sioux","PCC",1983,1110.48,"NorthEast"]
["2008-05-16","Tina","Fred Myer",222,168.72,"MidWest"]
["2008-01-07","Chin","Coop",109,50.14,"East"]
["2006-10-20","Joy","Fred Myer",77,60.83,"West"]
["2005-08-22","Tom","Fred Myer",250,145,"MidWest"]
["2007-02-07","Tina","Safeway",57,40.47,"West"]
["2007-04-07","Tom","PCC",119,69.02,"NorthWest"]
["2005-08-21","Chin","Coop",222,93.24,"West"]
["2006-07-26","Tina","Coop",119,51.17,"West"]
["2005-10-12","Tom","Coop",135,70.2,"West"]
["2007-02-09","Sioux","Whole Foods",1276,714.56,"MidWest"]
["2008-01-05","Tina","PCC",135,55.35,"NorthWest"]
["2005-10-18","Sioux","Coop",97,43.65,"NorthEast"]
["2007-11-21","Joy","PCC",536,225.12,"NorthEast"]
["2007-03-18","Sioux","Whole Foods",95,47.5,"NorthEast"]
["2006-12-06","Joy","PCC",186,81.84,"NorthEast"]
["2005-08-19","Tina","Safeway",184,119.6,"MidWest"]
["2008-06-22","Tom","PCC",225,153,"MidWest"]
["2007-05-13","Sioux","PCC",235,152.75,"NorthWest"]
["2006-10-01","Tom","Whole Foods",87,62.64,"NorthEast"]
["2007-02-18","Sioux","Safeway",1855,1391.25,"West"]
["2005-08-13","Sioux","Safeway",151,102.68,"MidWest"]
["2006-08-08","Sioux","Whole Foods",177,83.19,"NorthEast"]
["2006-12-14","Tina","Fred Myer",91,50.05,"East"]
["2008-03-08","Chin","Whole Foods",96,48.96,"MidWest"]
["2006-02-04","Tina","Safeway",87,46.98,"West"]
["2008-04-02","Chin","Fred Myer",189,75.599999999999994,"MidWest"]
["2008-04-08","Tina","Whole Foods",134,58.96,"NorthEast"]
["2006-01-05","Chin","Whole Foods",151,64.930000000000007,"MidWest"]
["2008-01-06","Sioux","Whole Foods",66,38.94,"West"]
["2008-03-23","Tina","Safeway",603,295.47000000000003,"MidWest"]
["2007-08-28","Tom","Whole Foods",239,160.13,"NorthEast"]
["2006-08-14","Sioux","Fred Myer",74,59.2,"MidWest"]
["2006-05-16","Sioux","Coop",73,48.91,"West"]
["2007-09-07","Joy","PCC",217,123.69,"West"]
["2005-12-24","Sioux","PCC",82,50.02,"West"]
["2007-03-01","Chin","Fred Myer",241,161.47,"NorthEast"]
["2006-05-18","Tina","Safeway",115,57.5,"NorthWest"]
["2007-12-14","Sioux","PCC",166,124.5,"East"]
["2006-03-14","Sioux","Fred Myer",203,83.23,"NorthEast"]
["2007-04-28","Sioux","Fred Myer",1746,1187.28,"West"]
["2006-12-18","Sioux","Fred Myer",144,105.12,"NorthWest"]
["2008-03-21","Chin","Coop",203,158.34,"NorthWest"]
["2007-04-15","Tom","Fred Myer",117,69.03,"East"]
["2006-10-19","Tom","Whole Foods",205,145.55000000000001,"West"]
["2005-07-24","Tom","Whole Foods",152,71.44,"East"]
["2008-06-30","Joy","Whole Foods",175,105,"NorthWest"]
["2007-11-07","Tom","Fred Myer",814,407,"NorthEast"]
["2006-10-16","Sioux","PCC",182,120.12,"MidWest"]
["2006-01-13","Chin","Whole Foods",156,106.08,"NorthWest"]
["2007-07-12","Chin","Coop",1051,756.72,"NorthWest"]
["2006-12-29","Sioux","Coop",232,120.64,"NorthEast"]
["2006-05-21","Joy","Fred Myer",103,67.98,"MidWest"]
["2007-01-18","Sioux","Fred Myer",233,132.81,"West"]
["2005-09-13","Chin","Fred Myer",92,59.8,"West"]
["2006-02-18","Joy","Coop",114,80.94,"West"]
["2005-07-18","Tina","PCC",64,43.52,"East"]
["2008-02-16","Tina","Whole Foods",211,145.59,"MidWest"]
["2006-04-21","Chin","Fred Myer",219,131.4,"East"]
["2005-06-09","Chin","PCC",166,112.88,"MidWest"]
["2006-06-20","Chin","Whole Foods",1622,713.68,"West"]
["2006-09-04","Chin","Fred Myer",204,95.88,"NorthEast"]
["2007-07-29","Tom","Whole Foods",137,60.28,"MidWest"]
["2008-03-01","Sioux","Fred Myer",222,106.56,"East"]
["2007-07-17","Joy","Safeway",815,448.25,"NorthEast"]
["2008-03-18","Chin","Fred Myer",61,45.75,"East"]
["2007-02-19","Tom","Fred Myer",192,82.56,"MidWest"]
["2006-04-23","Sioux","PCC",232,127.6,"West"]
["2006-10-23","Chin","PCC",141,95.88,"NorthEast"]
["2005-07-06","Tina","Safeway",130,62.4,"NorthWest"]
["2008-05-06","Chin","Fred Myer",1945,1108.6500000000001,"NorthEast"]
["2007-07-29","Joy","Coop",106,61.48,"West"]
["2006-06-11","Chin","Coop",53,28.62,"NorthWest"]
["2006-09-30","Tom","Safeway",128,61.44,"NorthWest"]
["2006-09-04","Joy","PCC",61,35.380000000000003,"West"]
["2006-04-22","Tina","Whole Foods",216,110.16,"West"]
["2006-11-29","Joy","Fred Myer",65,48.75,"East"]
["2006-04-12","Tina","Coop",89,37.380000000000003,"NorthEast"]
["2006-12-13","Tina","Safeway",175,126,"NorthEast"]
["2006-06-16","Joy","Fred Myer",200,158,"NorthEast"]
["2007-11-18","Joy","Coop",1541,1063.29,"NorthEast"]
["2008-04-04","Chin","PCC",1054,706.18,"MidWest"]
["2007-07-18","Joy","Safeway",81,50.22,"East"]
["2007-07-17","Joy","Safeway",243,182.25,"East"]
["2005-06-14","Tina","Safeway",154,72.38,"NorthEast"]
["2006-08-16","Chin","Safeway",114,64.98,"East"]
["2006-12-20","Chin","Safeway",96,44.16,"NorthWest"]
["2006-04-25","Sioux","PCC",96,76.8,"East"]
["2007-03-19","Joy","Safeway",191,78.31,"NorthEast"]
["2005-06-18","Joy","Fred Myer",250,147.5,"NorthWest"]
["2006-06-15","Joy","Fred Myer",1674,1138.32,"NorthWest"]
["2008-01-23","Tom","PCC",162,95.58,"East"]
["2006-10-27","Chin","Coop",73,37.229999999999997,"East"]
["2006-10-29","Tina","Safeway",110,75.900000000000006,"MidWest"]
["2006-12-12","Joy","PCC",232,143.84,"NorthEast"]
["2006-03-16","Chin","Fred Myer",80,32.799999999999997,"NorthWest"]
["2007-05-05","Chin","PCC",94,38.54,"NorthWest"]
["2006-10-13","Tina","Fred Myer",92,65.319999999999993,"East"]
["2007-05-31","Joy","Coop",1223,758.26,"West"]
["2006-08-06","Chin","Safeway",242,191.18,"NorthWest"]
["2005-10-15","Tom","Whole Foods",1434,630.96,"East"]
["2006-01-23","Sioux","PCC",194,135.80000000000001,"NorthEast"]
["2006-07-12","Tina","PCC",63,30.87,"West"]
["2007-09-16","Sioux","Fred Myer",206,115.36,"East"]
["2008-01-24","Tina","Fred Myer",154,120.12,"West"]
["2006-08-03","Chin","Coop",66,31.02,"NorthEast"]
["2007-12-03","Tina","PCC",156,82.68,"East"]
["2007-09-05","Joy","Whole Foods",224,98.56,"NorthEast"]
["2006-12-30","Chin","Safeway",64,34.56,"NorthWest"]
["2006-11-03","Sioux","Whole Foods",246,157.44,"MidWest"]
["2007-09-18","Tom","Fred Myer",1426,627.44000000000005,"West"]
["2007-06-01","Tina","Fred Myer",91,50.05,"NorthEast"]
["2005-10-28","Chin","PCC",83,56.44,"NorthWest"]
["2008-06-13","Joy","Coop",53,24.38,"NorthWest"]
["2008-01-07","Chin","Coop",114,74.099999999999994,"East"]
["2006-04-22","Tom","Whole Foods",1133,895.07,"East"]
["2006-09-04","Sioux","Whole Foods",102,54.06,"NorthWest"]
["2008-02-25","Chin","Safeway",234,114.66,"NorthWest"]
["2005-08-29","Joy","Safeway",239,174.47,"NorthWest"]
["2008-02-23","Tom","Fred Myer",151,78.52,"MidWest"]
["2006-11-24","Joy","Whole Foods",1075,849.25,"NorthEast"]
["2008-01-25","Tom","PCC",157,120.89,"MidWest"]
["2007-06-25","Joy","Coop",249,179.28,"West"]

{"sheet":"PT(1an)","index":9,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Sales","Customer"]
["Sales Rep","Whole Foods","Safeway","PCC","Fred Myer","Coop"]
["Chin",9614,4674,9605,11715,9377]
["Joy",3916,5230,9094,9208,9931]
["Sioux",7782,9137,7272,7399,4909]
["Tina",4594,4174,7374,6358,3957]
["Tom",12107,4660,6182,8988,8366]

{"sheet":"PT(2an)","index":10,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Customer","Sum of Sales","Average of Sales","StdDevp of Sales"]
["Coop",36540,401.53846153846155,516.28668472894242]
["Fred Myer",43668,323.46666666666664,466.01875339788478]
["PCC",39527,301.73282442748092,421.1596463351907]
["Safeway",27875,253.40909090909091,364.00457777976925]
["Whole Foods",38013,309.04878048780489,394.77203164618629]
["Grand Total",185623,314.61525423728813,435.0929370089853]

{"sheet":"PT(4)","index":11,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Sales","Sales Rep"]
["Customer","Chin","Joy","Sioux","Tina","Tom","Grand Total"]
["Coop",9377,9931,4909,3957,8366,36540]
["Fred Myer",11715,9208,7399,6358,8988,43668]
["PCC",9605,9094,7272,7374,6182,39527]
["Safeway",4674,5230,9137,4174,4660,27875]
["Whole Foods",9614,3916,7782,4594,12107,38013]
["Grand Total",44985,37379,36499,26457,40303,185623]

{"sheet":"Data Analysis(3)","index":12,"n_rows":389,"n_cols":9,"rows_kept":389,"cut":false,"hidden":false,"merged":[]}
["To Count a set of data, drop the field into the Row Labels area and the Value area.",null,null,null,null,null,null,null,{"$f":"CHOOSE(RANDBETWEEN(1,10),\"iPhone\",\"iPhone\",\"iPhone\",\"Nokia\",\"Motorola\",\"Sony Erickson\",\"Samsung\",\"T-Mobile\",\"Sony Erickson\",\"Samsung\")","v":"T-Mobile"}]
["When dropping fields into Value area, the default function for numbers is \"Sum\", the default function for text is \"Count\" (**In PivotTables \"Count\" function counts anything, numbers or text. This is different than the \"COUNT\" function that we use in a cell. \"COUNT\" function in cell counts numebrs only. In a PivotTable if you want to count numbers only, use the \"Count Number\" function.)"]
[]
["Student","Phone Type"]
["Student 01","iPhone"]
["Student 02","Nokia"]
["Student 03","iPhone"]
["Student 04","iPhone"]
["Student 05","iPhone"]
["Student 06","Sony Erickson"]
["Student 07","Motorola"]
["Student 08","Sony Erickson"]
["Student 09","T-Mobile"]
["Student 10","Samsung"]
["Student 11","iPhone"]
["Student 12","iPhone"]
["Student 13","T-Mobile"]
["Student 14","iPhone"]
["Student 15","Samsung"]
["Student 16","iPhone"]
["Student 17","Sony Erickson"]
["Student 18","iPhone"]
["Student 19","iPhone"]
["Student 20","iPhone"]
["Student 21","Nokia"]
["Student 22","T-Mobile"]
["Student 23","Motorola"]
["Student 24","Sony Erickson"]
["Student 25","Nokia"]
["Student 26","iPhone"]
["Student 27","T-Mobile"]
["Student 28","Sony Erickson"]
["Student 29","iPhone"]
["Student 30","Sony Erickson"]
["Student 31","Sony Erickson"]
["Student 32","Samsung"]
["Student 33","iPhone"]
["Student 34","Nokia"]
["Student 35","T-Mobile"]
["Student 36","Samsung"]
["Student 37","T-Mobile"]
["Student 38","iPhone"]
["Student 39","Sony Erickson"]
["Student 40","iPhone"]
["Student 41","T-Mobile"]
["Student 42","Sony Erickson"]
["Student 43","T-Mobile"]
["Student 44","Samsung"]
["Student 45","Motorola"]
["Student 46","Samsung"]
["Student 47","Motorola"]
["Student 48","Sony Erickson"]
["Student 49","T-Mobile"]
["Student 50","Nokia"]
["Student 51","Motorola"]
["Student 52","Sony Erickson"]
["Student 53","Nokia"]
["Student 54","Motorola"]
["Student 55","Sony Erickson"]
["Student 56","Nokia"]
["Student 57","Nokia"]
["Student 58","T-Mobile"]
["Student 59","Motorola"]
["Student 60","Samsung"]
["Student 61","iPhone"]
["Student 62","iPhone"]
["Student 63","T-Mobile"]
["Student 64","Samsung"]
["Student 65","iPhone"]
["Student 66","Samsung"]
["Student 67","iPhone"]
["Student 68","T-Mobile"]
["Student 69","Nokia"]
["Student 70","Samsung"]
["Student 71","iPhone"]
["Student 72","T-Mobile"]
["Student 73","Samsung"]
["Student 74","T-Mobile"]
["Student 75","iPhone"]
["Student 76","Sony Erickson"]
["Student 77","Sony Erickson"]
["Student 78","iPhone"]
["Student 79","Nokia"]
["Student 80","Sony Erickson"]
["Student 81","Sony Erickson"]
["Student 82","Sony Erickson"]
["Student 83","iPhone"]
["Student 84","Nokia"]
["Student 85","iPhone"]
["Student 86","Nokia"]
["Student 87","T-Mobile"]
["Student 88","iPhone"]
["Student 89","Sony Erickson"]
["Student 90","Motorola"]
["Student 91","Samsung"]
["Student 92","Sony Erickson"]
["Student 93","iPhone"]
["Student 94","iPhone"]
["Student 95","T-Mobile"]
["Student 96","Motorola"]
["Student 97","Samsung"]
["Student 98","Samsung"]
["Student 99","Sony Erickson"]
["Student 100","iPhone"]
["Student 101","Samsung"]
["Student 102","Nokia"]
["Student 103","Sony Erickson"]
["Student 104","iPhone"]
["Student 105","iPhone"]
["Student 106","Nokia"]
["Student 107","Sony Erickson"]
["Student 108","Sony Erickson"]
["Student 109","Samsung"]
["Student 110","Motorola"]
["Student 111","Motorola"]
["Student 112","Samsung"]
["Student 113","iPhone"]
["Student 114","Samsung"]
["Student 115","Sony Erickson"]
["Student 116","Samsung"]
["Student 117","Samsung"]
["Student 118","Sony Erickson"]
["Student 119","Samsung"]
["Student 120","iPhone"]
["Student 121","T-Mobile"]
["Student 122","Nokia"]
["Student 123","Samsung"]
["Student 124","iPhone"]
["Student 125","Nokia"]
["Student 126","Sony Erickson"]
["Student 127","T-Mobile"]
["Student 128","Samsung"]
["Student 129","Samsung"]
["Student 130","Samsung"]
["Student 131","iPhone"]
["Student 132","Motorola"]
["Student 133","Nokia"]
["Student 134","iPhone"]
["Student 135","Sony Erickson"]
["Student 136","T-Mobile"]
["Student 137","Samsung"]
["Student 138","Nokia"]
["Student 139","Nokia"]
["Student 140","Nokia"]
["Student 141","T-Mobile"]
["Student 142","Samsung"]
["Student 143","Samsung"]
["Student 144","T-Mobile"]
["Student 145","Nokia"]
["Student 146","T-Mobile"]
["Student 147","T-Mobile"]
["Student 148","Sony Erickson"]
["Student 149","iPhone"]
["Student 150","Samsung"]
["Student 151","Sony Erickson"]
["Student 152","Sony Erickson"]
["Student 153","Samsung"]
["Student 154","iPhone"]
["Student 155","Nokia"]
["Student 156","T-Mobile"]
["Student 157","T-Mobile"]
["Student 158","Sony Erickson"]
["Student 159","iPhone"]
["Student 160","Sony Erickson"]
["Student 161","Motorola"]
["Student 162","iPhone"]
["Student 163","T-Mobile"]
["Student 164","Samsung"]
["Student 165","Sony Erickson"]
["Student 166","Motorola"]
["Student 167","T-Mobile"]
["Student 168","Sony Erickson"]
["Student 169","Sony Erickson"]
["Student 170","iPhone"]
["Student 171","T-Mobile"]
["Student 172","Samsung"]
["Student 173","iPhone"]
["Student 174","iPhone"]
["Student 175","Motorola"]
["Student 176","iPhone"]
["Student 177","Samsung"]
["Student 178","Samsung"]
["Student 179","Samsung"]
["Student 180","Nokia"]
["Student 181","T-Mobile"]
["Student 182","iPhone"]
["Student 183","Motorola"]
["Student 184","Nokia"]
["Student 185","Samsung"]
["Student 186","Sony Erickson"]
["Student 187","Samsung"]
["Student 188","T-Mobile"]
["Student 189","T-Mobile"]
["Student 190","Nokia"]
["Student 191","T-Mobile"]
["Student 192","Sony Erickson"]
["Student 193","Samsung"]
["Student 194","iPhone"]
["Student 195","T-Mobile"]
["Student 196","Sony Erickson"]
["Student 197","Motorola"]
["Student 198","Samsung"]
["Student 199","Motorola"]
["Student 200","Sony Erickson"]
["Student 201","Motorola"]
["Student 202","Sony Erickson"]
["Student 203","Sony Erickson"]
["Student 204","Samsung"]
["Student 205","iPhone"]
["Student 206","Sony Erickson"]
["Student 207","Motorola"]
["Student 208","iPhone"]
["Student 209","iPhone"]
["Student 210","Samsung"]
["Student 211","Sony Erickson"]
["Student 212","Motorola"]
["Student 213","iPhone"]
["Student 214","Sony Erickson"]
["Student 215","Samsung"]
["Student 216","Nokia"]
["Student 217","iPhone"]
["Student 218","iPhone"]
["Student 219","Samsung"]
["Student 220","Nokia"]
["Student 221","iPhone"]
["Student 222","T-Mobile"]
["Student 223","Sony Erickson"]
["Student 224","Nokia"]
["Student 225","Sony Erickson"]
["Student 226","iPhone"]
["Student 227","T-Mobile"]
["Student 228","Samsung"]
["Student 229","Nokia"]
["Student 230","Sony Erickson"]
["Student 231","T-Mobile"]
["Student 232","iPhone"]
["Student 233","Samsung"]
["Student 234","Samsung"]
["Student 235","Sony Erickson"]
["Student 236","Sony Erickson"]
["Student 237","Samsung"]
["Student 238","Sony Erickson"]
["Student 239","Samsung"]
["Student 240","iPhone"]
["Student 241","iPhone"]
["Student 242","Sony Erickson"]
["Student 243","T-Mobile"]
["Student 244","Sony Erickson"]
["Student 245","T-Mobile"]
["Student 246","Motorola"]
["Student 247","Samsung"]
["Student 248","iPhone"]
["Student 249","Nokia"]
["Student 250","T-Mobile"]
["Student 251","Samsung"]
["Student 252","Motorola"]
["Student 253","Nokia"]
["Student 254","T-Mobile"]
["Student 255","Sony Erickson"]
["Student 256","Sony Erickson"]
["Student 257","iPhone"]
["Student 258","Samsung"]
["Student 259","iPhone"]
["Student 260","iPhone"]
["Student 261","Sony Erickson"]
["Student 262","Sony Erickson"]
["Student 263","iPhone"]
["Student 264","Motorola"]
["Student 265","iPhone"]
["Student 266","Sony Erickson"]
["Student 267","Samsung"]
["Student 268","Sony Erickson"]
["Student 269","Motorola"]
["Student 270","Sony Erickson"]
["Student 271","Motorola"]
["Student 272","T-Mobile"]
["Student 273","Nokia"]
["Student 274","Nokia"]
["Student 275","iPhone"]
["Student 276","iPhone"]
["Student 277","iPhone"]
["Student 278","iPhone"]
["Student 279","iPhone"]
["Student 280","Sony Erickson"]
["Student 281","iPhone"]
["Student 282","iPhone"]
["Student 283","Sony Erickson"]
["Student 284","T-Mobile"]
["Student 285","Motorola"]
["Student 286","Nokia"]
["Student 287","Motorola"]
["Student 288","Sony Erickson"]
["Student 289","Nokia"]
["Student 290","iPhone"]
["Student 291","Samsung"]
["Student 292","iPhone"]
["Student 293","Motorola"]
["Student 294","T-Mobile"]
["Student 295","iPhone"]
["Student 296","iPhone"]
["Student 297","Sony Erickson"]
["Student 298","Sony Erickson"]
["Student 299","iPhone"]
["Student 300","Samsung"]
["Student 301","Sony Erickson"]
["Student 302","T-Mobile"]
["Student 303","T-Mobile"]
["Student 304","iPhone"]
["Student 305","Samsung"]
["Student 306","Sony Erickson"]
["Student 307","Motorola"]
["Student 308","Nokia"]
["Student 309","iPhone"]
["Student 310","Nokia"]
["Student 311","Nokia"]
["Student 312","Motorola"]
["Student 313","Samsung"]
["Student 314","iPhone"]
["Student 315","T-Mobile"]
["Student 316","Samsung"]
["Student 317","iPhone"]
["Student 318","Samsung"]
["Student 319","iPhone"]
["Student 320","Motorola"]
["Student 321","Nokia"]
["Student 322","Samsung"]
["Student 323","Sony Erickson"]
["Student 324","iPhone"]
["Student 325","Sony Erickson"]
["Student 326","Nokia"]
["Student 327","iPhone"]
["Student 328","iPhone"]
["Student 329","Samsung"]
["Student 330","Samsung"]
["Student 331","Nokia"]
["Student 332","Samsung"]
["Student 333","Samsung"]
["Student 334","Sony Erickson"]
["Student 335","Motorola"]
["Student 336","Motorola"]
["Student 337","Motorola"]
["Student 338","Motorola"]
["Student 339","Sony Erickson"]
["Student 340","Nokia"]
["Student 341","iPhone"]
["Student 342","Sony Erickson"]
["Student 343","Sony Erickson"]
["Student 344","iPhone"]
["Student 345","Sony Erickson"]
["Student 346","T-Mobile"]
["Student 347","iPhone"]
["Student 348","Sony Erickson"]
["Student 349","iPhone"]
["Student 350","Motorola"]
["Student 351","Motorola"]
["Student 352","Samsung"]
["Student 353","iPhone"]
["Student 354","T-Mobile"]
["Student 355","Nokia"]
["Student 356","T-Mobile"]
["Student 357","Sony Erickson"]
["Student 358","T-Mobile"]
["Student 359","Motorola"]
["Student 360","Motorola"]
["Student 361","Nokia"]
["Student 362","iPhone"]
["Student 363","Motorola"]
["Student 364","Samsung"]
["Student 365","iPhone"]
["Student 366","Samsung"]
["Student 367","Motorola"]
["Student 368","iPhone"]
["Student 369","iPhone"]
["Student 370","iPhone"]
["Student 371","iPhone"]
["Student 372","Samsung"]
["Student 373","iPhone"]
["Student 374","Samsung"]
["Student 375","Samsung"]
["Student 376","Samsung"]
["Student 377","iPhone"]
["Student 378","Samsung"]
["Student 379","Motorola"]
["Student 380","iPhone"]
["Student 381","Samsung"]
["Student 382","T-Mobile"]
["Student 383","Motorola"]
["Student 384","iPhone"]
["Student 385","iPhone"]

{"sheet":"PT(3an)","index":13,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Phone Type","Count of Phone Type"]
["Motorola",44]
["Samsung",72]
["Sony Erickson",75]
["T-Mobile",51]
["Grand Total",242]

{"sheet":"Charts(3)","index":14,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Charts are on the Insert Menu"]
["Once you select a Chart, three context sensitive menus appear: Design, Layout, Format"]
["Most Chart Elements can be formatted with the Format Chart dialog box by right-clicking the element and pointing to \"Format …\" or by using the keyboard shortcut Ctrl + 1."]
["You can link chart titles and labels by: 1) selecting label, 2) clicking in formula bar, 3) typing an equal sign, 4) clicking on cell with label, 5) Enter."]
["Pie Charts: Compare \"parts to the whole\", or \"individual numbers to the total\". Good for percentages, proportions, probabilities."]
["Column Charts have VERTICAL bars that show changes across categories."]
["Bar Charts have HORIZONTAL bars that show changes across categories."]
["Line Charts are for showing changes across a category. The number is plotted on the vertical axis and the category is plotted on the horizontal axis. (Only ONE number is plotted (even if the category is a Year)."]
["X - Y Scatter charts are for showing the relationship between TWO numbers. The independent or X value is plotted on the horizontal axis and the dependent or Y value is plotted on the vertical axis."]
[]
["WARNING: Book calls column charts \"Bar\". In Excel and in this class (testing) Column = Vertical and Bar = Horizontal"]
[]
["Pie: Compare Parts To The Whole",null,null,"Column: Compare numbers across Categories"]
["Qtr","Sales",null,"SalesRep","Sales 2010"]
["Qtr 1",391163,null,"Joe",391163,null,"Bar: Compare numbers across Categories. Emphasize Differences."]
["Qtr 2",734599,null,"Sioux",734599,null,"Qtr","Sales"]
["Qtr 3",648414,null,"Chin",648414,null,"Joe",391163]
["Qtr 4",938115,null,"Shelia",938115,null,"Sioux",734599]
[null,null,null,null,null,null,"Chin",648414]
["Two Charts in 1",null,null,null,null,null,"Shelia",938115]
["Qtr","Revenue","Expenses"]
["Qtr 1",591163,295581.5]
["Qtr 2",734599,337915.54000000004]
["Qtr 3",648414,330691.14]
["Qtr 4",638115,299914.05]

{"sheet":"Charts(3an)","index":15,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Charts are on the Insert Menu"]
["Once you select a Chart, three context sensitive menus appear: Design, Layout, Format"]
["Most Chart Elements can be formatted with the Format Chart dialog box by right-clicking the element and pointing to \"Format …\" or by using the keyboard shortcut Ctrl + 1."]
["You can link chart titles and labels by: 1) selecting label, 2) clicking in formula bar, 3) typing an equal sign, 4) clicking on cell with label, 5) Enter."]
["Pie Charts: Compare \"parts to the whole\", or \"individual numbers to the total\". Good for percentages, proportions, probabilities."]
["Column Charts have VERTICAL bars that show changes across categories."]
["Bar Charts have HORIZONTAL bars that show changes across categories."]
["Line Charts are for showing changes across a category. The number is plotted on the vertical axis and the category is plotted on the horizontal axis. (Only ONE number is plotted (even if the category is a Year)."]
["X - Y Scatter charts are for showing the relationship between TWO numbers. The independent or X value is plotted on the horizontal axis and the dependent or Y value is plotted on the vertical axis."]
[]
["WARNING: Book calls column charts \"Bar\". In Excel and in this class (testing) Column = Vertical and Bar = Horizontal"]
[]
["Pie: Compare Parts To The Whole",null,null,"Column: Compare numbers across Categories"]
["Qtr","Sales",null,"SalesRep","Sales 2010"]
["Qtr 1",391163,null,"Joe",391163,null,"Bar: Compare numbers across Categories. Emphasize Differences."]
["Qtr 2",734599,null,"Sioux",734599,null,"Qtr","Sales"]
["Qtr 3",648414,null,"Chin",648414,null,"Joe",391163]
["Qtr 4",938115,null,"Shelia",938115,null,"Sioux",734599]
[null,null,null,null,null,null,"Chin",648414]
["Two Charts in 1",null,null,null,null,null,"Shelia",938115]
["Qtr","Revenue","Expenses"]
["Qtr 1",591163,295581.5]
["Qtr 2",734599,337915.54000000004]
["Qtr 3",648414,330691.14]
["Qtr 4",638115,299914.05]

{"sheet":"Charts(4)","index":16,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Line: Compare change across categories or Trend (ONE NUMBER ONLY!!)",null,null,null,null,null,"X-Y Scatter: Plot Relationship Between Two Numbers (X on Horizontal, Y on Vertical)."]
[]
["Qtr","Sales",null,"Year","Sales",null,"Hour Spent Studying Per Week For One Statistics Class","Test Score",null,"Select Whole  Table: Ctrl + *"]
["Qtr 1",391163,null,2000,91163,null,7,83]
["Qtr 2",734599,null,2001,134599,null,20,100]
["Qtr 3",648414,null,2002,148414,null,13,92]
["Qtr 4",938115,null,2003,138115,null,9,90]
[null,null,null,2004,199845,null,5,75]
[null,null,null,2005,199185,null,15,95]
[null,null,null,2006,122919,null,22,105]
[null,null,null,2007,180820,null,14,93]
[null,null,null,2008,162194,null,25,110]
[null,null,null,2009,249388,null,2,51]
[null,null,null,2010,196892,null,8,82]
[null,null,null,2011,209926,null,6,69]
[null,null,null,2012,355488,null,10,81]
[null,null,null,null,null,null,16,94]
[null,null,null,null,null,null,3,35]
[null,null,null,null,null,null,24,103]
[null,null,null,null,null,null,8,84]
[null,null,null,null,null,null,40,108]
[null,null,null,null,null,null,15,89]
[null,null,null,null,null,null,25,96]
[null,null,null,null,null,null,21,91]
[null,null,null,null,null,null,7,80]
[null,null,null,null,null,null,9,78]
[null,null,null,null,null,null,11,80]
[null,null,null,null,null,null,14,91]
[null,null,null,null,null,null,4,71]
[null,null,null,null,null,null,8,80]

{"sheet":"Charts(4an)","index":17,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Line: Compare change across categories or Trend (ONE NUMBER ONLY!!)",null,null,null,null,null,"X-Y Scatter: Plot Relationship Between Two Numbers (X on Horizontal, Y on Vertical)."]
[]
["Qtr","Sales",null,"Year","Sales",null,"Hour Spent Studying Per Week For One Statistics Class","Test Score",null,"Select Whole  Table: Ctrl + *"]
["Qtr 1",391163,null,2000,91163,null,7,83]
["Qtr 2",734599,null,2001,134599,null,20,100]
["Qtr 3",648414,null,2002,148414,null,13,92]
["Qtr 4",938115,null,2003,138115,null,9,90]
[null,null,null,2004,199845,null,5,75]
[null,null,null,2005,199185,null,15,95]
[null,null,null,2006,122919,null,22,105]
[null,null,null,2007,180820,null,14,93]
[null,null,null,2008,162194,null,25,110]
[null,null,null,2009,249388,null,2,51]
[null,null,null,2010,196892,null,8,82]
[null,null,null,2011,209926,null,6,69]
[null,null,null,2012,355488,null,10,81]
[null,null,null,null,null,null,16,94]
[null,null,null,null,null,null,3,35]
[null,null,null,null,null,null,24,103]
[null,null,null,null,null,null,8,84]
[null,null,null,null,null,null,40,108]
[null,null,null,null,null,null,15,89]
[null,null,null,null,null,null,25,96]
[null,null,null,null,null,null,21,91]
[null,null,null,null,null,null,7,80]
[null,null,null,null,null,null,9,78]
[null,null,null,null,null,null,11,80]
[null,null,null,null,null,null,14,91]
[null,null,null,null,null,null,4,71]
[null,null,null,null,null,null,8,80]

{"sheet":"Cell References","index":18,"n_rows":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Cell References are used in formulas. For Example if you have the formula =A7-$A$11 in cell B7, the formula will always take the value in cell \"One to the left\" of the cell that the formula sits in  and subtract the value in cell A11."]
[null,null,null,null,"In this class we will only use two of the four types of cell references"]
[null,null,null,null,"Relative Cell Reference means that when you copy the formula, the cell reference moves relatively. For example if the formula is in a cell and the formula is look at a cell reference that is one cell to the left, that cell reference will always look one cell to the left."]
[null,null,null,null,"Absolute Cell Reference means that when you copy the formula, the cell reference is locked. The cell reference will only point to the original cell. To Apply the $ sign code to the column and row reference, use the keyboard shortcut, F4 (F4 adds the two dollar signs to make the relative cell reference into an absolute cell reference."]
[]
[]
[{"$f":"\"Ave \"&A10","v":"Ave Quiz 1"},{"$f":"\"Ave \"&B10","v":"Ave Quiz 2"},"Ave Quiz 3",null,"Average"]
[]
[null,null,null,null,"X","X - Average"]
["Quiz 1","Quiz 2","Quiz 3",null,23]
[18,15,3,null,24]
[16,18,2,null,19]
[2,4,15,null,28]
[17,16,3]
[24,7,9,null,"CarTypes",null,"CarTypes","Frequency"]
[16,16,3,null,"Honda",null,"Ford"]
[14,5,16,null,"Toyota",null,"Toyota"]
[20,23,1,null,"Honda",null,"Honda"]
[14,7,18,null,"Toyota"]
[7,21,6,null,"Honda"]
[1,5,3,null,"Toyota"]
[11,5,19,null,"Ford"]
[4,19,15,null,"Toyota"]
[3,21,4,null,"Ford"]
[7,17,22,null,"Toyota"]
[17,3,22,null,"Toyota"]
[14,22,13,null,"Ford"]
[9,1,13,null,"Honda"]
[9,16,21,null,"Ford"]
[5,10,14,null,"Ford"]
[16,23,19,null,"Ford"]
[21,12,24,null,"Honda"]
[21,17,16,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]

{"sheet":"Cell References (an)","index":19,"n_rows":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Cell References are used in formulas. For Example if you have the formula =A7-$A$11 in cell B7, the formula will always take the value in cell \"One to the left\" of the cell that the formula sits in  and subtract the value in cell A11."]
[null,null,null,null,"In this class we will only use two of the four types of cell references"]
[null,null,null,null,"Relative Cell Reference means that when you copy the formula, the cell reference moves relatively. For example if the formula is in a cell and the formula is look at a cell reference that is one cell to the left, that cell reference will always look one cell to the left."]
[null,null,null,null,"Absolute Cell Reference means that when you copy the formula, the cell reference is locked. The cell reference will only point to the original cell. To Apply the $ sign code to the column and row reference, use the keyboard shortcut, F4 (F4 adds the two dollar signs to make the relative cell reference into an absolute cell reference."]
[]
[]
[{"$f":"\"Ave \"&A10","v":"Ave Quiz 1"},{"$f":"\"Ave \"&B10","v":"Ave Quiz 2"},"Ave Quiz 3",null,"Average",{"$f":"AVERAGE(E10:E13)","v":23.5}]
[{"$f":"AVERAGE(A11:A33)","v":12.434782608695652},{"$f":"AVERAGE(B11:B33)","v":13.173913043478262},12.217391304347826]
[null,null,null,null,"X","X - Average"]
["Quiz 1","Quiz 2","Quiz 3",null,23,{"$f":"E10-$F$7","v":-0.5}]
[18,15,3,null,24,{"$f":"E11-$F$7","v":0.5}]
[16,18,2,null,19,-4.5]
[2,4,15,null,28,{"$f":"E13-$F$7","v":4.5}]
[17,16,3]
[24,7,9,null,"CarTypes",null,"CarTypes","Frequency"]
[16,16,3,null,"Honda",null,"Ford",{"$f":"COUNTIF($E$16:$E$74,G16)","v":19}]
[14,5,16,null,"Toyota",null,"Toyota",{"$f":"COUNTIF($E$16:$E$74,G17)","v":29}]
[20,23,1,null,"Honda",null,"Honda",{"$f":"COUNTIF($E$16:$E$74,G18)","v":11}]
[14,7,18,null,"Toyota"]
[7,21,6,null,"Honda"]
[1,5,3,null,"Toyota"]
[11,5,19,null,"Ford"]
[4,19,15,null,"Toyota"]
[3,21,4,null,"Ford"]
[7,17,22,null,"Toyota"]
[17,3,22,null,"Toyota"]
[14,22,13,null,"Ford"]
[9,1,13,null,"Honda"]
[9,16,21,null,"Ford"]
[5,10,14,null,"Ford"]
[16,23,19,null,"Ford"]
[21,12,24,null,"Honda"]
[21,17,16,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Ford"]

{"sheet":"Prop Prob Perc","index":20,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["CarTypes",null,"CarTypes","Frequency","% Frequency",null,"Proportion","Probability","Percentage"]
["Toyota",null,"Ford"]
["Toyota",null,"Toyota"]
["Toyota",null,"Honda"]
["Honda",null,"Total"]
["Honda"]
["Ford",null,null,null,null,null,null,"check"]
["Ford",null,"Percent that is Ford OR Toyota =",null,null,null,null,{"$f":"(COUNTIF(A2:A60,C2)+COUNTIF(A2:A60,C3))/COUNTA(A2:A60)","v":0.67796610169491522}]
["Honda",null,"<==","<=="]
["Honda",null,"Because the two categories are mutually exclusive (Each car can only fit in one category), you can just add them."]
["Toyota"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Ford"]
["Ford"]
["Ford"]
["Honda"]
["Toyota"]
["Toyota"]
["Honda"]
["Ford"]
["Toyota"]
["Toyota"]
["Honda"]
["Honda"]
["Ford"]
["Honda"]
["Ford"]
["Toyota"]
["Honda"]
["Ford"]
["Honda"]
["Honda"]
["Ford"]
["Toyota"]
["Honda"]
["Ford"]
["Honda"]
["Ford"]
["Honda"]
["Toyota"]
["Ford"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Toyota"]
["Ford"]
["Ford"]
["Ford"]

{"sheet":"Prop Prob Perc (an)","index":21,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["CarTypes",null,"CarTypes","Frequency","% Frequency",null,"Proportion","Probability","Percentage"]
["Toyota",null,"Ford",{"$f":"COUNTIF($A$2:$A$60,C2)","v":17},{"$f":"D2/$D$5","v":0.28813559322033899},null,{"$f":"D2/$D$5","v":0.28813559322033899},{"$f":"D2/$D$5","v":0.28813559322033899},{"$f":"D2/$D$5","v":0.28813559322033899}]
["Toyota",null,"Toyota",{"$f":"COUNTIF($A$2:$A$60,C3)","v":23},{"$f":"D3/$D$5","v":0.38983050847457629},null,{"$f":"D3/$D$5","v":0.38983050847457629},{"$f":"D3/$D$5","v":0.38983050847457629},{"$f":"D3/$D$5","v":0.38983050847457629}]
["Toyota",null,"Honda",19,0.32203389830508472,null,0.32203389830508472,0.32203389830508472,0.32203389830508472]
["Honda",null,"Total",{"$f":"SUM(D2:D4)","v":59},1,null,1,1,1]
["Honda"]
["Ford",null,null,null,null,null,null,"check"]
["Ford",null,"Percent that is Ford OR Toyota =",null,{"$f":"SUM(E2:E3)","v":0.67796610169491522},null,null,{"$f":"(COUNTIF(A2:A60,C2)+COUNTIF(A2:A60,C3))/COUNTA(A2:A60)","v":0.67796610169491522}]
["Honda",null,"<==","<==",{"$f":"SUM(D2:D3)/D5","v":0.67796610169491522}]
["Honda",null,"Because the two categories are mutually exclusive (Each car can only fit in one category), you can just add them."]
["Toyota"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Honda"]
["Toyota"]
["Honda"]
["Toyota"]
["Toyota"]
["Toyota"]
["Toyota"]
["Ford"]
["Ford"]
["Ford"]
["Honda"]
["Toyota"]
["Toyota"]
["Honda"]
["Ford"]
["Toyota"]
["Toyota"]
["Honda"]
["Honda"]
["Ford"]
["Honda"]
["Ford"]
["Toyota"]
["Honda"]
["Ford"]
["Honda"]
["Honda"]
["Ford"]
["Toyota"]
["Honda"]
["Ford"]
["Honda"]
["Ford"]
["Honda"]
["Toyota"]
["Ford"]
["Toyota"]
["Honda"]
["Toyota"]
["Ford"]
["Toyota"]
["Ford"]
["Ford"]
["Ford"]