{"text_format":"1","workbook":"xlsx","n_sheets":37,"sheets":["ES(1)C","ES(2)C","ES(3)C","ES(4)C","TopicsCh(1)","Data & Table","Data Terms","PhoneCount","Statistics","TGN","Art","Example of Inferential Stats","What Excel Does","Structure","Conventions","Data & Alignmnet","Data & Alignmnet (an)","Keyboards","Keyboards (an)","Cursors","Formula Elements","Full List Worksheet Formula El ","Worksheet Formula Models","Worksheet Formula Models (an)","Types of Formulas","Formula Type Examples","Formula Type Examples (an)","ExcelTables","ExcelTables(an)","% Formulas","% Formulas (an)","PowerQueryPivotTableChartNotes","Second Frequency Distribution","PivotTables","PivotTables (an)","Power Query & PivotTables","Power Query & PivotTables (an)"],"not_rendered":{"charts":3,"images":11,"macros":1,"external_links":0,"defined_names":47,"comments":0,"pivot_tables":8},"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":"ES(1)C","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,1,14,9],[1,1,10,9]]}
[]
[null,"Excel Business\nStatistical Analysis:\n \nData & Statistics"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excel Business Statistics 1"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"LEN(C18)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,"Microsoft 365 Excel"]

{"sheet":"ES(2)C","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,10,9],[11,1,14,9]]}
[]
[null,"Excel Business\nStatistical Analysis:\n \nStructure of Excel files"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excel Business Statistics 2"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"LEN(C18)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,"Microsoft 365 Excel"]

{"sheet":"ES(3)C","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,10,9],[11,1,14,9]]}
[]
[null,"Excel Business\nStatistical Analysis:\n \nBuilding Worksheet Formula Models"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excel Business Statistics 3"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"LEN(C18)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,"Microsoft 365 Excel"]

{"sheet":"ES(4)C","index":3,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,10,9],[11,1,14,9]]}
[]
[null,"Excel Business Statistical Analysis:\n\nPower Query & PivotTable\n\n1) PivotTable to build Frequency Distribution\n2) Power Query to Import & Transform CSV File\n3) PivotTable Grouping Feature for Quantitative Data to Build Frequency Distributions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excel Business Statistics 4"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"LEN(C18)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,"Microsoft 365 Excel"]

{"sheet":"TopicsCh(1)","index":4,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[11,1,14,1],[2,1,4,1],[5,1,10,1],[15,1,17,1]]}
[]
[null,"Video","Chapter 1: Data, Statistics & Excel"]
[null,1,"Folder & files in class"]
[null,null,"Data Analysis, Data, Tables"]
[null,null,"What is statistics?"]
[null,2,"Microsoft 365 Excel:"]
[null,null,"1) Structure of Excel, Cells, Worksheet, Workbook, Ribbon, QAT"]
[null,null,"2) Excel workbook conventions for class"]
[null,null,"3) Data and Alignment in Excel"]
[null,null,"4) Keyboards"]
[null,null,"5) What Excel does"]
[null,3,"6) Worksheet formulas elements"]
[null,null,"7) Worksheet formula models"]
[null,null,"8) Types of worksheet formulas"]
[null,null,"9) % Formulas"]
[null,4,"10) PivotTable to build Frequency Distribution"]
[null,null,"11) Power Query to Import & Transform CSV File"]
[null,null,"12) PivotTable Grouping Feature for Quantitative Data to Build Frequency Distributions"]

{"sheet":"Data & Table","index":5,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,8,63,15],[62,8,62,15],[47,6,48,6],[56,8,56,15],[57,8,57,15],[59,8,59,15],[60,8,60,15]]}
[]
[null,"Data Analysis = Convert raw data into useful information to gain insight and make decisions."]
[null,"Synonyms: Data Analytics, Analytics, Business Intelligence, Statistical Analysis, Mathematical Analysis, Data Analysis"]
[null,"Goal: help make data-driven decisions, which tends to be more accurate and help to achieve goals more consistently"]
[]
[null,"Raw Data = data stored in its smallest form in a cell"]
[]
[null,"Not Raw Data:"]
[]
[null,"Data about Google Stock"]
[null,{"$f":"_xlfn.TEXTJOIN(\", \",,TEXT(A30,\"m/d/yyy\"),DOLLAR(B30),FIXED(C30,0),D30)","v":"10/25/2021, $2,775.46, 1,054,085, Google"}]
[]
[null,"Raw Data:"]
[]
[null,"Date","Close","Volume",null,"Company"]
[null,44494,2775.46,1054085,null,"Google"]
[]
[null,"Proper Data Set = Data Set = Table"]
[null,"Table is made up of:",null,null,null,null,null,null,"Textbook definitions:"]
[null,"Field = column in table",null,null,null,null,null,null,"Data = Facts and figures collected, measured, summarized, and analyzed for presentation and interpretation."]
[null,"Field Name= name at top of field that describes what data goes into field",null,null,null,null,null,null,"Table = field names in first row, records in subsequent rows"]
[null,"Record = one row in table",null,null,null,null,null,null,"Elements = unique list of entities on which variable data are collected"]
[null,null,null,null,null,null,null,null,"Each company name is an element in this element field"]
[null,"Table requirements in Excel:"]
[null,"1) Field names in first row",null,null,null,null,null,null,null,"Variable = a characteristic or attribute of interest for the element"]
[null,"2) Records of related data in subsequent rows",null,null,null,null,null,null,null,null,null,{"$f":"\"There are \"&COLUMNS(J29:N29)&\" variable fields in this table\"","v":"There are 5 variable fields in this table"}]
[null,"3) Empty cells or Excel Row/Column Headers, all the way around table"]
[]
["Date","Close Price","Volume","Company",null,null,"Fields",null,"Company","Ticker","Year Incorporated","Industry","No. Employees","P/E Ratio ($)"]
[44494,2775.46,1054085,"Google",null,null,"Records",null,"Google","GOOG",2015,"Software",150028,28.12]
[44495,2793.44,1412937,"Google",null,null,null,null,"Amazon","AMZN",1996,"Retail",1335000,58.72]
[44496,2928.55,2592546,"Google",null,null,null,null,"Microsoft","MSFT",1993,"Software",181000,36.840000000000003]
[44497,2922.58,1620903,"Google",null,".",null,null,"Ford","F",1919,"Auto",186000,20.09]
[44498,2965.41,1447725,"Google",null,".",null,null,"Caterpillar","CAT",1986,"Machinery",97300,21.82]
[44494,3320.37,2225956,"Amazon",null,"."]
[44495,3376.07,2698342,"Amazon",null,null,null,null,{"$f":"\"There are \"&COLUMNS(I29:N29)&\" fields in the above table: 1 element field and \"&COLUMNS(J29:N29)&\" variable fields\"","v":"There are 6 fields in the above table: 1 element field and 5 variable fields"}]
[44496,3392.49,2702224,"Amazon",null,null,null,null,{"$f":"\"For each record there are \"&COLUMNS(I30:N30)&\" cells: 1 element cell and \"&COLUMNS(J29:N29)&\" variable cells\"","v":"For each record there are 6 cells: 1 element cell and 5 variable cells"}]
[44497,3446.57,5708733,"Amazon"]
[44498,3372.43,6486077,"Amazon",null,null,null,null,"Observation = variable data for one element"]
[44494,308.13,17554469,"Microsoft",null,null,null,null,{"$f":"\"Observation for the element \"&I30&\" =\"","v":"Observation for the element Google ="},null,null,{"$f":"J30:N30","v":"GOOG"},2015,"Software",150028,28.12]
[44495,310.11,28107349,"Microsoft"]
[44496,323.17,52588690,"Microsoft",null,null,null,null,"Measurements are made for each variable to provide data in the observation."]
[44497,324.35000000000002,26297943,"Microsoft"]
[44498,331.62,34765982,"Microsoft",null,null,null,null,"Measurements made on past 5 days of raw data:"]
[44494,16,67808039,"Ford"]
[44495,15.94,64882295,"Ford",null,null,null,null,"Company","Mean Price","σ Price","Sum Volume"]
[44496,15.51,96094256,"Ford",null,null,null,null,"Google",2877.0880000000002,77.257845530395358,8128196]
[44497,16.86,215237578,"Ford",null,null,{"$f":"\"Raw Data ==>>\nMeasurements for the \"&ROWS(I30:I34)&\" elements\"","v":"Raw Data ==>>\nMeasurements for the 5 elements"},null,"Amazon",3381.5860000000002,40.505492763301376,19821332]
[44498,17.079999999999998,100560723,"Ford",null,null,null,null,"Microsoft",319.476,8.9591508526186381,159314433]
[44494,202.21,3294689,"Caterpillar",null,null,null,null,"Ford",16.277999999999999,0.59384846551957315,544582891]
[44495,199.64,2933573,"Caterpillar",null,null,null,null,"Caterpillar",201.21600000000001,3.0134870167293832,18389846]
[44496,196.13,3406655,"Caterpillar"]
[44497,204.09,4462713,"Caterpillar"]
[44498,204.01,4292216,"Caterpillar",null,null,null,null,"Different classifications of data in statistics:"]
[]
[null,null,null,null,null,null,null,null,"Categorical data = data grouped by a category (also known as Qualitative data)"]
[null,null,null,null,null,null,null,null,"Nominal = data with no rank or order. Like eye color: Brown, Hazel, Brown; or Phone name: iPhone, Samsung, iPhone. With this data you can count and then calculate the % of total based on the counts. If you use a number as a category label, you cannot do arithmetic (+, -, *. /, ^) on it - you can only count."]
[null,null,null,null,null,null,null,null,"Ordinal = data with rank but you don't know distance between each rank, Like: Bad, Good, Great; or *, **, ***, ****; or 1st, 2nd, 3rd. You usually count how many are in each category and then calculate the % of total. In some cases when a number is used to represent the category, you can calculate an average (mean)."]
[null,null,null,null,null,null,null,null,"Quantitative data = numeric data"]
[null,null,null,null,null,null,null,null,"Interval = data with rank and a fixed distance between each rank, but where zero is either not in the scale (like IQ or SAT scores) or zero is just a point on the scale (Like Fahrenheit temperature or Celsius temperature). Calculations like counting, % of count total, differences, averages and differences are OK, but ratios between two numbers is not OK."]
[null,null,null,null,null,null,null,null,"Ratio = data with rank and a fixed distance between each rank and zero means nothing exists. Like money, weight, height, time, Kelvin temperature. All are scales where zero means nothing exists. Calculations like counting, % of count total, differences and ratios are OK."]
[null,null,null,null,null,null,null,null,"Types of numbers:"]
[null,null,null,null,null,null,null,null,"Discrete numbers are counting numbers & have gaps between each successive number, like 1, 2, 3…, or 1.2, 1.3, 1.4…. Answers the question How Many?"]
[null,null,null,null,null,null,null,null,"Continuous numbers can occupy any value over a continuous range and depend on the measuring instrument. Like: time, weight, temperature, money ($ don't seem continuous, but many statisticians treat it as such).\nAnswers the question How Much?"]

{"sheet":"Data Terms","index":6,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[61,7,61,14],[22,7,22,11],[23,7,23,11],[54,7,54,14],[55,7,55,14],[57,7,57,14],[58,7,58,14],[60,7,60,14]]}
[]
[null,null,"Categorical data = data grouped by a category",null,null,null,null,"Quantitative data = numeric data"]
[null,null,"Nominal:",null,"Ordinal:",null,null,"Interval:",null,"Ratio:"]
[null,null,"Category",null,"Category",null,null,"Rank",null,"Rank"]
[null,null,"No Rank",null,"Rank",null,null,"Know distance between each rank",null,"Know distance between each rank"]
[null,null,"Calcs:",null,"Don't know distance",null,null,"Zero is either:",null,"Scales where zero = nothing exists"]
[null,null,"Count",null,"between each rank",null,null,"Not in the scale (like IQ scores)",null,"Ratio Okay"]
[null,null,"% of total based on the counts",null,"Calcs:",null,null,"Just point on the scale (like Celsius)",null,"Calcs:"]
[null,null,null,null,"Count",null,null,"Calcs:",null,"Count"]
[null,null,null,null,"% of total based on the counts",null,null,"Count",null,"% of total based on the counts"]
[null,null,null,null,"Average (Mean) OK for number category",null,null,"% of total based on the counts",null,"Averages"]
[null,null,null,null,null,null,null,"Averages",null,"Differences"]
[null,null,null,null,null,null,null,"Differences",null,"Ratio OK"]
[null,null,null,null,null,null,null,"Ratio Not Okay"]
[null,"Student","Phone","Eye Color","Rank In Class (1st to 4th)","Rating of Teacher (Bad, Good, Great)","Rating of Teacher (1,2,3)","Temperature Fahrenheit","SAT Score (400 to 1200)","Score On Final\n(0 - 100)","Temperature\nKelvin","Money In Bank"]
[null,"Chantel","iPhone","Brown","1st","Good",2,-10,1170,81,{"$f":"CONVERT(H16,\"F\",\"K\")","v":249.81666666666663},{"$f":"L17*2","v":12000}]
[null,"Michael","Samsung","Brown","4th","Great",3,0,{"$f":"I18/2","v":590},90,{"$f":"CONVERT(H17,\"F\",\"K\")","v":255.37222222222221},6000]
[null,"Mo","iPhone","Brown","3th","Bad",1,20,1180,45,266.48333333333329,4369]
[null,"Sioux","iPhone","Hazel","2nd","Good",2,10,1099,84,260.92777777777775,3131]
[]
[]
[null,null,null,null,null,null,null,"Types of numbers:"]
[null,null,null,null,null,null,null,"Discrete numbers are counting numbers & have gaps between each successive number,\nlike 1, 2, 3…, or 1.2, 1.3, 1.4…. Answers the question How Many?"]
[null,null,null,null,null,null,null,"Continuous numbers can occupy any value over a continuous range and depend on the measuring instrument. Like: time, weight, temperature, money ($ don't seem continuous, but many statisticians treat it as such). Answers the question How Much?"]
[]
[null,null,null,null,null,null,null,"Cross-sectional data = Data collected at the same or nearly the same point in time"]
[null,null,null,null,null,null,null,"This cross-sectional data was collected on 11/5/2021:"]
[null,null,null,null,null,null,null,"Useful to compare elements such as company."]
[]
[null,null,null,null,null,null,null,{"$f":"'Data & Table'!I29","v":"Company"},{"$f":"'Data & Table'!J29","v":"Ticker"},{"$f":"'Data & Table'!K29","v":"Year Incorporated"},{"$f":"'Data & Table'!L29","v":"Industry"},{"$f":"'Data & Table'!M29","v":"No. Employees"},{"$f":"'Data & Table'!N29","v":"P/E Ratio ($)"}]
[null,null,null,null,null,null,null,{"$f":"'Data & Table'!I30","v":"Google"},{"$f":"'Data & Table'!J30","v":"GOOG"},{"$f":"'Data & Table'!K30","v":2015},{"$f":"'Data & Table'!L30","v":"Software"},{"$f":"'Data & Table'!M30","v":150028},{"$f":"'Data & Table'!N30","v":28.12}]
[null,null,null,null,null,null,null,{"$f":"'Data & Table'!I31","v":"Amazon"},{"$f":"'Data & Table'!J31","v":"AMZN"},{"$f":"'Data & Table'!K31","v":1996},{"$f":"'Data & Table'!L31","v":"Retail"},{"$f":"'Data & Table'!M31","v":1335000},{"$f":"'Data & Table'!N31","v":58.72}]
[null,null,null,null,null,null,null,{"$f":"'Data & Table'!I32","v":"Microsoft"},{"$f":"'Data & Table'!J32","v":"MSFT"},{"$f":"'Data & Table'!K32","v":1993},{"$f":"'Data & Table'!L32","v":"Software"},{"$f":"'Data & Table'!M32","v":181000},{"$f":"'Data & Table'!N32","v":36.840000000000003}]
[null,null,null,null,null,null,null,{"$f":"'Data & Table'!I33","v":"Ford"},{"$f":"'Data & Table'!J33","v":"F"},{"$f":"'Data & Table'!K33","v":1919},{"$f":"'Data & Table'!L33","v":"Auto"},{"$f":"'Data & Table'!M33","v":186000},{"$f":"'Data & Table'!N33","v":20.09}]
[null,null,null,null,null,null,null,{"$f":"'Data & Table'!I34","v":"Caterpillar"},{"$f":"'Data & Table'!J34","v":"CAT"},{"$f":"'Data & Table'!K34","v":1986},{"$f":"'Data & Table'!L34","v":"Machinery"},{"$f":"'Data & Table'!M34","v":97300},{"$f":"'Data & Table'!N34","v":21.82}]
[]
[null,null,null,null,null,null,null,"Time-series data = Data collected over time"]
[null,null,null,null,null,null,null,"This data was collected for Amazon over a 5-day period"]
[null,null,null,null,null,null,null,"Useful for seeing trends in the past that may help us to estimate what trends there may be in the near future"]
[]
[null,null,null,null,null,null,null,null,{"$f":"H32&\" \"&'Data & Table'!B29&\", \"&TEXT(MIN('Data & Table'!A30:A66),\"m/d/y\")&\" to \"&TEXT(MAX('Data & Table'!A30:A66),\"m/d/y\")","v":"Amazon Close Price, 10/25/21 to 10/29/21"}]
[]
[null,null,null,null,null,null,null,null,{"$f":"'Data & Table'!A29:B29","v":"Date"},"Close Price"]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn._xlws.FILTER('Data & Table'!A30:B66,'Data & Table'!D30:D66=H32)","v":44494},3320.37]
[null,null,null,null,null,null,null,null,44495,3376.07]
[null,null,null,null,null,null,null,null,44496,3392.49]
[null,null,null,null,null,null,null,null,44497,3446.57]
[null,null,null,null,null,null,null,null,44498,3372.43]
[]
[]
[]
[null,null,null,null,null,null,null,"Different classifications of data in statistics:"]
[]
[null,null,null,null,null,null,null,"Categorical data = data grouped by a category (also known as Qualitative data)"]
[null,null,null,null,null,null,null,"Nominal = data with no rank or order. Like eye color: Brown, Hazel, Brown; or Phone name: iPhone, Samsung, iPhone. With this data you can count and then calculate the % of total based on the counts. If you use a number as a category label, you cannot do arithmetic (+, -, *. /, ^) on it - you can only count."]
[null,null,null,null,null,null,null,"Ordinal = data with rank but you don't know distance between each rank, Like: Bad, Good, Great; or *, **, ***, ****; or 1st, 2nd, 3rd. You usually count how many are in each category and then calculate the % of total. In some cases when a number is used to represent the category, you can calculate an average (mean)."]
[null,null,null,null,null,null,null,"Quantitative data = numeric data"]
[null,null,null,null,null,null,null,"Interval = data with rank and a fixed distance between each rank, but where zero is either not in the scale (like IQ or SAT scores) or zero is just a point on the scale (Like Fahrenheit temperature or Celsius temperature). Calculations like counting, % of count total, differences, averages and differences are OK, but ratios between two numbers is not OK."]
[null,null,null,null,null,null,null,"Ratio = data with rank and a fixed distance between each rank and zero means nothing exists. Like money, weight, height, time, Kelvin temperature. All are scales where zero means nothing exists. Calculations like counting, % of count total, differences and ratios are OK."]
[null,null,null,null,null,null,null,"Types of numbers:"]
[null,null,null,null,null,null,null,"Discrete numbers are counting numbers & have gaps between each successive number, like 1, 2, 3…, or 1.2, 1.3, 1.4…. Answers the question How Many?"]
[null,null,null,null,null,null,null,"Continuous numbers can occupy any value over a continuous range and depend on the measuring instrument. Like: time, weight, temperature, money ($ don't seem continuous, but many statisticians treat it as such).\nAnswers the question How Much?"]

