{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Grapher","Example"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Grapher","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[27,0,27,1],[13,2,13,4],[11,2,11,4],[12,2,12,4],[14,0,14,1],[15,0,15,1],[15,2,15,4],[14,2,14,4],[19,0,19,1],[18,0,18,1],[17,0,17,1],[23,0,23,1],[24,0,24,1],[20,0,20,1],[21,0,21,1],[22,0,22,1]]}
["Regression Graph Creator: (Instructions: Enter all information for 1, 2, or 3 regression lines in the yellow highlighted cells.)"]
[]
[null,null,"Line #1","Line #2","Line #3"]
["Enter X Minimum:"]
["Enter X Maximum:"]
["Enter X Mean:"]
["Enter Y Minimum:"]
["Enter Y Maximum:"]
["Enter Slope:"]
["Enter Y-Intercept:"]
["Enter Line Label:"]
["Enter Y axis label:"]
["Enter X axis label:"]
["Enter Graph Title:"]
["Enter minimum Y axis value:"]
["Enter maximum Y axis value:"]
[]
["Calculations:"]
["Predicted Y Minimum:",null,{"$f":" IF(C$10 =\"\",\"\", C$10 + (C$9*C$24))","v":""},{"$f":" IF(D$10 =\"\",\"\", D$10 + (D$9*D$24))","v":""},""]
["Predicted Y Maximum:",null,{"$f":" IF(C$10 =\"\",\"\",C10+(C$9*C$25))","v":""},{"$f":" IF(D$10 =\"\",\"\",D10+(D$9*D$25))","v":""},""]
["Y @ X = 0:",null,{"$f":"C10","v":0},{"$f":"D10","v":0},{"$f":"IF(E$10=\"\",\"\",E$10)","v":""}]
["Y @ X = maximum:",null,{"$f":"C$10 + (C$9*C5)","v":0},{"$f":"D10 + (D9*D5)","v":0},{"$f":"IF(E$10=\"\",\"\",E10 + (E9*E5))","v":""}]
["Y @ X = Mean:",null,{"$f":"C$10 + (C$9*C6)","v":0},{"$f":"D$10 + (D$9*D6)","v":0},{"$f":"IF(E$10=\"\",\"\",E$10 + (E$9 * E$6))","v":""}]
["X forPredicted Y minimum:",null,{"$f":"IF(C4>=C15,C4,(C15-C10)/C9)","v":0},{"$f":"IF(D4>=D15,D4,(D15-D10)/D9)","v":0},0]
["X for predicted Y maximum:",null,{"$f":"IF(C5<=C16,C5,(C16-C10)/C9)","v":0},{"$f":"IF(D5<=$C16,D5,($C16-D10)/D9)","v":0},{"$f":"IF(E5<=$C16,E5,($C16-E10)/E9)","v":0}]
[]
["Line Intersections:"]
["Line Pair",null,"Intersect?","Intersection","Intersection within Graph Range?"]
["Line 1","Line 2",{"$f":"IF(C$9=\"\",\"\",IF(C$9=D$9,\"No\",\"Yes\"))","v":""},{"$f":"IF(C$9=\"\",\"\",C$10 + C$9*((D$10-C$10)/(C$9-D$9)))","v":""},{"$f":"IF(D29 = \"\",\"\", IF(D29<C$15,\"No\", IF(D29 <= C$16,\"Yes\", \"No\")))","v":""}]
["Line 1","Line 3",{"$f":"IF(C$9=\"\",\"\",IF(C$9=E$9,\"No\",\"Yes\"))","v":""},{"$f":"IF(C$9=\"\",\"\",C$10 + C$9*((E$10-C$10)/(C$9-E$9)))","v":""},{"$f":"IF(D30 = \"\",\"\", IF(D30<C$15,\"No\", IF(D30 <= C$16,\"Yes\", \"No\")))","v":""}]
["Line 2","Line 3",{"$f":"IF(D$9=\"\",\"\",IF(D$9=E$9,\"No\",\"Yes\"))","v":""},{"$f":"IF(D$9=\"\",\"\",D$10 + D$9*((E$10-D$10)/(D$9-E$9)))","v":""},""]

{"sheet":"Example","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[11,2,11,4],[12,2,12,4],[13,2,13,4],[27,0,27,1],[24,0,24,1],[22,0,22,1],[21,0,21,1],[20,0,20,1],[19,0,19,1],[18,0,18,1],[17,0,17,1],[14,2,14,4],[15,2,15,4],[23,0,23,1]]}
["Example: To see the process work, copy data in yellow box below to the yellow box in the Grapher tab."]
[]
[null,null,"Line #1","Line #2","Line #3"]
["Enter X Minimum:",null,20,20,20]
["Enter X Maximum:",null,100,100,100]
["Enter X Mean:",null,65,60,55]
["Enter Y Minimum:",null,0.5,0.5,0.5]
["Enter Y Maximum:",null,4,4,4]
["Enter Slope:",null,5.8500000000000003E-2,4.3200000000000002E-2,7.3499999999999996E-2]
["Enter Y-Intercept:",null,-0.75370000000000004,0.1137,0.2]
["Enter Line Label:",null,"Liberals","Conservatives","Independents"]
["Enter Y axis label:",null,"GPA"]
["Enter X axis label:",null,"Admission Test Score"]
["Enter Graph Title:",null,"Regression Lines"]
["Enter minimum Y axis value:",null,0]
["Enter maximum Y axis value:",null,4]
[]
["Calculations:"]
["Predicted Y Minimum:",null,0.41630000000000011,0.97770000000000012,1.67]
["Predicted Y Maximum:",null,4,4,3.9999999999999996]
["Y @ X = 0:",null,-0.75370000000000004,0.1137,0.2]
["Y @ X = maximum:",null,5.0963000000000003,4.4337,7.55]
["Y @ X = Mean:",null,3.0488,2.7057000000000002,4.2424999999999997]
["X forPredicted Y minimum:",null,20,20,20]
["X for predicted Y maximum:",null,81.259829059829059,89.960648148148138,51.700680272108841]
[]
["Line Intersections:"]
["Line Pair",null,"Intersect?","Intersection","Intersection within Graph Range?"]
["Line 1","Line 2",{"$f":"IF(C$9=\"\",\"\",IF(C$9=D$9,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(C$9=\"\",\"\",C$10 + C$9*((D$10-C$10)/(C$9-D$9)))","v":2.5628294117647057},{"$f":"IF(D29 = \"\",\"\", IF(D29<C$15,\"No\", IF(D29 <= C$16,\"Yes\", \"No\")))","v":"Yes"}]
["Line 1","Line 3",{"$f":"IF(C$9=\"\",\"\",IF(C$9=E$9,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(C$9=\"\",\"\",C$10 + C$9*((E$10-C$10)/(C$9-E$9)))","v":-4.473130000000002},{"$f":"IF(D30 = \"\",\"\", IF(D30<C$15,\"No\", IF(D30 <= C$16,\"Yes\", \"No\")))","v":"No"}]
["Line 2","Line 3",{"$f":"IF(D$9=\"\",\"\",IF(D$9=E$9,\"No\",\"Yes\"))","v":"Yes"},{"$f":"IF(D$9=\"\",\"\",D$10 + D$9*((E$10-D$10)/(D$9-E$9)))","v":-9.3415841584158915E-3},"No"]