{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["(2)","(3)","(4)","(5)","(10)","(14)","(17)","(24)"],"not_rendered":{"charts":3,"images":0,"macros":0,"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":"(2)","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Car","Size","Cylinders","City MPG","Highway MPG","Fuel",null,"Scales of Measurement"]
["Audu A8","Large",12,13,19,"Premium",null,"Nominal"]
["BMW 328 Xi","Compact",6,17,25,"Premium",null,"Ordinal"]
["Cadillac CTS","Midsized",6,16,25,"Regular",null,"Interval"]
["Chrysler 300","Large",8,13,18,"Premium",null,"Ratio"]
["Ford Focus","Compact",4,24,33,"Regular"]
["Hyundai Elantra","Midsized",4,25,33,"Regular"]
["Jeep Grand Cherokee","Midsized",6,17,26,"Diesel"]
["Pontiac G6","Compact",6,15,22,"Regular"]
["Toyota Camry","Midsized",4,21,31,"Regular"]
["VW Jetta","Compact",5,21,29,"Regular"]
[]
["a",{"$f":"COUNTA(A2:A11)","v":10},"Elements or Primary Keys"]
["b",{"$f":"COUNTA(B1:F1)","v":5},"Variables"]
[]
["c",{"$f":"TRANSPOSE(B1:F1)","v":"Size"},"Categorical"]
[null,"Cylinders","Quantitative"]
[null,"City MPG","Quantitative"]
[null,"Highway MPG","Quantitative"]
[null,"Fuel","Categorical"]
[]
["d",{"$f":"TRANSPOSE(B1:F1)","v":"Size"},"Ordinal"]
[null,"Cylinders","Ratio"]
[null,"City MPG","Ratio"]
[null,"Highway MPG","Ratio"]
[null,"Fuel","Nominal"]

{"sheet":"(3)","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Car","Size","Cylinders","City MPG","Highway MPG","Fuel",null,"Scales of Measurement"]
["Audu A8","Large",12,13,19,"Premium",null,"Nominal"]
["BMW 328 Xi","Compact",6,17,25,"Premium",null,"Ordinal"]
["Cadillac CTS","Midsized",6,16,25,"Regular",null,"Interval"]
["Chrysler 300","Large",8,13,18,"Premium",null,"Ratio"]
["Ford Focus","Compact",4,24,33,"Regular"]
["Hyundai Elantra","Midsized",4,25,33,"Regular"]
["Jeep Grand Cherokee","Midsized",6,17,26,"Diesel"]
["Pontiac G6","Compact",6,15,22,"Regular"]
["Toyota Camry","Midsized",4,21,31,"Regular"]
["VW Jetta","Compact",5,21,29,"Regular"]
[]
["a",{"$f":"AVERAGE(D2:D11)","v":18.2},{"$f":"\"Average for \"&D1","v":"Average for City MPG"}]
[null,{"$f":"AVERAGE(E2:E11)","v":26.1},{"$f":"\"Average for \"&E1","v":"Average for Highway MPG"}]
["b",{"$f":"B14-B13","v":7.9000000000000021},{"$f":"\"The difference between \"&C13&\" and \"&C14","v":"The difference between Average for City MPG and Average for Highway MPG"}]
["c","Criteria:",4,{"$f":"C1","v":"Cylinders"}]
[null,{"$f":"\"# cars with \"&C16&\" \"&D16","v":"# cars with 4 Cylinders"},{"$f":"COUNTIF(C2:C11,C16)","v":3}]
[null,"Total Cars",{"$f":"COUNTA(A2:A11)","v":10},null,null,"Check"]
[null,{"$f":"\"Percentage Cars that have \"&C16&\" \"&D16","v":"Percentage Cars that have 4 Cylinders"},{"$f":"C17/C18","v":0.3},null,null,{"$f":"COUNTIF(C2:C11,C16)/COUNT(C2:C11)","v":0.3}]
["d","Criteria:","regular",{"$f":"F1","v":"Fuel"}]
[null,{"$f":"\"# cars with \"&C20&\" \"&D20","v":"# cars with regular Fuel"},{"$f":"COUNTIF(F2:F11,C20)","v":6}]
[null,"Total Cars",{"$f":"COUNTA(A2:A11)","v":10},null,null,"Check"]
[null,{"$f":"\"Percentage Cars that have \"&C20&\" \"&D20","v":"Percentage Cars that have regular Fuel"},{"$f":"C21/C22","v":0.6},null,null,{"$f":"COUNTIF(F2:F11,C20)/COUNTA(F2:F11)","v":0.6}]

{"sheet":"(4)","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["School","State","Campus Setting","Endowment ($B)","% Applicants Admitted","NCAA Division",null,"Scales of Measurement"]
["Amherst","Massachusetts","Town: Fringe",1.7,0.18,"III",null,"Nominal"]
["Duke","North Carolina","City: Midsized",5.9,0.21,"I-A",null,"Ordinal"]
["Harvard","Massachusetts","City: Midsized",34.6,0.09,"I-AA",null,"Interval"]
["Swathmore","Pennsylvania","Suburb: Large",1.4,0.18,"III",null,"Ratio"]
["U of P","Pennsylvania","City: Large",6.6,0.18,"I-AA"]
["Williams","Massachusetts","Town: Fringe",1.9,0.18,"III"]
["Yale","Connecticut","City: Midsized",22.5,0.09,"I-AA"]
[]
["a",{"$f":"COUNTA(A2:A8)","v":7},"Elements (Primary Key)"]
["b",{"$f":"COUNTA(B1:F1)","v":5},"Variables"]
["c",{"$f":"TRANSPOSE(B1:F1)","v":"State"},"Categorical","Nominal"]
[null,"Campus Setting","Categorical","Nominal"]
[null,"Endowment ($B)","Quantitative","Ratio"]
[null,"% Applicants Admitted","Quantitative","Ratio"]
[null,"NCAA Division","Categorical","Ordinal"]

{"sheet":"(5)","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["School","State","Campus Setting","Endowment ($B)","% Applicants Admitted","NCAA Division"]
["Amherst","Massachusetts","Town: Fringe",1.7,0.18,"III"]
["Duke","North Carolina","City: Midsized",5.9,0.21,"I-A"]
["Harvard","Massachusetts","City: Midsized",34.6,0.09,"I-AA"]
["Swathmore","Pennsylvania","Suburb: Large",1.4,0.18,"III"]
["U of P","Pennsylvania","City: Large",6.6,0.18,"I-AA"]
["Williams","Massachusetts","Town: Fringe",1.9,0.18,"III"]
["Yale","Connecticut","City: Midsized",22.5,0.09,"I-AA"]
[]
["a",{"$f":"AVERAGE(D2:D8)","v":10.657142857142857},{"$f":"\"Average \"&D1","v":"Average Endowment ($B)"}]
["b",{"$f":"AVERAGE(E2:E8)","v":0.15857142857142856},{"$f":"\"Average \"&E1","v":"Average % Applicants Admitted"}]
[]
["c",{"$f":"COUNTIF(F2:F8,E13)","v":3},{"$f":"\"# Schools with \"&E13","v":"# Schools with III"},"Criteria:","III"]
[null,{"$f":"COUNTA(F2:F8)","v":7},"Total Schools",null,null,null,"Check:"]
[null,{"$f":"B13/B14","v":0.42857142857142855},{"$f":"\"% Schools with \"&E13","v":"% Schools with III"},null,null,null,{"$f":"COUNTIF(F2:F8,E13)/COUNTA(F2:F8)","v":0.42857142857142855}]
[]
["d",{"$f":"COUNTIF(C2:C8,E17)","v":3},{"$f":"\"# Schools with \"&E17","v":"# Schools with City: Midsized"},"Criteria:","City: Midsized"]
[null,{"$f":"COUNTA(C2:C8)","v":7},"Total Schools",null,null,null,"Check:"]
[null,{"$f":"B17/B18","v":0.42857142857142855},{"$f":"\"% Schools with \"&E17","v":"% Schools with City: Midsized"},null,null,null,{"$f":"COUNTIF(C2:C8,E17)/COUNTA(C2:C8)","v":0.42857142857142855}]

{"sheet":"(10)","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Quote: \"Drivers of motor vehicles should be allowed to talk on a hand-held cell phone while driving\""]
[null,"Frequency","Relative Frequency","Percent Frequency"]
["Strongly Agree",44,{"$f":"B3/$B$7","v":4.0740740740740744E-2},{"$f":"C3","v":4.0740740740740744E-2}]
["Somewhat Agree",130,{"$f":"B4/$B$7","v":0.12037037037037036},0.12037037037037036]
["Somewhat disagree",165,0.15277777777777779,0.15277777777777779]
["Strongly disagree",741,0.68611111111111112,0.68611111111111112]
["Total",{"$f":"SUM(B3:B6)","v":1080},{"$f":"SUM(C3:C6)","v":1},1]
[]
["a","Categorical and Ordinal"]
["b","Percentages"]
["c",{"$f":"D3","v":4.0740740740740744E-2}]
["d",{"$f":"\" Against = \"&TEXT(D5,\"0.000%\")&\" + \"&TEXT(D6,\"0.000%\")&\" = \"&TEXT(D5+D6,\"0.000%\")","v":" Against = 15.278% + 68.611% = 83.889%"}]

{"sheet":"(14)","index":5,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Global Auto Production of Autos"]
[null,2004,2005,2006,2007,null,"a"]
["GM",8900000,9000000,8900000,8800000]
["Ford",7800000,7700000,7800000,7900000]
["DC",4100000,4200000,4300000,4600000]
["Toyota",7800000,8300000,9100000,9600000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"b","GM is no longer the industry leader. Toyota is passing. In addition GM is the only one to show a downward trend."]
[null,null,null,null,null,null,"c"]

{"sheet":"(17)","index":6,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[17,"Internal data on salaries of other employees can be obtained from the personnel department.  External data might be obtained from the Department of Labor or industry associations."]

{"sheet":"(24)","index":7,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[24,"a","This is a statistically correct descriptive statistic for the sample."]
[null,"b","An incorrect generalization since the data was not collected for the entire population."]
[null,"c","An acceptable statistical inference based on the use of the word “estimate.”"]
[null,"d","While this statement is true for the sample, it is not a justifiable conclusion for the entire population."]
[null,"e","This statement is not statistically supportable.  While it is true for the particular sample observed, it is entirely possible and even very likely that at least some students will be outside the 65 to 90 range of grades."]