{"sheet":"PhoneCount","index":7,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Phones","Count\n(Frequency)",null,"% of Total\n(% Frequency)"]
[null,null,null,"iPhone",3,{"$f":"E10:E11&\"/\"&E12&\" =\"","v":"3/4 ="},{"$f":"E10:E11/E12","v":0.75}]
[null,null,null,"Samsung",1,"1/4 =",0.25]
[null,null,null,"Totals",{"$f":"SUM(E10:E11)","v":4},null,{"$f":"SUM(_xlfn.ANCHORARRAY(G10))","v":1}]

{"sheet":"Statistics","index":8,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Statistics"]
[null,"Numerical facts like:"]
[null,"USA unemployment rate reported Jan. 2021 was 6.3%"]
[null,"Sioux Radcoolinator student ranked at the 90th percentile for the test"]
[null,"3rd quarter YouTube advertising revenue was $7.20 billion vs. $7.4 billion expected."]
[null,"Subject of Statistics defined:"]
[null,"Statistics is the art and science of collecting, analyzing, presenting and interpreting data."]
[null,"Descriptive Statistics:"]
[null,"Data that is summarized and presented"]
[null,"Tabular: table of information"]
[null,"Graphical: charts, graphs, visualizations"]
[null,"Numerical: like an average (mean), median, mode"]
[null,"Inferential Statistics:"]
[null,"The process of using data obtained from a sample to make estimates and test hypotheses about the characteristics/attribute of a population"]
[null,"Take a sample from the population and draw reasonable conclusions that can help to estimate the unknown future."]
[null,"Define Terms:"]
[null,"Population: The set of all elements of interest in a particular study"]
[null,"(In many situations it is too costly to get data from all the elements in the population)"]
[null,"Example ==>> Census: Collecting data for a population"]
[null,"Sample: A subset of the population"]
[null,"Example ==>> Sample survey: Collecting data for a sample"]

{"sheet":"TGN","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Art","index":10,"n_rows":252,"n_cols":6,"rows_kept":252,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Retail Sales",null,"Step 1: Determine Number of Classes using the guide: 2^k > n"]
[null,615.83000000000004,null,"COUNT function = No. in Sample = n =",{"$f":"COUNT(B3:B252)","v":250}]
[null,28.31,null,"k = No. Classes =",6,"This is a judgment call (the art side of statistics)"]
[null,0.33,null,"2^k =",{"$f":"2^E4","v":64}]
[null,76.319999999999993,null,"Step 2: Determine width of Classes"]
[null,331.65,null,"MAX",{"$f":"MAX(B3:B252)","v":1178.98}]
[null,15.96,null,"MIN",{"$f":"MIN(B3:B252)","v":0.33}]
[null,293.23,null,"\"Range of ages\"",{"$f":"E7-E8","v":1178.6500000000001}]
[null,165.56,null,"Approximate width =",{"$f":"E9/E4","v":196.44166666666669}]
[null,897.31,null,"Width of Class (Increment for each class)",{"$f":"_xlfn.CEILING.MATH(E10,10)","v":200},"This is a judgment call (the art side of statistics)"]
[null,226.24,null,"\"Range for classes\" = Width of Class*k =",{"$f":"E11*E4","v":1200}]
[null,82.08,null,"Step 3: Determine Lower Limit of First"]
[null,35.25,null,"Lower Limit of First Class (look at MIN then estimate)",0,"This is a judgment call (the art side of statistics)"]
[null,914.33]
[null,25.31]
[null,477.35]
[null,70.23]
[null,366.97]
[null,755.06]
[null,8]
[null,1120.75]
[null,75.88]
[null,485.51]
[null,47.36]
[null,248.99]
[null,13.07]
[null,45.28]
[null,18.5]
[null,37.35]
[null,32.69]
[null,2.76]
[null,341.1]
[null,443.52]
[null,53.06]
[null,51.01]
[null,25.06]
[null,126.75]
[null,319.2]
[null,75.459999999999994]
[null,331.5]
[null,7.6]
[null,88.23]
[null,91.06]
[null,85.04]
[null,50.67]
[null,194.27]
[null,42.92]
[null,65.45]
[null,631.80999999999995]
[null,97.46]
[null,201.9]
[null,31.44]
[null,23.89]
[null,54.7]
[null,143.61000000000001]
[null,32.520000000000003]
[null,53.08]
[null,200.14]
[null,61.1]
[null,58.07]
[null,134.35]
[null,76.38]
[null,284.8]
[null,965.64]
[null,42.92]
[null,62.66]
[null,51.3]
[null,33.299999999999997]
[null,19.37]
[null,67.180000000000007]
[null,895.85]
[null,97.56]
[null,69.739999999999995]
[null,317.39999999999998]
[null,683.64]
[null,81.77]
[null,75.05]
[null,5.97]
[null,49.85]
[null,53.69]
[null,80.64]
[null,491.28]
[null,58.46]
[null,340.72]
[null,10.44]
[null,158.22999999999999]
[null,13.61]
[null,4.26]
[null,89.98]
[null,34.06]
[null,326.01]
[null,376.98]
[null,81.319999999999993]
[null,82.55]
[null,59.35]
[null,62.7]
[null,167.96]
[null,276.64999999999998]
[null,87.38]
[null,170.86]
[null,42.47]
[null,69.33]
[null,129.1]
[null,113.68]
[null,1049.53]
[null,66.900000000000006]
[null,222]
[null,9.09]
[null,310.70999999999998]
[null,90.54]
[null,122.03]
[null,84.29]
[null,58.39]
[null,381.78]
[null,3.57]
[null,48.25]
[null,58.16]
[null,51.4]
[null,77.239999999999995]
[null,76.88]
[null,890.41]
[null,48.81]
[null,68.67]
[null,22.99]
[null,45.26]
[null,8.56]
[null,61.55]
[null,24.02]
[null,462.88]
[null,46.47]
[null,9.57]
[null,181.79]
[null,86.69]
[null,69.98]
[null,1019.38]
[null,162.53]
[null,78.39]
[null,71.31]
[null,470.63]
[null,82.86]
[null,1016.08]
[null,306.88]
[null,42.3]
[null,36.29]
[null,326.39999999999998]
[null,72.98]
[null,481.82]
[null,62.32]
[null,1084.3699999999999]
[null,1178.98]
[null,432.62]
[null,49.42]
[null,103.65]
[null,563.47]
[null,13.39]
[null,56.75]
[null,80.010000000000005]
[null,257.2]
[null,797.84]
[null,791.74]
[null,349.48]
[null,17.13]
[null,53.31]
[null,522.28]
[null,621.61]
[null,496.28]
[null,84.01]
[null,60.1]
[null,100.44]
[null,457.65]
[null,49.31]
[null,36.450000000000003]
[null,42.81]
[null,78.75]
[null,318.42]
[null,52.04]
[null,94.77]
[null,78.06]
[null,421.33]
[null,69.430000000000007]
[null,396.87]
[null,320.58]
[null,71.97]
[null,340.69]
[null,170.53]
[null,562.84]
[null,340]
[null,84.7]
[null,5.75]
[null,48.95]
[null,76.88]
[null,96.48]
[null,20.059999999999999]
[null,360.05]
[null,78.760000000000005]
[null,21.13]
[null,49.2]
[null,88.07]
[null,94.79]
[null,86.26]
[null,33.909999999999997]
[null,43.17]
[null,96.19]
[null,7.9]
[null,349.5]
[null,40.68]
[null,110.61]
[null,98.08]
[null,679.17]
[null,310.43]
[null,47.79]
[null,95.4]
[null,67.42]
[null,332.95]
[null,15.9]
[null,1000.24]
[null,398.67]
[null,19.59]
[null,76.099999999999994]
[null,14.46]
[null,49.45]
[null,9.69]
[null,40.4]
[null,31.93]
[null,911.76]
[null,60.4]
[null,79.78]
[null,88]
[null,52.24]
[null,89.58]
[null,64.44]
[null,400.24]
[null,81.040000000000006]
[null,48.78]
[null,65.72]
[null,71.48]
[null,12.37]
[null,528.65]
[null,50.6]
[null,201.79]
[null,82.05]
[null,313.5]
[null,30.16]
[null,381.22]
[null,33]
[null,34.22]
[null,14.41]
[null,27.48]
[null,44.65]
[null,56.11]
[null,15.66]

{"sheet":"Example of Inferential Stats","index":11,"n_rows":602,"n_cols":8,"rows_kept":602,"cut":false,"hidden":false,"merged":[]}
["Production: Sampling box weight to see if filling machine is filling accurately (chapter 9)"]
["H0 : Mu = 10 grams"]
["H1 : Mu <> 10 grams"]
["Historical Average =",10,"grams"]
["Historical Standard Deviation =",0.5,"grams"]
["Level of Significance =",0.05]
["Level of Significance Divided by 2 =",{"$f":"B6/2","v":2.5000000000000001E-2}]
["Sample Mean = AVERAGE =",{"$f":"AVERAGE(A22:A99)","v":9.8918974358974321},"grams"]
["Sample Standard Deviation = STDEV =",{"$f":"STDEV(A22:A99)","v":0.23834492029892521},"grams"]
["Sample size = COUNT =",{"$f":"COUNT($A$22:$A$99)","v":78}]
["Standard Error",{"$f":"B5/SQRT(B10)","v":5.6613851707229781E-2},"grams"]
["z",{"$f":"(B8-B4)/B11","v":-1.9094719903815138}]
["X",{"$f":"B12*B11+B4","v":9.8918974358974321},{"$f":"D102","v":"P(9.892)"},null,null,null,null,{"$f":"VLOOKUP(B13,B103:C602,2)","v":0.77880751766756706}]
["p-value =",{"$f":"IF(B8<B4,2*NORMDIST(B8,B4,B5/SQRT(B10),1),2*(1-NORMDIST(B8,B4,B5/SQRT(B10),1)))","v":5.6201231660777291E-2}]
["p-value =",{"$f":"2*(1-NORMSDIST(ABS(B12)))","v":5.6201231660777395E-2}]
[{"$f":"IF(B15>B6,\"Because the p-value is greater than our alpha, it is reasonable to assume that the machine is filling accurately\",\" Because the p-value is less than or equal to our alpha, it is reasonable to assume that the machine is not filling accurately\")","v":"Because the p-value is greater than our alpha, it is reasonable to assume that the machine is filling accurately"}]
[]
[]
[]
[]
["Sample data"]
[{"$f":"RANDBETWEEN(9500,10300)/1000","v":10.087}]
[9.5139999999999993]
[9.5630000000000006]
[9.5649999999999995]
[9.7530000000000001]
[10.018000000000001]
[10.23]
[9.7530000000000001]
[10.137]
[9.5540000000000003]
[9.7059999999999995]
[9.6050000000000004]
[9.7940000000000005]
[9.9250000000000007]
[10.186]
[9.8689999999999998]
[10.257999999999999]
[9.9]
[10.066000000000001]
[9.8339999999999996]
[9.9879999999999995]
[9.8089999999999993]
[9.7460000000000004]
[9.5619999999999994]
[9.9629999999999992]
[10.012]
[10.000999999999999]
[9.859]
[9.7970000000000006]
[10.269]
[9.8510000000000009]
[10.077999999999999]
[10.054]
[10.272]
[10.036]
[9.8729999999999993]
[10.252000000000001]
[10.151]
[9.6780000000000008]
[9.5890000000000004]
[10.068]
[9.9260000000000002]
[9.9849999999999994]
[9.6969999999999992]
[9.6579999999999995]
[10.225]
[9.5359999999999996]
[9.5690000000000008]
[9.9879999999999995]
[9.9819999999999993]
[9.7240000000000002]
[9.6359999999999992]
[10.286]
[10.105]
[9.5020000000000007]
[9.5399999999999991]
[10.220000000000001]
[9.6750000000000007]
[9.5169999999999995]
[9.6319999999999997]
[9.9109999999999996]
[9.7089999999999996]
[10.141]
[10.042999999999999]
[{"$f":"RANDBETWEEN(9500,10300)/1000","v":10.292999999999999}]
[9.8829999999999991]
[9.5210000000000008]
[9.6940000000000008]
[9.7729999999999997]
[10.039999999999999]
[10.002000000000001]
[9.9440000000000008]
[9.8970000000000002]
[10.255000000000001]
[9.5670000000000002]
[9.8710000000000004]
[10.164999999999999]
[10.231]
[]
["Chart Data:"]
["z","X","P(Exactly x)",{"$f":"\"P(\"&ROUND(B8,3)&\")\"","v":"P(9.892)"},"P(alpha)"]
[{"$f":"(B103-B$4)/B$11","v":-35.327043465311391},8,{"$f":"NORMDIST(B103,B$4,B$5,0)","v":2.6766045152977074E-4},{"$f":"IF(C103<=B$14/2,C103,0)","v":2.6766045152977074E-4},{"$f":"IF(C103<=B$6/2,C103,0)","v":2.6766045152977074E-4}]
[-35.150408247984835,{"$f":"B103+0.01","v":8.01},2.8989512084778157E-4,2.8989512084778157E-4,2.8989512084778157E-4]
[-34.973773030658286,{"$f":"B104+0.01","v":8.02},3.1385126813106339E-4,3.1385126813106339E-4,3.1385126813106339E-4]
[-34.79713781333173,8.0299999999999994,3.3965119885868533E-4,3.3965119885868533E-4,3.3965119885868533E-4]
[-34.620502596005181,8.0399999999999991,3.6742499600491161E-4,3.6742499600491161E-4,3.6742499600491161E-4]
[-34.443867378678625,8.0499999999999989,3.9731094278554186E-4,3.9731094278554186E-4,3.9731094278554186E-4]
[-34.267232161352069,8.0599999999999987,4.2945596300072948E-4,4.2945596300072948E-4,4.2945596300072948E-4]
[-34.090596944025521,8.0699999999999985,4.640160793138794E-4,4.640160793138794E-4,4.640160793138794E-4]
[-33.913961726698965,8.0799999999999983,5.0115688978171489E-4,5.0115688978171489E-4,5.0115688978171489E-4]
[-33.737326509372416,8.0899999999999981,5.4105406292303377E-4,5.4105406292303377E-4,5.4105406292303377E-4]
[-33.56069129204586,8.0999999999999979,5.8389385158291068E-4,5.8389385158291068E-4,5.8389385158291068E-4]
[-33.384056074719304,8.1099999999999977,6.2987362581503248E-4,6.2987362581503248E-4,6.2987362581503248E-4]
[-33.207420857392755,8.1199999999999974,6.7920242496729633E-4,6.7920242496729633E-4,6.7920242496729633E-4]
[-33.030785640066199,8.1299999999999972,7.3210152911465571E-4,7.3210152911465571E-4,7.3210152911465571E-4]
[-32.854150422739643,8.139999999999997,7.8880504993829564E-4,7.8880504993829564E-4,7.8880504993829564E-4]
[-32.677515205413094,8.1499999999999968,8.4956054110148335E-4,8.4956054110148335E-4,8.4956054110148335E-4]
[-32.500879988086538,8.1599999999999966,9.1462962811969084E-4,9.1462962811969084E-4,9.1462962811969084E-4]
[-32.324244770759989,8.1699999999999964,9.8428865766576087E-4,9.8428865766576087E-4,9.8428865766576087E-4]
[-32.147609553433433,8.1799999999999962,1.0588293661898404E-3,1.0588293661898404E-3,1.0588293661898404E-3]
[-31.970974336106881,8.1899999999999959,1.1385595676684718E-3,1.1385595676684718E-3,1.1385595676684718E-3]
[-31.794339118780329,8.1999999999999957,1.2238038602275069E-3,1.2238038602275069E-3,1.2238038602275069E-3]
[-31.617703901453773,8.2099999999999955,1.3149043513093108E-3,1.3149043513093108E-3,1.3149043513093108E-3]
[-31.44106868412722,8.2199999999999953,1.412221400976026E-3,1.412221400976026E-3,1.412221400976026E-3]
[-31.264433466800668,8.2299999999999951,1.5161343828573679E-3,1.5161343828573679E-3,1.5161343828573679E-3]
[-31.087798249474115,8.2399999999999949,1.6270424621635578E-3,1.6270424621635578E-3,1.6270424621635578E-3]
[-30.911163032147563,8.2499999999999947,1.7453653900914553E-3,1.7453653900914553E-3,1.7453653900914553E-3]
[-30.734527814821007,8.2599999999999945,1.8715443138548878E-3,1.8715443138548878E-3,1.8715443138548878E-3]
[-30.557892597494455,8.2699999999999942,2.006042601468395E-3,2.006042601468395E-3,2.006042601468395E-3]
[-30.381257380167902,8.279999999999994,2.1493466803073815E-3,2.1493466803073815E-3,2.1493466803073815E-3]
[-30.20462216284135,8.2899999999999938,2.3019668883568706E-3,2.3019668883568706E-3,2.3019668883568706E-3]
[-30.027986945514794,8.2999999999999936,2.4644383369459301E-3,2.4644383369459301E-3,2.4644383369459301E-3]
[-29.851351728188241,8.3099999999999934,2.6373217836453645E-3,2.6373217836453645E-3,2.6373217836453645E-3]
[-29.674716510861689,8.3199999999999932,2.8212045138826369E-3,2.8212045138826369E-3,2.8212045138826369E-3]
[-29.498081293535137,8.329999999999993,3.0167012297004727E-3,3.0167012297004727E-3,3.0167012297004727E-3]
[-29.321446076208584,8.3399999999999928,3.2244549439540918E-3,3.2244549439540918E-3,3.2244549439540918E-3]
[-29.144810858882028,8.3499999999999925,3.4451378781071912E-3,3.4451378781071912E-3,3.4451378781071912E-3]
[-28.968175641555476,8.3599999999999923,3.6794523616483724E-3,3.6794523616483724E-3,3.6794523616483724E-3]
[-28.791540424228923,8.3699999999999921,3.9281317310085493E-3,3.9281317310085493E-3,3.9281317310085493E-3]
[-28.614905206902371,8.3799999999999919,4.1919412257156678E-3,4.1919412257156678E-3,4.1919412257156678E-3]
[-28.438269989575815,8.3899999999999917,4.4716788793768385E-3,4.4716788793768385E-3,4.4716788793768385E-3]
[-28.261634772249263,8.3999999999999915,4.7681764029294266E-3,4.7681764029294266E-3,4.7681764029294266E-3]
[-28.08499955492271,8.4099999999999913,5.0823000574527627E-3,5.0823000574527627E-3,5.0823000574527627E-3]
[-27.908364337596158,8.419999999999991,5.4149515136810971E-3,5.4149515136810971E-3,5.4149515136810971E-3]
[-27.731729120269605,8.4299999999999908,5.7670686952065453E-3,5.7670686952065453E-3,5.7670686952065453E-3]
[-27.555093902943049,8.4399999999999906,6.1396266022091268E-3,6.1396266022091268E-3,6.1396266022091268E-3]
[-27.378458685616497,8.4499999999999904,6.5336381123994548E-3,6.5336381123994548E-3,6.5336381123994548E-3]
[-27.201823468289945,8.4599999999999902,6.950154755709456E-3,6.950154755709456E-3,6.950154755709456E-3]
[-27.025188250963392,8.46999999999999,7.390267459117617E-3,7.390267459117617E-3,7.390267459117617E-3]
[-26.848553033636836,8.4799999999999898,7.8551072578490703E-3,7.8551072578490703E-3,7.8551072578490703E-3]
[-26.671917816310284,8.4899999999999896,8.3458459690473989E-3,8.3458459690473989E-3,8.3458459690473989E-3]
[-26.495282598983732,8.4999999999999893,8.8636968238754478E-3,8.8636968238754478E-3,8.8636968238754478E-3]
[-26.318647381657179,8.5099999999999891,9.4099150538673494E-3,9.4099150538673494E-3,9.4099150538673494E-3]
[-26.142012164330627,8.5199999999999889,9.9857984272240952E-3,9.9857984272240952E-3,9.9857984272240952E-3]
[-25.965376947004071,8.5299999999999887,1.0592687730621334E-2,1.0592687730621334E-2,1.0592687730621334E-2]
[-25.788741729677518,8.5399999999999885,1.1231967191981178E-2,1.1231967191981178E-2,1.1231967191981178E-2]
[-25.612106512350966,8.5499999999999883,1.1905064839550903E-2,1.1905064839550903E-2,1.1905064839550903E-2]
[-25.435471295024414,8.5599999999999881,1.2613452792530983E-2,1.2613452792530983E-2,1.2613452792530983E-2]
[-25.258836077697861,8.5699999999999878,1.3358647478404305E-2,1.3358647478404305E-2,1.3358647478404305E-2]
[-25.082200860371305,8.5799999999999876,1.4142209772037907E-2,1.4142209772037907E-2,1.4142209772037907E-2]
[-24.905565643044753,8.5899999999999874,1.4965745051560056E-2,1.4965745051560056E-2,1.4965745051560056E-2]
[-24.7289304257182,8.5999999999999872,1.5830903165958796E-2,1.5830903165958796E-2,1.5830903165958796E-2]
[-24.552295208391648,8.609999999999987,1.6739378309304848E-2,1.6739378309304848E-2,1.6739378309304848E-2]
[-24.375659991065092,8.6199999999999868,1.7692908796473155E-2,1.7692908796473155E-2,1.7692908796473155E-2]
[-24.19902477373854,8.6299999999999866,1.8693276735223197E-2,1.8693276735223197E-2,1.8693276735223197E-2]
[{"$f":"(B167-B$4)/B$11","v":-24.022389556411987},8.6399999999999864,{"$f":"NORMDIST(B167,B$4,B$5,0)","v":1.9742307589500806E-2},{"$f":"IF(C167<=B$14/2,C167,0)","v":1.9742307589500806E-2},{"$f":"IF(C167<=B$6/2,C167,0)","v":1.9742307589500806E-2}]
[-23.845754339085435,8.6499999999999861,2.0841869628843636E-2,2.0841869628843636E-2,2.0841869628843636E-2]
[-23.669119121758882,{"$f":"B168+0.01","v":8.6599999999999859},2.1993873258809502E-2,2.1993873258809502E-2,2.1993873258809502E-2]
[-23.492483904432326,8.6699999999999857,2.3200270227403372E-2,2.3200270227403372E-2,2.3200270227403372E-2]
[-23.315848687105774,8.6799999999999855,2.4463052702554073E-2,2.4463052702554073E-2,2.4463052702554073E-2]
[-23.139213469779222,8.6899999999999853,2.5784252215788624E-2,2.5784252215788624E-2,0]
[-22.962578252452669,8.6999999999999851,2.716593846736913E-2,2.716593846736913E-2,0]
[-22.785943035126113,8.7099999999999849,2.8610217988297156E-2,0,0]
[-22.609307817799561,8.7199999999999847,3.0119232654752533E-2,0,0]
[-22.432672600473008,8.7299999999999844,3.1695158050719131E-2,0,0]
[-22.256037383146456,8.7399999999999842,3.3340201674759477E-2,0,0]
[-22.079402165819904,8.749999999999984,3.505660098713427E-2,0,0]
[-21.902766948493348,8.7599999999999838,3.6846621293721134E-2,0,0]
[-21.726131731166795,8.7699999999999836,3.8712553463470793E-2,0,0]
[-21.549496513840243,8.7799999999999834,4.0656711476448372E-2,0,0]
[-21.37286129651369,8.7899999999999832,4.2681429799842081E-2,0,0]
[-21.196226079187134,8.7999999999999829,4.4789060589682121E-2,0,0]
[-21.019590861860582,8.8099999999999827,4.6981970716398869E-2,0,0]
[-20.84295564453403,8.8199999999999825,4.9262538612760948E-2,0,0]
[-20.666320427207477,8.8299999999999823,5.1633150943171099E-2,0,0]
[-20.489685209880925,8.8399999999999821,5.4096199093759061E-2,0,0]
[-20.313049992554369,8.8499999999999819,5.6654075483197612E-2,0,0]
[-20.136414775227816,8.8599999999999817,5.9309169694677581E-2,0,0]
[-19.959779557901264,8.8699999999999815,6.2063864430011308E-2,0,0]
[-19.783144340574712,8.8799999999999812,6.4920531287389477E-2,0,0]
[-19.606509123248156,8.889999999999981,6.7881526364892669E-2,0,0]
[-19.429873905921603,8.8999999999999808,7.0949185692456895E-2,0,0]
[-19.253238688595051,8.9099999999999806,7.412582049560669E-2,0,0]
[-19.076603471268498,8.9199999999999804,7.741371229490468E-2,0,0]
[-18.899968253941946,8.9299999999999802,8.081510784571376E-2,0,0]
[-18.72333303661539,8.93999999999998,8.4332213923533475E-2,0,0]
[-18.546697819288838,8.9499999999999797,8.7967191960846916E-2,0,0]
[-18.370062601962285,8.9599999999999795,9.172215254210199E-2,0,0]
[-18.193427384635733,8.9699999999999793,9.5599149764145921E-2,0,0]
[-18.016792167309177,8.9799999999999791,9.9600175470133057E-2,0,0]
[-17.840156949982624,8.9899999999999789,0.10372715336563228,0,0]
[-17.663521732656072,8.9999999999999787,0.10798193302636691,0,0]
[-17.48688651532952,9.0099999999999785,0.11236628380772651,0,0]
[-17.310251298002967,9.0199999999999783,0.11688188866689296,0,0]
[-17.133616080676411,9.029999999999978,0.12153033790911921,0,0]
[-16.956980863349859,9.0399999999999778,0.12631312287038651,0,0]
[-16.780345646023306,9.0499999999999776,0.13123162954934203,0,0]
[-16.603710428696754,9.0599999999999774,0.13628713220207755,0,0]
[-16.427075211370198,9.0699999999999772,0.14148078691395477,0,0]
[-16.250439994043646,9.079999999999977,0.14681362516330135,0,0]
[-16.073804776717093,9.0899999999999768,0.15228654739240177,0,0]
[-15.897169559390541,9.0999999999999766,0.157900316601775,0,0]
[-15.720534342063987,9.1099999999999763,0.16365555198427184,0,0]
[-15.543899124737434,9.1199999999999761,0.16955272261603022,0,0]
[-15.36726390741088,9.1299999999999759,0.17559214122179656,0,0]
[-15.190628690084328,9.1399999999999757,0.18177395803255053,0,0]
[-15.013993472757774,9.1499999999999755,0.18809815475375818,0,0]
[-14.837358255431221,9.1599999999999753,0.19456453866291884,0,0]
[-14.660723038104669,9.1699999999999751,0.20117273685536449,0,0]
[-14.484087820778115,9.1799999999999748,0.20792219065751125,0,0]
[-14.307452603451562,9.1899999999999746,0.21481215022694999,0,0]
[-14.130817386125008,9.1999999999999744,0.22184166935889293,0,0]
[-13.954182168798456,9.2099999999999742,0.22900960051856609,0,0]
[-13.777546951471901,9.219999999999974,0.23631459011914541,0,0]
[-13.600911734145349,9.2299999999999738,0.24375507406478383,0,0]
[-13.424276516818795,9.2399999999999736,0.2513292735781561,0,0]
[-13.247641299492242,9.2499999999999734,0.25903519133176273,0,0]
[-13.07100608216569,9.2599999999999731,0.26687060790198341,0,0]
[-12.894370864839136,9.2699999999999729,0.27483307856454181,0,0]
[{"$f":"(B231-B$4)/B$11","v":-12.717735647512583},9.2799999999999727,{"$f":"NORMDIST(B231,B$4,B$5,0)","v":0.28291993044965535},{"$f":"IF(C231<=B$14/2,C231,0)","v":0},{"$f":"IF(C231<=B$6/2,C231,0)","v":0}]
[-12.541100430186029,9.2899999999999725,0.29112826007467246,0,0]
[-12.364465212859477,{"$f":"B232+0.01","v":9.2999999999999723},0.2994549312714665,0,0]
[-12.187829995532923,9.3099999999999721,0.30789657352524369,0,0]
[-12.01119477820637,9.3199999999999719,0.31644958074074186,0,0]
[-11.834559560879816,9.3299999999999716,0.3251101104510436,0,0]
[-11.657924343553264,9.3399999999999714,0.33387408348340253,0,0]
[-11.481289126226711,9.3499999999999712,0.34273718409558906,0,0]
[-11.304653908900157,9.359999999999971,0.35169486059529864,0,0]
[-11.128018691573605,9.3699999999999708,0.36074232645413418,0,0]
[-10.95138347424705,9.3799999999999706,0.36987456192658363,0,0]
[-10.774748256920498,9.3899999999999704,0.37908631618325306,0,0]
[-10.598113039593944,9.3999999999999702,0.38837210996639809,0,0]
[-10.421477822267391,9.4099999999999699,0.39772623877452357,0,0]
[-10.244842604940839,9.4199999999999697,0.40714277658149028,0,0]
[-10.068207387614285,9.4299999999999695,0.41661558009418775,0,0]
[-9.8915721702877324,9.4399999999999693,0.42613829355140648,0,0]
[-9.7149369529611782,9.4499999999999691,0.43570435406507141,0,0]
[-9.5383017356346258,9.4599999999999689,0.44530699750349234,0,0]
[-9.3616665183080716,9.4699999999999687,0.45493926491474157,0,0]
[-9.1850313009815192,9.4799999999999685,0.46459400948670193,0,0]
[-9.008396083654965,9.4899999999999682,0.47426390403872848,0,0]
[-8.8317608663284126,9.499999999999968,0.48394144903825581,0,0]
[-8.6551256490018602,9.5099999999999678,0.49361898113405428,0,0]
[-8.478490431675306,9.5199999999999676,0.50328868219620293,0,0]
[-8.3018552143487536,9.5299999999999674,0.51294258885120925,0,0]
[-8.1252199970221994,9.5399999999999672,0.52257260249907467,0,0]
[-7.948584779695647,9.549999999999967,0.53217049979747799,0,0]
[-7.7719495623690937,9.5599999999999667,0.54172794359664433,0,0]
[-7.5953143450425404,9.5699999999999665,0.55123649430688171,0,0]
[-7.4186791277159871,9.5799999999999663,0.56068762167920938,0,0]
[-7.2420439103894338,9.5899999999999661,0.57007271697798279,0,0]
[-7.0654086930628806,9.5999999999999659,0.57938310552293393,0,0]
[-6.8887734757363273,9.6099999999999657,0.58861005957661872,0,0]
[-6.712138258409774,9.6199999999999655,0.5977448115518742,0,0]
[-6.5355030410832207,9.6299999999999653,0.60677856751256898,0,0]
[-6.3588678237566683,9.639999999999965,0.61570252093967492,0,0]
[-6.182232606430115,9.6499999999999648,0.62450786673349179,0,0]
[-6.0055973891035617,9.6599999999999646,0.63318581542175512,0,0]
[-5.8289621717770084,9.6699999999999644,0.64172760754231495,0,0]
[-5.6523269544504551,9.6799999999999642,0.65012452816813449,0,0]
[-5.4756917371239018,9.689999999999964,0.65836792154150015,0,0]
[-5.2990565197973485,9.6999999999999638,0.66644920578357036,0,0]
[-5.1224213024707952,9.7099999999999635,0.67435988764473265,0,0]
[-4.9457860851442428,9.7199999999999633,0.68209157726067715,0,0]
[-4.7691508678176895,9.7299999999999631,0.68963600287863924,0,0]
[-4.5925156504911362,9.7399999999999629,0.69698502551792219,0,0]
[-4.4158804331645829,9.7499999999999627,0.70413065352857274,0,0]
[-4.2392452158380296,9.7599999999999625,0.71106505701196854,0,0]
[-4.0626099985114763,9.7699999999999623,0.7177805820670643,0,0]
[-3.8859747811849235,9.7799999999999621,0.72426976482616023,0,0]
[-3.7093395638583702,9.7899999999999618,0.73052534524428447,0,0]
[-3.5327043465318169,9.7999999999999616,0.73654028060662402,0,0]
[-3.3560691292052636,9.8099999999999614,0.74230775871891019,0,0]
[-3.1794339118787103,9.8199999999999612,0.74782121074623586,0,0]
[-3.0027986945521574,9.829999999999961,0.75307432366648797,0,0]
[-2.8261634772256041,9.8399999999999608,0.75806105230538434,0,0]
[-2.6495282598990508,9.8499999999999606,0.76277563092103018,0,0]
[-2.4728930425724975,9.8599999999999604,0.76721258430694006,0,0]
[-2.2962578252459447,9.8699999999999601,0.77136673838361614,0,0]
[-2.1196226079193914,9.8799999999999599,0.77523323025001334,0,0]
[-1.9429873905928381,9.8899999999999597,0.77880751766756706,0,0]
[-1.766352173266285,9.8999999999999595,0.7820853879508991,0,0]
[-1.5897169559397317,9.9099999999999593,0.78506296624084626,0,0]
[{"$f":"(B295-B$4)/B$11","v":-1.4130817386131787},9.9199999999999591,{"$f":"NORMDIST(B295,B$4,B$5,0)","v":0.78773672313707144},{"$f":"IF(C295<=B$14/2,C295,0)","v":0},{"$f":"IF(C295<=B$6/2,C295,0)","v":0}]
[-1.2364465212866254,9.9299999999999589,0.7901034816692134,0,0]
[-1.0598113039600723,{"$f":"B296+0.01","v":9.9399999999999586},0.79216042358730432,0,0]
[-0.88317608663351899,9.9499999999999584,0.79390509495401695,0,0]
[-0.7065408693069658,9.9599999999999582,0.79533541102321248,0,0]
[-0.52990565198041262,9.969999999999958,0.79644966039120979,0,0]
[-0.35327043465385943,9.9799999999999578,0.79724650840920741,0,0]
[-0.17663521732730622,9.9899999999999576,0.79772499984733092,0,0]
[-7.5304122330474977E-13,9.9999999999999574,0.79788456080286541,0,0]
[0.17663521732580015,10.009999999999957,0.79772499984733358,0,0]
[0.35327043465235336,10.019999999999957,0.79724650840921274,0,0]
[0.52990565197890649,10.029999999999957,0.7964496603912179,0,0]
[0.70654086930545967,10.039999999999957,0.79533541102322336,0,0]
[0.88317608663201286,10.049999999999956,0.7939050949540305,0,0]
[1.0598113039585662,10.059999999999956,0.79216042358732053,0,0]
[1.2364465212851192,10.069999999999956,0.79010348166923228,0,0]
[1.4130817386116725,10.079999999999956,0.78773672313709286,0,0]
[1.5897169559382256,10.089999999999955,0.78506296624087035,0,0]
[1.7663521732647789,10.099999999999955,0.78208538795092586,0,0]
[1.942987390591332,10.109999999999955,0.77880751766759626,0,0]
[2.119622607917885,10.119999999999955,0.77523323025004509,0,0]
[2.2962578252444383,10.129999999999955,0.77136673838365033,0,0]
[2.4728930425709916,10.139999999999954,0.7672125843069767,0,0]
[2.6495282598975449,10.149999999999954,0.76277563092106915,0,0]
[2.8261634772240982,10.159999999999954,0.75806105230542564,0,0]
[3.0027986945506511,10.169999999999954,0.7530743236665316,0,0]
[3.1794339118772044,10.179999999999954,0.74782121074628183,0,0]
[3.3560691292037577,10.189999999999953,0.74230775871895838,0,0]
[3.532704346530311,10.199999999999953,0.73654028060667431,0,0]
[3.7093395638568638,10.209999999999953,0.73052534524433665,0,0]
[3.8859747811834171,10.219999999999953,0.72426976482621463,0,0]
[4.06260999850997,10.229999999999952,0.71778058206712059,0,0]
[4.2392452158365233,10.239999999999952,0.71106505701202671,0,0]
[4.4158804331630765,10.249999999999952,0.7041306535286328,0,0]
[4.5925156504896298,10.259999999999952,0.69698502551798402,0,0]
[4.7691508678161831,10.269999999999952,0.68963600287870275,0,0]
[4.9457860851427364,10.279999999999951,0.68209157726074221,0,0]
[5.1224213024692897,10.289999999999951,0.67435988764479937,0,0]
[5.299056519795843,10.299999999999951,0.66644920578363853,0,0]
[5.4756917371223963,10.309999999999951,0.65836792154156976,0,0]
[5.6523269544489487,10.319999999999951,0.65012452816820543,0,0]
[5.828962171775502,10.32999999999995,0.64172760754238711,0,0]
[6.0055973891020553,10.33999999999995,0.63318581542182861,0,0]
[6.1822326064286086,10.34999999999995,0.6245078667335664,0,0]
[6.3588678237551619,10.35999999999995,0.61570252093975042,0,0]
[6.5355030410817152,10.369999999999949,0.60677856751264569,0,0]
[6.7121382584082685,10.379999999999949,0.59774481155195169,0,0]
[6.8887734757348218,10.389999999999949,0.5886100595766971,0,0]
[7.0654086930613742,10.399999999999949,0.57938310552301286,0,0]
[7.2420439103879275,10.409999999999949,0.5700727169780625,0,0]
[7.4186791277144808,10.419999999999948,0.56068762167928976,0,0]
[7.5953143450410341,10.429999999999948,0.55123649430696242,0,0]
[7.7719495623675874,10.439999999999948,0.5417279435967256,0,0]
[7.9485847796941407,10.449999999999948,0.5321704997975597,0,0]
[8.1252199970206931,10.459999999999948,0.52257260249915671,0,0]
[8.3018552143472473,10.469999999999947,0.51294258885129151,0,0]
[8.4784904316737997,10.479999999999947,0.50328868219628531,0,0]
[8.6551256490003539,10.489999999999947,0.49361898113413677,0,0]
[8.8317608663269063,10.499999999999947,0.4839414490383383,0,0]
[9.0083960836534605,10.509999999999946,0.47426390403881091,0,0]
[9.1850313009800129,10.519999999999946,0.46459400948678431,0,0]
[9.3616665183065653,10.529999999999946,0.45493926491482378,0,0]
[9.5383017356331194,10.539999999999946,0.44530699750357439,0,0]
[9.7149369529596719,10.549999999999946,0.43570435406515318,0,0]
[{"$f":"(B359-B$4)/B$11","v":9.891572170286226},10.559999999999945,{"$f":"NORMDIST(B359,B$4,B$5,0)","v":0.42613829355148786},{"$f":"IF(C359<=B$14/2,C359,0)","v":0},{"$f":"IF(C359<=B$6/2,C359,0)","v":0}]
[10.068207387612778,10.569999999999945,0.41661558009426869,0,0]
[10.244842604939333,{"$f":"B360+0.01","v":10.579999999999945},0.40714277658157089,0,0]
[10.421477822265885,10.589999999999945,0.39772623877460361,0,0]
[10.598113039592439,10.599999999999945,0.38837210996647759,0,0]
[10.774748256918992,10.609999999999944,0.37908631618333194,0,0]
[10.951383474245544,10.619999999999944,0.36987456192666185,0,0]
[11.128018691572098,10.629999999999944,0.36074232645421161,0,0]
[11.304653908898651,10.639999999999944,0.35169486059537541,0,0]
[11.481289126225205,10.649999999999944,0.34273718409566512,0,0]
[11.657924343551757,10.659999999999943,0.33387408348347763,0,0]
[11.834559560878311,10.669999999999943,0.32511011045111787,0,0]
[12.011194778204864,10.679999999999943,0.31644958074081525,0,0]
[12.187829995531418,10.689999999999943,0.30789657352531613,0,0]
[12.36446521285797,10.699999999999942,0.29945493127153799,0,0]
[12.541100430184523,10.709999999999942,0.29112826007474296,0,0]
[12.717735647511077,10.719999999999942,0.28291993044972485,0,0]
[12.894370864837629,10.729999999999942,0.27483307856461026,0,0]
[13.071006082164184,10.739999999999942,0.26687060790205069,0,0]
[13.247641299490736,10.749999999999941,0.25903519133182901,0,0]
[13.42427651681729,10.759999999999941,0.25132927357822121,0,0]
[13.600911734143843,10.769999999999941,0.24375507406484789,0,0]
[13.777546951470395,10.779999999999941,0.23631459011920825,0,0]
[13.954182168796949,10.789999999999941,0.22900960051862779,0,0]
[14.130817386123502,10.79999999999994,0.22184166935895347,0,0]
[14.307452603450056,10.80999999999994,0.21481215022700934,0,0]
[14.484087820776608,10.81999999999994,0.20792219065756939,0,0]
[14.660723038103162,10.82999999999994,0.20117273685542145,0,0]
[14.837358255429715,10.839999999999939,0.19456453866297455,0,0]
[15.013993472756269,10.849999999999939,0.18809815475381275,0,0]
[15.190628690082821,10.859999999999939,0.18177395803260385,0,0]
[15.367263907409374,10.869999999999939,0.17559214122184866,0,0]
[15.543899124735928,10.879999999999939,0.16955272261608109,0,0]
[15.72053434206248,10.889999999999938,0.16365555198432152,0,0]
[15.897169559389035,10.899999999999938,0.15790031660182346,0,0]
[16.073804776715587,10.909999999999938,0.15228654739244901,0,0]
[16.250439994042139,10.919999999999938,0.14681362516334742,0,0]
[16.427075211368695,10.929999999999938,0.14148078691399962,0,0]
[16.603710428695248,10.939999999999937,0.13628713220212127,0,0]
[16.7803456460218,10.949999999999937,0.13123162954938455,0,0]
[16.956980863348353,10.959999999999937,0.1263131228704279,0,0]
[17.133616080674905,10.969999999999937,0.12153033790915942,0,0]
[17.310251298001461,10.979999999999936,0.11688188866693204,0,0]
[17.486886515328013,10.989999999999936,0.11236628380776444,0,0]
[17.663521732654566,10.999999999999936,0.10798193302640373,0,0]
[17.840156949981118,11.009999999999936,0.10372715336566801,0,0]
[18.016792167307674,11.019999999999936,9.9600175470167682E-2,0,0]
[18.193427384634226,11.029999999999935,9.5599149764179506E-2,0,0]
[18.370062601960779,11.039999999999935,9.1722152542134533E-2,0,0]
[18.546697819287331,11.049999999999935,8.7967191960878419E-2,0,0]
[18.723333036613884,11.059999999999935,8.4332213923563951E-2,0,0]
[18.89996825394044,11.069999999999935,8.0815107845743264E-2,0,0]
[19.076603471266992,11.079999999999934,7.7413712294933185E-2,0,0]
[19.253238688593544,11.089999999999934,7.4125820495634237E-2,0,0]
[19.429873905920097,11.099999999999934,7.0949185692483527E-2,0,0]
[19.606509123246653,11.109999999999934,6.7881526364918371E-2,0,0]
[19.783144340573205,11.119999999999933,6.4920531287414263E-2,0,0]
[19.959779557899758,11.129999999999933,6.2063864430035233E-2,0,0]
[20.13641477522631,11.139999999999933,5.9309169694700646E-2,0,0]
[20.313049992552862,11.149999999999933,5.6654075483219858E-2,0,0]
[20.489685209879418,11.159999999999933,5.4096199093780467E-2,0,0]
[20.666320427205971,11.169999999999932,5.1633150943191694E-2,0,0]
[20.842955644532523,11.179999999999932,4.9262538612780765E-2,0,0]
[21.019590861859076,11.189999999999932,4.6981970716417923E-2,0,0]
[{"$f":"(B423-B$4)/B$11","v":21.196226079185632},11.199999999999932,{"$f":"NORMDIST(B423,B$4,B$5,0)","v":4.4789060589700461E-2},{"$f":"IF(C423<=B$14/2,C423,0)","v":0},{"$f":"IF(C423<=B$6/2,C423,0)","v":0}]
[21.372861296512184,11.209999999999932,4.2681429799859706E-2,0,0]
[21.549496513838736,{"$f":"B424+0.01","v":11.219999999999931},4.0656711476465289E-2,0,0]
[21.726131731165289,11.229999999999931,3.8712553463487023E-2,0,0]
[21.902766948491841,11.239999999999931,3.6846621293736725E-2,0,0]
[22.079402165818397,11.249999999999931,3.5056600987149224E-2,0,0]
[22.25603738314495,11.259999999999931,3.3340201674773792E-2,0,0]
[22.432672600471502,11.26999999999993,3.1695158050732856E-2,0,0]
[22.609307817798054,11.27999999999993,3.0119232654765682E-2,0,0]
[22.785943035124607,11.28999999999993,2.8610217988309733E-2,0,0]
[22.962578252451163,11.29999999999993,2.7165938467381169E-2,2.7165938467381169E-2,0]
[23.139213469777715,11.309999999999929,2.5784252215800146E-2,2.5784252215800146E-2,0]
[23.315848687104268,11.319999999999929,2.4463052702565088E-2,2.4463052702565088E-2,2.4463052702565088E-2]
[23.49248390443082,11.329999999999929,2.3200270227413892E-2,2.3200270227413892E-2,2.3200270227413892E-2]
[23.669119121757376,11.339999999999929,2.1993873258819553E-2,2.1993873258819553E-2,2.1993873258819553E-2]
[23.845754339083928,11.349999999999929,2.0841869628853222E-2,2.0841869628853222E-2,2.0841869628853222E-2]
[24.022389556410481,11.359999999999928,1.9742307589509969E-2,1.9742307589509969E-2,1.9742307589509969E-2]
[24.199024773737033,11.369999999999928,1.869327673523194E-2,1.869327673523194E-2,1.869327673523194E-2]
[24.375659991063586,11.379999999999928,1.7692908796481485E-2,1.7692908796481485E-2,1.7692908796481485E-2]
[24.552295208390142,11.389999999999928,1.6739378309312779E-2,1.6739378309312779E-2,1.6739378309312779E-2]
[24.728930425716694,11.399999999999928,1.5830903165966352E-2,1.5830903165966352E-2,1.5830903165966352E-2]
[24.905565643043246,11.409999999999927,1.4965745051567253E-2,1.4965745051567253E-2,1.4965745051567253E-2]
[25.082200860369799,11.419999999999927,1.4142209772044752E-2,1.4142209772044752E-2,1.4142209772044752E-2]
[25.258836077696355,11.429999999999927,1.3358647478410819E-2,1.3358647478410819E-2,1.3358647478410819E-2]
[25.435471295022907,11.439999999999927,1.2613452792537177E-2,1.2613452792537177E-2,1.2613452792537177E-2]
[25.61210651234946,11.449999999999926,1.1905064839556783E-2,1.1905064839556783E-2,1.1905064839556783E-2]
[25.788741729676012,11.459999999999926,1.1231967191986766E-2,1.1231967191986766E-2,1.1231967191986766E-2]
[25.965376947002564,11.469999999999926,1.0592687730626641E-2,1.0592687730626641E-2,1.0592687730626641E-2]
[26.14201216432912,11.479999999999926,9.9857984272291329E-3,9.9857984272291329E-3,9.9857984272291329E-3]
[26.318647381655673,11.489999999999926,9.4099150538721303E-3,9.4099150538721303E-3,9.4099150538721303E-3]
[26.495282598982225,11.499999999999925,8.8636968238799824E-3,8.8636968238799824E-3,8.8636968238799824E-3]
[26.671917816308778,11.509999999999925,8.3458459690516976E-3,8.3458459690516976E-3,8.3458459690516976E-3]
[26.848553033635334,11.519999999999925,7.8551072578531434E-3,7.8551072578531434E-3,7.8551072578531434E-3]
[27.025188250961886,11.529999999999925,7.3902674591214699E-3,7.3902674591214699E-3,7.3902674591214699E-3]
[27.201823468288438,11.539999999999925,6.9501547557131041E-3,6.9501547557131041E-3,6.9501547557131041E-3]
[27.378458685614991,11.549999999999924,6.5336381124029069E-3,6.5336381124029069E-3,6.5336381124029069E-3]
[27.555093902941543,11.559999999999924,6.1396266022123933E-3,6.1396266022123933E-3,6.1396266022123933E-3]
[27.731729120268099,11.569999999999924,5.767068695209634E-3,5.767068695209634E-3,5.767068695209634E-3]
[27.908364337594652,11.579999999999924,5.4149515136840158E-3,5.4149515136840158E-3,5.4149515136840158E-3]
[28.084999554921204,11.589999999999923,5.0823000574555218E-3,5.0823000574555218E-3,5.0823000574555218E-3]
[28.261634772247756,11.599999999999923,4.768176402932027E-3,4.768176402932027E-3,4.768176402932027E-3]
[28.438269989574312,11.609999999999923,4.4716788793792966E-3,4.4716788793792966E-3,4.4716788793792966E-3]
[28.614905206900865,11.619999999999923,4.1919412257179827E-3,4.1919412257179827E-3,4.1919412257179827E-3]
[28.791540424227417,11.629999999999923,3.9281317310107334E-3,3.9281317310107334E-3,3.9281317310107334E-3]
[28.96817564155397,11.639999999999922,3.6794523616504315E-3,3.6794523616504315E-3,3.6794523616504315E-3]
[29.144810858880522,11.649999999999922,3.4451378781091284E-3,3.4451378781091284E-3,3.4451378781091284E-3]
[29.321446076207078,11.659999999999922,3.2244549439559189E-3,3.2244549439559189E-3,3.2244549439559189E-3]
[29.49808129353363,11.669999999999922,3.0167012297021901E-3,3.0167012297021901E-3,3.0167012297021901E-3]
[29.674716510860183,11.679999999999922,2.8212045138842558E-3,2.8212045138842558E-3,2.8212045138842558E-3]
[29.851351728186735,11.689999999999921,2.637321783646885E-3,2.637321783646885E-3,2.637321783646885E-3]
[30.027986945513291,11.699999999999921,2.4644383369473596E-3,2.4644383369473596E-3,2.4644383369473596E-3]
[30.204622162839843,11.709999999999921,2.301966888358212E-3,2.301966888358212E-3,2.301966888358212E-3]
[30.381257380166396,11.719999999999921,2.1493466803086435E-3,2.1493466803086435E-3,2.1493466803086435E-3]
[30.557892597492948,11.72999999999992,2.0060426014695799E-3,2.0060426014695799E-3,2.0060426014695799E-3]
[30.734527814819501,11.73999999999992,1.8715443138559982E-3,1.8715443138559982E-3,1.8715443138559982E-3]
[30.911163032146057,11.74999999999992,1.7453653900924967E-3,1.7453653900924967E-3,1.7453653900924967E-3]
[31.087798249472609,11.75999999999992,1.6270424621645345E-3,1.6270424621645345E-3,1.6270424621645345E-3]
[31.264433466799161,11.76999999999992,1.5161343828582838E-3,1.5161343828582838E-3,1.5161343828582838E-3]
[31.441068684125714,11.779999999999919,1.4122214009768827E-3,1.4122214009768827E-3,1.4122214009768827E-3]
[31.61770390145227,11.789999999999919,1.3149043513101131E-3,1.3149043513101131E-3,1.3149043513101131E-3]
[31.794339118778822,11.799999999999919,1.2238038602282581E-3,1.2238038602282581E-3,1.2238038602282581E-3]
[31.970974336105375,11.809999999999919,1.1385595676691748E-3,1.1385595676691748E-3,1.1385595676691748E-3]
[32.147609553431927,11.819999999999919,1.0588293661904977E-3,1.0588293661904977E-3,1.0588293661904977E-3]
[32.324244770758483,11.829999999999918,9.842886576663754E-4,9.842886576663754E-4,9.842886576663754E-4]
[{"$f":"(B487-B$4)/B$11","v":32.500879988085032},11.839999999999918,{"$f":"NORMDIST(B487,B$4,B$5,0)","v":9.1462962812026525E-4},{"$f":"IF(C487<=B$14/2,C487,0)","v":9.1462962812026525E-4},{"$f":"IF(C487<=B$6/2,C487,0)","v":9.1462962812026525E-4}]
[32.677515205411588,11.849999999999918,8.4956054110201895E-4,8.4956054110201895E-4,8.4956054110201895E-4]
[32.854150422738144,{"$f":"B488+0.01","v":11.859999999999918},7.8880504993879589E-4,7.8880504993879589E-4,7.8880504993879589E-4]
[33.030785640064693,11.869999999999918,7.3210152911512257E-4,7.3210152911512257E-4,7.3210152911512257E-4]
[33.207420857391249,11.879999999999917,6.7920242496773186E-4,6.7920242496773186E-4,6.7920242496773186E-4]
[33.384056074717797,11.889999999999917,6.2987362581543808E-4,6.2987362581543808E-4,6.2987362581543808E-4]
[33.560691292044353,11.899999999999917,5.8389385158328928E-4,5.8389385158328928E-4,5.8389385158328928E-4]
[33.737326509370909,11.909999999999917,5.4105406292338657E-4,5.4105406292338657E-4,5.4105406292338657E-4]
[33.913961726697458,11.919999999999916,5.0115688978204286E-4,5.0115688978204286E-4,5.0115688978204286E-4]
[34.090596944024014,11.929999999999916,4.6401607931418476E-4,4.6401607931418476E-4,4.6401607931418476E-4]
[34.267232161350563,11.939999999999916,4.2945596300101365E-4,4.2945596300101365E-4,4.2945596300101365E-4]
[34.443867378677119,11.949999999999916,3.9731094278580624E-4,3.9731094278580624E-4,3.9731094278580624E-4]
[34.620502596003675,11.959999999999916,3.6742499600515702E-4,3.6742499600515702E-4,3.6742499600515702E-4]
[34.797137813330224,11.969999999999915,3.3965119885891372E-4,3.3965119885891372E-4,3.3965119885891372E-4]
[34.97377303065678,11.979999999999915,3.1385126813127524E-4,3.1385126813127524E-4,3.1385126813127524E-4]
[35.150408247983329,11.989999999999915,2.8989512084797852E-4,2.8989512084797852E-4,2.8989512084797852E-4]
[35.327043465309885,11.999999999999915,2.6766045152995331E-4,2.6766045152995331E-4,2.6766045152995331E-4]
[35.503678682636441,12.009999999999915,2.4703232668221671E-4,2.4703232668221671E-4,2.4703232668221671E-4]
[35.680313899962989,12.019999999999914,2.2790279613788713E-4,2.2790279613788713E-4,2.2790279613788713E-4]
[35.856949117289545,12.029999999999914,2.1017052086094693E-4,2.1017052086094693E-4,2.1017052086094693E-4]
[36.033584334616101,12.039999999999914,1.9374041679757483E-4,1.9374041679757483E-4,1.9374041679757483E-4]
[36.21021955194265,12.049999999999914,1.7852331435439206E-4,1.7852331435439206E-4,1.7852331435439206E-4]
[36.386854769269206,12.059999999999913,1.6443563307268913E-4,1.6443563307268913E-4,1.6443563307268913E-4]
[36.563489986595755,12.069999999999913,1.5139907106043106E-4,1.5139907106043106E-4,1.5139907106043106E-4]
[36.740125203922311,12.079999999999913,1.3934030873852965E-4,1.3934030873852965E-4,1.3934030873852965E-4]
[36.916760421248867,12.089999999999913,1.2819072645430535E-4,1.2819072645430535E-4,1.2819072645430535E-4]
[37.093395638575416,12.099999999999913,1.1788613551316619E-4,1.1788613551316619E-4,1.1788613551316619E-4]
[37.270030855901972,12.109999999999912,1.0836652217916037E-4,1.0836652217916037E-4,1.0836652217916037E-4]
[37.446666073228521,12.119999999999912,9.9575804196098462E-5,9.9575804196098462E-5,9.9575804196098462E-5]
[37.623301290555077,12.129999999999912,9.1461599383271027E-5,9.1461599383271027E-5,9.1461599383271027E-5]
[37.799936507881633,12.139999999999912,8.3975005863298042E-5,8.3975005863298042E-5,8.3975005863298042E-5]
[37.976571725208181,12.149999999999912,7.707039348423286E-5,7.707039348423286E-5,7.707039348423286E-5]
[38.153206942534737,12.159999999999911,7.0705206003600458E-5,7.0705206003600458E-5,7.0705206003600458E-5]
[38.329842159861286,12.169999999999911,6.4839773608477537E-5,6.4839773608477537E-5,6.4839773608477537E-5]
[38.506477377187842,12.179999999999911,5.9437135352930646E-5,5.9437135352930646E-5,5.9437135352930646E-5]
[38.683112594514398,12.189999999999911,5.4462871102027792E-5,5.4462871102027792E-5,5.4462871102027792E-5]
[38.859747811840947,12.19999999999991,4.9884942580146407E-5,4.9884942580146407E-5,4.9884942580146407E-5]
[39.036383029167503,12.20999999999991,4.5673543130330107E-5,4.5673543130330107E-5,4.5673543130330107E-5]
[39.213018246494059,12.21999999999991,4.1800955800934303E-5,4.1800955800934303E-5,4.1800955800934303E-5]
[39.389653463820608,12.22999999999991,3.8241419385666245E-5,3.8241419385666245E-5,3.8241419385666245E-5]
[39.566288681147164,12.23999999999991,3.4971002053306656E-5,3.4971002053306656E-5,3.4971002053306656E-5]
[39.742923898473713,12.249999999999909,3.1967482213837018E-5,3.1967482213837018E-5,3.1967482213837018E-5]
[39.919559115800269,12.259999999999909,2.9210236278329801E-5,2.9210236278329801E-5,2.9210236278329801E-5]
[40.096194333126824,12.269999999999909,2.6680132980733716E-5,2.6680132980733716E-5,2.6680132980733716E-5]
[40.272829550453373,12.279999999999909,2.4359433940557653E-5,2.4359433940557653E-5,2.4359433940557653E-5]
[40.449464767779929,12.289999999999909,2.2231700156374218E-5,2.2231700156374218E-5,2.2231700156374218E-5]
[40.626099985106478,12.299999999999908,2.0281704130990596E-5,2.0281704130990596E-5,2.0281704130990596E-5]
[40.802735202433034,12.309999999999908,1.8495347340026941E-5,1.8495347340026941E-5,1.8495347340026941E-5]
[40.97937041975959,12.319999999999908,1.685958276647195E-5,1.685958276647195E-5,1.685958276647195E-5]
[41.156005637086139,12.329999999999908,1.5362342234514148E-5,1.5362342234514148E-5,1.5362342234514148E-5]
[41.332640854412695,12.339999999999907,1.3992468286552889E-5,1.3992468286552889E-5,1.3992468286552889E-5]
[41.509276071739244,12.349999999999907,1.2739650357745315E-5,1.2739650357745315E-5,1.2739650357745315E-5]
[41.6859112890658,12.359999999999907,1.1594365012724728E-5,1.1594365012724728E-5,1.1594365012724728E-5]
[41.862546506392356,12.369999999999907,1.0547820019211919E-5,1.0547820019211919E-5,1.0547820019211919E-5]
[42.039181723718904,12.379999999999907,9.5919020431135629E-6,9.5919020431135629E-6,9.5919020431135629E-6]
[42.21581694104546,12.389999999999906,8.7191277593510796E-6,8.7191277593510796E-6,8.7191277593510796E-6]
[42.392452158372009,12.399999999999906,7.922598182071286E-6,7.922598182071286E-6,7.922598182071286E-6]
[42.569087375698565,12.409999999999906,7.1959560270490272E-6,7.1959560270490272E-6,7.1959560270490272E-6]
[42.745722593025121,12.419999999999906,6.5333459279925033E-6,6.5333459279925033E-6,6.5333459279925033E-6]
[42.92235781035167,12.429999999999906,5.9293773370959906E-6,5.9293773370959906E-6,5.9293773370959906E-6]
[43.098993027678226,12.439999999999905,5.3790899485480153E-6,5.3790899485480153E-6,5.3790899485480153E-6]
[43.275628245004782,12.449999999999905,4.8779214917912538E-6,4.8779214917912538E-6,4.8779214917912538E-6]
[43.452263462331331,12.459999999999905,4.4216777491409743E-6,4.4216777491409743E-6,4.4216777491409743E-6]
[43.628898679657887,12.469999999999905,4.0065046599007574E-6,4.0065046599007574E-6,4.0065046599007574E-6]
[{"$f":"(B551-B$4)/B$11","v":43.805533896984436},12.479999999999905,{"$f":"NORMDIST(B551,B$4,B$5,0)","v":3.6288623803675035E-6},{"$f":"IF(C551<=B$14/2,C551,0)","v":3.6288623803675035E-6},{"$f":"IF(C551<=B$6/2,C551,0)","v":3.6288623803675035E-6}]
[43.982169114310992,12.489999999999904,3.2855011760932822E-6,3.2855011760932822E-6,3.2855011760932822E-6]
[44.158804331637548,{"$f":"B552+0.01","v":12.499999999999904},2.9734390294714477E-6,2.9734390294714477E-6,2.9734390294714477E-6]
[44.335439548964096,12.509999999999904,2.6899408521414789E-6,2.6899408521414789E-6,2.6899408521414789E-6]
[44.512074766290652,12.519999999999904,2.4324991978649997E-6,2.4324991978649997E-6,2.4324991978649997E-6]
[44.688709983617201,12.529999999999903,2.1988163774185546E-6,2.1988163774185546E-6,2.1988163774185546E-6]
[44.865345200943757,12.539999999999903,1.986787882681779E-6,1.986787882681779E-6,1.986787882681779E-6]
[45.041980418270313,12.549999999999903,1.7944870324784397E-6,1.7944870324784397E-6,1.7944870324784397E-6]
[45.218615635596862,12.559999999999903,1.6201507578578836E-6,1.6201507578578836E-6,1.6201507578578836E-6]
[45.395250852923418,12.569999999999903,1.4621664493921603E-6,1.4621664493921603E-6,1.4621664493921603E-6]
[45.571886070249967,12.579999999999902,1.3190597937163742E-6,1.3190597937163742E-6,1.3190597937163742E-6]
[45.748521287576523,12.589999999999902,1.1894835309627571E-6,1.1894835309627571E-6,1.1894835309627571E-6]
[45.925156504903079,12.599999999999902,1.0722070689406179E-6,1.0722070689406179E-6,1.0722070689406179E-6]
[46.101791722229628,12.609999999999902,9.6610689390092655E-7,9.6610689390092655E-7,9.6610689390092655E-7]
[46.278426939556184,12.619999999999902,8.701577215039215E-7,8.701577215039215E-7,8.701577215039215E-7]
[46.45506215688274,12.629999999999901,7.8342433518777594E-7,7.8342433518777594E-7,7.8342433518777594E-7]
[46.631697374209288,12.639999999999901,7.0505406252354529E-7,7.0505406252354529E-7,7.0505406252354529E-7]
[46.808332591535844,12.649999999999901,6.3426984334386106E-7,6.3426984334386106E-7,6.3426984334386106E-7]
[46.984967808862393,12.659999999999901,5.7036384645739907E-7,5.7036384645739907E-7,5.7036384645739907E-7]
[47.161603026188949,12.6699999999999,5.1269159461546322E-7,5.1269159461546322E-7,5.1269159461546322E-7]
[47.338238243515505,12.6799999999999,4.6066656008833471E-7,4.6066656008833471E-7,4.6066656008833471E-7]
[47.514873460842054,12.6899999999999,4.1375519574437563E-7,4.1375519574437563E-7,4.1375519574437563E-7]
[47.69150867816861,12.6999999999999,3.7147236891146043E-7,3.7147236891146043E-7,3.7147236891146043E-7]
[47.868143895495159,12.7099999999999,3.3337716754481956E-7,3.3337716754481956E-7,3.3337716754481956E-7]
[48.044779112821715,12.719999999999899,2.9906905033464666E-7,2.9906905033464666E-7,2.9906905033464666E-7]
[48.221414330148271,12.729999999999899,2.6818431436738989E-7,2.6818431436738989E-7,2.6818431436738989E-7]
[48.39804954747482,12.739999999999899,2.4039285581283106E-7,2.4039285581283106E-7,2.4039285581283106E-7]
[48.574684764801376,12.749999999999899,2.1539520085110544E-7,2.1539520085110544E-7,2.1539520085110544E-7]
[48.751319982127924,12.759999999999899,1.9291978568568323E-7,1.9291978568568323E-7,1.9291978568568323E-7]
[48.92795519945448,12.769999999999898,1.7272046601581461E-7,1.7272046601581461E-7,1.7272046601581461E-7]
[49.104590416781036,12.779999999999898,1.5457423777063331E-7,1.5457423777063331E-7,1.5457423777063331E-7]
[49.281225634107585,12.789999999999898,1.3827915224240565E-7,1.3827915224240565E-7,1.3827915224240565E-7]
[49.457860851434141,12.799999999999898,1.236524100034586E-7,1.236524100034586E-7,1.236524100034586E-7]
[49.634496068760697,12.809999999999897,1.1052861915512173E-7,1.1052861915512173E-7,1.1052861915512173E-7]
[49.811131286087246,12.819999999999897,9.875820454232317E-8,9.875820454232317E-8,9.875820454232317E-8]
[49.987766503413802,12.829999999999897,8.8205955578848947E-8,8.8205955578848947E-8,8.8205955578848947E-8]
[50.164401720740351,12.839999999999897,7.8749701270089321E-8,7.8749701270089321E-8,7.8749701270089321E-8]
[50.341036938066907,12.849999999999897,7.0279101896491571E-8,7.0279101896491571E-8,7.0279101896491571E-8]
[50.517672155393463,12.859999999999896,6.2694547635913748E-8,6.2694547635913748E-8,6.2694547635913748E-8]
[50.694307372720012,12.869999999999896,5.5906155160376038E-8,5.5906155160376038E-8,5.5906155160376038E-8]
[50.870942590046567,12.879999999999896,4.9832853945961641E-8,4.9832853945961641E-8,4.9832853945961641E-8]
[51.047577807373116,12.889999999999896,4.4401554687211501E-8,4.4401554687211501E-8,4.4401554687211501E-8]
[51.224213024699672,12.899999999999896,3.9546392812537254E-8,3.9546392812537254E-8,3.9546392812537254E-8]
[51.400848242026228,12.909999999999895,3.5208040658014593E-8,3.5208040658014593E-8,3.5208040658014593E-8]
[51.577483459352777,12.919999999999895,3.1333082376303439E-8,3.1333082376303439E-8,3.1333082376303439E-8]
[51.754118676679333,12.929999999999895,2.7873446138129144E-8,2.7873446138129144E-8,2.7873446138129144E-8]
[51.930753894005882,12.939999999999895,2.4785888628330898E-8,2.4785888628330898E-8,2.4785888628330898E-8]
[52.107389111332438,12.949999999999894,2.2031527249392092E-8,2.2031527249392092E-8,2.2031527249392092E-8]
[52.284024328658994,12.959999999999894,1.9575415824906837E-8,1.9575415824906837E-8,1.9575415824906837E-8]
[52.460659545985543,12.969999999999894,1.7386159945782274E-8,1.7386159945782274E-8,1.7386159945782274E-8]
[52.637294763312099,12.979999999999894,1.5435568425160579E-8,1.5435568425160579E-8,1.5435568425160579E-8]
[52.813929980638648,12.989999999999894,1.3698337625988989E-8,1.3698337625988989E-8,1.3698337625988989E-8]

{"sheet":"What Excel Does","index":12,"n_rows":204,"n_cols":8,"rows_kept":204,"cut":false,"hidden":false,"merged":[]}
[]
[null,"1) Hold data",null,"2) Make calculations"]
[]
[null,"Revenue",null,"Average Sale",{"$f":"AVERAGE(B5:B204)","v":75.057750000000041}]
[null,45.9]
[null,19.95]
[null,21.95,null,"3) Perform data analysis (analytics) = Converting data into useful information to gain insight and make decisions"]
[null,19.95]
[null,79.8,null,"Tabular = table of information = report",null,null,null,"Graphical = visualize, like with a chart"]
[null,79.8]
[null,59.849999999999994,null,"Revenue ($) Upper Limit not Included)","Frequency","Cumulative Frequency"]
[null,139.65,null,"0-25",53,0.26500000000000001]
[null,119.69999999999999,null,"25-50",44,0.48499999999999999]
[null,43.9,null,"50-75",22,0.59499999999999997]
[null,43.9,null,"75-100",24,0.71499999999999997]
[null,99.75,null,"100-125",30,0.86499999999999999]
[null,114.75,null,"125-150",7,0.9]
[null,91.8,null,"150-175",9,0.94499999999999995]
[null,114.75,null,"175-200",4,0.96499999999999997]
[null,22.95,null,"200-225",2,0.97499999999999998]
[null,124.75,null,"225-250",4,0.995]
[null,19.95,null,"275-300",1,1]
[null,87.8,null,"Grand Total",200]
[null,22.95]
[null,299.5]
[null,19.95]
[null,99.75,null,"Table",null,null,null,"Chart"]
[null,39.9]
[null,65.849999999999994]
[null,24.95]
[null,21.95]
[null,19.95]
[null,91.8]
[null,65.849999999999994]
[null,39.9]
[null,43.9]
[null,65.849999999999994]
[null,43.9]
[null,99.75]
[null,29.95]
[null,65.849999999999994]
[null,22.95]
[null,19.95]
[null,99.75]
[null,124.75]
[null,21.95]
[null,174.65]
[null,29.95]
[null,149.75]
[null,29.95]
[null,45.9]
[null,160.65]
[null,160.65]
[null,119.69999999999999]
[null,43.9]
[null,119.69999999999999]
[null,65.849999999999994]
[null,22.95]
[null,65.849999999999994]
[null,109.75]
[null,114.75]
[null,249.5]
[null,109.75]
[null,114.75]
[null,114.75]
[null,119.8]
[null,29.95]
[null,114.75]
[null,209.65]
[null,114.75]
[null,59.849999999999994]
[null,124.75]
[null,39.9]
[null,124.75]
[null,24.95]
[null,22.95]
[null,249.5]
[null,59.849999999999994]
[null,43.9]
[null,19.95]
[null,29.95]
[null,19.95]
[null,65.849999999999994]
[null,22.95]
[null,79.8]
[null,79.8]
[null,114.75]
[null,22.95]
[null,19.95]
[null,109.75]
[null,59.9]
[null,43.9]
[null,39.9]
[null,209.65]
[null,19.95]
[null,79.8]
[null,124.75]
[null,24.95]
[null,160.65]
[null,65.849999999999994]
[null,137.69999999999999]
[null,29.95]
[null,119.69999999999999]
[null,19.95]
[null,39.9]
[null,114.75]
[null,21.95]
[null,179.7]
[null,39.9]
[null,24.95]
[null,99.8]
[null,87.8]
[null,39.9]
[null,65.849999999999994]
[null,199.5]
[null,21.95]
[null,124.75]
[null,29.95]
[null,21.95]
[null,119.8]
[null,89.85]
[null,65.849999999999994]
[null,91.8]
[null,149.69999999999999]
[null,59.849999999999994]
[null,131.69999999999999]
[null,49.9]
[null,43.9]
[null,19.95]
[null,21.95]
[null,24.95]
[null,39.9]
[null,24.95]
[null,114.75]
[null,119.69999999999999]
[null,43.9]
[null,24.95]
[null,174.65]
[null,24.95]
[null,49.9]
[null,19.95]
[null,39.9]
[null,45.9]
[null,179.7]
[null,160.65]
[null,21.95]
[null,124.75]
[null,89.85]
[null,49.9]
[null,22.95]
[null,19.95]
[null,99.75]
[null,91.8]
[null,49.9]
[null,21.95]
[null,45.9]
[null,22.95]
[null,45.9]
[null,24.95]
[null,39.9]
[null,179.7]
[null,21.95]
[null,24.95]
[null,74.849999999999994]
[null,79.8]
[null,19.95]
[null,22.95]
[null,45.9]
[null,65.849999999999994]
[null,139.65]
[null,22.95]
[null,39.9]
[null,109.75]
[null,160.65]
[null,49.9]
[null,22.95]
[null,45.9]
[null,68.849999999999994]
[null,229.5]
[null,29.95]
[null,39.9]
[null,43.9]
[null,19.95]
[null,59.9]
[null,99.75]
[null,174.65]
[null,65.849999999999994]
[null,124.75]
[null,87.8]
[null,229.5]
[null,99.75]
[null,19.95]
[null,19.95]
[null,99.8]
[null,24.95]
[null,114.75]
[null,59.849999999999994]
[null,43.9]
[null,74.849999999999994]
[null,19.95]
[null,22.95]
[null,153.65]
[null,39.9]
[null,131.69999999999999]

{"sheet":"Structure","index":13,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Excel Layout:"]
["Column Headers"]
["Row Headers"]
["Cells = Intersection of Column and Row"]
["Horizontal & Vertical Scroll Bars & Buttons = Expose more rows or columns of cells"]
["Worksheets = Sheet = All The Cells"]
["Sheet Tab Names = Name of Sheet"]
["Active Sheet is the Worksheet that is Selected"]
["Double-click Sheet Tab to remine"]
["Right-click Sheet Tab, Tab Color to add color to Sheet Tab"]
["Workbooks = All Sheets"]
["File = Workbook"]
["Ribbon Tabs (keyboard to show or hide Ribbon: Ctrl + F1 (toggle))"]
["Quick Access Toolbar = QAT"]
["Right-click features in Ribbon Tabs, Add To QAT"]
[]
[]
[]
[]
[]
["Navigate to new Worksheets:"]
["1) Click Sheet Tab = Activates a Worksheet"]
["2) Worksheet Scroll Arrow exposes more Worksheets without moving Active Worksheet"]
["3) … icons selects next hidden worksheet to make it the Active Worksheet"]
["4) Activate dialog box (right-click Worksheet Scroll Arrows)"]
["5) Keyboard to Move Active Sheet = Ctrl + PageDown (Right) or PageUp (Left)"]

{"sheet":"Conventions","index":14,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sheet Tab Fill Colors:"]
[null,"Yellow = Information"]
[null,"Blue = You work on this sheet"]
[null,"Red = Answer as I completed it while filming video"]
[]
[]
[null,"Data Set and Formula Fill Colors:",null,null,null,"Sales","Tax Amount ($)",null,"Tax Rate"]
[null,"Dark blue = field names (column headers)",null,null,null,326.82,{"$f":"ROUND(F9:F13*I9,2)","v":24.35},null,7.4499999999999997E-2]
[null,"Dark blue = Answer cell label",null,null,null,446.39,33.26]
[null,"Red = formula input",null,null,null,474.74,35.369999999999997]
[null,null,null,null,null,233.21,17.37]
[null,null,null,null,null,488.01,36.36]
[null,null,null,null,"Total",{"$f":"SUM(F9:F13)","v":1969.17},{"$f":"SUM(_xlfn.ANCHORARRAY(G9))","v":146.70999999999998}]

{"sheet":"Data & Alignmnet","index":15,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Data Types in Excel","Default Alignment","Example1","Example2"]
["Text","Left"]
["Numbers","Right"]
["Logical/Boolean (TRUE or FALSE)","Center and All CAPS"]
["Errors","Center"]
["Empty Cells",null,null,null,"<<== Not really a Data Type, but it is a \"thing\" in Excel that can sometimes cause problems."]
[null,null,null,null,"**Refer to Empty Cells as \"Empty Cells\", not blanks."]
["Why is Default Alignment important:"]
["Answer: It helps to track down errors."]
["Example 1: We download these numbers from company web site:",null,null,null,"Example 2: We download these numbers from company database:"]
[]
[null,"Sales",null,null,null,"Sales"]
[null,326.82," <<== Excel sees these as Numbers",null,null,"326.82"," <<== Excel sees these as Text"]
[null,446.39,null,null,null,"446.39"]
[null,474.74,null,null,null,"474.74"]
[null,233.21,null,null,null,"233.21"]
[null,488.01,null,null,null,"488.01"]
["Total",null,null,null,"Total"]
[]
[null,null,null,null,null,"*The immediate visual cue is that the numbers are NOT aligned right"]
[]
[]
["Important Rule for entering data: 1) Don't use Alignment. Always keep Default Alignment."]
[]
["Common mistake made in the working world:"]
[]
["Date","Units Purchased","Cost","Units Sold","Price","Running Balance"]
["Balance Forward:",null,null,null,null,159]
["2015-01-05",null,null,48,25.5,{"$f":"IF(A29,F28+B29-D29,\"\")","v":111}]
["2015-01-06","144",11.55,null,null,{"$f":"IF(A30,F29+B30-D30,\"\")","v":255}]
["2015-01-07",null,null,190,24.35,65]
[null,null,null,"24",27,""]
[null,192,null,null,null,""]
[]
[]
[]
[null,"SUM:"]
[null,{"$f":"SUM(B29:B35)","v":192}]

{"sheet":"Data & Alignmnet (an)","index":16,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Data Types in Excel","Default Alignment","Example1","Example2"]
["Text","Left","Excel"]
["Numbers","Right",43]
["Logical/Boolean (TRUE or FALSE)","Center and All CAPS",true,false]
["Errors","Center",{"$f":"C3/0","v":{"$error":"#DIV/0!"}},{"$f":"C3+C2","v":{"$error":"#VALUE!"}}]
["Empty Cells",null,null,null,"<<== Not really a Data Type, but it is a \"thing\" in Excel that can sometimes cause problems."]
[null,null,null,null,"**Refer to Empty Cells as \"Empty Cells\", not blanks."]
["Why is Default Alignment important:"]
["Answer: It helps to track down errors."]
["Example 1: We download these numbers from company web site:",null,null,null,"Example 2: We download these numbers from company database:"]
[]
[null,"Sales",null,null,null,"Sales"]
[null,326.82," <<== Excel sees these as Numbers",null,null,"326.82"," <<== Excel sees these as Text"]
[null,446.39,null,null,null,"446.39"]
[null,474.74,null,null,null,"474.74"]
[null,233.21,null,null,null,"233.21"]
[null,488.01,null,null,null,"488.01"]
["Total",{"$f":"SUM(B13:B17)","v":1969.17},null,null,"Total",{"$f":"SUM(F13:F17)","v":0}]
[]
[null,null,null,null,null,"*The immediate visual cue is that the numbers are NOT aligned right"]
[]
[]
["Important Rule for entering data: 1) Don't use Alignment. Always keep Default Alignment."]
[]
["Common mistake made in the working world:"]
[]
["Date","Units Purchased","Cost","Units Sold","Price","Running Balance"]
["Balance Forward:",null,null,null,null,159]
["2015-01-05",null,null,48,25.5,{"$f":"IF(A29,F28+B29-D29,\"\")","v":111}]
["2015-01-06","144",11.55,null,null,{"$f":"IF(A30,F29+B30-D30,\"\")","v":255}]
["2015-01-07",null,null,190,24.35,65]
["2015-01-08",null,null,"24",27,41]
[null,192,11.34,null,null,""]
[]
[]
[]
[null,"SUM:"]
[null,{"$f":"SUM(B29:B35)","v":192}]

{"sheet":"Keyboards","index":17,"n_rows":235,"n_cols":6,"rows_kept":235,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Revenue ($)",null,"Total",null,"Keyboards are fast:"]
[null,1145.19,null,null,null,"Jump to end of current region => Ctrl + Arrow"]
[null,19.95,null,null,null,"Highlight to end of current region => Ctrl + Shift + Arrow"]
[null,21.95,null,null,null,"Sum Function => Alt + ="]
[null,1219.95,null,null,null,"Open Format Cells dialog box if cell or range is selected => Ctrl + 1"]
[null,79.8,null,null,null,"Open Chart Format Task Pane if chart is selected => Ctrl + 1"]
[null,79.8,null,null,null,"Many, many more that we will learn in class …"]
[null,59.849999999999994]
[null,139.65,null,null,null,"Entering Data & Formulas into Cells:"]
[null,119.69999999999999,null,null,null,"Ctrl + Enter = Puts the content into active cell and keeps active cell selected. Use this when your goal is to put the content into the active cell and immediately do something to the active cell, like copy or format it."]
[null,1743.9,null,null,null,"Enter = Puts the content into active cell and moves the selected cell down by one row. Use this when your goal is to put the content into the active cell and immediately do something in the cell below, like enter more content."]
[null,43.9,null,null,null,"Shift + Enter = Puts the content into active cell and moves the selected cell up by one row. Use this when your goal is to put the content into the active cell and move the selected cell up by one row, like when you need to enter a formula but the worksheet screen does not show the active cell."]
[null,99.75,null,null,null,"Tab = Puts the content into active cell and moves the selected cell to the right by one column. Use this when your goal is to put the content into the active cell and immediately do something in the cell to the right, like enter more content."]
[null,114.75,null,null,null,"Shift + Tab = Puts the content into active cell and moves the selected cell to the right by one column. Use this when your goal is to put the content into the active cell and immediately do something in the cell to the left, like enter more content."]
[null,91.8]
[null,114.75,null,null,null,"Selection keyboards"]
[null,22.95,null,null,null,"Ctrl + Shift + Arrow = Selects a range of cell content in the direction of the arrow, stops when it bumps into the first empty cell. Use this when you want to quickly highlight a column or row of cell content. If there is no content when you invoke this keyboard, then this keyboard jumps all the way to the edge of the worksheet."]
[null,124.75,null,null,null,"Ctrl + * (Number Pad) = Ctrl + Shift + 8 (Standard Keys) = Selects the current region, which means everything in all directions from the active cell, up to the first complete row or column of empty cells, or it bumps into the worksheet row numbers or column letters. This is the keyboard shortcut to instantly select a whole table."]
[null,19.95,null,null,null,"Shift + Arrow = Highlights one cell at a time in the direction of the arrow, incrementing slowly on each click of the arrow. The trick is to hold the Shift key and then tap the arrow key, once for each character that you want to select. This is useful when you have a small selection to make within a larger block of cells."]
[null,87.8]
[null,22.95,null,null,null,"Navigation Keys"]
[null,299.5,null,null,null,"Ctrl + Home = Jumps the active cell to cell A1. This is convenient when you want to jump to the very top of the worksheet."]
[null,19.95,null,null,null,"Ctrl + End = Jumps the active cell to last cell used in entire worksheet. You can use this to jump to the very bottom of your work area."]
[null,99.75,null,null,null,"Ctrl + Arrow = Jumps the active cell to last cell with content, in the direction of the arrow, stoping when it bumps into the first empty cell. This keyboard is great when you want to jump to the last bit of data in a row or a column."]
[null,39.9,null,null,null,"Ctrl + . (period or Decimal key) = Jumps the active cell to next corner in a selected range. This keyboard only jumps between the four corners of a selected range. It is useful for navigating the four corners of a large table."]
[null,65.849999999999994,null,null,null,"Ctrl + Backspace = Jumps the screen back to the active cell. This keyboard works whether or not the active cell is in edit mode or the cell is just selected. It is a great keyboard when the active cell is off screen, but you need to instantly jump back to the active cell."]
[null,24.95]
[null,21.95,null,null,null,"Other Keyboards"]
[null,19.95,null,null,null,"F2 = put cell in edit mode."]
[null,91.8,null,null,null,"F4 = Toggles between the different types of cell references in a formula."]
[null,65.849999999999994,null,null,null,"F7 = Spell Check."]
[null,39.9,null,null,null,"F9 = Evaluate Formula Element."]
[null,43.9,null,null,null,"Ctrl + C = Copy."]
[null,65.849999999999994,null,null,null,"Ctrl + V = Paste."]
[null,43.9,null,null,null,"Ctrl + X = Cut."]
[null,99.75,null,null,null,"Ctrl + Shift + Arrow = Select everything up to the first empty cell."]
[null,29.95,null,null,null,"Alt + = (Equal Sign) = Insert SUM function into cell."]
[null,65.849999999999994,null,null,null,"Fx + F12 = Save As when keyboards require the Fx Function Key."]
[null,22.95,null,null,null,"Ctrl + Backspace = Jump Back to Active Cell."]
[null,19.95,null,null,null,"Shift + Enter = Puts the content into active cell and moves the selected cell up by one row."]
[null,99.75,null,null,null,"Alt, N, V, T = Open Create PivotTable dialog box."]
[null,124.75,null,null,null,"Alt, N, V = Open Create PivotTable dialog box if you do not have a Power BI Account or you are not logged in."]
[null,21.95,null,null,null,"Alt, P, S, P = Open Page Setup dialog box."]
[null,174.65,null,null,null,"Alt, A, M = Remove Duplicates."]
[null,29.95,null,null,null,"Alt, A, D, M = Open Data Model."]
[null,149.75,null,null,null,"Right-Click Key, B, V = Convert Excel Table to Range."]
[null,29.95,null,null,null,"Alt, “Position of Item in QAT” = Invoke button from QAT based on position of button in QAT."]
[null,45.9]
[null,160.65]
[null,160.65]
[null,119.69999999999999]
[null,43.9]
[null,119.69999999999999]
[null,65.849999999999994]
[null,22.95]
[null,65.849999999999994]
[null,109.75]
[null,114.75]
[null,249.5]
[null,109.75]
[null,114.75]
[null,114.75]
[null,119.8]
[null,29.95]
[null,114.75]
[null,209.65]
[null,114.75]
[null,59.849999999999994]
[null,124.75]
[null,39.9]
[null,124.75]
[null,24.95]
[null,22.95]
[null,249.5]
[null,59.849999999999994]
[null,43.9]
[null,19.95]
[null,29.95]
[null,19.95]
[null,65.849999999999994]
[null,22.95]
[null,79.8]
[null,79.8]
[null,114.75]
[null,22.95]
[null,19.95]
[null,109.75]
[null,59.9]
[null,43.9]
[null,39.9]
[null,209.65]
[null,19.95]
[null,79.8]
[null,124.75]
[null,24.95]
[null,160.65]
[null,65.849999999999994]
[null,137.69999999999999]
[null,29.95]
[null,119.69999999999999]
[null,19.95]
[null,39.9]
[null,114.75]
[null,21.95]
[null,179.7]
[null,39.9]
[null,24.95]
[null,99.8]
[null,87.8]
[null,39.9]
[null,65.849999999999994]
[null,199.5]
[null,21.95]
[null,124.75]
[null,29.95]
[null,21.95]
[null,119.8]
[null,89.85]
[null,65.849999999999994]
[null,91.8]
[null,149.69999999999999]
[null,59.849999999999994]
[null,131.69999999999999]
[null,49.9]
[null,43.9]
[null,19.95]
[null,21.95]
[null,24.95]
[null,39.9]
[null,24.95]
[null,114.75]
[null,119.69999999999999]
[null,43.9]
[null,24.95]
[null,174.65]
[null,24.95]
[null,49.9]
[null,19.95]
[null,39.9]
[null,45.9]
[null,179.7]
[null,160.65]
[null,21.95]
[null,124.75]
[null,89.85]
[null,49.9]
[null,22.95]
[null,19.95]
[null,99.75]
[null,91.8]
[null,49.9]
[null,21.95]
[null,45.9]
[null,22.95]
[null,45.9]
[null,24.95]
[null,39.9]
[null,179.7]
[null,21.95]
[null,24.95]
[null,74.849999999999994]
[null,79.8]
[null,19.95]
[null,22.95]
[null,45.9]
[null,65.849999999999994]
[null,139.65]
[null,22.95]
[null,39.9]
[null,109.75]
[null,160.65]
[null,49.9]
[null,22.95]
[null,45.9]
[null,68.849999999999994]
[null,229.5]
[null,29.95]
[null,39.9]
[null,43.9]
[null,19.95]
[null,59.9]
[null,99.75]
[null,174.65]
[null,65.849999999999994]
[null,124.75]
[null,87.8]
[null,229.5]
[null,99.75]
[null,19.95]
[null,19.95]
[null,99.8]
[null,24.95]
[null,114.75]
[null,59.849999999999994]
[null,43.9]
[null,74.849999999999994]
[null,19.95]
[null,22.95]
[null,153.65]
[null,39.9]
[null,131.69999999999999]

{"sheet":"Keyboards (an)","index":18,"n_rows":235,"n_cols":6,"rows_kept":235,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Revenue ($)",null,"Total",null,"Keyboards are fast:"]
[null,1145.19,null,{"$f":"SUM(B36:B235)","v":19010.840000000029},null,"Jump to end of current region => Ctrl + Arrow"]
[null,19.95,null,null,null,"Highlight to end of current region => Ctrl + Shift + Arrow"]
[null,21.95,null,null,null,"Sum Function => Alt + ="]
[null,1219.95,null,null,null,"Open Format Cells dialog box if cell or range is selected => Ctrl + 1"]
[null,79.8,null,null,null,"Open Chart Format Task Pane if chart is selected => Ctrl + 1"]
[null,79.8,null,null,null,"Many, many more that we will learn in class …"]
[null,59.849999999999994]
[null,139.65,null,null,null,"Entering Data & Formulas into Cells:"]
[null,119.69999999999999,null,null,null,"Ctrl + Enter = Puts the content into active cell and keeps active cell selected. Use this when your goal is to put the content into the active cell and immediately do something to the active cell, like copy or format it."]
[null,1743.9,null,null,null,"Enter = Puts the content into active cell and moves the selected cell down by one row. Use this when your goal is to put the content into the active cell and immediately do something in the cell below, like enter more content."]
[null,43.9,null,null,null,"Shift + Enter = Puts the content into active cell and moves the selected cell up by one row. Use this when your goal is to put the content into the active cell and move the selected cell up by one row, like when you need to enter a formula but the worksheet screen does not show the active cell."]
[null,99.75,null,null,null,"Tab = Puts the content into active cell and moves the selected cell to the right by one column. Use this when your goal is to put the content into the active cell and immediately do something in the cell to the right, like enter more content."]
[null,114.75,null,null,null,"Shift + Tab = Puts the content into active cell and moves the selected cell to the right by one column. Use this when your goal is to put the content into the active cell and immediately do something in the cell to the left, like enter more content."]
[null,91.8]
[null,114.75,null,null,null,"Selection keyboards"]
[null,22.95,null,null,null,"Ctrl + Shift + Arrow = Selects a range of cell content in the direction of the arrow, stops when it bumps into the first empty cell. Use this when you want to quickly highlight a column or row of cell content. If there is no content when you invoke this keyboard, then this keyboard jumps all the way to the edge of the worksheet."]
[null,124.75,null,null,null,"Ctrl + * (Number Pad) = Ctrl + Shift + 8 (Standard Keys) = Selects the current region, which means everything in all directions from the active cell, up to the first complete row or column of empty cells, or it bumps into the worksheet row numbers or column letters. This is the keyboard shortcut to instantly select a whole table."]
[null,19.95,null,null,null,"Shift + Arrow = Highlights one cell at a time in the direction of the arrow, incrementing slowly on each click of the arrow. The trick is to hold the Shift key and then tap the arrow key, once for each character that you want to select. This is useful when you have a small selection to make within a larger block of cells."]
[null,87.8]
[null,22.95,null,null,null,"Navigation Keys"]
[null,299.5,null,null,null,"Ctrl + Home = Jumps the active cell to cell A1. This is convenient when you want to jump to the very top of the worksheet."]
[null,19.95,null,null,null,"Ctrl + End = Jumps the active cell to last cell used in entire worksheet. You can use this to jump to the very bottom of your work area."]
[null,99.75,null,null,null,"Ctrl + Arrow = Jumps the active cell to last cell with content, in the direction of the arrow, stoping when it bumps into the first empty cell. This keyboard is great when you want to jump to the last bit of data in a row or a column."]
[null,39.9,null,null,null,"Ctrl + . (period or Decimal key) = Jumps the active cell to next corner in a selected range. This keyboard only jumps between the four corners of a selected range. It is useful for navigating the four corners of a large table."]
[null,65.849999999999994,null,null,null,"Ctrl + Backspace = Jumps the screen back to the active cell. This keyboard works whether or not the active cell is in edit mode or the cell is just selected. It is a great keyboard when the active cell is off screen, but you need to instantly jump back to the active cell."]
[null,24.95]
[null,21.95,null,null,null,"Other Keyboards"]
[null,19.95,null,null,null,"F2 = put cell in edit mode."]
[null,91.8,null,null,null,"F4 = Toggles between the different types of cell references in a formula."]
[null,65.849999999999994,null,null,null,"F7 = Spell Check."]
[null,39.9,null,null,null,"F9 = Evaluate Formula Element."]
[null,43.9,null,null,null,"Ctrl + C = Copy."]
[null,65.849999999999994,null,null,null,"Ctrl + V = Paste."]
[null,43.9,null,null,null,"Ctrl + X = Cut."]
[null,99.75,null,null,null,"Ctrl + Shift + Arrow = Select everything up to the first empty cell."]
[null,29.95,null,null,null,"Alt + = (Equal Sign) = Insert SUM function into cell."]
[null,65.849999999999994,null,null,null,"Fx + F12 = Save As when keyboards require the Fx Function Key."]
[null,22.95,null,null,null,"Ctrl + Backspace = Jump Back to Active Cell."]
[null,19.95,null,null,null,"Shift + Enter = Puts the content into active cell and moves the selected cell up by one row."]
[null,99.75,null,null,null,"Alt, N, V, T = Open Create PivotTable dialog box."]
[null,124.75,null,null,null,"Alt, N, V = Open Create PivotTable dialog box if you do not have a Power BI Account or you are not logged in."]
[null,21.95,null,null,null,"Alt, P, S, P = Open Page Setup dialog box."]
[null,174.65,null,null,null,"Alt, A, M = Remove Duplicates."]
[null,29.95,null,null,null,"Alt, A, D, M = Open Data Model."]
[null,149.75,null,null,null,"Right-Click Key, B, V = Convert Excel Table to Range."]
[null,29.95,null,null,null,"Alt, “Position of Item in QAT” = Invoke button from QAT based on position of button in QAT."]
[null,45.9]
[null,160.65]
[null,160.65]
[null,119.69999999999999]
[null,43.9]
[null,119.69999999999999]
[null,65.849999999999994]
[null,22.95]
[null,65.849999999999994]
[null,109.75]
[null,114.75]
[null,249.5]
[null,109.75]
[null,114.75]
[null,114.75]
[null,119.8]
[null,29.95]
[null,114.75]
[null,209.65]
[null,114.75]
[null,59.849999999999994]
[null,124.75]
[null,39.9]
[null,124.75]
[null,24.95]
[null,22.95]
[null,249.5]
[null,59.849999999999994]
[null,43.9]
[null,19.95]
[null,29.95]
[null,19.95]
[null,65.849999999999994]
[null,22.95]
[null,79.8]
[null,79.8]
[null,114.75]
[null,22.95]
[null,19.95]
[null,109.75]
[null,59.9]
[null,43.9]
[null,39.9]
[null,209.65]
[null,19.95]
[null,79.8]
[null,124.75]
[null,24.95]
[null,160.65]
[null,65.849999999999994]
[null,137.69999999999999]
[null,29.95]
[null,119.69999999999999]
[null,19.95]
[null,39.9]
[null,114.75]
[null,21.95]
[null,179.7]
[null,39.9]
[null,24.95]
[null,99.8]
[null,87.8]
[null,39.9]
[null,65.849999999999994]
[null,199.5]
[null,21.95]
[null,124.75]
[null,29.95]
[null,21.95]
[null,119.8]
[null,89.85]
[null,65.849999999999994]
[null,91.8]
[null,149.69999999999999]
[null,59.849999999999994]
[null,131.69999999999999]
[null,49.9]
[null,43.9]
[null,19.95]
[null,21.95]
[null,24.95]
[null,39.9]
[null,24.95]
[null,114.75]
[null,119.69999999999999]
[null,43.9]
[null,24.95]
[null,174.65]
[null,24.95]
[null,49.9]
[null,19.95]
[null,39.9]
[null,45.9]
[null,179.7]
[null,160.65]
[null,21.95]
[null,124.75]
[null,89.85]
[null,49.9]
[null,22.95]
[null,19.95]
[null,99.75]
[null,91.8]
[null,49.9]
[null,21.95]
[null,45.9]
[null,22.95]
[null,45.9]
[null,24.95]
[null,39.9]
[null,179.7]
[null,21.95]
[null,24.95]
[null,74.849999999999994]
[null,79.8]
[null,19.95]
[null,22.95]
[null,45.9]
[null,65.849999999999994]
[null,139.65]
[null,22.95]
[null,39.9]
[null,109.75]
[null,160.65]
[null,49.9]
[null,22.95]
[null,45.9]
[null,68.849999999999994]
[null,229.5]
[null,29.95]
[null,39.9]
[null,43.9]
[null,19.95]
[null,59.9]
[null,99.75]
[null,174.65]
[null,65.849999999999994]
[null,124.75]
[null,87.8]
[null,229.5]
[null,99.75]
[null,19.95]
[null,19.95]
[null,99.8]
[null,24.95]
[null,114.75]
[null,59.849999999999994]
[null,43.9]
[null,74.849999999999994]
[null,19.95]
[null,22.95]
[null,153.65]
[null,39.9]
[null,131.69999999999999]

{"sheet":"Cursors","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Formula Elements","index":20,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Formulas elements (things that can go into formulas):",null,null,"Full list of worksheet formula elements => Next Sheet"]
[null,"Equal sign as first character in cell to tell Excel you are making a formula"]
[null,"Cell references and table references"]
[null,"Math operators"]
[null,"Numbers (if the number won't change like 12 for months in a year)"]
[null,"Built-in functions (like SUM, COUNTIFS, SUMIFS, AVERAGE, NORM.DIST, RSQ)"]
[null,"Comparative operators (like > and <)"]
[null,"Join Symbol: & (Ampersand)"]
[null,"Text in double quotes (like \"Revenue\" or \", \")"]
[]
[null,"Math Operators (Shown in Math Order of Operations)"]
[null," ( ) represents Parentheses"," Shift + 9 and Shift + 0"]
[null," ^ represents Exponents (powers and roots)"," Shift + 6 = ^ = caret"]
[null," * represents Multiplication"," * on Number pad"]
[null," /  represents Division"," / on Number pad"]
[null," + represents Addition"," + on Number pad"]
[null," – represents Subtraction"," - on Number pad"]
[]
[null,"Comparative Operators"]
[null," > Greater Than"]
[null," >= Greater Than Or Equal To"]
[null," < Less Than"]
[null," <= Less Than Or Equal To"]
[null," = Equal To"]
[null," <> Not Equal To"]
[]
[null,"Join Symbol (Ampersand)"]
[null,"&"]
[]
[null,"Excel Formula Order of Operations:"]
[null,"1) Parenthesis ( )"]
[null,"2) Reference Operators: colon, space, comma"]
[null,"Example of colon in range of cells: =SUM(A1:A4)"]
[null,"Example of intersection operator: =E12:G12 F10:F15 (retrieve what is in F12)"]
[null,"Example of comma (union): =SUM(E10:G10,E14:G14)"]
[null,"3) Negation (-)        (give me opposite)"]
[null,"Example: = -2^4 = 16"]
[null,"Example: = -(2^4) = -16"]
[null,"Example: --2+1 = 3"]
[null,"4) Converts % (1% to .01)"]
[null,"5) Exponents (^)"]
[null,"Example: 3^2 = 9"]
[null,"Example: 2^3 = 2*2*2 = 8"]
[null,"Example: 4^(1/2) = 2"]
[null,"6) Multiplication (*) and Division (/), left to right"]
[null,"7) Adding (+) and Subtracting (-), left to right"]
[null,"8) Ampersand (&)    (Join operator)"]
[null,"9) Comparative operators: =, <>, >=, <=, <, >"]

{"sheet":"Full List Worksheet Formula El ","index":21,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[16,1,22,1]]}
[]
[null,"Element","Description","Example"]
[null,"Equal Sign","As first character in cell, it tells Excel you are making a formula","=SUM(I2:I6)"]
[null,"Cell References","Four types of cell references: Relative, Absolute, Mixed with Row Locked, Mixed with Column Locked","G2, $G$2, G$2, $G2"]
[null,"Range of Cells","Four types of ranges: Relative, Absolute, Mixed with Row Locked, Mixed with Column Locked","G2:G5, $G$2:$G$5, G$2:G$5, $G2:$G5"]
[null,"Reference Operator: colon","Used in between two cell reference, two sheet names or two lookup functions to create a range of cells","G2:G5,   Jan:Apr!C3\nXLOOKUP(V2,V3:Z3,V4:Z4):XLOOKUP(W2,V3:Z3,V4:Z4)"]
[null,"Reference Operator: comma","Used to combine ranges. Works in FREQUNCY, IRR, INDEX, AREAS, LET and aggregate functions like SUM and LARGE. Works in Defined Names.","ARGE((V5:Z5,Sales),3)"]
[null,"Reference Operator: space","Used as an intersection operator to get the value at the intersection of two ranges","G2:G6 F4:H4 yields \"Quad\""]
[null,"Spilled Range Operator (#)","Spilled Range Operator (#) that allows you to refer to all items that are spilled from a cell with a spilled array formula","C3#"]
[null,"Implicit Intersection Operator (@)","Implicit Intersection Operator (@) allows you to get a corresponding item in the current row of a column or a parallel column. Most commonly seen in relative cell reference in Excel Table columns.","fSales[@Product], @Product, @G2:G6"]
[null,"Data Type Operator\n(Dot Operator)","For cells that contains a record, the dot allows you to specify what field you want to extra from the cell","[@Stock].Price  . B12.Price"]
[null,"Worksheet Reference","Name of worksheet (in single quotes if a space in name) with exclamation point before cell reference. Any one of four cell references allowed.","LookupTable!B3:B6 , 'Lookup Table'!B3:B6"]
[null,"Workbook\nReference","Same as Worksheet Reference with name of workbook in square brackets and full file path. Any one of four cell references allowed.","If referenced workbook opened:\n'[Ch12-Excel365-WorksheetFormulas.xlsx]Elements'!$G$5,\nIf referenced workbook NOT opened: \n'F:\\[Ch12-Excel365-WorksheetFormulas.xlsx]Elements'!G5"]
[null,"Defined Names","Defined Names are names that can represent a cell, ranges of cells, or formulas. The Defined Names can be used in other formulas and features, including in Power Query and the Power Pivot Data Model.","Example 16 in chapter 12: Defined Name to define a cell:\nCallRepConditionAnswer ='Ch12(31-34an)'!$G$9\n\nExample 16 in  chapter 14: Defined Name to define formula:\nLookupPicture =XLOOKUP('Ch14(38-40)'!$B$6,'Ch14(38-40)'!$B$9:$B$12,'Ch14(38-40)'!$D$9:$D$12)"]
[]
[null,"Element","Description","Example"]
[null,"Table Formula Nomenclature\nin an Excel Table that has name fSales, and columns: Date, Product and Sales","Full Table","CallTable[#All]"]
[null,null,"Records in Table","CallTable"]
[null,null,"Field Names","CallTable[#Headers]"]
[null,null,"Mixed with Row Locked Column Reference","CallTable[Rep]"]
[null,null,"Locked Column Reference","CallTable[[Rep]:[Rep]]"]
[null,null,"Selected Columns","CallTable[[Rep]:[Calls]]"]
[null,null,"Relative Cell Reference (Implicit Intersection Operator)","CallTable[@Rep]"]
[null,"Worksheet Functions","Built-in function like SUM and ROUND that are programmed to make a defined calculation based on the formula inputs entered into the function’s arguments","SUM, COUNTIFS, SUMIFS, FORMULATEXT, ROUND, MROUND, UNIQUE, SORT, EDATE, EOMONTH, NETWORKDAYS.INTL, WORKDAY.INTL, AVERAGE, SEQUENCE, LARGE, RANK.EQ,  XLOOKUP, FILTER and many more. About 450 in total."]
[null,"Function argument elements","Some functions require that you select an item from a dropdown list in order to instruct the function which type of calculation to make, like with NETWORKDAYS.INTL that needs a 7 to instruct it to ignore Fridays and Saturdays","NETWORKDAYS.INTL(F2,F2,7)"]
[null,"Math Operators","Used to create math calculations","+  Adding\n- Subtracting or Negation\n* Multiplying\n/  Dividing\n^  Raising to an exponent\n( )  Parentheses"]
[null,"Comparative Operator","Used to create comparative calculations","=    Equal: are two things equal?\n<> Not: are two things Not equal? (less & greater than symbol)\n> Greater than: left side greater than right side?\n>=    Greater than or Equal to: left side >=  than right side?\n<    Less than: left side less than right side?\n<=    Less than or Equal to: left side <=  than right side?"]
[null,"Join Operator (&)","Ampersand symbol (&) to join two items into one items","C8&\", \"&B8  ,  \"Item # \"&C8:C12"]
[null,"Text within quotation marks","Text in Formulas must be in quotes","C8&\", \"&B8  ,  \"Item # \"&C8:C12"]
[null,"Hard Coded\nNumbers","When a number will not change, like 12 months in a year or 24 hours in a day, you can hard code it into formula.","C10/12, (EndTime-StartTime)*24"]
[null,"Array constants\n(hard coded arrays)","Hard coded tables, columns or rows.\nCurly Brackets house the array:  {   }\nComma means column   ,\nSemi-colon means row    ;","{\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\";1,2,3,4,5}"]

{"sheet":"Worksheet Formula Models","index":22,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Worksheet Formula Models"]
[null,"1) ","Worksheet formulas = tool to make calculations and perform data analysis"]
[null,null,"Can contain built-in functions (like SUM), math operators, cell references and other formula elements"]
[null,"2) ","Number Formatting as Façade:"]
[null,null,"Number formatting displays numbers in a certain way without changing the underlying number"]
[null,null,"Formulas do not act on Number Formatting, they act on underlying value"]
[null,null,"The General Number format is like an eraser that wipe away all number formatting to see the actual numbers in the cell"]
[null,"3) ","Excel's Golden Rule: "]
[null,null,"If a formula input can change, put in in a cell, label it and refer to it in formula with reference."]
[null,null,"If a formula input will not change, you can type it into formula, like 12 months in a year, 24 hours in a day or 1 to represent a base amount in percentage formulas."]
[null,"4) ","Document formulas with =IFNA(FORMULATEXT(Cell),\"\")"]
[null,"5)","To round a number use the ROUND function. In the second argumnet, 2 rounds to the penny (hundredth), 0 rounds to the dollar (ones position). See picture to right =>"]
[]
[null,"Example 1:",null,"Sales",null,"Sales",null,"Sales",null,"Sales",null,null,null,"Sales"]
[null,"What is going on here",null,4.49,null,4,null,4.49,null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(J16),\"\")","v":""},null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(N16),\"\")","v":""}]
[null,null,null,3.43,null,3,null,3.43]
[null,null,null,4.9800000000000004,null,5,null,4.9800000000000004]
[null,null,null,4.49,null,4,null,4.49]
[null,null,null,3.44,null,3,null,3.44]
[null,null,"SUM:"]
[]
[null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D21),\"\")","v":""},null,"",null,"",null,"",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(N21),\"\")","v":""},null,null,"Spilled Range Operator (#) that allows you to refer to all items that are spilled from a cell with a spilled array formula"]
[]
[]
[]
[]
[null,"Example 2:"]
[null,"In the last statistics class 5 out of 62 earned an A grade. Using this past data, estimate the chance (probability) that a student will get an A in the current class."]
[null,"Build a model that allows you to change formula inputs and which is well documented."]

{"sheet":"Worksheet Formula Models (an)","index":23,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Worksheet Formula Models"]
[null,"1) ","Worksheet formulas = tool to make calculations and perform data analysis"]
[null,null,"Can contain built-in functions (like SUM), math operators, cell references and other formula elements"]
[null,"2) ","Number Formatting as Façade:"]
[null,null,"Number formatting displays numbers in a certain way without changing the underlying number"]
[null,null,"Formulas do not act on Number Formatting, they act on underlying value"]
[null,null,"The General Number format is like an eraser that wipe away all number formatting to see the actual numbers in the cell"]
[null,"3) ","Excel's Golden Rule: "]
[null,null,"If a formula input can change, put in in a cell, label it and refer to it in formula with reference."]
[null,null,"If a formula input will not change, you can type it into formula, like 12 months in a year, 24 hours in a day or 1 to represent a base amount in percentage formulas."]
[null,"4) ","Document formulas with =IFNA(FORMULATEXT(Cell),\"\")"]
[null,"5)","To round a number use the ROUND function. In the second argumnet, 2 rounds to the penny (hundredth), 0 rounds to the dollar (ones position). See picture to right =>"]
[]
[null,"Example 1:",null,"Sales",null,"Sales",null,"Sales",null,"Sales",null,null,null,"Sales"]
[null,"What is going on here",null,4.49,null,4,null,4.49,null,{"$f":"ROUND(H16,0)","v":4},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(J16),\"\")","v":"=ROUND(H16,0)"},null,{"$f":"ROUND(H16:H20,0)","v":4},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(N16),\"\")","v":"=ROUND(H16:H20,0)"}]
[null,null,null,3.43,null,3,null,3.43,null,{"$f":"ROUND(H17,0)","v":3},null,null,null,3]
[null,null,null,4.9800000000000004,null,5,null,4.9800000000000004,null,5,null,null,null,5]
[null,null,null,4.49,null,4,null,4.49,null,4,null,null,null,4]
[null,null,null,3.44,null,3,null,3.44,null,{"$f":"ROUND(H20,0)","v":3},null,null,null,3]
[null,null,"SUM:",{"$f":"SUM(D16:D20)","v":20.830000000000002},null,{"$f":"SUM(F16:F20)","v":19},null,{"$f":"SUM(H16:H20)","v":20.830000000000002},null,{"$f":"SUM(J16:J20)","v":19},null,null,null,{"$f":"SUM(_xlfn.ANCHORARRAY(N16))","v":19}]
[]
[null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D21),\"\")","v":"=SUM(D16:D20)"},null,"=SUM(F16:F20)",null,"=SUM(H16:H20)",null,"=SUM(J16:J20)",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(N21),\"\")","v":"=SUM(N16#)"}]
[]
[null,null,null,"Spilled Range Operator (#) that allows you to refer to all items that are spilled from a cell with a spilled array formula"]
[]
[]
[null,"Example 2:"]
[null,"In the last statistics class 5 out of 62 earned an A grade. Using this past data, estimate the chance (probability) that a student will get an A in the current class."]
[null,"Build a model that allows you to change formula inputs and which is well documented."]
[]
[null,null,"Past Data:",null,null,"Formula:"]
[null,null,"Number of students who earned an A Grade",5]
[null,null,"Total Students",62]
[null,null,"Probability of getting an A",{"$f":"D33/D34","v":8.0645161290322578E-2},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D35),\"\")","v":"=D33/D34"}]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D36),\"\")","v":""}]
[null,null,"Reference to value in D35",{"$f":"D35","v":8.0645161290322578E-2},null,"=D35"]

