{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Topics","Detailed Topic List","Keyboards","Notes","Print B","Print P","PD(1)","PD(2)","PD(2an)","PD(3)","PD(3an)","EVSD(1)","EVSD(1an)","EVSD(2)","EVSD(2an)","BDPD","B(1)","B(1an)","B(2)","B(2an)","B(3)","B(3an)","B(4)","B(4an)","B(5)"],"not_rendered":{"charts":8,"images":1,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Topics","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Topics","Sheet Name (link to jump)"]
["Random Variables"]
["Discrete Random Variables"]
["Continuous Random Variables"]
["Build Discrete Probability Distributions\nExpected Value for a  Discrete Random Variables\nVariance and Standard Deviation for a Discrete Random Variables","PD(2)"]
[null,"PD(3)"]
[null,"EVSD(1)"]
[null,"EVSD(2)"]
["Binomial Experiment & Binomial Probabilities\nExpected Value and Variance and Standard Deviation for a Binomial Distribution","B(1)"]
[null,"B(2)"]
[null,"B(3)"]
[null,"B(4)"]
[null,"B(5)"]

{"sheet":"Detailed Topic List","index":1,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Video31:","Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD"]
["Number","Topic In Video and minute mark in Video.","Time In Video",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Text"]
[{"$f":"ROWS(A3:A$3)","v":1},{"$f":"TRIM(REPLACE(R3,1,SEARCH(\")\",R3)+1,\"\"))","v":"Discussion about Discrete Probability Distributions, Random Variables, Continuous Random Variables, Discrete Random Variables, Discrete Probability Functions, Steps for creating Discrete Probability Distributions and calculating Expected Value (Mean) and Standard Deviation from a Discrete Probability Distributions."},{"$f":"TRIM(LEFT(R3,SEARCH(\")\",R3)))","v":"(00:12)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(00:12) Discussion about Discrete Probability Distributions, Random Variables, Continuous Random Variables, Discrete Random Variables, Discrete Probability Functions, Steps for creating Discrete Probability Distributions and calculating Expected Value (Mean) and Standard Deviation from a Discrete Probability Distributions."]
[{"$f":"ROWS(A$3:A4)","v":2},{"$f":"TRIM(REPLACE(R4,1,SEARCH(\")\",R4)+1,\"\"))","v":"Create Discrete Probability Distributions for Isaac’s Italian Restaurant where we need to calculate probabilities for the random variable “Number of Banquet Rooms Used in One Day"},{"$f":"TRIM(LEFT(R4,SEARCH(\")\",R4)))","v":"(12:50)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(12:50) Create Discrete Probability Distributions for Isaac’s Italian Restaurant where we need to calculate probabilities for the random variable “Number of Banquet Rooms Used in One Day"]
[{"$f":"ROWS(A$3:A5)","v":3},"Calculate Expected Value (Mean) from Discrete Probability Distributions using SUMPRODUCT.","(15:14)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(15:14) Calculate Expected Value (Mean) from Discrete Probability Distributions using SUMPRODUCT."]
[{"$f":"ROWS(A$3:A6)","v":4},"Test to see if Expected Value formula works by calculating Mean for original Data Set","(16:55)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(16:55) Test to see if Expected Value formula works by calculating Mean for original Data Set"]
[{"$f":"ROWS(A$3:A7)","v":5},"Calculate Standard Deviation from Discrete Probability Distributions Long Hand.","(17:15)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(17:15) Calculate Standard Deviation from Discrete Probability Distributions Long Hand."]
[{"$f":"ROWS(A$3:A8)","v":6},"Test to see if Standard Deviation formula works by calculating Standard Deviation for original Data Set using STDEV.P","(20:32)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(20:32) Test to see if Standard Deviation formula works by calculating Standard Deviation for original Data Set using STDEV.P"]
[{"$f":"ROWS(A$3:A9)","v":7},"Calculate Standard Deviation from Discrete Probability Distributions in a single cell using SUMPRODUCT and SQRT functions","(21:28)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(21:28) Calculate Standard Deviation from Discrete Probability Distributions in a single cell using SUMPRODUCT and SQRT functions"]
[{"$f":"ROWS(A$3:A10)","v":8},"Calculate Probabilities from Discrete Probability Distributions for Isaac’s Italian Restaurant where we need to calculate probabilities for the random variable “Number of Banquet Rooms Used in One Day","(24:49)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(24:49) Calculate Probabilities from Discrete Probability Distributions for Isaac’s Italian Restaurant where we need to calculate probabilities for the random variable “Number of Banquet Rooms Used in One Day"]
[{"$f":"ROWS(A$3:A11)","v":9},"Create Discrete Probability Distributions and calculate Expected Value and Standard Deviation and calculate probabilities from Discrete Probability Distributions For Dick’s Hamburger Drive In Customer Arrival Data","(26:12)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(26:12) Create Discrete Probability Distributions and calculate Expected Value and Standard Deviation and calculate probabilities from Discrete Probability Distributions For Dick’s Hamburger Drive In Customer Arrival Data"]
[]
["Video32:","Excel 2013 Statistical Analysis #32: Expected Value & Standard Deviation Discrete Probability"]
["Number","Topic In Video and minute mark in Video.","Time In Video",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Text"]
[{"$f":"ROWS(A$15:A15)","v":1},{"$f":"TRIM(REPLACE(R15,1,SEARCH(\")\",R15)+1,\"\"))","v":"Accounting Example with Expected Value and Standard Deviation calculated from a Discrete Probability Distribution"},{"$f":"TRIM(LEFT(R15,SEARCH(\")\",R15)))","v":"(00:09)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(00:09) Accounting Example with Expected Value and Standard Deviation calculated from a Discrete Probability Distribution"]
[{"$f":"ROWS(A$15:A16)","v":2},{"$f":"TRIM(REPLACE(R16,1,SEARCH(\")\",R16)+1,\"\"))","v":"Finance Example with Expected Value and Standard Deviation calculated from a Discrete Probability Distribution"},{"$f":"TRIM(LEFT(R16,SEARCH(\")\",R16)))","v":"(04:48)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(04:48) Finance Example with Expected Value and Standard Deviation calculated from a Discrete Probability Distribution"]
[]
["Video33:","Excel 2013 Statistical Analysis #33: Binomial Probability Distributions: Tables, Charts, Functions"]
["Number","Topic In Video and minute mark in Video.","Time In Video",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Text"]
[{"$f":"ROWS(A$20:A20)","v":1},{"$f":"TRIM(REPLACE(R20,1,SEARCH(\")\",R20)+1,\"\"))","v":"Discussion about Binominal Experiments and Probability Distributions"},{"$f":"TRIM(LEFT(R20,SEARCH(\")\",R20)))","v":"(00:11)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(00:11) Discussion about Binominal Experiments and Probability Distributions"]
[{"$f":"ROWS(A$20:A21)","v":2},"xample 1: Experiment is attempting four sales calls. This example show how to create the Binomial Distribution in Table and Column Chart. This example show the 5 possibilities for comparative operators while using the BINOM.DIST function.","(11:00)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(11:00)Example 1: Experiment is attempting four sales calls. This example show how to create the Binomial Distribution in Table and Column Chart. This example show the 5 possibilities for comparative operators while using the BINOM.DIST function."]
[{"$f":"ROWS(A$20:A22)","v":3},"Example 2: Experiment concerns late airline flights. This example show the 5 possibilities for comparative operators while using the BINOM.DIST function.","(24:10)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(24:10) Example 2: Experiment concerns late airline flights. This example show the 5 possibilities for comparative operators while using the BINOM.DIST function."]
[{"$f":"ROWS(A$20:A23)","v":4},"Example 3: Experiment concerns West Seattle Bridge “Stuck in Traffic”.","(29:47)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(29:47) Example 3: Experiment concerns West Seattle Bridge “Stuck in Traffic”."]
[{"$f":"ROWS(A$20:A24)","v":5},"xample 4: Experiment concerns Student’s probability of withdrawing from Accounting 202. This example show how to use two BINOM.DIST function to calculate probabilities between two values.","(31:39)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(31:39)Example 4: Experiment concerns Student’s probability of withdrawing from Accounting 202. This example show how to use two BINOM.DIST function to calculate probabilities between two values."]
[{"$f":"ROWS(A$20:A25)","v":6},"As number of trials get large, distribution approaches a Bell Shape. As the probability approaches 0.5, the distribution approaches a Bell Shape.","(35:24)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(35:24) As number of trials get large, distribution approaches a Bell Shape. As the probability approaches 0.5, the distribution approaches a Bell Shape."]

{"sheet":"Keyboards","index":2,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Primary Key","Action","Keyboard Short Cut","Category"]
[1,"Move the Active Worksheet up or down","Ctrl + Page Up/Page Down","Navigation"]
[2,"Put content in Cell and move selected Cell down","Enter","Entering Data in a Cell"]
[3,"Put content in Cell and keep Cell selected","Ctrl + Enter","Entering Data in a Cell"]
[4,"Undo","Ctrl + Z","Basic"]
[5,"Copy","Ctrl + C","Basic"]
[6,"Paste","Ctrl + V","Basic"]
[7,"Cut","Ctrl + X","Basic"]
[8,"Bold","Ctrl + B","Basic"]
[9,"Put Cell in Edit Mode","F2","Formula Edit Mode Keys"]
[10,"Arrow to point to a formula Cell Reference","Arrow Keys","Formula Edit Mode Keys"]
[11,"SUM function","Alt + =","Formula Edit Mode Keys"]
[12,"Delete Cell content","Delete","Basic"]
[13,"Lock Cell Reference (make Absolute)","F4","Formula Edit Mode Keys"]
[14,"Put content in Cell and move selected Cell to right","Tab","Entering Data in a Cell"]
[15,"Put content in Cell and move selected Cell to left","Shift + Tab","Entering Data in a Cell"]
[16,"Jump to bottom of data set (Current Range)","Ctrl + Arrow","Navigation"]
[17,"Select to bottom of data set (Current Range)","Ctrl + Shift + Enter","Formula Edit Mode Keys"]
[18,"Put content in Cell and move selected Cell up","Shift + Enter","Entering Data in a Cell"]
[19,"Jump Back to Active Cell","Ctrl + Backspace","Formula Edit Mode Keys"]
[20,"Open Create PivotTable  dialog box","Alt, N, V","PivotTable"]
[21,"Format Chart Element with Task Pane","Ctrl + 1","Chart"]
[22,"Open Format Cells dialog box","Ctrl + 1","Format Cells"]
[23,"Jump to Cell A1","Ctrl + Home","Navigation"]
[24,"Jump to last Cell used","Ctrl + End","Navigation"]
[25,"Open Control Panel","Window + Pause/Break","Window Key"]
[26,"Show Desktop","Window + D\nor\nWindow + M","Window Key"]
[27,"Select Whole Table (Select Current Region)","Ctrl + * (on Number Pad)\nor\nCtrl + Shift + 8","Selection"]
[28,"Select Ranges not next to each other (noncontiguous ranges)","Ctrl + Mouse Click","Selection"]
[29,"Open Print Options and Print Preview view","Ctrl + P","Basic"]
[30,"Close Print Options and Print Preview view ","Esc","Basic"]
[31,"New Workbook File","Ctrl + N","Basic"]
[32,"Save As Dialog Box","F12","Basic"]
[33,"Find and Replace","Ctrl + Home","Basic"]
[34]

{"sheet":"Notes","index":3,"n_rows":114,"n_cols":15,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
["See handwritten notes in PDF download at web site"]
[]
["Chapter 4 Terms:"]
["Probability"]
[" E = Event, P = Probability, then P(E) = A Number between 0 and 1, inclusive."]
["Estimate of the unknown future"]
["Random Experiment:"]
["1) Well Defined Outcomes"]
["2) Any single Trial only one outcome can occur"]
["3) Outcome occurs by chance"]
["Multi-Step Experiment:"]
["Random Experiment with more than 1 Step/Trial"]
["Sample Point"]
["Sample Point = Experimental Outcome"]
["Sample Space"]
["List of all Possible Sample Points/Experimental Outcomes"]
["{Total Number Sample Points} for Multi-Step Experiment:"]
["k = Number of Steps"]
["nk = Outcomes for particular Step"]
["{Total Number Sample Points} = n1 + n2 + … nk "]
["If number of outcomes is same for each Step, {Total Number Sample Points} = n^k"]
["Assigning Probability"]
["Classical = All Sample Points are equally likely"]
["Relative Frequency = Data from past is Relative Frequency Table that has categories which are:"]
["Mutually Exclusive (no item fits into more than one category) and Collectively Exhaustive (enough categories to count everything)."]
["Subjective = Outcomes not equally likely, Little past data, Use best information you can find but it will be your personal belief"]
["Requirements for Assigning Probabilities:"]
["1) All Sample Points must have a probability between 0 and 1, inclusive"]
["2) Sum of all Sample Point Probabilities = 1"]
["Event"]
["Collection of 1 or more Sample Points"]
["Probability of an Event"]
["Sum of the probabilities of the  Sample Points in the Event"]
[]
["Chapter 5:"]
["Random Variables"]
["A numerical description of the outcome of an experiment"]
["Discrete Random Variables"]
["May assume either: a finite number of values like: 1, 2, 3 or an infinite sequence of numbers like 1, 2, 3… (Gaps between numbers)"]
["Continuous Random Variables"]
["May assume any numerical value in an interval or collection of intervals. Depends on measuring instrument"]
["Many possible numbers between 1 & 2. \"No Gaps\""]
["Probability Distributions"]
["A description/Presentation of how the probabilities are distributed over the values of the random variable."]
["Models"]
["Random Variables and Probability Distributions are models for populations of data that we can use to estimate the unknown future."]
["Discrete Probability Distributions"]
["A description/Presentation of how the probabilities are distributed over the values of a discrete random variable."]
["Discrete Probability Function",null,null,null,null,null,null,null,null,null,null,null,null,null,"                              "]
["A probability function, f(x) or P(x), that provides the probability for each value that the discrete random variable can assume."]
["Requirements for f(x) or P(x)",null,null,null,null,null,null,null,null,null,null,null,null,null,"                              "]
["f(x) = P(x) >= 0 AND ∑f(x) = ∑P(x) = 1"]
["Methods for creating Discrete Probability Distributions:",null,null,null,null,null,null,null,null,null,null,null,null,null,"                              "]
["Classical, Relative Frequency (for large data sets it is called Empirical Discrete Distribution) and Subjective"]
["Advantage of Probability Distributions?"]
["Once you have the table, it is easy to calculate a variety of Events!!!"]
["Steps for building a Discrete Probability Distribution:"]
["1) Define Random Variable"]
["2) Build Frequency Distribution"]
["3) Calculate Relative Frequency - P(x) = f(x)"]
["4) Check Requirement #1: f(x) >= 0 , Check Requirement #2: Σf(x) = 1"]
["5) Create a Column Chart for a Discrete Variable (Columns do not touch)"]
["6) Make predictions"]
["Expected Value for a  Discrete Random Variables",null,null,null,null,null,null,null,null,null,null,null,null,null,"                              "]
["E(x) = µ = Weighted Average = ∑x*f(x) = ∑x*P(x), use: =SUMPRODUCT(XRange,P(x)Range)"]
["Variance and Standard Deviation for a Discrete Random Variables"]
["Var = ∑(x-E(x))^2*P(x), use: =SUMPRODUCT((Xrange-E(x))^2,P(x)Range)"]
["SD = SQRT(∑(x-E(x))^2*P(x)), use: =SQRT(SUMPRODUCT((Xrange-E(x))^2,P(x)Range))"]
["Binomial Experiment"]
["Requirements:"]
["1) Fixed Number of Trials, n = # Trials"]
["2) Each Trial can only result in two outcomes: Success or Failure"]
["3) Probability of success is the same for each trial"]
["4) Trials are independent (one does not affect the next)"]
["Binomial Probability Function"]
["f(x) = P(x) = n!/(x!*(n-x)!)*p^x*(1-p)^(n-x)"]
["In Excel use: BINOM.DIST(x,n,p,cumulative)"]
["x = Number of Successes = Discrete Random Variable = number_s"]
["n = Total Steps/Trials = trials"]
["p = Probability of Success = probability_s"]
["cumulative = FALSE = 0 = probability mass function. Use to calculate exactly x"]
["OR"]
["cumulative = TRUE = 1 = probability mass function. Use to calculate <= x (everything from smallest up to and including x)"]
["Expected Value and Variance and Standard Deviation for a Binomial Distribution"]
["E(x) = µ = mean n*p"]
["Standard Deviation = s = SQRT(n*p*(1-p))"]
["Poisson Distribution"]
["Poisson Probability Distribution can be used to estimate the number of occurrences over a specified interval of time or space"]
["Discrete Random Variable = x = Number of occurrences over a specified interval of time or space."]
["Good for number of  arrivals in waiting line situations over a certain time period (like 15 mins)"]
["Good for number of repairs needed over a distance of road or pipe"]
["Properties (Requirements) of a Poisson Experiment:"]
["1) The probability of an occurrence is the same for any two intervals of equal length"]
["2) The occurrence or nonoccurrence in any interval is independent of the occurrence or nonoccurrence in any other interval"]
["3) Mean = Variance (observed from calculations made off of source data)"]
["f(x) = P(x) = the probability of x occurrences in an interval = height of column when you plot column chart."]
["Discrete Random Variable = x = Number of occurrences over a specified interval of time or space."]
["No upper limit for X: 0,1,2,3… , but as x increases past the mean, the probability decreases and gest quite small."]
["Mean = µ = Calculated from past data"]
["e = constant = 2.71828 = =EXP(1) in Excel"]
["In Excel use: POISSON.DIST(x,mean,cumulative)"]
["x = Number of occurrences over a specified interval of time or space = Discrete Random Variable"]
["mean = µ = Calculated from past data"]
["cumulative = 0 for exactly x OR 1 for less than or equal to x"]
["Hypergeometric Distribution"]
["Similar to Binomial Distribution except: 1) the trails are not independent AND 2) the probability of success changes from trial to trial."]
["In Excel use: HYPGEOM.DIST(x,n,population_s,number_pop,cumulative)"]
["x = Number of Successes in Sample = Discrete Random Variable = sample_s"]
["n = Trials/Steps in Experiment = Sample Size = number_sample"]
["Number Successes in Pop. =  population_s"]
["Population Size = number_pop"]
["cumulative = FALSE = 0 = probability mass function. Use to calculate exactly x"]
["OR"]
["cumulative = TRUE = 1 = probability mass function. Use to calculate <= x (everything from smallest up to and including x)"]

{"sheet":"Print B","index":4,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["An insurance agent has appointments with 4 clients tomorrow."]
["From past data, the chance of making a sale is 1 in 5. What is likelihood that she will sell 3 policies in 4 tries?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes"]
[2,"Each trial only results in S or F",null,null,"Yes"]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials = Appointments",null,null,null,4]
["p = Prob of Success =",null,null,null,0.2]
[{"$f":"\"Random Discrete Variable = x = # Sales in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = # Sales in 4 Tries"}]
["Mean = µ = E(x) = Expected Value =",null,null,null,{"$f":"SUMPRODUCT(A18:A22,B18:B22)","v":0.79999999999999982},null,{"$f":"IF(_xlfn.ISFORMULA(E12),_xlfn.FORMULATEXT(E12),\"\")","v":"=SUMPRODUCT(A18:A22,B18:B22)"}]
["Mean = µ = E(x) = Expected Value =",null,null,null,{"$f":"E9*E10","v":0.8},null,{"$f":"IF(_xlfn.ISFORMULA(E13),_xlfn.FORMULATEXT(E13),\"\")","v":"=E9*E10"}]
["Standard Deviation = s =",null,null,null,{"$f":"SUMPRODUCT((A18:A22-E12)^2,B18:B22)","v":0.6399999999999999},null,"=SUMPRODUCT((A18:A22-E12)^2,B18:B22)"]
["Standard Deviation = s =",null,null,null,{"$f":"E9*E10*(1-E10)","v":0.64000000000000012},null,"=E9*E10*(1-E10)"]
[]
["X","P(x) = f(x)"]
[0,{"$f":"_xlfn.BINOM.DIST(A18,$E$9,$E$10,0)","v":0.40959999999999996},null,{"$f":"IF(_xlfn.ISFORMULA(B18),_xlfn.FORMULATEXT(B18),\"\")","v":"=BINOM.DIST(A18,$E$9,$E$10,0)"}]
[1,{"$f":"_xlfn.BINOM.DIST(A19,$E$9,$E$10,0)","v":0.40959999999999996},null,"=BINOM.DIST(A19,$E$9,$E$10,0)"]
[2,{"$f":"_xlfn.BINOM.DIST(A20,$E$9,$E$10,0)","v":0.15359999999999996},null,"=BINOM.DIST(A20,$E$9,$E$10,0)"]
[3,{"$f":"_xlfn.BINOM.DIST(A21,$E$9,$E$10,0)","v":2.5600000000000005E-2},null,"=BINOM.DIST(A21,$E$9,$E$10,0)"]
[4,{"$f":"_xlfn.BINOM.DIST(A22,$E$9,$E$10,0)","v":1.6000000000000005E-3},null,"=BINOM.DIST(A22,$E$9,$E$10,0)"]
["Total",{"$f":"SUM(B18:B22)","v":0.99999999999999989},null,"=SUM(B18:B22)"]
[]
["P(x) = f(x)","P(x) = f(x)","SUM","X"]
[{"$f":"\"P(x = \"&D26&\")\"","v":"P(x = 3)"},{"$f":"_xlfn.BINOM.DIST(D26,E9,E10,0)","v":2.5600000000000005E-2},{"$f":"SUM(B21)","v":2.5600000000000005E-2},3,null,{"$f":"IF(_xlfn.ISFORMULA(B26),_xlfn.FORMULATEXT(B26),\"\")","v":"=BINOM.DIST(D26,E9,E10,0)"},null,null,null,{"$f":"IF(_xlfn.ISFORMULA(C26),_xlfn.FORMULATEXT(C26),\"\")","v":"=SUM(B21)"}]
[{"$f":"\"P(x <= \"&D30&\")\"","v":"P(x <= 3)"},{"$f":"_xlfn.BINOM.DIST(D27,E9,E10,1)","v":0.99839999999999995},{"$f":"SUM(B18:B21)","v":0.99839999999999984},3,null,{"$f":"IF(_xlfn.ISFORMULA(B27),_xlfn.FORMULATEXT(B27),\"\")","v":"=BINOM.DIST(D27,E9,E10,1)"},null,null,null,{"$f":"IF(_xlfn.ISFORMULA(C27),_xlfn.FORMULATEXT(C27),\"\")","v":"=SUM(B18:B21)"}]
[{"$f":"\"P(x > \"&D28&\")\"","v":"P(x > 3)"},{"$f":"1-_xlfn.BINOM.DIST(D28,E9,E10,1)","v":1.6000000000000458E-3},{"$f":"SUM(B22)","v":1.6000000000000005E-3},3,null,"=1-BINOM.DIST(D28,E9,E10,1)",null,null,null,"=SUM(B22)"]
[{"$f":"\"P(x >= \"&D27&\")\"","v":"P(x >= 3)"},{"$f":"1-_xlfn.BINOM.DIST(D29-1,E9,E10,1)","v":2.7200000000000002E-2},{"$f":"SUM(B21:B22)","v":2.7200000000000005E-2},3,null,"=1-BINOM.DIST(D29-1,E9,E10,1)",null,null,null,"=SUM(B21:B22)"]
[{"$f":"\"P(x < \"&D29&\")\"","v":"P(x < 3)"},{"$f":"_xlfn.BINOM.DIST(D30-1,E9,E10,1)","v":0.9728},{"$f":"SUM(B18:B20)","v":0.97279999999999989},3,null,"=BINOM.DIST(D30-1,E9,E10,1)",null,null,null,"=SUM(B18:B20)"]

{"sheet":"Print P","index":5,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Arrivals to Dick's Hamburgers at 45th Ave in Seattle at Saturday noon lunch during a 1-minute period. Mean = \"&ROUND(B3,2)","v":"Arrivals to Dick's Hamburgers at 45th Ave in Seattle at Saturday noon lunch during a 1-minute period. Mean = 3.88"}]
[]
["Mean",3.8796934865900381]
["Variance",3.7546870225418991]
[]
["X = Arrivals During 1 min","Poisson P(X)"]
[0,{"$f":"_xlfn.POISSON.DIST(A7,$B$3,0)","v":2.0657155906734028E-2},null,{"$f":"_xlfn.FORMULATEXT(B7)","v":"=POISSON.DIST(A7,$B$3,0)"}]
[1,8.0143433222830948E-2,null,{"$f":"_xlfn.FORMULATEXT(B8)","v":"=POISSON.DIST(A8,$B$3,0)"}]
[2,0.15546597793379047,null,"=POISSON.DIST(A9,$B$3,0)"]
[3,0.20105344732535915,null,"=POISSON.DIST(A10,$B$3,0)"]
[4,0.19500643751116731,null,"=POISSON.DIST(A11,$B$3,0)"]
[5,0.1513130410910406,null,"=POISSON.DIST(A12,$B$3,0)"]
[6,9.7841369992840155E-2,null,"=POISSON.DIST(A13,$B$3,0)"]
[7,5.422778941146688E-2,null,"=POISSON.DIST(A14,$B$3,0)"]
[8,2.6298400171480534E-2,null,"=POISSON.DIST(A15,$B$3,0)"]
[9,1.1336636872559033E-2,null,"=POISSON.DIST(A16,$B$3,0)"]
[10,4.3982676234303759E-3,null,"=POISSON.DIST(A17,$B$3,0)"]
[11,1.5512663864456957E-3,null,"=POISSON.DIST(A18,$B$3,0)"]
[12,5.0153650795495307E-4,null,"=POISSON.DIST(A19,$B$3,0)"]
[13,1.4967753255384184E-4,null,"=POISSON.DIST(A20,$B$3,0)"]
[14,4.1478782009857719E-5,null,"=POISSON.DIST(A21,$B$3,0)"]
[15,1.0728330693022202E-5,null,"=POISSON.DIST(A22,$B$3,0)"]
["Total",{"$f":"SUM(B7:B22)","v":0.99999664460235693},null,"=SUM(B7:B22)"]
[]
[]
["Low X","High X",null,null,"SUM","POISSON","Formula"]
[null,0,null,{"$f":"\"P(\"&B27&\")\"","v":"P(0)"},{"$f":"SUM(B7)","v":2.0657155906734028E-2},{"$f":"_xlfn.POISSON.DIST(B27,B3,0)","v":2.0657155906734028E-2},{"$f":"B3^B27*EXP(1)^-B3/FACT(B27)","v":2.0657155906734032E-2},null,{"$f":"IF(_xlfn.ISFORMULA(E27),_xlfn.FORMULATEXT(E27),\"\")","v":"=SUM(B7)"},null,{"$f":"IF(_xlfn.ISFORMULA(F27),_xlfn.FORMULATEXT(F27),\"\")","v":"=POISSON.DIST(B27,B3,0)"},null,null,{"$f":"IF(_xlfn.ISFORMULA(G27),_xlfn.FORMULATEXT(G27),\"\")","v":"=B3^B27*EXP(1)^-B3/FACT(B27)"}]
[3,5,null,{"$f":"\"P(\"&A28&\" <= No. Arvls. <= \"&B28&\")\"","v":"P(3 <= No. Arvls. <= 5)"},{"$f":"SUM(B10:B12)","v":0.54737292592756703},{"$f":"_xlfn.POISSON.DIST(B28,B3,1)-_xlfn.POISSON.DIST(A28-1,B3,1)","v":0.54737292592756703},null,null,{"$f":"IF(_xlfn.ISFORMULA(E28),_xlfn.FORMULATEXT(E28),\"\")","v":"=SUM(B10:B12)"},null,{"$f":"IF(_xlfn.ISFORMULA(F28),_xlfn.FORMULATEXT(F28),\"\")","v":"=POISSON.DIST(B28,B3,1)-POISSON.DIST(A28-1,B3,1)"}]
[2,null,null,{"$f":"\"P( No. Arvls > \"&A29&\")\"","v":"P( No. Arvls > 2)"},{"$f":"SUM(B10:B22)","v":0.74373007753900144},{"$f":"1-_xlfn.POISSON.DIST(A29,B3,1)","v":0.74373343293664451},null,null,{"$f":"IF(_xlfn.ISFORMULA(E29),_xlfn.FORMULATEXT(E29),\"\")","v":"=SUM(B10:B22)"},null,{"$f":"IF(_xlfn.ISFORMULA(F29),_xlfn.FORMULATEXT(F29),\"\")","v":"=1-POISSON.DIST(A29,B3,1)"}]

{"sheet":"PD(1)","index":6,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Experiment of tossing coin three times"]
["Steps in Experiment",3]
["Outcomes Step 1",2]
["Outcomes Step 2",2]
["Outcomes Step 3",2,null,null,null,"Success ="]
["Total Experimental Outcomes",{"$f":"PRODUCT(B3:B5)","v":8},"(Sample Points)",null,null,"Tails"]
["P(for each) =",{"$f":"1/B6","v":0.125},"Classical",null,null,{"$f":"\"Notation for \"&F6&\" is \"&LEFT(F6,1)","v":"Notation for Tails is T"}]
[null,null,null,null,null,{"$f":"LEFT(F6,1)","v":"T"}]
["# SP","Toss 1","Toss 2","Toss 3","Sample Space","Probability of Sample Point","# of heads for sample points"]
[1,"H","H","H",{"$f":"\"(\"&B10&\", \"&C10&\", \"&D10&\")\"","v":"(H, H, H)"},{"$f":"1/$B$6","v":0.125},{"$f":"COUNTIF(B10:D10,$F$8)","v":0}]
[2,"T","H","H",{"$f":"\"(\"&B11&\", \"&C11&\", \"&D11&\")\"","v":"(T, H, H)"},0.125,1]
[3,"H","T","H","(H, T, H)",0.125,1]
[4,"H","H","T","(H, H, T)",0.125,1]
[5,"T","T","H","(T, T, H)",0.125,2]
[6,"T","H","T","(T, H, T)",0.125,2]
[7,"H","T","T","(H, T, T)",0.125,2]
[8,"T","T","T","(T, T, T)",0.125,3]
[null,null,null,null,null,{"$f":"SUM(F10:F17)","v":1}]
["x = Discrete Random Variable =",{"$f":"\"# of \"&F6&\" in 3 flips\"","v":"# of Tails in 3 flips"}]
[null,null,null,null,"Steps:","#1","Define Random Variable"]
["X","Frequency","P(X) = f(x)","Each f(x)>=0?",null,"#2","Build Frequency Distribution"]
[0,{"$f":"COUNTIF($G$10:$G$17,A22)","v":1},{"$f":"B22/$B$26","v":0.125},{"$f":"C22>=0","v":true},null,"#3","Calculate Relative Frequency - P(x) = f(x)"]
[1,{"$f":"COUNTIF($G$10:$G$17,A23)","v":3},{"$f":"B23/$B$26","v":0.375},{"$f":"C23>=0","v":true},null,"#4","Check Requirement #1: f(x) >= 0"]
[2,{"$f":"COUNTIF($G$10:$G$17,A24)","v":3},{"$f":"B24/$B$26","v":0.375},{"$f":"C24>=0","v":true},null,"#5","Check Requirement #2: Σf(x) = 1"]
[3,{"$f":"COUNTIF($G$10:$G$17,A25)","v":1},{"$f":"B25/$B$26","v":0.125},{"$f":"C25>=0","v":true},null,"#6","Create a Column Chart for a Discrete Variable (Columns do not touch)"]
["Total",{"$f":"SUM(B22:B25)","v":8},{"$f":"SUM(C22:C25)","v":1},null,null,"#7","Make predictions"]
[]
["P(X =1)",{"$f":"C22","v":0.125}]
["P(X > = 2)",{"$f":"SUM(C24:C25)","v":0.5}]
["P(x = 0 or x = 3)",{"$f":"SUM(C22,C25)","v":0.25},{"$f":"C22+C25","v":0.25}]
["P(X not 2)",{"$f":"SUM(C22:C23,C25)","v":0.625},{"$f":"1-C24","v":0.625}]

{"sheet":"PD(2)","index":7,"n_rows":112,"n_cols":10,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
["Steps to Build Discrete Probability Distribution:"]
["#1","Define Random Variable"]
["#2","Build Frequency Distribution"]
["#3","Calculate Relative Frequency - P(x) = f(x)"]
["#4","Check Requirement #1: f(x) >= 0 , Check Requirement #2: Σf(x) = 1"]
["#5","Create a Column Chart for a Discrete Variable (Columns do not touch)"]
["#6","Make predictions"]
[]
["Isaac's Italian Restaurant has 4 banquet rooms",null,null,"Number of Rooms",4]
["Over the past year, they collected the below data:",null,null,"X = Random Discrete Variable = Number of Rooms Used for the Day"]
["                         "]
["Day","# Rooms Used",null,"X = # Rooms Used","Frequency","Relative Frequency P(X)",null,"X -E(X)","(X - E(X))^2","(X - E(X))^2 * P(X)"]
["2014-01-03",1]
["2014-01-04",2]
["2014-01-10",4]
["2014-01-11",3]
["2014-01-17",3]
["2014-01-18",2,null,"Total",null,null,null,null,"s^2"]
["2014-01-24",2]
["2014-01-25",2,null,null,null,null,null,null,"s"]
["2014-01-31",4,null,"Mean = Expected Value = E(x) = µ"]
["2014-02-01",1,null,"Mean"]
["2014-02-07",2,null,"Population SD"]
["2014-02-08",2,null,"SD = s"]
["2014-02-14",2]
["2014-02-15",1]
["2014-02-21",1,null,"P(X <=1)"]
["2014-02-22",2,null,"P(X = 2 OR X = 3)"]
["2014-02-28",2,null,"P(X > 0)"]
["2014-03-07",2]
["2014-03-08",4]
["2014-03-14",2]
["2014-03-15",3]
["2014-03-21",2]
["2014-03-22",3]
["2014-03-28",3]
["2014-03-29",2]
["2014-04-04",2]
["2014-04-05",2]
["2014-04-11",2]
["2014-04-12",3]
["2014-04-18",3]
["2014-04-25",1]
["2014-04-26",1]
["2014-05-02",3]
["2014-05-03",3]
["2014-05-09",1]
["2014-05-10",3]
["2014-05-16",2]
["2014-05-17",3]
["2014-05-23",1]
["2014-05-24",1]
["2014-05-30",2]
["2014-05-31",1]
["2014-06-06",1]
["2014-06-07",4]
["2014-06-14",3]
["2014-06-20",1]
["2014-06-21",3]
["2014-06-27",2]
["2014-06-28",2]
["2014-07-04",2]
["2014-07-05",2]
["2014-07-11",3]
["2014-07-12",3]
["2014-07-18",2]
["2014-07-19",2]
["2014-07-25",2]
["2014-07-26",1]
["2014-08-01",2]
["2014-08-02",2]
["2014-08-08",3]
["2014-08-09",0]
["2014-08-15",3]
["2014-08-16",4]
["2014-08-22",3]
["2014-08-23",1]
["2014-08-29",2]
["2014-08-30",2]
["2014-09-05",1]
["2014-09-06",2]
["2014-09-12",3]
["2014-09-13",2]
["2014-09-19",2]
["2014-09-20",3]
["2014-09-26",3]
["2014-09-27",1]
["2014-10-03",1]
["2014-10-04",2]
["2014-10-10",1]
["2014-10-11",3]
["2014-10-17",3]
["2014-10-18",2]
["2014-10-24",2]
["2014-10-25",2]
["2014-10-31",2]
["2014-11-01",1]
["2014-11-07",2]
["2014-11-08",4]
["2014-11-14",0]
["2014-11-15",4]
["2014-11-21",2]
["2014-11-22",1]
["2014-11-29",3]
["2014-12-05",4]
["2014-12-06",3]
["2014-12-12",3]
["2014-12-13",2]
["2014-12-19",1]
["2014-12-20",3]
["2014-12-26",2]
["2014-12-27",2]

{"sheet":"PD(2an)","index":8,"n_rows":112,"n_cols":10,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
["Steps to Build Discrete Probability Distribution:"]
["#1","Define Random Variable"]
["#2","Build Frequency Distribution"]
["#3","Calculate Relative Frequency - P(x) = f(x)"]
["#4","Check Requirement #1: f(x) >= 0 , Check Requirement #2: Σf(x) = 1"]
["#5","Create a Column Chart for a Discrete Variable (Columns do not touch)"]
["#6","Make predictions"]
[]
["Isaac's Italian Restaurant has 4 banquet rooms",null,null,"Number of Rooms",4]
["Over the past year, they collected the below data:",null,null,"X = Random Discrete Variable = Number of Rooms Used for the Day"]
["                         "]
["Day","# Rooms Used",null,"X = # Rooms Used","Frequency","Relative Frequency P(X)",null,"X -E(X)","(X - E(X))^2","(X - E(X))^2 * P(X)"]
["2014-01-03",1,null,0,{"$f":"COUNTIFS($B$13:$B$112,D13)","v":2},{"$f":"E13/$E$18","v":0.02},null,{"$f":"D13-$F$21","v":-2.1800000000000002},{"$f":"H13^2","v":4.7524000000000006},{"$f":"I13*F13","v":9.5048000000000021E-2}]
["2014-01-04",2,null,1,{"$f":"COUNTIFS($B$13:$B$112,D14)","v":21},{"$f":"E14/$E$18","v":0.21},null,{"$f":"D14-$F$21","v":-1.1800000000000002},{"$f":"H14^2","v":1.3924000000000003},{"$f":"I14*F14","v":0.29240400000000005}]
["2014-01-10",4,null,2,42,0.42,null,{"$f":"D15-$F$21","v":-0.18000000000000016},3.2400000000000061E-2,1.3608000000000025E-2]
["2014-01-11",3,null,3,27,0.27,null,{"$f":"D16-$F$21","v":0.81999999999999984},0.67239999999999978,0.18154799999999996]
["2014-01-17",3,null,4,8,0.08,null,{"$f":"D17-$F$21","v":1.8199999999999998},3.3123999999999993,0.26499199999999995]
["2014-01-18",2,null,"Total",{"$f":"SUM(E13:E17)","v":100},{"$f":"SUM(F13:F17)","v":0.99999999999999989},null,{"$f":"SUM(H13:H17)","v":-0.9000000000000008},"s^2",{"$f":"SUM(J13:J17)","v":0.84759999999999991}]
["2014-01-24",2]
["2014-01-25",2,null,null,null,null,null,null,"s",{"$f":"SQRT(J18)","v":0.92065194291871233}]
["2014-01-31",4,null,"Mean = Expected Value = E(x) = µ",null,{"$f":"SUMPRODUCT(D13:D17,F13:F17)","v":2.1800000000000002}]
["2014-02-01",1,null,"Mean",null,{"$f":"AVERAGE(B13:B112)","v":2.1800000000000002}]
["2014-02-07",2,null,"Population SD",null,{"$f":"_xlfn.STDEV.P(B13:B112)","v":0.92065194291871233}]
["2014-02-08",2,null,"SD = s",null,{"$f":"SQRT(SUMPRODUCT((D13:D17-F21)^2,F13:F17))","v":0.92065194291871233}]
["2014-02-14",2]
["2014-02-15",1]
["2014-02-21",1,null,"P(X <=1)",{"$f":"SUM(F13:F14)","v":0.22999999999999998}]
["2014-02-22",2,null,"P(X = 2 OR X = 3)",{"$f":"SUM(F15:F16)","v":0.69}]
["2014-02-28",2,null,"P(X > 0)",{"$f":"1-F13","v":0.98},{"$f":"SUM(F14:F17)","v":0.98}]
["2014-03-07",2]
["2014-03-08",4]
["2014-03-14",2]
["2014-03-15",3]
["2014-03-21",2]
["2014-03-22",3]
["2014-03-28",3]
["2014-03-29",2]
["2014-04-04",2]
["2014-04-05",2]
["2014-04-11",2]
["2014-04-12",3]
["2014-04-18",3]
["2014-04-25",1]
["2014-04-26",1]
["2014-05-02",3]
["2014-05-03",3]
["2014-05-09",1]
["2014-05-10",3]
["2014-05-16",2]
["2014-05-17",3]
["2014-05-23",1]
["2014-05-24",1]
["2014-05-30",2]
["2014-05-31",1]
["2014-06-06",1]
["2014-06-07",4]
["2014-06-14",3]
["2014-06-20",1]
["2014-06-21",3]
["2014-06-27",2]
["2014-06-28",2]
["2014-07-04",2]
["2014-07-05",2]
["2014-07-11",3]
["2014-07-12",3]
["2014-07-18",2]
["2014-07-19",2]
["2014-07-25",2]
["2014-07-26",1]
["2014-08-01",2]
["2014-08-02",2]
["2014-08-08",3]
["2014-08-09",0]
["2014-08-15",3]
["2014-08-16",4]
["2014-08-22",3]
["2014-08-23",1]
["2014-08-29",2]
["2014-08-30",2]
["2014-09-05",1]
["2014-09-06",2]
["2014-09-12",3]
["2014-09-13",2]
["2014-09-19",2]
["2014-09-20",3]
["2014-09-26",3]
["2014-09-27",1]
["2014-10-03",1]
["2014-10-04",2]
["2014-10-10",1]
["2014-10-11",3]
["2014-10-17",3]
["2014-10-18",2]
["2014-10-24",2]
["2014-10-25",2]
["2014-10-31",2]
["2014-11-01",1]
["2014-11-07",2]
["2014-11-08",4]
["2014-11-14",0]
["2014-11-15",4]
["2014-11-21",2]
["2014-11-22",1]
["2014-11-29",3]
["2014-12-05",4]
["2014-12-06",3]
["2014-12-12",3]
["2014-12-13",2]
["2014-12-19",1]
["2014-12-20",3]
["2014-12-26",2]
["2014-12-27",2]

{"sheet":"PD(3)","index":9,"n_rows":1318,"n_cols":7,"rows_kept":1318,"cut":false,"hidden":false,"merged":[]}
["Steps to Build Discrete Probability Distribution:"]
["#1","Define Random Variable"]
["#2","Build Frequency Distribution"]
["#3","Calculate Relative Frequency - P(x) = f(x)"]
["#4","Check Requirement #1: f(x) >= 0 , Check Requirement #2: Σf(x) = 1"]
["#5","Create a Column Chart for a Discrete Variable (Columns do not touch)"]
["#6","Make predictions"]
[]
["Data collected: Number of Arrivals to Dick's Hamburgers at 45th Ave in Seattle at Saturday noon lunch during a 1-minute period."]
["Discrete Variable = X = Number of Arrivals in 1 min period during Sat. noon lunch rush (noon to 1 PM)"]
[]
[]
["X = Arrivals During 1 min",null,"X = Arrivals During 1 min","Frequency","P(X) Relative Frequency"]
[0,null,0,null,null,null,"Mean"]
[0,null,1,null,null,null,"Variance"]
[0,null,2,null,null,null,"SD"]
[0,null,3]
[0,null,4,null,null,null,"P(X <=2)"]
[0,null,5,null,null,null,"P(X = 3 OR X = 4 OR x = 5)"]
[0,null,6,null,null,null,"P(X > 0)"]
[0,null,7]
[0,null,8]
[0,null,9]
[0,null,10]
[0,null,11]
[0,null,12]
[0,null,13]
[0,null,14]
[0,null,"Total"]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[10]
[10]
[10]
[10]
[10]
[11]
[11]
[12]
[14]

{"sheet":"PD(3an)","index":10,"n_rows":1318,"n_cols":8,"rows_kept":1318,"cut":false,"hidden":false,"merged":[]}
["Steps to Build Discrete Probability Distribution:"]
["#1","Define Random Variable"]
["#2","Build Frequency Distribution"]
["#3","Calculate Relative Frequency - P(x) = f(x)"]
["#4","Check Requirement #1: f(x) >= 0 , Check Requirement #2: Σf(x) = 1"]
["#5","Create a Column Chart for a Discrete Variable (Columns do not touch)"]
["#6","Make predictions"]
[]
["Data collected: Number of Arrivals to Dick's Hamburgers at 45th Ave in Seattle at Saturday noon lunch during a 1-minute period."]
["Discrete Variable = X = Number of Arrivals in 1 min period during Sat. noon lunch rush (noon to 1 PM)"]
[]
[]
["X = Arrivals During 1 min",null,"X = Arrivals During 1 min","Frequency","P(X) Relative Frequency"]
[0,null,0,{"$f":"COUNTIFS($A$14:$A$1318,C14)","v":28},{"$f":"D14/$D$29","v":2.1455938697318006E-2},null,"Mean",{"$f":"SUMPRODUCT(C14:C28,E14:E28)","v":3.8796934865900377}]
[0,null,1,{"$f":"COUNTIFS($A$14:$A$1318,C15)","v":102},{"$f":"D15/$D$29","v":7.8160919540229884E-2},null,"Variance",{"$f":"SUMPRODUCT((C14:C28-H14)^2,E14:E28)","v":3.7518098677353535}]
[0,null,2,191,0.14636015325670498,null,"SD",{"$f":"SQRT(H15)","v":1.9369589225730508}]
[0,null,3,263,0.20153256704980843]
[0,null,4,266,0.20383141762452106,null,"P(X <=2)",{"$f":"SUM(E14:E16)","v":0.24597701149425288}]
[0,null,5,204,0.15632183908045977,null,"P(X = 3 OR X = 4 OR x = 5)",{"$f":"SUM(E17:E19)","v":0.56168582375478926}]
[0,null,6,136,0.10421455938697317,null,"P(X > 0)",{"$f":"1-E14","v":0.97854406130268201}]
[0,null,7,70,5.3639846743295021E-2]
[0,null,8,22,1.6858237547892719E-2]
[0,null,9,14,1.0727969348659003E-2]
[0,null,10,5,3.8314176245210726E-3]
[0,null,11,2,1.5325670498084292E-3]
[0,null,12,1,7.6628352490421458E-4]
[0,null,13,0,0]
[0,null,14,1,7.6628352490421458E-4]
[0,null,"Total",{"$f":"SUM(D14:D28)","v":1305},{"$f":"SUM(E14:E28)","v":1}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[3]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[4]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[6]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[7]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[8]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[9]
[10]
[10]
[10]
[10]
[10]
[11]
[11]
[12]
[14]

{"sheet":"EVSD(1)","index":11,"n_rows":125,"n_cols":4,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Unit Demand = x","Prob = f(x)"]
[500,0.1]
[600,0.15]
[700,0.15]
[800,0.2]
[900,0.2]
[1000,0.15]
[1100,0.05]
[null,{"$f":"SUM(B2:B8)","v":1}]
[]
["Mean = Expected Value",null," = monthly order quantity"]
["SD"]
[]
["Price per unit",125]
["Cost per unit",60]
["Units sold for cash",500]
["Cash IN"]
["Cash OUT"]
["Cash Flow Implication",null,null,"NOT Accrual Accounting Profit"]
[]
[]
[]
[null,"All Values"]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1100]
[null,1100]
[null,1100]
[null,1100]
[null,1100]
["VAR.P",{"$f":"_xlfn.VAR.P(B24:B123)","v":28900}]
["STDEV.S",{"$f":"_xlfn.STDEV.P(B24:B123)","v":170}]

{"sheet":"EVSD(1an)","index":12,"n_rows":125,"n_cols":4,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Unit Demand = x","Prob = f(x)"]
[500,0.1]
[600,0.15]
[700,0.15]
[800,0.2]
[900,0.2]
[1000,0.15]
[1100,0.05]
[null,{"$f":"SUM(B2:B8)","v":1}]
[]
["Mean = Expected Value",{"$f":"SUMPRODUCT(A2:A8,B2:B8)","v":790}," = monthly order quantity"]
["SD",{"$f":"SQRT(SUMPRODUCT((A2:A8-B11)^2,B2:B8))","v":170}]
[]
["Price per unit",125]
["Cost per unit",60]
["Units sold for cash",500]
["Cash IN",{"$f":"B16*B14","v":62500}]
["Cash OUT",{"$f":"MROUND(B11,100)*B15","v":48000}]
["Cash Flow Implication",{"$f":"B17-B18","v":14500},null,"NOT Accrual Accounting Profit"]
[]
[]
[]
[null,"All Values"]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,500]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,600]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,700]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,800]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,900]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1000]
[null,1100]
[null,1100]
[null,1100]
[null,1100]
[null,1100]
["VAR.P",{"$f":"_xlfn.VAR.P(B24:B123)","v":28900}]
["STDEV.S",{"$f":"_xlfn.STDEV.P(B24:B123)","v":170}]

{"sheet":"EVSD(2)","index":13,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["State of Economy","Prob. Of State of Economy","Stock A Return","Stock B Return","Stock C Return"]
["Boom",0.15,0.15,0.25,0.11]
["Normal",{"$f":"1-SUM(B2,B4)","v":0.29999999999999993},7.0000000000000007E-2,0.13,0.1]
["Bust",0.55000000000000004,-0.02,-0.13500000000000001,0.03]
[null,"E(Ri)"]
["Sd = Proxy for Risk","Standard Deviation"]
[null,"CV = SD/Mean"]
[null,"Mean/SD"]

{"sheet":"EVSD(2an)","index":14,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["State of Economy","Prob. Of State of Economy","Stock A Return","Stock B Return","Stock C Return"]
["Boom",0.15,0.15,0.25,0.11]
["Normal",{"$f":"1-SUM(B2,B4)","v":0.29999999999999993},7.0000000000000007E-2,0.13,0.1]
["Bust",0.55000000000000004,-0.02,-0.13500000000000001,0.03]
[null,"E(Ri)",{"$f":"SUMPRODUCT(C2:C4,$B$2:$B$4)","v":3.2499999999999994E-2},2.2499999999999742E-3,6.3E-2]
["Sd = Proxy for Risk","Standard Deviation",{"$f":"SQRT(SUMPRODUCT((C2:C4-C5)^2,$B$2:$B$4))","v":6.3314690238522056E-2},{"$f":"SQRT(SUMPRODUCT((D2:D4-D5)^2,$B$2:$B$4))","v":0.15640871938610074},3.661966684720111E-2]
[null,"CV = SD/Mean",{"$f":"C6/C5","v":1.9481443150314481},{"$f":"D6/D5","v":69.514986393823349},0.58126455313017633]
[null,"Mean/SD",{"$f":"C5/C6","v":0.5133089947619498},{"$f":"D5/D6","v":1.438538726505244E-2},1.7203870330899849]

{"sheet":"BDPD","index":15,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[12,15,13,15],[12,0,13,0],[12,5,13,5],[12,10,13,10],[12,11,13,11],[12,13,13,13],[12,14,13,14]]}
["pi =",0.2]
["1 - pi =",{"$f":"1-B1","v":0.8}]
["n =",4]
["Fixed # of Trials?","Yes"]
["Each Trial Independent?","Yes"]
["Success is?","Sale","S"]
["Fail is?","No Sale","NS"]
["Success or fail each trial?","Yes"]
["pi the same each Trial?","Yes"]
["Sample Space =",{"$f":"2^B3","v":16}]
[]
[{"$f":"\"Build Discrete Probability Distribution with \"&A3&\" \"&B3&\", \"&A1&\" \"&B1","v":"Build Discrete Probability Distribution with n = 4, pi = 0.2"}]
["Possible Outcomes","Attempted Sale",null,null,null,"# of Sales","Probability associated with each attempt",null,null,null,"Probability of Occurrence Calculation","Probability of Occurrence",null,"# of Sales (Random Variable X)","P(x)","P(x)"]
[null,"1st","2nd","3rd","4th",null,"1st","2nd","3rd","4th"]
[1,"S","S","S","S",{"$f":"COUNTIF(B15:E15,$C$6)","v":4},{"$f":"IF(B15=$C$6,$B$1,$B$2)","v":0.2},0.2,0.2,0.2,{"$f":"G15&\"*\"&H15&\"*\"&I15&\"*\"&J15&\" =\"","v":"0.2*0.2*0.2*0.2 ="},{"$f":"PRODUCT(G15:J15)","v":1.6000000000000005E-3},null,0,{"$f":"\"P(\"&N15&\") =\"","v":"P(0) ="},{"$f":"SUMIF($F$15:$F$30,N15,$L$15:$L$30)","v":0.40960000000000013}]
[2,"S","S","S","NS",3,0.2,0.2,0.2,0.8,"0.2*0.2*0.2*0.8 =",6.400000000000002E-3,null,1,{"$f":"\"P(\"&N16&\") =\"","v":"P(1) ="},{"$f":"SUMIF($F$15:$F$30,N16,$L$15:$L$30)","v":0.40960000000000013}]
[3,"S","S","NS","S",3,0.2,0.2,0.8,0.2,"0.2*0.2*0.8*0.2 =",6.400000000000002E-3,null,2,{"$f":"\"P(\"&N17&\") =\"","v":"P(2) ="},{"$f":"SUMIF($F$15:$F$30,N17,$L$15:$L$30)","v":0.15360000000000004}]
[4,"S","NS","S","S",3,0.2,0.8,0.2,0.2,"0.2*0.8*0.2*0.2 =",6.400000000000002E-3,null,3,{"$f":"\"P(\"&N18&\") =\"","v":"P(3) ="},{"$f":"SUMIF($F$15:$F$30,N18,$L$15:$L$30)","v":2.5600000000000008E-2}]
[5,"NS","S","S","S",3,0.8,0.2,0.2,0.2,"0.8*0.2*0.2*0.2 =",6.400000000000002E-3,null,4,{"$f":"\"P(\"&N19&\") =\"","v":"P(4) ="},{"$f":"SUMIF($F$15:$F$30,N19,$L$15:$L$30)","v":1.6000000000000005E-3}]
[6,"S","S","NS","NS",2,0.2,0.2,0.8,0.8,"0.2*0.2*0.8*0.8 =",2.5600000000000008E-2,null,null,null,{"$f":"SUM(P15:P19)","v":1.0000000000000002}]
[7,"S","NS","NS","S",2,0.2,0.8,0.8,0.2,"0.2*0.8*0.8*0.2 =",2.5600000000000008E-2]
[8,"NS","NS","S","S",2,0.8,0.8,0.2,0.2,"0.8*0.8*0.2*0.2 =",2.5600000000000008E-2,null,null,"E(x)",{"$f":"SUMPRODUCT(N15:N19,P15:P19)","v":0.80000000000000016},{"$f":"B3*B1","v":0.8}]
[9,"S","NS","S","NS",2,0.2,0.8,0.2,0.8,"0.2*0.8*0.2*0.8 =",2.5600000000000008E-2,null,null,"SD",{"$f":"SQRT(SUMPRODUCT((N15:N19-P22)^2,P15:P19))","v":0.8},{"$f":"SQRT(Q22*(1-B1))","v":0.8}]
[10,"NS","S","NS","S",2,0.8,0.2,0.8,0.2,"0.8*0.2*0.8*0.2 =",2.5600000000000008E-2]
[11,"NS","S","S","NS",2,0.8,0.2,0.2,0.8,"0.8*0.2*0.2*0.8 =",2.5600000000000008E-2]
[12,"S","NS","NS","NS",1,0.2,0.8,0.8,0.8,"0.2*0.8*0.8*0.8 =",0.10240000000000003]
[13,"NS","S","NS","NS",1,0.8,0.2,0.8,0.8,"0.8*0.2*0.8*0.8 =",0.10240000000000003]
[14,"NS","NS","S","NS",1,0.8,0.8,0.2,0.8,"0.8*0.8*0.2*0.8 =",0.10240000000000003]
[15,"NS","NS","NS","S",1,0.8,0.8,0.8,0.2,"0.8*0.8*0.8*0.2 =",0.10240000000000003]
[16,"NS","NS","NS","NS",0,0.8,0.8,0.8,0.8,"0.8*0.8*0.8*0.8 =",0.40960000000000013]

{"sheet":"B(1)","index":16,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["An insurance agent has appointments with 4 clients tomorrow."]
["From past data, the chance of making a sale is 1 in 5. What is likelihood that she will sell 3 policies in 4 tries?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,null,null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 4, p = 0.2"}]
[2,"Each trial only results in S or F"]
[3,"p remains the same for each trial"]
[4,"All events are independent"]
[]
["n = # of Fixed Trials = Appointments",null,null,null,4]
["p = Prob of Success =",null,null,null,0.2]
[{"$f":"\"Random Discrete Variable = x = # Sales in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = # Sales in 4 Tries"}]
["Mean = µ = E(x) = Expected Value ="]
["Mean = µ = E(x) = Expected Value ="]
["Standard Deviation = s ="]
["Standard Deviation = s ="]
[null,null,null,null,null,null,null,null,null,null,"P(x) = f(x)","P(x) = f(x)"]
["X","P(x) = f(x)",null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A18)*FACT($E$9-A18))*$E$10^A18*(1-$E$10)^($E$9-A18)","v":0.40960000000000019},{"$f":"COMBIN($E$9,A18)*$E$10^A18*(1-$E$10)^($E$9-A18)","v":0.40960000000000019}]
[0,null,null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A19)*FACT($E$9-A19))*$E$10^A19*(1-$E$10)^($E$9-A19)","v":0.40960000000000013},{"$f":"COMBIN($E$9,A19)*$E$10^A19*(1-$E$10)^($E$9-A19)","v":0.40960000000000013}]
[1,null,null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A20)*FACT($E$9-A20))*$E$10^A20*(1-$E$10)^($E$9-A20)","v":0.15360000000000007},{"$f":"COMBIN($E$9,A20)*$E$10^A20*(1-$E$10)^($E$9-A20)","v":0.15360000000000007}]
[2,null,null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A21)*FACT($E$9-A21))*$E$10^A21*(1-$E$10)^($E$9-A21)","v":2.5600000000000008E-2},{"$f":"COMBIN($E$9,A21)*$E$10^A21*(1-$E$10)^($E$9-A21)","v":2.5600000000000008E-2}]
[3,null,null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A22)*FACT($E$9-A22))*$E$10^A22*(1-$E$10)^($E$9-A22)","v":1.6000000000000007E-3},{"$f":"COMBIN($E$9,A22)*$E$10^A22*(1-$E$10)^($E$9-A22)","v":1.6000000000000007E-3}]
[4,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(K17:K21)","v":1.0000000000000004},{"$f":"SUM(L17:L21)","v":1.0000000000000004}]
["Total"]
[]
["P(x) = f(x)","P(x) = f(x)","SUM","X"]
[{"$f":"\"P(x = \"&D26&\")\"","v":"P(x = 3)"},null,null,3]
[{"$f":"\"P(x <= \"&D30&\")\"","v":"P(x <= 3)"},null,null,3]
[{"$f":"\"P(x > \"&D28&\")\"","v":"P(x > 3)"},null,null,3]
[{"$f":"\"P(x >= \"&D27&\")\"","v":"P(x >= 3)"},null,null,3]
[{"$f":"\"P(x < \"&D29&\")\"","v":"P(x < 3)"},null,null,3]

{"sheet":"B(1an)","index":17,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["An insurance agent has appointments with 4 clients tomorrow."]
["From past data, the chance of making a sale is 1 in 5. What is likelihood that she will sell 3 policies in 4 tries?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 4, p = 0.2"}]
[2,"Each trial only results in S or F",null,null,"Yes"]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials = Appointments",null,null,null,4]
["p = Prob of Success =",null,null,null,0.2]
[{"$f":"\"Random Discrete Variable = x = # Sales in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = # Sales in 4 Tries"}]
["Mean = µ = E(x) = Expected Value =",null,null,null,{"$f":"SUMPRODUCT(A18:A22,B18:B22)","v":0.79999999999999982}]
["Mean = µ = E(x) = Expected Value =",null,null,null,{"$f":"E9*E10","v":0.8}]
["Standard Deviation = s =",null,null,null,{"$f":"SQRT(SUMPRODUCT((A18:A22-E12)^2,B18:B22))","v":0.79999999999999993}]
["Standard Deviation = s =",null,null,null,{"$f":"SQRT(E13*(1-E10))","v":0.8}]
[null,null,null,null,null,null,null,null,null,null,"P(x) = f(x)","P(x) = f(x)"]
["X","P(x) = f(x)",null,null,{"$f":"SUMPRODUCT((A18:A22-E12)^2,B18:B22)","v":0.6399999999999999},null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A18)*FACT($E$9-A18))*$E$10^A18*(1-$E$10)^($E$9-A18)","v":0.40960000000000019},{"$f":"COMBIN($E$9,A18)*$E$10^A18*(1-$E$10)^($E$9-A18)","v":0.40960000000000019}]
[0,{"$f":"_xlfn.BINOM.DIST(A18,$E$9,$E$10,0)","v":0.40959999999999996},null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A19)*FACT($E$9-A19))*$E$10^A19*(1-$E$10)^($E$9-A19)","v":0.40960000000000013},{"$f":"COMBIN($E$9,A19)*$E$10^A19*(1-$E$10)^($E$9-A19)","v":0.40960000000000013}]
[1,{"$f":"_xlfn.BINOM.DIST(A19,$E$9,$E$10,0)","v":0.40959999999999996},null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A20)*FACT($E$9-A20))*$E$10^A20*(1-$E$10)^($E$9-A20)","v":0.15360000000000007},{"$f":"COMBIN($E$9,A20)*$E$10^A20*(1-$E$10)^($E$9-A20)","v":0.15360000000000007}]
[2,0.15359999999999996,null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A21)*FACT($E$9-A21))*$E$10^A21*(1-$E$10)^($E$9-A21)","v":2.5600000000000008E-2},{"$f":"COMBIN($E$9,A21)*$E$10^A21*(1-$E$10)^($E$9-A21)","v":2.5600000000000008E-2}]
[3,2.5600000000000005E-2,null,null,null,null,null,null,null,null,{"$f":"FACT($E$9)/(FACT(A22)*FACT($E$9-A22))*$E$10^A22*(1-$E$10)^($E$9-A22)","v":1.6000000000000007E-3},{"$f":"COMBIN($E$9,A22)*$E$10^A22*(1-$E$10)^($E$9-A22)","v":1.6000000000000007E-3}]
[4,1.6000000000000005E-3,null,null,null,null,null,null,null,"Total",{"$f":"SUM(K17:K21)","v":1.0000000000000004},{"$f":"SUM(L17:L21)","v":1.0000000000000004}]
["Total",{"$f":"SUM(B18:B22)","v":0.99999999999999989}]
[]
["P(x) = f(x)","P(x) = f(x)","SUM","X"]
[{"$f":"\"P(x = \"&D26&\")\"","v":"P(x = 3)"},{"$f":"_xlfn.BINOM.DIST(D26,E9,E10,0)","v":2.5600000000000005E-2},{"$f":"B21","v":2.5600000000000005E-2},3]
[{"$f":"\"P(x <= \"&D30&\")\"","v":"P(x <= 3)"},{"$f":"_xlfn.BINOM.DIST(D27,E9,E10,1)","v":0.99839999999999995},{"$f":"SUM(B18:B21)","v":0.99839999999999984},3]
[{"$f":"\"P(x > \"&D28&\")\"","v":"P(x > 3)"},{"$f":"1-_xlfn.BINOM.DIST(D28,E9,E10,1)","v":1.6000000000000458E-3},{"$f":"B22","v":1.6000000000000005E-3},3]
[{"$f":"\"P(x >= \"&D27&\")\"","v":"P(x >= 3)"},{"$f":"1-_xlfn.BINOM.DIST(D29-1,E9,E10,1)","v":2.7200000000000002E-2},{"$f":"SUM(B21:B22)","v":2.7200000000000005E-2},3]
[{"$f":"\"P(x < \"&D29&\")\"","v":"P(x < 3)"},{"$f":"_xlfn.BINOM.DIST(D30-1,E9,E10,1)","v":0.9728},{"$f":"SUM(B18:B20)","v":0.97279999999999989},3]

{"sheet":"B(2)","index":18,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["A flight from Oakland to Seattle occurs 6 times per day. The probability that any 1 flight is late is 10%. "]
["What is the probability that exactly 2 planes are late? Less than 2 are late? What is the mean and standard deviation?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,null,null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = , p = "}]
[2,"Each trial only results in S or F"]
[3,"p remains the same for each trial"]
[4,"All events are independent"]
[]
["n = # of Fixed Trials =# flights"]
["p = Prob of Success ="]
[{"$f":"\"Random Discrete Variable = x = Planes Late in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Planes Late in  Tries"}]
["Mean = µ = E(x) = Expected Value ="]
["Standard Deviation = s ="]
[]
["X","P(x) = f(x)",null,"P(x) = f(x)","P(x) = f(x)","SUM","X"]
[0,null,null,{"$f":"\"P(x = \"&G16&\")\"","v":"P(x = 2)"},null,null,2]
[1,null,null,{"$f":"\"P(x <= \"&G18&\")\"","v":"P(x <= 2)"},null,null,2]
[2,null,null,{"$f":"\"P(x < \"&G19&\")\"","v":"P(x < 2)"},null,null,2]
[3,null,null,{"$f":"\"P(x >= \"&G17&\")\"","v":"P(x >= 2)"},null,null,2]
[4,null,null,{"$f":"\"P(x > \"&G20&\")\"","v":"P(x > 2)"},null,null,2]
[5]
[6]
["Total"]

{"sheet":"B(2an)","index":19,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["A flight from Oakland to Seattle occurs 6 times per day. The probability that any 1 flight is late is 10%. "]
["What is the probability that exactly 2 planes are late? Less than 2 are late? What is the mean and standard deviation?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 6, p = 0.1"}]
[2,"Each trial only results in S or F",null,null,"Yes"]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials =# flights",null,null,null,6]
["p = Prob of Success =",null,null,null,0.1]
[{"$f":"\"Random Discrete Variable = x = Planes Late in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Planes Late in 6 Tries"}]
["Mean = µ = E(x) = Expected Value =",null,null,null,{"$f":"E9*E10","v":0.60000000000000009}]
["Standard Deviation = s =",null,null,null,{"$f":"SQRT(E12*(1-E10))","v":0.73484692283495356},null,{"$f":"SQRT(SUMPRODUCT((A16:A22-E12)^2,B16:B22))","v":0.73484692283495345}]
[]
["X","P(x) = f(x)",null,"P(x) = f(x)","P(x) = f(x)","SUM","X"]
[0,{"$f":"_xlfn.BINOM.DIST(A16,$E$9,$E$10,0)","v":0.53144100000000005},null,{"$f":"\"P(x = \"&G16&\")\"","v":"P(x = 2)"},{"$f":"_xlfn.BINOM.DIST(G16,E9,E10,0)","v":9.8415000000000002E-2},{"$f":"B18","v":9.8415000000000002E-2},2]
[1,{"$f":"_xlfn.BINOM.DIST(A17,$E$9,$E$10,0)","v":0.354294},null,{"$f":"\"P(x <= \"&G18&\")\"","v":"P(x <= 2)"},{"$f":"_xlfn.BINOM.DIST(G17,E9,E10,1)","v":0.98414999999999997},{"$f":"SUM(B16:B18)","v":0.98415000000000008},2]
[2,9.8415000000000002E-2,null,{"$f":"\"P(x < \"&G19&\")\"","v":"P(x < 2)"},{"$f":"_xlfn.BINOM.DIST(G18-1,E9,E10,1)","v":0.88573499999999994},{"$f":"SUM(B16:B17)","v":0.88573500000000005},2]
[3,1.4580000000000011E-2,null,{"$f":"\"P(x >= \"&G17&\")\"","v":"P(x >= 2)"},{"$f":"1-_xlfn.BINOM.DIST(G19-1,E9,E10,1)","v":0.11426500000000006},{"$f":"SUM(B18:B22)","v":0.11426500000000002},2]
[4,1.2150000000000012E-3,null,{"$f":"\"P(x > \"&G20&\")\"","v":"P(x > 2)"},{"$f":"1-_xlfn.BINOM.DIST(G20,E9,E10,1)","v":1.5850000000000031E-2},{"$f":"SUM(B19:B22)","v":1.5850000000000013E-2},2]
[5,5.3999999999999998E-5]
[6,1.0000000000000004E-6]
["Total",{"$f":"SUM(B16:B22)","v":1}]

{"sheet":"B(3)","index":20,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["The probability of getting stuck in traffic on the West Seattle Bridge in the morning is 0.15."]
["Over the next two weeks (10 workdays), what is probability that you will get stuck in traffic 0 times? 1 Time?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,null,null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = , p = "}]
[2,"Each trial only results in S or F"]
[3,"p remains the same for each trial"]
[4,"All events are independent"]
[]
["n = # of Fixed Trials = # drive on bridge"]
["p = Prob of Success ="]
[{"$f":"\"Random Discrete Variable = x = Stuck In Traffic in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Stuck In Traffic in  Tries"}]
["Mean = µ = E(x) = Expected Value ="]
[]
["X","P(x) = f(x)"]
[0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
["Total"]

{"sheet":"B(3an)","index":21,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["The probability of getting stuck in traffic on the West Seattle Bridge in the morning is 0.15."]
["Over the next two weeks (10 workdays), what is probability that you will get stuck in traffic 0 times? 1 Time?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,{"$f":"\"Binomial Distribution, n = \"&E9&\", p = \"&E10","v":"Binomial Distribution, n = 10, p = 0.15"}]
[2,"Each trial only results in S or F",null,null,"Yes"]
[3,"p remains the same for each trial",null,null,"Yes"]
[4,"All events are independent",null,null,"Yes"]
[]
["n = # of Fixed Trials = # drive on bridge",null,null,null,10]
["p = Prob of Success =",null,null,null,0.15]
[{"$f":"\"Random Discrete Variable = x = Stuck In Traffic in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = Stuck In Traffic in 10 Tries"}]
["Mean = µ = E(x) = Expected Value =",null,null,null,{"$f":"E9*E10","v":1.5}]
[]
["X","P(x) = f(x)"]
[0,{"$f":"_xlfn.BINOM.DIST(A15,$E$9,$E$10,0)","v":0.1968744043407227}]
[1,{"$f":"_xlfn.BINOM.DIST(A16,$E$9,$E$10,0)","v":0.3474254194248047}]
[2,0.27589665660205087]
[3,0.12983372075390626]
[4,4.0095707879882835E-2]
[5,8.4908557863281192E-3]
[6,1.2486552626953143E-3]
[7,1.2591481640624995E-4]
[8,8.3325981445312545E-6]
[9,3.267685546874998E-7]
[10,5.7665039062500008E-9]
["Total",{"$f":"SUM(B15:B25)","v":1}]

{"sheet":"B(4)","index":22,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Highline found that 16.00% of its students withdraw from Accounting 202."]
["In the current class that has 35 students enrolled, what is the probability that between 3 and 7 students withdraw? What is the mean?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,"X","P(x) = f(x)"]
[2,"Each trial only results in S or F",null,null,"Yes",null,0,{"$f":"_xlfn.BINOM.DIST(G5,$E$9,$E$10,0)","v":2.237561661310864E-3}]
[3,"p remains the same for each trial",null,null,"Yes",null,1,{"$f":"_xlfn.BINOM.DIST(G6,$E$9,$E$10,0)","v":1.4917077742072401E-2}]
[4,"All events are independent",null,null,"Yes",null,2,4.8302918402901164E-2]
[null,null,null,null,null,null,3,0.10120611474893576]
["n = # of Fixed Trials = Appointments",null,null,null,35,null,4,0.1542188415221879]
["p = Prob of Success =",null,null,null,0.16,null,5,0.18212510808334575]
[{"$f":"\"Random Discrete Variable = x = withdraw from class in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = withdraw from class in 35 Tries"},null,null,null,null,null,6,0.17345248388890069]
["Mean = µ = E(x) = Expected Value =",null,null,null,null,null,7,0.13687406891913259]
[null,null,null,null,null,null,8,9.1249379279421713E-2]
[null,3,7,"P(3 <= X <= 7)",null,null,9,5.214250244538389E-2]
[null,null,null,null,null,null,10,2.5822953591999594E-2]
[null,null,null,null,null,null,11,1.1178767788744425E-2]
[null,null,null,null,null,null,12,4.2585782052359696E-3]
[null,null,null,null,null,null,13,1.4351252559769558E-3]
[null,null,null,null,null,null,14,4.2956130110874928E-4]
[null,null,null,null,null,null,15,1.1454968029566635E-4]
[null,null,null,null,null,null,16,2.7273733403730106E-5]
[null,null,null,null,null,null,17,5.8061729374887625E-6]
[null,null,null,null,null,null,18,1.1059377023788146E-6]
[null,null,null,null,null,null,19,1.8848061093172766E-7]
[null,null,null,null,null,null,20,2.8720854999120366E-8]
[null,null,null,null,null,null,21,3.9075993196082252E-9]
[null,null,null,null,null,null,22,4.7364840237675317E-10]
[null,null,null,null,null,null,23,5.0993202740354349E-11]
[null,null,null,null,null,null,24,4.8564954990813856E-12]
[null,null,null,null,null,null,25,4.070205751611065E-13]
[null,null,null,null,null,null,26,2.9818357154659719E-14]
[null,null,null,null,null,null,27,1.8932290256926889E-15]
[null,null,null,null,null,null,28,1.0303287214654029E-16]
[null,null,null,null,null,null,29,4.7371435469673773E-18]
[null,null,null,null,null,null,30,1.8046261131304366E-19]
[null,null,null,null,null,null,33,2.2857828267064335E-24]
[null,null,null,null,null,null,34,2.5611012063937432E-26]
[null,null,null,null,null,null,35,1.3937965749081525E-28]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H38)","v":0.99999999999999978}]

{"sheet":"B(4an)","index":23,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Highline found that 16.00% of its students withdraw from Accounting 202."]
["In the current class that has 35 students enrolled, what is the probability that between 3 and 7 students withdraw? What is the mean?"]
["Binomial Experiment?"]
[1,"Fixed # of Identical Trials = n",null,null,"Yes",null,"X","P(x) = f(x)"]
[2,"Each trial only results in S or F",null,null,"Yes",null,0,{"$f":"_xlfn.BINOM.DIST(G5,$E$9,$E$10,0)","v":2.237561661310864E-3}]
[3,"p remains the same for each trial",null,null,"Yes",null,1,{"$f":"_xlfn.BINOM.DIST(G6,$E$9,$E$10,0)","v":1.4917077742072401E-2}]
[4,"All events are independent",null,null,"Yes",null,2,4.8302918402901164E-2]
[null,null,null,null,null,null,3,0.10120611474893576]
["n = # of Fixed Trials = Appointments",null,null,null,35,null,4,0.1542188415221879]
["p = Prob of Success =",null,null,null,0.16,null,5,0.18212510808334575]
[{"$f":"\"Random Discrete Variable = x = withdraw from class in \"&E9&\" Tries\"","v":"Random Discrete Variable = x = withdraw from class in 35 Tries"},null,null,null,null,null,6,0.17345248388890069]
["Mean = µ = E(x) = Expected Value =",null,null,null,{"$f":"E9*E10","v":5.6000000000000005},null,7,0.13687406891913259]
[null,null,null,null,null,null,8,9.1249379279421713E-2]
[null,3,7,"P(3 <= X <= 7)",{"$f":"_xlfn.BINOM.DIST(C14,E9,E10,1)-_xlfn.BINOM.DIST(B14-1,E9,E10,1)","v":0.74787661716250275},null,9,5.214250244538389E-2]
[null,null,null,null,null,null,10,2.5822953591999594E-2]
[null,null,null,null,null,null,11,1.1178767788744425E-2]
[null,null,null,null,null,null,12,4.2585782052359696E-3]
[null,null,null,null,null,null,13,1.4351252559769558E-3]
[null,null,null,null,null,null,14,4.2956130110874928E-4]
[null,null,null,null,null,null,15,1.1454968029566635E-4]
[null,null,null,null,null,null,16,2.7273733403730106E-5]
[null,null,null,null,null,null,17,5.8061729374887625E-6]
[null,null,null,null,null,null,18,1.1059377023788146E-6]
[null,null,null,null,null,null,19,1.8848061093172766E-7]
[null,null,null,null,null,null,20,2.8720854999120366E-8]
[null,null,null,null,null,null,21,3.9075993196082252E-9]
[null,null,null,null,null,null,22,4.7364840237675317E-10]
[null,null,null,null,null,null,23,5.0993202740354349E-11]
[null,null,null,null,null,null,24,4.8564954990813856E-12]
[null,null,null,null,null,null,25,4.070205751611065E-13]
[null,null,null,null,null,null,26,2.9818357154659719E-14]
[null,null,null,null,null,null,27,1.8932290256926889E-15]
[null,null,null,null,null,null,28,1.0303287214654029E-16]
[null,null,null,null,null,null,29,4.7371435469673773E-18]
[null,null,null,null,null,null,30,1.8046261131304366E-19]
[null,null,null,null,null,null,33,2.2857828267064335E-24]
[null,null,null,null,null,null,34,2.5611012063937432E-26]
[null,null,null,null,null,null,35,1.3937965749081525E-28]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H38)","v":0.99999999999999978}]

{"sheet":"B(5)","index":24,"n_rows":85,"n_cols":5,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["n",10,null,null,{"$f":"\"Binomial Distribution, n = \"&B1&\" p = \"&B2","v":"Binomial Distribution, n = 10 p = 0.1"}]
["p",0.1]
[]
[]
["X","p(x)"]
[{"$f":"IF(ROWS(A$6:A6)<=$B$1+1,ROWS(A$6:A6)-1,\"\")","v":0},{"$f":"IF(ROWS(A$6:A6)<=$B$1+1,_xlfn.BINOM.DIST(A6,$B$1,$B$2,0),\"\")","v":0.34867844009999993}]
[{"$f":"IF(ROWS(A$6:A7)<=$B$1+1,ROWS(A$6:A7)-1,\"\")","v":1},{"$f":"IF(ROWS(A$6:A7)<=$B$1+1,_xlfn.BINOM.DIST(A7,$B$1,$B$2,0),\"\")","v":0.38742048899999998}]
[{"$f":"IF(ROWS(A$6:A8)<=$B$1+1,ROWS(A$6:A8)-1,\"\")","v":2},{"$f":"IF(ROWS(A$6:A8)<=$B$1+1,_xlfn.BINOM.DIST(A8,$B$1,$B$2,0),\"\")","v":0.19371024450000005}]
[{"$f":"IF(ROWS(A$6:A9)<=$B$1+1,ROWS(A$6:A9)-1,\"\")","v":3},{"$f":"IF(ROWS(A$6:A9)<=$B$1+1,_xlfn.BINOM.DIST(A9,$B$1,$B$2,0),\"\")","v":5.739562799999999E-2}]
[{"$f":"IF(ROWS(A$6:A10)<=$B$1+1,ROWS(A$6:A10)-1,\"\")","v":4},{"$f":"IF(ROWS(A$6:A10)<=$B$1+1,_xlfn.BINOM.DIST(A10,$B$1,$B$2,0),\"\")","v":1.1160261000000003E-2}]
[{"$f":"IF(ROWS(A$6:A11)<=$B$1+1,ROWS(A$6:A11)-1,\"\")","v":5},{"$f":"IF(ROWS(A$6:A11)<=$B$1+1,_xlfn.BINOM.DIST(A11,$B$1,$B$2,0),\"\")","v":1.4880348000000001E-3}]
[{"$f":"IF(ROWS(A$6:A12)<=$B$1+1,ROWS(A$6:A12)-1,\"\")","v":6},{"$f":"IF(ROWS(A$6:A12)<=$B$1+1,_xlfn.BINOM.DIST(A12,$B$1,$B$2,0),\"\")","v":1.3778099999999988E-4}]
[{"$f":"IF(ROWS(A$6:A13)<=$B$1+1,ROWS(A$6:A13)-1,\"\")","v":7},{"$f":"IF(ROWS(A$6:A13)<=$B$1+1,_xlfn.BINOM.DIST(A13,$B$1,$B$2,0),\"\")","v":8.7480000000000084E-6}]
[{"$f":"IF(ROWS(A$6:A14)<=$B$1+1,ROWS(A$6:A14)-1,\"\")","v":8},{"$f":"IF(ROWS(A$6:A14)<=$B$1+1,_xlfn.BINOM.DIST(A14,$B$1,$B$2,0),\"\")","v":3.6450000000000065E-7},null,null,"As n increases, distributions approached Bell"]
[{"$f":"IF(ROWS(A$6:A15)<=$B$1+1,ROWS(A$6:A15)-1,\"\")","v":9},{"$f":"IF(ROWS(A$6:A15)<=$B$1+1,_xlfn.BINOM.DIST(A15,$B$1,$B$2,0),\"\")","v":8.9999999999999962E-9},null,null,"As p approaches 0.5, distributions approached Bell"]
[{"$f":"IF(ROWS(A$6:A16)<=$B$1+1,ROWS(A$6:A16)-1,\"\")","v":10},{"$f":"IF(ROWS(A$6:A16)<=$B$1+1,_xlfn.BINOM.DIST(A16,$B$1,$B$2,0),\"\")","v":1.0000000000000031E-10},null,null,"At p = .5, distribution is Bell"]
[{"$f":"IF(ROWS(A$6:A17)<=$B$1+1,ROWS(A$6:A17)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A17)<=$B$1+1,_xlfn.BINOM.DIST(A17,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A18)<=$B$1+1,ROWS(A$6:A18)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A18)<=$B$1+1,_xlfn.BINOM.DIST(A18,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A19)<=$B$1+1,ROWS(A$6:A19)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A19)<=$B$1+1,_xlfn.BINOM.DIST(A19,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A20)<=$B$1+1,ROWS(A$6:A20)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A20)<=$B$1+1,_xlfn.BINOM.DIST(A20,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A21)<=$B$1+1,ROWS(A$6:A21)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A21)<=$B$1+1,_xlfn.BINOM.DIST(A21,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A22)<=$B$1+1,ROWS(A$6:A22)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A22)<=$B$1+1,_xlfn.BINOM.DIST(A22,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A23)<=$B$1+1,ROWS(A$6:A23)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A23)<=$B$1+1,_xlfn.BINOM.DIST(A23,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A24)<=$B$1+1,ROWS(A$6:A24)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A24)<=$B$1+1,_xlfn.BINOM.DIST(A24,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A25)<=$B$1+1,ROWS(A$6:A25)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A25)<=$B$1+1,_xlfn.BINOM.DIST(A25,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A26)<=$B$1+1,ROWS(A$6:A26)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A26)<=$B$1+1,_xlfn.BINOM.DIST(A26,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A27)<=$B$1+1,ROWS(A$6:A27)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A27)<=$B$1+1,_xlfn.BINOM.DIST(A27,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A28)<=$B$1+1,ROWS(A$6:A28)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A28)<=$B$1+1,_xlfn.BINOM.DIST(A28,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A29)<=$B$1+1,ROWS(A$6:A29)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A29)<=$B$1+1,_xlfn.BINOM.DIST(A29,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A30)<=$B$1+1,ROWS(A$6:A30)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A30)<=$B$1+1,_xlfn.BINOM.DIST(A30,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A31)<=$B$1+1,ROWS(A$6:A31)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A31)<=$B$1+1,_xlfn.BINOM.DIST(A31,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A32)<=$B$1+1,ROWS(A$6:A32)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A32)<=$B$1+1,_xlfn.BINOM.DIST(A32,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A33)<=$B$1+1,ROWS(A$6:A33)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A33)<=$B$1+1,_xlfn.BINOM.DIST(A33,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A34)<=$B$1+1,ROWS(A$6:A34)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A34)<=$B$1+1,_xlfn.BINOM.DIST(A34,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A35)<=$B$1+1,ROWS(A$6:A35)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A35)<=$B$1+1,_xlfn.BINOM.DIST(A35,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A36)<=$B$1+1,ROWS(A$6:A36)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A36)<=$B$1+1,_xlfn.BINOM.DIST(A36,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A37)<=$B$1+1,ROWS(A$6:A37)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A37)<=$B$1+1,_xlfn.BINOM.DIST(A37,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A38)<=$B$1+1,ROWS(A$6:A38)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A38)<=$B$1+1,_xlfn.BINOM.DIST(A38,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A39)<=$B$1+1,ROWS(A$6:A39)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A39)<=$B$1+1,_xlfn.BINOM.DIST(A39,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A40)<=$B$1+1,ROWS(A$6:A40)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A40)<=$B$1+1,_xlfn.BINOM.DIST(A40,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A41)<=$B$1+1,ROWS(A$6:A41)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A41)<=$B$1+1,_xlfn.BINOM.DIST(A41,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A42)<=$B$1+1,ROWS(A$6:A42)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A42)<=$B$1+1,_xlfn.BINOM.DIST(A42,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A43)<=$B$1+1,ROWS(A$6:A43)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A43)<=$B$1+1,_xlfn.BINOM.DIST(A43,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A44)<=$B$1+1,ROWS(A$6:A44)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A44)<=$B$1+1,_xlfn.BINOM.DIST(A44,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A45)<=$B$1+1,ROWS(A$6:A45)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A45)<=$B$1+1,_xlfn.BINOM.DIST(A45,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A46)<=$B$1+1,ROWS(A$6:A46)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A46)<=$B$1+1,_xlfn.BINOM.DIST(A46,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A47)<=$B$1+1,ROWS(A$6:A47)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A47)<=$B$1+1,_xlfn.BINOM.DIST(A47,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A48)<=$B$1+1,ROWS(A$6:A48)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A48)<=$B$1+1,_xlfn.BINOM.DIST(A48,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A49)<=$B$1+1,ROWS(A$6:A49)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A49)<=$B$1+1,_xlfn.BINOM.DIST(A49,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A50)<=$B$1+1,ROWS(A$6:A50)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A50)<=$B$1+1,_xlfn.BINOM.DIST(A50,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A51)<=$B$1+1,ROWS(A$6:A51)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A51)<=$B$1+1,_xlfn.BINOM.DIST(A51,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A52)<=$B$1+1,ROWS(A$6:A52)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A52)<=$B$1+1,_xlfn.BINOM.DIST(A52,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A53)<=$B$1+1,ROWS(A$6:A53)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A53)<=$B$1+1,_xlfn.BINOM.DIST(A53,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A54)<=$B$1+1,ROWS(A$6:A54)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A54)<=$B$1+1,_xlfn.BINOM.DIST(A54,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A55)<=$B$1+1,ROWS(A$6:A55)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A55)<=$B$1+1,_xlfn.BINOM.DIST(A55,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A56)<=$B$1+1,ROWS(A$6:A56)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A56)<=$B$1+1,_xlfn.BINOM.DIST(A56,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A57)<=$B$1+1,ROWS(A$6:A57)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A57)<=$B$1+1,_xlfn.BINOM.DIST(A57,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A58)<=$B$1+1,ROWS(A$6:A58)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A58)<=$B$1+1,_xlfn.BINOM.DIST(A58,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A59)<=$B$1+1,ROWS(A$6:A59)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A59)<=$B$1+1,_xlfn.BINOM.DIST(A59,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A60)<=$B$1+1,ROWS(A$6:A60)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A60)<=$B$1+1,_xlfn.BINOM.DIST(A60,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A61)<=$B$1+1,ROWS(A$6:A61)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A61)<=$B$1+1,_xlfn.BINOM.DIST(A61,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A62)<=$B$1+1,ROWS(A$6:A62)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A62)<=$B$1+1,_xlfn.BINOM.DIST(A62,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A63)<=$B$1+1,ROWS(A$6:A63)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A63)<=$B$1+1,_xlfn.BINOM.DIST(A63,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A64)<=$B$1+1,ROWS(A$6:A64)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A64)<=$B$1+1,_xlfn.BINOM.DIST(A64,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A65)<=$B$1+1,ROWS(A$6:A65)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A65)<=$B$1+1,_xlfn.BINOM.DIST(A65,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A66)<=$B$1+1,ROWS(A$6:A66)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A66)<=$B$1+1,_xlfn.BINOM.DIST(A66,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A67)<=$B$1+1,ROWS(A$6:A67)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A67)<=$B$1+1,_xlfn.BINOM.DIST(A67,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A68)<=$B$1+1,ROWS(A$6:A68)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A68)<=$B$1+1,_xlfn.BINOM.DIST(A68,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A69)<=$B$1+1,ROWS(A$6:A69)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A69)<=$B$1+1,_xlfn.BINOM.DIST(A69,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A70)<=$B$1+1,ROWS(A$6:A70)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A70)<=$B$1+1,_xlfn.BINOM.DIST(A70,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A71)<=$B$1+1,ROWS(A$6:A71)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A71)<=$B$1+1,_xlfn.BINOM.DIST(A71,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A72)<=$B$1+1,ROWS(A$6:A72)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A72)<=$B$1+1,_xlfn.BINOM.DIST(A72,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A73)<=$B$1+1,ROWS(A$6:A73)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A73)<=$B$1+1,_xlfn.BINOM.DIST(A73,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A74)<=$B$1+1,ROWS(A$6:A74)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A74)<=$B$1+1,_xlfn.BINOM.DIST(A74,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A75)<=$B$1+1,ROWS(A$6:A75)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A75)<=$B$1+1,_xlfn.BINOM.DIST(A75,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A76)<=$B$1+1,ROWS(A$6:A76)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A76)<=$B$1+1,_xlfn.BINOM.DIST(A76,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A77)<=$B$1+1,ROWS(A$6:A77)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A77)<=$B$1+1,_xlfn.BINOM.DIST(A77,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A78)<=$B$1+1,ROWS(A$6:A78)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A78)<=$B$1+1,_xlfn.BINOM.DIST(A78,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A79)<=$B$1+1,ROWS(A$6:A79)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A79)<=$B$1+1,_xlfn.BINOM.DIST(A79,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A80)<=$B$1+1,ROWS(A$6:A80)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A80)<=$B$1+1,_xlfn.BINOM.DIST(A80,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A81)<=$B$1+1,ROWS(A$6:A81)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A81)<=$B$1+1,_xlfn.BINOM.DIST(A81,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A82)<=$B$1+1,ROWS(A$6:A82)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A82)<=$B$1+1,_xlfn.BINOM.DIST(A82,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A83)<=$B$1+1,ROWS(A$6:A83)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A83)<=$B$1+1,_xlfn.BINOM.DIST(A83,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A84)<=$B$1+1,ROWS(A$6:A84)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A84)<=$B$1+1,_xlfn.BINOM.DIST(A84,$B$1,$B$2,0),\"\")","v":""}]
[{"$f":"IF(ROWS(A$6:A85)<=$B$1+1,ROWS(A$6:A85)-1,\"\")","v":""},{"$f":"IF(ROWS(A$6:A85)<=$B$1+1,_xlfn.BINOM.DIST(A85,$B$1,$B$2,0),\"\")","v":""}]