{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Defining Function","Sheet3"],"not_rendered":{"charts":1,"macros":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[27,2,27,3]]}
[null,"  A Function and its Inverse"]
[]
[null,"This graphing utility produces the graph "]
[null," of any increasing or decreasing function"]
[{"$nulls":3},"y = f(x)"]
[null,"along with the graph of the inverse function"]
[null,"     on any interval from x = a  to x = b."]
[]
["  Enter the function in terms of x:   f(x)  =",{"$nulls":4},"x^3"]
[]
[]
["Now enter the interval for x:  "]
[null,null,"xMin =",0]
[null,null,"xMax =",2]
[]
[null,{"$f":"IF(Sheet2!I106=\"OK\",\"\",\"This function is not strictly increasing or decreasing on this interval\")","v":""}]
[null,null,{"$f":"IF(Sheet2!I106=\"OK\",\"\",\"so it does not have an inverse on this interval\")","v":""}]
[]
[{"$nulls":9},"The graph of the function y = f(x) =",{"$nulls":3},{"$f":"F9","v":"x^3"}]
["Click each item below for suggestions and investigations",{"$nulls":8},{"$f":"IF(Sheet2!I106=\"OK\",\"                    and its inverse \",\"\")","v":"                    and its inverse "},null,null,"f -1"]
[null,"   Item 1"]
[null,"   Item 2"]
[null,"   Item 3"]
[]
[]
[]
["To access/download all the DIGMath Apps for Calculus"]
["      Click this link:",null,"DIGMath for Calculus"]
[]
["Created by:  Sheldon P. Gordon   "]
["                      Farmingdale State College    "]
["Development of this module was supported by the "]
["NSF's Division of Undergraduate Education  "]
["under grants DUE-0310123 and DUE-0442160."]

{"sheet":"Sheet2","index":1,"n_rows":106,"n_cols":9,"rows_kept":106}
[null,null,"x","y = f(x)","x^-1","y^-1","IncreasingDecreasing"]
[{"$nulls":3},{"$f":"Sheet1!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Sheet1!D13","v":0},{"$f":"x^3","v":0},{"$f":"IF($I$106=\"OK\",D3,D$3)","v":0},{"$f":"IF($I$106=\"OK\",C3,C$3)","v":0}]
[null,null,{"$f":"C3+Sheet2!B$12","v":0.019801980198019802},7.7647211834211556E-6,{"$f":"IF($I$106=\"OK\",D4,D$3)","v":7.7647211834211556E-6},{"$f":"IF($I$106=\"OK\",C4,C$3)","v":0.019801980198019802},{"$f":"IF(D4>=D3,0,1)","v":0},{"$f":"IF(D4<=D3,0,1)","v":1}]
[null,null,{"$f":"C4+Sheet2!B$12","v":0.039603960396039604},6.2117769467369245E-5,6.2117769467369245E-5,{"$f":"IF($I$106=\"OK\",C5,C$3)","v":0.039603960396039604},{"$f":"IF(D5>=D4,0,1)","v":0},{"$f":"IF(D5<=D4,0,1)","v":1}]
[null,null,{"$f":"C5+Sheet2!B$12","v":0.0594059405940594},2.0964747195237118E-4,2.0964747195237118E-4,{"$f":"IF($I$106=\"OK\",C6,C$3)","v":0.0594059405940594},0,1]
[null,null,{"$f":"C6+Sheet2!B$12","v":0.07920792079207921},0.000496942155738954,0.000496942155738954,{"$f":"IF($I$106=\"OK\",C7,C$3)","v":0.07920792079207921},0,1]
[null,null,{"$f":"C7+Sheet2!B$12","v":0.09900990099009901},9.7059014792764465E-4,9.7059014792764465E-4,0.09900990099009901,0,1]
[null,null,{"$f":"C8+Sheet2!B$12","v":0.11881188118811882},0.00167717977561897,0.00167717977561897,0.11881188118811882,0,1]
[null,null,{"$f":"C9+Sheet2!B$12","v":0.13861386138613863},0.002663299365913457,0.002663299365913457,0.13861386138613863,0,1]
[null,null,{"$f":"C10+Sheet2!B$12","v":0.15841584158415842},0.003975537245911632,0.003975537245911632,0.15841584158415842,0,1]
["delta x = ",{"$f":"(Sheet1!D14-Sheet1!D13)/101","v":0.019801980198019802},{"$f":"C11+Sheet2!B$12","v":0.1782178217821782},5.6604817427140216E-3,5.6604817427140216E-3,0.1782178217821782,0,1]
[null,null,{"$f":"C12+Sheet2!B$12","v":0.198019801980198},0.007764721183421153,0.007764721183421153,0.198019801980198,0,1]
[null,null,{"$f":"C13+Sheet2!B$12","v":0.2178217821782178},0.010334843895133554,0.010334843895133554,0.2178217821782178,0,1]
[null,null,{"$f":"C14+Sheet2!B$12","v":0.23762376237623759},0.01341743820495175,0.01341743820495175,0.23762376237623759,0,1]
[null,null,{"$f":"C15+Sheet2!B$12","v":0.2574257425742574},0.017059092439976272,0.017059092439976272,0.2574257425742574,0,1]
[null,null,{"$f":"C16+Sheet2!B$12","v":0.2772277227722772},0.021306394927307643,0.021306394927307643,0.2772277227722772,0,1]
[null,null,{"$f":"C17+Sheet2!B$12","v":0.297029702970297},0.026205933994046395,0.026205933994046395,0.297029702970297,0,1]
[null,null,{"$f":"C18+Sheet2!B$12","v":0.31683168316831684},0.03180429796729305,0.03180429796729305,0.31683168316831684,0,1]
[null,null,{"$f":"C19+Sheet2!B$12","v":0.33663366336633666},0.038148075174148144,0.038148075174148144,0.33663366336633666,0,1]
[null,null,{"$f":"C20+Sheet2!B$12","v":0.3564356435643565},0.0452838539417122,0.0452838539417122,0.3564356435643565,0,1]
[null,null,{"$f":"C21+Sheet2!B$12","v":0.3762376237623763},0.05325822259708573,0.05325822259708573,0.3762376237623763,0,1]
[null,null,{"$f":"C22+Sheet2!B$12","v":0.3960396039603961},0.06211776946736928,0.06211776946736928,0.3960396039603961,0,1]
[null,null,{"$f":"C23+Sheet2!B$12","v":0.41584158415841593},0.07190908287966337,0.07190908287966337,0.41584158415841593,0,1]
[null,null,{"$f":"C24+Sheet2!B$12","v":0.43564356435643575},0.08267875116106853,0.08267875116106853,0.43564356435643575,0,1]
[null,null,{"$f":"C25+Sheet2!B$12","v":0.4554455445544556},0.09447336263868528,0.09447336263868528,0.4554455445544556,0,1]
[null,null,{"$f":"C26+Sheet2!B$12","v":0.4752475247524754},0.10733950563961416,0.10733950563961416,0.4752475247524754,0,1]
[null,null,{"$f":"C27+Sheet2!B$12","v":0.4950495049504952},0.12132376849095568,0.12132376849095568,0.4950495049504952,0,1]
[null,null,{"$f":"C28+Sheet2!B$12","v":0.514851485148515},0.13647273951981034,0.13647273951981034,0.514851485148515,0,1]
[null,null,{"$f":"C29+Sheet2!B$12","v":0.5346534653465348},0.15283300705327874,0.15283300705327874,0.5346534653465348,0,1]
[null,null,{"$f":"C30+Sheet2!B$12","v":0.5544554455445546},0.17045115941846137,0.17045115941846137,0.5544554455445546,0,1]
[null,null,{"$f":"C31+Sheet2!B$12","v":0.5742574257425744},0.1893737849424587,0.1893737849424587,0.5742574257425744,0,1]
[null,null,{"$f":"C32+Sheet2!B$12","v":0.5940594059405943},0.2096474719523714,0.2096474719523714,0.5940594059405943,0,1]
[null,null,{"$f":"C33+Sheet2!B$12","v":0.6138613861386141},0.2313188087752999,0.2313188087752999,0.6138613861386141,0,1]
[null,null,{"$f":"C34+Sheet2!B$12","v":0.6336633663366339},{"$f":"x^3","v":0.2544343837383447},0.2544343837383447,0.6336633663366339,0,1]
[null,null,{"$f":"C35+Sheet2!B$12","v":0.6534653465346537},0.27904078516860636,0.27904078516860636,0.6534653465346537,0,1]
[null,null,{"$f":"C36+Sheet2!B$12","v":0.6732673267326735},0.30518460139318543,0.30518460139318543,0.6732673267326735,0,1]
[null,null,{"$f":"C37+Sheet2!B$12","v":0.6930693069306934},0.3329124207391824,0.3329124207391824,0.6930693069306934,0,1]
[null,null,{"$f":"C38+Sheet2!B$12","v":0.7128712871287132},0.36227083153369793,0.36227083153369793,0.7128712871287132,0,1]
[null,null,{"$f":"C39+Sheet2!B$12","v":0.732673267326733},0.3933064221038323,0.3933064221038323,0.732673267326733,0,1]
[null,null,{"$f":"C40+Sheet2!B$12","v":0.7524752475247528},0.4260657807766862,0.4260657807766862,0.7524752475247528,0,1]
[null,null,{"$f":"C41+Sheet2!B$12","v":0.7722772277227726},0.46059549587936016,0.46059549587936016,0.7722772277227726,0,1]
[null,null,{"$f":"C42+Sheet2!B$12","v":0.7920792079207924},0.4969421557389546,0.4969421557389546,0.7920792079207924,0,1]
[null,null,{"$f":"C43+Sheet2!B$12","v":0.8118811881188123},0.5351523486825702,0.5351523486825702,0.8118811881188123,0,1]
[null,null,{"$f":"C44+Sheet2!B$12","v":0.8316831683168321},0.5752726630373075,0.5752726630373075,0.8316831683168321,0,1]
[null,null,{"$f":"C45+Sheet2!B$12","v":0.8514851485148519},0.6173496871302667,0.6173496871302667,0.8514851485148519,0,1]
[null,null,{"$f":"C46+Sheet2!B$12","v":0.8712871287128717},0.6614300092885487,0.6614300092885487,0.8712871287128717,0,1]
[null,null,{"$f":"C47+Sheet2!B$12","v":0.8910891089108915},0.7075602178392538,0.7075602178392538,0.8910891089108915,0,1]
[null,null,{"$f":"C48+Sheet2!B$12","v":0.9108910891089114},0.7557869011094828,0.7557869011094828,0.9108910891089114,0,1]
[null,null,{"$f":"C49+Sheet2!B$12","v":0.9306930693069312},0.806156647426336,0.806156647426336,0.9306930693069312,0,1]
[null,null,{"$f":"C50+Sheet2!B$12","v":0.950495049504951},0.8587160451169138,0.8587160451169138,0.950495049504951,0,1]
[null,null,{"$f":"C51+Sheet2!B$12","v":0.9702970297029708},0.913511682508317,0.913511682508317,0.9702970297029708,0,1]
[null,null,{"$f":"C52+Sheet2!B$12","v":0.9900990099009906},0.970590147927646,0.970590147927646,0.9900990099009906,0,1]
[null,null,{"$f":"C53+Sheet2!B$12","v":1.0099009900990104},1.029998029702001,1.029998029702001,1.0099009900990104,0,1]
[null,null,{"$f":"C54+Sheet2!B$12","v":1.0297029702970302},1.0917819161584834,1.0917819161584834,1.0297029702970302,0,1]
[null,null,{"$f":"C55+Sheet2!B$12","v":1.04950495049505},1.155988395624193,1.155988395624193,1.04950495049505,0,1]
[null,null,{"$f":"C56+Sheet2!B$12","v":1.0693069306930698},1.2226640564262305,1.2226640564262305,1.0693069306930698,0,1]
[null,null,{"$f":"C57+Sheet2!B$12","v":1.0891089108910896},1.2918554868916967,1.2918554868916967,1.0891089108910896,0,1]
[null,null,{"$f":"C58+Sheet2!B$12","v":1.1089108910891095},1.3636092753476916,1.3636092753476916,1.1089108910891095,0,1]
[null,null,{"$f":"C59+Sheet2!B$12","v":1.1287128712871293},1.4379720101213163,1.4379720101213163,1.1287128712871293,0,1]
[null,null,{"$f":"C60+Sheet2!B$12","v":1.148514851485149},1.5149902795396708,1.5149902795396708,1.148514851485149,0,1]
[null,null,{"$f":"C61+Sheet2!B$12","v":1.168316831683169},1.5947106719298558,1.5947106719298558,1.168316831683169,0,1]
[null,null,{"$f":"C62+Sheet2!B$12","v":1.1881188118811887},1.6771797756189721,1.6771797756189721,1.1881188118811887,0,1]
[null,null,{"$f":"C63+Sheet2!B$12","v":1.2079207920792085},1.76244417893412,1.76244417893412,1.2079207920792085,0,1]
[null,null,{"$f":"C64+Sheet2!B$12","v":1.2277227722772284},1.8505504702024,1.8505504702024,1.2277227722772284,0,1]
[null,null,{"$f":"C65+Sheet2!B$12","v":1.2475247524752482},1.9415452377509128,1.9415452377509128,1.2475247524752482,0,1]
[null,null,{"$f":"C66+Sheet2!B$12","v":1.267326732673268},{"$f":"x^3","v":2.0354750699067585},2.0354750699067585,1.267326732673268,0,1]
[null,null,{"$f":"C67+Sheet2!B$12","v":1.2871287128712878},2.132386554997038,{"$f":"IF($I$106=\"OK\",D68,D$3)","v":2.132386554997038},1.2871287128712878,0,1]
[null,null,{"$f":"C68+Sheet2!B$12","v":1.3069306930693076},2.2323262813488522,2.2323262813488522,1.3069306930693076,{"$f":"IF(D69>=D68,0,1)","v":0},{"$f":"IF(D69<=D68,0,1)","v":1}]
[null,null,{"$f":"C69+Sheet2!B$12","v":1.3267326732673275},2.335340837289301,2.335340837289301,1.3267326732673275,0,1]
[null,null,{"$f":"C70+Sheet2!B$12","v":1.3465346534653473},2.4414768111454848,2.4414768111454848,{"$f":"IF($I$106=\"OK\",C71,C$3)","v":1.3465346534653473},0,1]
[null,null,{"$f":"C71+Sheet2!B$12","v":1.366336633663367},2.5507807912445046,2.5507807912445046,1.366336633663367,0,1]
[null,null,{"$f":"C72+Sheet2!B$12","v":1.386138613861387},2.6632993659134607,2.6632993659134607,1.386138613861387,0,1]
[null,null,{"$f":"C73+Sheet2!B$12","v":1.4059405940594067},2.779079123479454,2.779079123479454,1.4059405940594067,0,1]
[null,null,{"$f":"C74+Sheet2!B$12","v":1.4257425742574266},2.8981666522695844,2.8981666522695844,1.4257425742574266,0,1]
[null,null,{"$f":"C75+Sheet2!B$12","v":1.4455445544554464},3.020608540610953,3.020608540610953,1.4455445544554464,0,1]
[null,null,{"$f":"C76+Sheet2!B$12","v":1.4653465346534662},3.14645137683066,3.14645137683066,1.4653465346534662,0,1]
[null,null,{"$f":"C77+Sheet2!B$12","v":1.485148514851486},3.2757417492558054,3.2757417492558054,1.485148514851486,0,1]
[null,null,{"$f":"C78+Sheet2!B$12","v":1.5049504950495058},3.408526246213491,3.408526246213491,1.5049504950495058,0,1]
[null,null,{"$f":"C79+Sheet2!B$12","v":1.5247524752475257},3.5448514560308166,3.5448514560308166,1.5247524752475257,0,1]
[null,null,{"$f":"C80+Sheet2!B$12","v":1.5445544554455455},3.6847639670348826,3.6847639670348826,1.5445544554455455,0,1]
[null,null,{"$f":"C81+Sheet2!B$12","v":1.5643564356435653},3.82831036755279,3.82831036755279,1.5643564356435653,0,1]
[null,null,{"$f":"C82+Sheet2!B$12","v":1.5841584158415851},3.9755372459116387,3.9755372459116387,1.5841584158415851,0,1]
[null,null,{"$f":"C83+Sheet2!B$12","v":1.603960396039605},4.12649119043853,4.12649119043853,1.603960396039605,0,1]
[null,null,{"$f":"C84+Sheet2!B$12","v":1.6237623762376248},4.281218789460564,4.281218789460564,1.6237623762376248,0,1]
[null,null,{"$f":"C85+Sheet2!B$12","v":1.6435643564356446},4.439766631304841,4.439766631304841,1.6435643564356446,0,1]
[null,null,{"$f":"C86+Sheet2!B$12","v":1.6633663366336644},4.602181304298461,4.602181304298461,1.6633663366336644,0,1]
[null,null,{"$f":"C87+Sheet2!B$12","v":1.6831683168316842},4.768509396768526,4.768509396768526,1.6831683168316842,0,1]
[null,null,{"$f":"C88+Sheet2!B$12","v":1.702970297029704},4.938797497042136,4.938797497042136,1.702970297029704,0,1]
[null,null,{"$f":"C89+Sheet2!B$12","v":1.7227722772277239},5.11309219344639,5.11309219344639,1.7227722772277239,0,1]
[null,null,{"$f":"C90+Sheet2!B$12","v":1.7425742574257437},5.291440074308392,5.291440074308392,1.7425742574257437,0,1]
[null,null,{"$f":"C91+Sheet2!B$12","v":1.7623762376237635},5.473887727955239,5.473887727955239,1.7623762376237635,0,1]
[null,null,{"$f":"C92+Sheet2!B$12","v":1.7821782178217833},5.660481742714033,5.660481742714033,1.7821782178217833,0,1]
[null,null,{"$f":"C93+Sheet2!B$12","v":1.8019801980198031},5.851268706911875,5.851268706911875,1.8019801980198031,0,1]
[null,null,{"$f":"C94+Sheet2!B$12","v":1.821782178217823},6.046295208875865,6.046295208875865,1.821782178217823,0,1]
[null,null,{"$f":"C95+Sheet2!B$12","v":1.8415841584158428},6.245607836933103,6.245607836933103,1.8415841584158428,0,1]
[null,null,{"$f":"C96+Sheet2!B$12","v":1.8613861386138626},6.4492531794106895,6.4492531794106895,1.8613861386138626,0,1]
[null,null,{"$f":"C97+Sheet2!B$12","v":1.8811881188118824},6.6572778246357265,6.6572778246357265,1.8811881188118824,0,1]
[null,null,{"$f":"C98+Sheet2!B$12","v":1.9009900990099022},{"$f":"x^3","v":6.869728360935313},6.869728360935313,1.9009900990099022,0,1]
[null,null,{"$f":"C99+Sheet2!B$12","v":1.920792079207922},7.08665137663655,7.08665137663655,1.920792079207922,0,1]
[null,null,{"$f":"C100+Sheet2!B$12","v":1.9405940594059419},7.308093460066539,7.308093460066539,1.9405940594059419,0,1]
[null,null,{"$f":"C101+Sheet2!B$12","v":1.9603960396039617},7.534101199552379,7.534101199552379,1.9603960396039617,0,1]
[null,null,{"$f":"C102+Sheet2!B$12","v":1.9801980198019815},7.7647211834211705,7.7647211834211705,1.9801980198019815,0,1]
[null,null,{"$f":"C103+Sheet2!B$12","v":2.0000000000000013},8.000000000000016,8.000000000000016,2.0000000000000013,0,1]
[]
[{"$nulls":6},{"$f":"SUM(G3:G104)","v":0},{"$f":"SUM(H3:H104)","v":101},{"$f":"IF(OR(G106=0,H106=0),\"OK\",\"NO\")","v":"OK"}]

{"sheet":"Defining Function","index":2,"n_rows":12,"n_cols":1,"rows_kept":12}
["                                                     Defining a Function in Excel"]
[]
["Computers have very specific rules you must follow when defining a function.  If you don't, the program will either not work at all or will work incorrectly."]
[]
["1. The Variable used should be the one named in the instruction, usually x, though sometimes y, t, Q (for an angle theta), "]
[" or even x and y (for a function of two variables). "]
[]
["2.  Order of Operations:  There five arithmetic operations, addition (+), subtraction (-), multiplication (*), division (/), and  exponentiation or power (^).  When computers see any of these operation symbols, they perform the indicated steps in a very particular order.  First, the power is done.  Second, products and quotients of adjacent terms is done.  Third, and last, sums and differences of adjacent terms are done.  So, in 10*x^3 + 5*x – 7, say with x = 2, the first pass only calculates 2^3 and ignores the multiplications and the sums and differences to calculate 2^3 = 8.  The second pass looks at 10*8 + 5*2 – 7 and only does the multiplications, so it produces 80 + 10 -  7.  The third pass looks at the +’s and –‘s to produce 80 + 10 – 7 = 83.  "]
[]
["3.    Parentheses  If you need an operation involving more than two adjacent terms, as in Ö4^3 + 6^2, the computer would take the square root of  4 to produce 2^3 + 6^2;  it would then cube the 2 and square the 6 to produce 8 + 36; and finally it would add the 8 and the 36 to get 44.  If you actually wanted the square root of the entire expression, you would need to use parentheses, as in Ö(4^3 + 6^2) to tell the computer to do all the operations inside the parentheses before taking the square root.  Therefore, it would calculate (4^3 + 6^2) = 64 + 36 = 100 and then take the square root of Ö100  =  10."]
[]
["4.  Built-In Functions  Computer programs have built-in functions for most common algebraic functions.  In Excel, the square root function is denoted by SQRT(…), so SQRT(100) = 10.  Alternatively, you could enter it as 100^.5 or 100^(1/2); notice that parentheses are needed to have the ½ done first.  The common trig functions are SIN (…), COS (…), and TAN (…), where the arguments are automatically interpreted as being in radians, not degrees.  The logarithm to the base 10 is represented by LOG (…) and the logarithm with the base e, known as the natural logarithm, is LN (…). The corresponding exponential function with base e is EXP (x).  If x is the variable, then each of these would be SQRT (x), SIN (x), COS (x), TAN (x), LOG (x) (for log with base 10 ), LN (x) (for log with base e ), and EXP (x)."]

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}