{"sheet":"Types of Formulas","index":24,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Formulas by data type:"]
[null,"1) Number Formulas deliver numbers results (numbers, times, dates)."]
[null,"2) Text Formulas deliver text results."]
[null,"3) Logical Formulas deliver logical values, or Boolean values. These formulas deliver either a TRUE or a FALSE."]
[]
[null,"Formulas by calculation type:"]
[null,"1) Aggregate Formulas operate on an array of values and deliver a single answer, like with adding, averaging or running an AND logical test."]
[null,"2) Single Input-Output Formulas are formulas that operate on single inputs and deliver a single answer."]
[null,"This type of formula has single values entered into a function argument, like =FORMULATEXT(B1), or has single values on either side of an operator, like =A1*B1, where the operator is a multiplication operator."]
[null,"These formulas require that you:"]
[null,"1) Consider what type of cell references (relative, absolute, mixed) are required."]
[null,"2) Enter the formula into one cell, and if the formula must be copied, you must manually copy the formula to other cells."]
[null,"3) If you need to edit the formula, you edit the cell and re-copy the formula to other cells if necessary."]
[null,"Array Formulas are formulas that contain one or more array operations that deliver an array of answers rather than a single answer. The array operation can involve multiple values entered into a function argument, like =FORMULATEXT(B1:B4), or there can be multiple values on one or more sides of an operator, like =A1*B1:B5, or A1:A5*B1, or A1:A5*B1:B5. Array formula is the general term used to describe both types of array formulas:"]
[null,"3) Dynamic Spilled Array Formulas are array formulas that deliver a spilled array to the worksheet as the final answer."]
[null,"4) Scalar Array Formulas are array formulas that deliver a single, scalar value as the final answer."]

{"sheet":"Formula Type Examples","index":25,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,"Formulas by data type:"]
[1,"Number Formulas"]
[2,"Text Formulas"]
[3,"Logical Formulas"]
[]
[null,"Formulas by calculation type:"]
[1,"Aggregate Formulas"]
[2,"Single Input-Output Formulas"]
[3,"Dynamic Spilled Array Formulas"]
[4,"Scalar Array Formulas"]
[null,null,null,null,"Formulas by data type","Formulas by calculation type","Formula:","Notes:"]
[null,"Units","Price ($)",null,"Text Formulas","Single Input-Output Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D12),\"\")","v":""}]
[null,5,15.5,null,"Number Formulas","Single Input-Output Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D13),\"\")","v":""}]
[]
[null,"Your GPA","GPA required","Past Hurdle?"]
[null,3.75,3.75,null,"Logical Formulas","Single Input-Output Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D16),\"\")","v":""},"Mode of Cell =>"]
[]
[null,null,"Students","Test Scores"]
[null,null,"Student 1",87.5]
[null,null,"Student 2",79.5]
[null,null,"Student 3",91]
[null,null,"Student 4",68.900000000000006]
[]
[null,"Average (mean) test score",null,null,"Number Formulas","Aggregate Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D24),\"\")","v":""},"AVERAGE function adds up numbers and divides by count."]
[null,"Count numbers",null,null,"Number Formulas","Aggregate Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D25),\"\")","v":""},"COUNT counts numbers in a range"]
[null,"Count not empty",null,null,"Number Formulas","Aggregate Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D26),\"\")","v":""},"COUNTA counts not empty cells in a range"]
[null,"Count Rows",null,null,"Number Formulas","Aggregate Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D27),\"\")","v":""},"ROWS counts number of rows in a range"]
[]
[null,null,"Test Scores (X)","Deviations = X-Mean"]
[null,null,87.5,null,"Number Formulas","Single Input-Output Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D30),\"\")","v":""},"Relative cell reference - absolute cell reference"]
[null,null,79.5,null,null,"<\n<\n<",null,"Relative reference moves throught copy action"]
[null,null,91,null,null,"1) Use relative and absolute references (F4 key)",null,"Absolute reference (locked) does not move throughout copy action. F4 key adds $ signs."]
[null,null,68.900000000000006,null,null,"2) Enter formula in one cell and copy to other cells"]
[null,null,null,null,null,"3) To edit you must edit to cell and re-copy the formula"]
[null,null,"Test Scores (X)","Deviations = X-Mean"]
[null,null,87.5,null,"Number Formulas","Dynamic Spilled Array Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D36),\"\")","v":""}]
[null,null,79.5,null,null,"<\n<\n<"]
[null,null,91,null,null,"Highlight all cells that would be relative"]
[null,null,68.900000000000006,null,null,"Don't have to lock cell reference"]
[null,null,null,null,null,"Don't have to copy formula"]
[null,null,null,null,null,"Formula only lives in top cell (all other ones are greyed out)"]
[null,null,null,null,null,"Editing is done in top cell and edited formula automatically spills down"]
[]
[null,"Number of restaurant banquet rooms = 4"]
[null,"X = Random Discrete Variable = Number of Rooms Used for the Day"]
[]
[null,"X = # Rooms Used","Frequency","Relative Frequency P(X)",null,"X -E(X)","(X - E(X))^2","(X - E(X))^2 * P(X)"]
[null,0,2,0.02,null,{"$f":"B48-$D$56","v":-2.1800000000000002},{"$f":"F48^2","v":4.7524000000000006},{"$f":"G48*D48","v":9.5048000000000021E-2}]
[null,1,21,0.21,null,{"$f":"B49-$D$56","v":-1.1800000000000002},{"$f":"F49^2","v":1.3924000000000003},{"$f":"G49*D49","v":0.29240400000000005}]
[null,2,42,0.42,null,{"$f":"B50-$D$56","v":-0.18000000000000016},3.2400000000000061E-2,1.3608000000000025E-2]
[null,3,27,0.27,null,{"$f":"B51-$D$56","v":0.81999999999999984},0.67239999999999978,0.18154799999999996]
[null,4,8,0.08,null,{"$f":"B52-$D$56","v":1.8199999999999998},3.3123999999999993,0.26499199999999995]
[null,"Total",100,0.99999999999999989,null,{"$f":"SUM(F48:F52)","v":-0.9000000000000008},"s^2",{"$f":"SUM(H48:H52)","v":0.84759999999999991}]
[null,null,null,null,null,null,"s",{"$f":"SQRT(H53)","v":0.92065194291871233}]
[]
[null,"  Mean = Expected Value = E(x) = µ",null,{"$f":"SUM(B48:B52*D48:D52)","v":2.1800000000000002},null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D56:D57),\"\")","v":"=SUM(B48:B52*D48:D52)"}]
[null,"Population SD = σ",null,{"$f":"SQRT(SUM((B48:B52-D56)^2*D48:D52))","v":0.92065194291871233},null,null,"=SQRT(SUM((B48:B52-D56)^2*D48:D52))"]

