{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Regression Line","Negative Slope","SLOPE and INTERCEPT","VBA SLOPE Function","#N A! Error","#DIV 0! Error"],"not_rendered":{"charts":3,"images":0,"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":"Regression Line","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Slope of a Regression Line"]
[]
[null,"Sales","Profit"]
[null,900,120]
[null,1200,180]
[null,1800,350]
[null,2000,400]
[null,2100,430]
[]
[null,"Slope",{"$f":"SLOPE(C5:C9,B5:B9)","v":0.26272727272727275}]

{"sheet":"Negative Slope","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Negative Slope"]
[]
[null,"Budget ","Expense"]
[null,1800,1600]
[null,1950,1500]
[null,2000,1200]
[null,2150,1100]
[null,2300,950]
[]
[null,"Slope",{"$f":"SLOPE(B5:B9,C5:C9)","v":-0.66778523489932884}]

{"sheet":"SLOPE and INTERCEPT","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Pairing SLOPE and INTERCEPT  "]
[]
[null,"Sales","Profit"]
[null,900,120]
[null,1200,180]
[null,1800,350]
[null,2000,400]
[null,2100,430]
[]
[null,"SLOPE",{"$f":"SLOPE(C5:C9,B5:B9)","v":0.26272727272727275}]
[null,"INTERCEPT",{"$f":"INTERCEPT(C5:C9,B5:B9)","v":-124.36363636363643}]
[null,"Pairing SLOPE and INTERCEPT","y = 0.26x -124.36"]

{"sheet":"VBA SLOPE Function","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"VBA to Find SLOPE"]
[]
[null,"Sales","Profit"]
[null,900,120]
[null,1200,180]
[null,1800,350]
[null,2000,400]
[null,2100,430]

{"sheet":"#N A! Error","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"#N/A! Error in SLOPE Function"]
[]
[null,"Sales","Profit"]
[null,900,120]
[null,1200,180]
[null,1800,350]
[null,2000,400]
[null,2100,430]
[null,"Slope",{"$f":"SLOPE(C5:C9,B5:B10)","v":{"$error":"#N/A"}}]

{"sheet":"#DIV 0! Error","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"#DIV/0! Error in SLOPE Function"]
[]
[null,"Sales","Profit"]
[null,null,120]
[null,null,180]
[null,null,350]
[null,null,400]
[null,null,430]
[null,"Slope",{"$f":"SLOPE(C5:C9,B5:B9)","v":{"$error":"#DIV/0!"}}]