{"sheet":"Formula Type Examples (an)","index":26,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,"Formulas by data type:"]
[1,"Number Formulas"]
[2,"Text Formulas"]
[3,"Logical Formulas"]
[]
[null,"Formulas by calculation type:"]
[1,"Aggregate Formulas"]
[2,"Single Input-Output Formulas"]
[3,"Dynamic Spilled Array Formulas"]
[4,"Scalar Array Formulas"]
[null,null,null,null,"Formulas by data type","Formulas by calculation type","Formula:","Notes:"]
[null,"Units","Price ($)",{"$f":"\"Sales ($) = \"&B13&\" * \"&C13","v":"Sales ($) = 5 * 15.5"},"Text Formulas","Single Input-Output Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D12),\"\")","v":"=\"Sales ($) = \"&B13&\" * \"&C13"}]
[null,5,15.5,{"$f":"B13*C13","v":77.5},"Number Formulas","Single Input-Output Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D13),\"\")","v":"=B13*C13"}]
[]
[null,"Your GPA","GPA required","Past Hurdle?"]
[null,3.75,3.75,{"$f":"B16>=C16","v":true},"Logical Formulas","Single Input-Output Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D16),\"\")","v":"=B16>=C16"},"Mode of Cell =>"]
[]
[null,null,"Students","Test Scores"]
[null,null,"Student 1",87.5]
[null,null,"Student 2",79.5]
[null,null,"Student 3",91]
[null,null,"Student 4",68.900000000000006]
[]
[null,"Average (mean) test score",null,{"$f":"AVERAGE(D19:D22)","v":81.724999999999994},"Number Formulas","Aggregate Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D24),\"\")","v":"=AVERAGE(D19:D22)"},"AVERAGE function adds up numbers and divides by count."]
[null,"Count numbers",null,{"$f":"COUNT(D19:D22)","v":4},"Number Formulas","Aggregate Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D25),\"\")","v":"=COUNT(D19:D22)"},"COUNT counts numbers in a range"]
[null,"Count not empty",null,{"$f":"COUNTA(C19:C22)","v":4},"Number Formulas","Aggregate Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D26),\"\")","v":"=COUNTA(C19:C22)"},"COUNTA counts not empty cells in a range"]
[null,"Count Rows",null,{"$f":"ROWS(C19:C22)","v":4},"Number Formulas","Aggregate Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D27),\"\")","v":"=ROWS(C19:C22)"},"ROWS counts number of rows in a range"]
[]
[null,null,"Test Scores (X)","Deviations = X-Mean"]
[null,null,87.5,{"$f":"(C30-$D$24)^2","v":33.350625000000065},"Number Formulas","Single Input-Output Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D30),\"\")","v":"=(C30-$D$24)^2"},"Relative cell reference - absolute cell reference"]
[null,null,79.5,{"$f":"(C31-$D$24)^2","v":4.9506249999999747},null,"<\n<\n<",null,"Relative reference moves throught copy action"]
[null,null,91,86.025625000000105,null,"1) Use relative and absolute references (F4 key)",null,"Absolute reference (locked) does not move throughout copy action. F4 key adds $ signs."]
[null,null,68.900000000000006,164.48062499999972,null,"2) Enter formula in one cell and copy to other cells"]
[null,null,null,null,null,"3) To edit you must edit to cell and re-copy the formula"]
[null,null,"Test Scores (X)","Deviations = X-Mean"]
[null,null,87.5,{"$f":"(C36:C39-D24)^2","v":33.350625000000065},"Number Formulas","Dynamic Spilled Array Formulas",{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D36),\"\")","v":"=(C36:C39-D24)^2"}]
[null,null,79.5,4.9506249999999747,null,"<\n<\n<"]
[null,null,91,86.025625000000105,null,"Highlight all cells that would be relative"]
[null,null,68.900000000000006,164.48062499999972,null,"Don't have to lock cell reference"]
[null,null,null,null,null,"Don't have to copy formula"]
[null,null,null,null,null,"Formula only lives in top cell (all other ones are greyed out)"]
[null,null,null,null,null,"Editing is done in top cell and edited formula automatically spills down"]
[]
[null,"Number of restaurant banquet rooms = 4"]
[null,"X = Random Discrete Variable = Number of Rooms Used for the Day"]
[]
[null,"X = # Rooms Used","Frequency","Relative Frequency P(X)",null,"X -E(X)","(X - E(X))^2","(X - E(X))^2 * P(X)"]
[null,0,2,0.02,null,{"$f":"B48-$D$56","v":-2.1800000000000002},{"$f":"F48^2","v":4.7524000000000006},{"$f":"G48*D48","v":9.5048000000000021E-2}]
[null,1,21,0.21,null,{"$f":"B49-$D$56","v":-1.1800000000000002},{"$f":"F49^2","v":1.3924000000000003},{"$f":"G49*D49","v":0.29240400000000005}]
[null,2,42,0.42,null,{"$f":"B50-$D$56","v":-0.18000000000000016},3.2400000000000061E-2,1.3608000000000025E-2]
[null,3,27,0.27,null,{"$f":"B51-$D$56","v":0.81999999999999984},0.67239999999999978,0.18154799999999996]
[null,4,8,0.08,null,{"$f":"B52-$D$56","v":1.8199999999999998},3.3123999999999993,0.26499199999999995]
[null,"Total",100,0.99999999999999989,null,{"$f":"SUM(F48:F52)","v":-0.9000000000000008},"s^2",{"$f":"SUM(H48:H52)","v":0.84759999999999991}]
[null,null,null,null,null,null,"s",{"$f":"SQRT(H53)","v":0.92065194291871233}]
[]
[null,"  Mean = Expected Value = E(x) = µ",null,{"$f":"SUM(B48:B52*D48:D52)","v":2.1800000000000002},null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D56:D57),\"\")","v":"=SUM(B48:B52*D48:D52)"}]
[null,"Population SD = σ",null,{"$f":"SQRT(SUM((B48:B52-D56)^2*D48:D52))","v":0.92065194291871233},null,null,"=SQRT(SUM((B48:B52-D56)^2*D48:D52))"]

{"sheet":"ExcelTables","index":27,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Single Input-Output Formulas",null,null,"Dynamic Spilled Array Formulas",null,null,"Excel Table Formulas"]
[]
[null,"Tax Rate",9.7500000000000003E-2,null,"Tax Rate",9.7500000000000003E-2,null,"Tax Rate",9.7500000000000003E-2]
[]
[null,"Sales","Tax Amount",null,"Sales","Tax Amount",null,"Sales","Tax Amount",null,null,"Total Sales From Excel Table"]
[null,4.49,null,null,4.49,null,null,4.49]
[null,3.43,null,null,3.43,null,null,3.43]
[null,4.9800000000000004,null,null,4.9800000000000004,null,null,4.9800000000000004]
[null,4.49,null,null,4.49,null,null,4.49]
[null,3.44,null,null,3.44,null,null,3.44]
[]
[]
[null,"Excel Tables are dynamic because if you add rows or columns, anything pointing to table will update with new data"]
[null,"Things like: formulas, PivotTable, Power Query, Charts and more)"]
[null,"fSales = Excel Table Name"]
[null,"[Sales] = Field Name in an Excel Table"]
[null,"[@Sales] = Relative Cell Reference"]
[null,"Implicit Intersection Operator (@)"]
[null,"Implicit Intersection Operator (@) allows you to get a corresponding item in the current row of a column or a parallel column."]

{"sheet":"ExcelTables(an)","index":28,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Single Input-Output Formulas",null,null,"Dynamic Spilled Array Formulas",null,null,"Excel Table Formulas"]
[]
[null,"Tax Rate",9.7500000000000003E-2,null,"Tax Rate",9.7500000000000003E-2,null,"Tax Rate",9.7500000000000003E-2]
[]
[null,"Sales","Tax Amount",null,"Sales","Tax Amount",null,"Sales","Tax Amount",null,null,"Total Sales From Excel Table"]
[null,4.49,{"$f":"ROUND(B7*$C$4,2)","v":0.44},null,4.49,{"$f":"ROUND(E7:E11*F4,2)","v":0.44},null,4.49,{"$f":"ROUND(fSales7[[#This Row],[Sales]]*$I$4,2)","v":0.44},null,null,{"$f":"SUM(fSales7[Sales])","v":20.830000000000002}]
[null,3.43,{"$f":"ROUND(B8*$C$4,2)","v":0.33},null,3.43,0.33,null,3.43,{"$f":"ROUND(fSales7[[#This Row],[Sales]]*$I$4,2)","v":0.33}]
[null,4.9800000000000004,0.49,null,4.9800000000000004,0.49,null,4.9800000000000004,{"$f":"ROUND(fSales7[[#This Row],[Sales]]*$I$4,2)","v":0.49}]
[null,4.49,0.44,null,4.49,0.44,null,4.49,{"$f":"ROUND(fSales7[[#This Row],[Sales]]*$I$4,2)","v":0.44}]
[null,3.44,0.34,null,3.44,0.34,null,3.44,{"$f":"ROUND(fSales7[[#This Row],[Sales]]*$I$4,2)","v":0.34}]
[]
[]
[null,"Excel Tables are dynamic because if you add rows or columns, anything pointing to table will update with new data"]
[null,"Things like: formulas, PivotTable, Power Query, Charts and more)"]
[null,"fSales = Excel Table Name"]
[null,"[Sales] = Field Name in an Excel Table"]
[null,"[@Sales] = Relative Cell Reference"]
[null,"Implicit Intersection Operator (@)"]
[null,"Implicit Intersection Operator (@) allows you to get a corresponding item in the current row of a column or a parallel column."]

{"sheet":"% Formulas","index":29,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number of restaurant banquet rooms = 4"]
[null,"X = Random Discrete Variable = Number of Rooms Used for the Day"]
[]
[null,"X = # Rooms Used","Frequency","Relative Frequency P(X)","Relative Frequency P(X)"]
[null,0,2]
[null,1,21]
[null,2,42]
[null,3,27]
[null,4,8]
[null,"Total",{"$f":"SUM(C6:C10)","v":100}]
[]
[null,"Formula data type:",null,"Number Formulas","Number Formulas"]
[null,"Formula calculation type:",null,"Single Input-Output Formulas","Dynamic Spilled Array Formulas"]
[null,"Formula:",null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D6:E6),\"\")","v":""},""]
[null,"Notes:",null,"% of Total Formula","% of Total Formula"]
[]
[null,"Start Invenment","End Investment","% Change = (End-Begin)/Begin","% Change = End/Begin-1"]
[null,75000,87500]
[]
[null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D19:E19),\"\")","v":""},""]
[]
[null,null,null,"Change = End - Begin"]
[null,null,null,"% Change = (End - Begin)/Begin"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"% Change - End/Begin-1"]

{"sheet":"% Formulas (an)","index":30,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number of restaurant banquet rooms = 4"]
[null,"X = Random Discrete Variable = Number of Rooms Used for the Day"]
[]
[null,"X = # Rooms Used","Frequency","Relative Frequency P(X)","Relative Frequency P(X)"]
[null,0,2,{"$f":"C6/$C$11","v":0.02},{"$f":"C6:C11/C11","v":0.02}]
[null,1,21,{"$f":"C7/$C$11","v":0.21},0.21]
[null,2,42,0.42,0.42]
[null,3,27,0.27,0.27]
[null,4,8,0.08,0.08]
[null,"Total",100,{"$f":"SUM(D6:D10)","v":0.99999999999999989},1]
[]
[null,"Formula data type:",null,"Number Formulas","Number Formulas"]
[null,"Formula calculation type:",null,"Single Input-Output Formulas","Dynamic Spilled Array Formulas"]
[null,"Formula:",null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D6:E6),\"\")","v":"=C6/$C$11"},"=C6:C11/C11"]
[null,"Notes:",null,"% of Total Formula","% of Total Formula"]
[]
[null,"Start Invenment","End Investment","% Change = (End-Begin)/Begin","% Change = End/Begin-1"]
[null,75000,87500,{"$f":"(C19-B19)/B19","v":0.16666666666666666},{"$f":"C19/B19-1","v":0.16666666666666674}]
[]
[null,null,null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(D19:E19),\"\")","v":"=(C19-B19)/B19"},"=C19/B19-1"]
[]
[null,null,null,"Change = End - Begin"]
[null,null,null,"% Change = (End - Begin)/Begin"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"% Change - End/Begin-1"]

{"sheet":"PowerQueryPivotTableChartNotes","index":31,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,8],[27,1,27,8],[11,1,11,8],[13,1,13,8],[14,1,14,8],[19,1,19,8],[25,1,25,8],[22,1,22,8],[31,1,31,8]]}
[]
[null,"Frequency Distribution = Tabular summary that shows a unique list of nonoverlapping categories with the counts (frequency) for each category"]
[null,"Text files = type of file that is used to get a proper data set from a database to an analytic tool like Excel. \"csv\" and \".txt\" are typical test files. Text files use delimiters."]
[null,"Delimiter = character that is used to separate bits of data, such as a comma or tab character"]
[null,"Power Query tool is used to import, clean and transform data"]
[null,"Power Query consists of all commands in the Get & Transform Data group and Queries & Connections group in the Data tab in the Excel Ribbon"]
[null,"In this class we will use the Get Data dropdown arrow, From File option to get either: From Text/CSV (\".csv\" file) or From Workbook (Excel file)."]
[null,"From Text/CSV (\".csv\" file) Notes:"]
[null,"In the first dialog box be sure that the delimiter is \"Comma\" when you import a :csv\" Text File"]
[null,"In the second dialog box be sure to click the Transform Data button to bring data into the Power Query Editor window"]
[null,"In the Power Query Editor window use can use the user interface to clean and transform the data if necessary"]
[null,"To load the data from the Power Query Editor window to a location, in the Power Query ribbon tab, in the Home tab, in the Close group, click the Close & Load dropdown arrow, then click \"Close & Load To\" to open the Import Data dialog box"]
[null,"In the Import Data dialog box we will use one of two options:"]
[null,"1) Click Table dialog button and select new worksheet or existing location (this loads table of data to worksheet). If you make a PivotTable from this table and source data changes, to refresh you must refresh both the query table and the PivotTable (right-click Refresh each one separately).."]
[null,"2) Click PivotTable Report dialog button (loads data to the behind the scenes PivotTable cache and allows you to create a PivotTable). If source data changes, you refresh only the PivotTable (right-click refresh)."]
[null,"Setting Data Types in Power Query helps to assure that the calculations made in the worksheet will work correctly."]
[null,"PivotTable tool is used to create summary reports based on conditional calculations"]
[null,"#1 tool in the world to take proper data sets (table) and convert then into summary reports with conditional calculations."]
[null,"Conditional calculation means that you make a calculation like counting or summing, not on all the values in the column, but on variable data from a unique list."]
[null,"To create a PivotTable report from a table, click in one cell in the table, click Insert tab in the Excel Ribbon, in the Table group click the PivotTable dropdown arrow and then select: From Table/Range (if table is in worksheet)"]
[null,"When you build a PivotTable report, the source table of data is added to the PivotTable Cache, which is a behind the scenes location to store a second occurrence of table."]
[null,"If data in the source table of data changes, you must refresh PivotTable Cache. You can refresh by right-clicking the PivotTable and clicking on \"Refresh\"."]
[null,"Dragging a fields from the PivotTable Fields task pane field list to the Row or Column area creates a unique list of items from the column. These items are the conditions for the calculations in the Values area."]
[null,"Dragging a fields from the PivotTable Fields task pane field list to the Values area allows you to make a calculation on that field."]
[null,"Right-click Values area, point to Summarize Values By, then in sub menu click to change the aggregate calculation (aggregate function)"]
[null,"Right-click Values area, click on Show Values As, then in sub menu click to change the calculation to calculation such as \"% of Column Total\", \"Running Total In\", \"% of Grand Total\" and more"]
[null,"To add Number Formatting to Values area field, right-click Values area, click on Number Formatting"]
[null,"To group numbers in a PivotTable, drag number field to Row area, right-click Row area, click Group. In the Group dialog box, the lower limit for the first group is set in the Staring at text box,  the upper limit for the last group is set in the Ending at text box, and the width for each group is set in the By textbox."]
[null,"If you are grouping whole numbers, such as 1, 2, 3, 4, 5, 6…, if you use Starting at = 1, Ending At = 6, and By = 3, the categories will be: 1-3, 4-6…"]
[null,"If you are grouping decimal numbers, such as 9.1, 10.2, 22.7, 27.2, 31.2, 34.6…, if you use Starting at = 0, Ending At = 40, and By = 10, the categories will be:  0-10, 10-20…"]
[null,"If you group numbers, dates or times, the grouping is saved in the PivotTable Cache."]
[null,"To show grouping categories that do not have data, right-click the Rows area in the PivotTable report, click Field Settings, then in the Field Settings dialog box, click the Layout & Print tab, check the checkbox for \"Show items with no data\"."]
[null,"Prevent PivotTable from Auto fitting column width: right-click PivotTable, click PivotTable options, on the Display & Format tab, uncheck the check box for \"Autofit Column widths on update\""]

{"sheet":"Second Frequency Distribution","index":32,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Phones","Frequency","% Frequency"]
["Apple iPhone 6",41,0.20499999999999999]
["Apple iPhone 6 Plus",36,0.18]
["LG G3",13,6.5000000000000002E-2]
["Motorola Moto G",6,0.03]
["Samsung Galaxy Note 4 ",56,0.28000000000000003]
["Samsung Galaxy S5",25,0.125]
["Sony Xperia Z3",23,0.115]
["Grand Total",200,1]

{"sheet":"PivotTables","index":33,"n_rows":202,"n_cols":2,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sample of Phone Purchases"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Motorola Moto G"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6"]
[null,"Motorola Moto G"]
[null,"Motorola Moto G"]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"LG G3"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy S5"]
[null,"Motorola Moto G"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Sony Xperia Z3"]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"LG G3"]
[null,"Samsung Galaxy S5"]
[null,"LG G3"]
[null,"LG G3"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Motorola Moto G"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"LG G3"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Sony Xperia Z3"]
[null,"LG G3"]
[null,"LG G3"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"LG G3"]
[null,"Apple iPhone 6"]
[null,"Motorola Moto G"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]

{"sheet":"PivotTables (an)","index":34,"n_rows":227,"n_cols":14,"rows_kept":227,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Exceλambda Spilled Formula:"]
[null,"Sample of Phone Purchases",null,"Phones","Frequency","% Frequency",null,null,null,null,null,{"$f":"_xlfn.LAMBDA(_xlpm.a,_xlop.p,_xlfn.LET(_xlpm.u,_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlpm.a)),_xlpm.r,_xlfn.BYROW(_xlpm.u,_xlfn.LAMBDA(_xlpm.u,SUM(--(_xlpm.a=_xlpm.u)))),_xlpm.f,CHOOSE({1,2,3},_xlpm.u,_xlpm.r,_xlpm.r/COUNTA(_xlpm.a)),IF(_xlpm.p,_xlpm.f,CHOOSE({1,2},_xlpm.u,_xlpm.r))))(B3:B202,1)","v":"Apple iPhone 6"},41,0.20499999999999999]
[null,"Apple iPhone 6",null,"Apple iPhone 6",41,0.20499999999999999,null,null,null,null,null,"Apple iPhone 6 Plus",36,0.18]
[null,"Apple iPhone 6",null,"Apple iPhone 6 Plus",36,0.18,null,null,null,null,null,"LG G3",13,6.5000000000000002E-2]
[null,"Apple iPhone 6",null,"LG G3",13,6.5000000000000002E-2,null,null,null,null,null,"Motorola Moto G",6,0.03]
[null,"Samsung Galaxy Note 4 ",null,"Motorola Moto G",6,0.03,null,null,null,null,null,"Samsung Galaxy Note 4 ",56,0.28000000000000003]
[null,"Apple iPhone 6 Plus",null,"Samsung Galaxy Note 4 ",56,0.28000000000000003,null,null,null,null,null,"Samsung Galaxy S5",25,0.125]
[null,"Samsung Galaxy S5",null,"Samsung Galaxy S5",25,0.125,null,null,null,null,null,"Sony Xperia Z3",23,0.115]
[null,"Samsung Galaxy S5",null,"Sony Xperia Z3",23,0.115]
[null,"Apple iPhone 6 Plus",null,"Grand Total",200,1,null,null,null,null,null,"a: array, list, range, table column"]
[null,"Apple iPhone 6",null,null,null,null,null,null,null,null,null,"[p]: percentage argument, 0 or omitted only 2 clms report array, prod and frequency ; 1 (or <>0) 3 clms report including percentage"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5",null,null,null,null,null,null,null,null,null,"Exceλambda Spilled Formula:"]
[null,"Apple iPhone 6 Plus",null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.LAMBDA(_xlpm.a,_xlop.by,_xlop.s,_xlop.e,_xlfn.LET(_xlpm.m,IF(_xlpm.s,_xlpm.s,MIN(_xlpm.a)),_xlpm.x,IF(_xlpm.e,_xlpm.e,MAX(_xlpm.a)),IF(_xlpm.by=0,CHOOSE({1;2},_xlpm.m,_xlpm.x),\n_xlfn.LET(_xlpm.n,ROUNDUP((_xlpm.x-_xlpm.m+1)/_xlpm.by,0),_xlpm.k,_xlfn.SEQUENCE(_xlpm.n,,_xlpm.m,_xlpm.by),_xlpm.l,_xlpm.k+_xlpm.by,\n_xlpm.p,_xlfn.MAP(_xlpm.k,_xlpm.l,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,SUM((_xlpm.a>=_xlpm.x)*(_xlpm.a<_xlpm.y)))),_xlfn._xlws.FILTER(CHOOSE({1,2},_xlpm.k&\" <=\"&\" val \"&\"< \"&_xlpm.l,_xlpm.p),_xlpm.p<>0)))))(B3:B202)","v":0}]
[null,"Apple iPhone 6",null,null,null,null,null,null,null,null,null,0]
[null,"Motorola Moto G"]
[null,"Apple iPhone 6",null,null,null,null,null,null,null,null,null,"a: array, range, table column"]
[null,"Samsung Galaxy Note 4 ",null,null,null,null,null,null,null,null,null,"[by]: by argument, when omitted returns min and max values"]
[null,"LG G3",null,null,null,null,null,null,null,null,null,"[s]: start, if omitted will take value min(a)"]
[null,"Samsung Galaxy Note 4 ",null,null,null,null,null,null,null,null,null,"[e]: end, if omitted will take value max(a)"]
[null,"Samsung Galaxy Note 4 ",null,null,null,null,null,null,null,null,null,"(same parameters like in PT grouping)"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6"]
[null,"Motorola Moto G"]
[null,"Motorola Moto G"]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"LG G3"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy S5"]
[null,"Motorola Moto G"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Sony Xperia Z3"]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy S5"]
[null,"Samsung Galaxy Note 4 "]
[null,"LG G3"]
[null,"Samsung Galaxy S5"]
[null,"LG G3"]
[null,"LG G3"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Motorola Moto G"]
[null,"Samsung Galaxy Note 4 "]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"LG G3"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Sony Xperia Z3"]
[null,"LG G3"]
[null,"LG G3"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Sony Xperia Z3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Apple iPhone 6"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy Note 4 "]
[null,"Apple iPhone 6"]
[null,"Samsung Galaxy Note 4 "]
[null,"LG G3"]
[null,"Apple iPhone 6"]
[null,"Motorola Moto G"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"Apple iPhone 6 Plus"]
[null,"Apple iPhone 6 Plus"]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy S5"]
[null,"Sony Xperia Z3"]
[null,"LG G3"]
[null,"Samsung Galaxy Note 4 "]
[null,"Samsung Galaxy Note 4 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"a: array, range, table column"]
[null,null,null,null,null,null,"[by]: by argument, when omitted returns min and max values"]
[null,null,null,null,null,null,"[s]: start, if omitted will take value min(a)"]
[null,null,null,null,null,null,"[e]: end, if omitted will take value max(a) (same parameters like in PT grouping)"]

{"sheet":"Power Query & PivotTables","index":35,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Power Query & PivotTables (an)","index":36,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Truck Element","Overall Score","Recommended","Owner Satisfaction","Overall Miles Per Gallon","Acceleration (0-60) Sec",null,"Recommended","Frequency"]
[null,"Flair - D-150",87,"Yes","**",24,9.5,null,"No",9]
[null,"Tyro - Thunder",86,"No","***",23,10.3,null,"Yes",12]
[null,"Caliber - Silver 1500 Hybrid",84,"Yes","***",26,8.6999999999999993,null,"Grand Total",21]
[null,"ABC - Nevada 1500",84,"Yes","***",25,10.3]
[null,"Nights - NP200",84,"No","****",23,9.8000000000000007]
[null,"Tyro - Seattle",83,"Yes","*****",25,9,null,"Overall Score","Frequency"]
[null,"Caliber - Silver 2500 HD",83,"Yes","***",27,8.6,null,"64-67",3]
[null,"Impetus - F-Max",83,"No","**",22,7.2,null,"68-71",1]
[null,"Flair - F-150 Eagle",82,"Yes","****",24,8.6,null,"76-79",5]
[null,"Caliber - Silver 3500 HD",81,"Yes","***",24,9.3000000000000007,null,"80-83",7]
[null,"Victory - Treck",81,"Yes","*****",22,10.199999999999999,null,"84-87",5]
[null,"Nights - 1000",80,"Yes","****",25,10.3,null,"Grand Total",21]
[null,"Flair - D-350",79,"Yes","**",23,10.1]
[null,"ABC - Nevada 2500",77,"No","**",24,10]
[null,"ABC - Nevada 3500",76,"No","**",31,10.1,null,"Acceleration (0-60) Sec (Upper Limit NOT Included)","Frequency"]
[null,"Tyro - Land Hugger 43",76,"No","**",26,8.6999999999999993,null,"7<= Seconds <8",1]
[null,"Jazz - Gladiator",76,"No","*",22,10.9,null,"8<= Seconds <9",6]
[null,"Flair - D-250",71,"Yes","***",23,9.6,null,"9<= Seconds <10",6]
[null,"Flair - D-450",67,"Yes","**",21,8.5,null,"10<= Seconds <11",8]
[null,"Nights - Frontier",66,"No","**",24,9.8000000000000007,null,"Grand Total",21]
[null,"ABC - Nevada Hybrid",64,"No","**",26,8.4]
[]
[]
[null,null,null,null,null,null,null,null,"7 up to 8"]
[null,null,null,null,null,null,null,null,"7 <= Seconds < 8"]
[]
[]
[null,null,null,null,null,null,null,null,"Overall Score",null,null,"Acceleration (0-60) Sec"]
[null,null,null,null,null,null,null,null,"64-67",null,null,7.2]
[null,null,null,null,null,null,null,null,"68-71",null,null,8.4]
[null,null,null,null,null,null,null,null,"76-79",null,null,8.5]
[null,null,null,null,null,null,null,null,"80-83",null,null,8.6]
[null,null,null,null,null,null,null,null,"84-87",null,null,8.6999999999999993]
[null,null,null,null,null,null,null,null,"Grand Total",null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,9.3000000000000007]
[null,null,null,null,null,null,null,null,null,null,null,9.5]
[null,null,null,null,null,null,null,null,null,null,null,9.6]
[null,null,null,null,null,null,null,null,null,null,null,9.8000000000000007]
[null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,10.1]
[null,null,null,null,null,null,null,null,null,null,null,10.199999999999999]
[null,null,null,null,null,null,null,null,null,null,null,10.3]
[null,null,null,null,null,null,null,null,null,null,null,10.9]
[null,null,null,null,null,null,null,null,null,null,null,"Grand Total"]