Question: Record Section Age Car Class Courses Night Texts Major Live Transport Gender 1 3 25 Ford Senior 3 1 50 Management Portland city/urban area, not
Record Section Age Car Class Courses Night Texts Major Live Transport Gender 1 3 25 Ford Senior 3 1 50 Management Portland city/urban area, not on campus TriMet (bus or Max) Woman 2 3 23 None Junior 3 1 10 Marketing Portland city/urban area, not on campus Walk Man 3 6 36 Toyota Junior 3 1 20 Accounting Portland city/urban area, not on campus Car Woman 4 3 23 Volvo Junior 4 1 15 Finance Portland city/urban area, not on campus Bike Man 5 3 25 Toyota Junior 4 1 90 Finance On campus Walk Woman 6 3 23 Volvo Junior 4 1 15 Finance Portland city/urban area, not on campus Bike Man 7 3 19 None Junior 4 1 50 Supply & Logistics On campus Walk Woman 8 3 19 Jaguar Sophomore 4 1 50 Marketing West suburbs (Beaverton, Hillsboro, etc.) Car Woman 9 3 48 Kia Sophomore 1 1 20 Finance West suburbs (Beaverton, Hillsboro, etc.) Car Man 10 3 25 None Sophomore 4 1 50 Human Resources West suburbs (Beaverton, Hillsboro, etc.) Car Woman 11 3 26 Ford Senior 3 1 50 Management East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman 12 3 20 Honda Sophomore 4 1 400 Human Resources Vancouver area TriMet (bus or Max) Woman 13 3 26 Subaru Senior 3 1 20 Accounting South suburbs (Lake Oswego, West Linn, etc.) Car Woman 14 3 24 Volkswagen Senior 4 2 70 Marketing Portland city/urban area, not on campus Walk Woman 15 3 30 Hyundai Junior 3 1 20 Accounting West suburbs (Beaverton, Hillsboro, etc.) Car Woman 16 3 23 None Junior 4 1 15 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman 17 3 23 Mercedes Senior 4 1 10 Accounting Other Car Woman 18 6 54 Mazda Junior 3 1 50 Human Resources On campus Walk Woman 19 3 29 Toyota Sophomore 3 1 10 Accounting Portland city/urban area, not on campus Car Man 20 6 19 Volkswagen Sophomore 4 1 200 Accounting On campus Car Woman 21 6 31 None Junior 3 0 30 Marketing Portland city/urban area, not on campus Car Woman 22 6 19 Honda Junior 4 1 30 Human Resources South suburbs (Lake Oswego, West Linn, etc.) Car Woman 23 3 23 None Junior 3 1 0 Marketing Portland city/urban area, not on campus Walk Man 24 3 18 None Sophomore 4 1 100 Finance On campus Walk Woman 25 6 20 Toyota Junior 4 1 200 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman 26 6 25 None Senior 3 1 30 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman 27 6 24 Mazda Junior 4 1 20 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man 28 3 23 Subaru Senior 4 1 20 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman 29 3 25 Nissan Junior 4 1 2 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 30 3 20 Ford Sophomore 4 0 20 Management Other Car Woman 31 6 21 None Senior 4 1 50 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman 32 6 21 None Senior 4 1 50 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman 33 6 37 None Senior 3 1 30 Finance On campus Walk Woman 34 3 25 Hyundai Junior 4 1 150 Accounting South suburbs (Lake Oswego, West Linn, etc.) Car Woman 35 3 20 None Sophomore 4 1 30 Accounting Portland city/urban area, not on campus Walk Woman 36 3 20 Volkswagen Junior 3 1 20 Marketing On campus Walk Woman 37 3 20 None Sophomore 4 1 40 Accounting Portland city/urban area, not on campus Walk Woman 38 6 46 Honda Post-Bac 3 0 5 Accounting Other Car Woman 39 3 19 None Junior 4 1 100 Supply & Logistics On campus Walk Woman 40 6 20 None Junior 3 1 50 Supply & Logistics Other TriMet (bus or Max) Man 41 6 42 Mitsubishi Junior 3 1 130 Finance Portland city/urban area, not on campus TriMet (bus or Max) Woman 42 3 21 None Senior 3 1 70 Management Portland city/urban area, not on campus TriMet (bus or Max) Woman 43 6 22 None Junior 3 1 65 Marketing On campus Walk Woman 44 6 24 None Senior 3 1 10 Marketing On campus Walk Woman 45 6 44 Toyota Senior 1 3 10 Marketing On campus Walk Woman 46 3 24 Jeep Junior 4 0 20 Management South suburbs (Lake Oswego, West Linn, etc.) Car Woman 47 3 24 Honda Senior 3 1 10 Advertising West suburbs (Beaverton, Hillsboro, etc.) Car Woman 48 3 28 Volvo Junior 4 1 200 Marketing East suburbs (Gresham, Milwaukie, etc.) Car Woman 49 3 24 None Post-Bac 3 1 10 Accounting On campus TriMet (bus or Max) Man 50 3 46 Dodge Senior 4 1 10 Supply & Logistics South suburbs (Lake Oswego, West Linn, etc.) Car Man 51 3 24 Lexus Junior 3 2 5 Human Resources On campus Walk Man 52 6 21 Volkswagen Junior 4 1 50 Management Portland city/urban area, not on campus Walk Woman 53 3 26 Toyota Senior 3 2 30 Supply & Logistics Portland city/urban area, not on campus TriMet (bus or Max) Man 54 3 20 Pontiac Junior 3 1 20 Accounting East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman 55 6 21 Honda Junior 4 0 20 Advertising Portland city/urban area, not on campus Car Woman 56 3 26 Toyota Senior 3 2 30 Supply & Logistics Portland city/urban area, not on campus TriMet (bus or Max) Man 57 3 38 Toyota Post-Bac 3 1 25 Supply & Logistics East suburbs (Gresham, Milwaukie, etc.) Car Man 58 3 38 Toyota Post-Bac 3 1 20 Supply & Logistics East suburbs (Gresham, Milwaukie, etc.) Car Man 59 6 19 Ford Junior 4 2 75 Marketing On campus Walk Woman 60 3 38 Toyota Post-Bac 3 1 20 Supply & Logistics East suburbs (Gresham, Milwaukie, etc.) Car Man 61 6 20 Nissan Sophomore 4 1 72 Marketing East suburbs (Gresham, Milwaukie, etc.) Car Man 62 6 20 None Junior 3 1 10 Advertising Portland city/urban area, not on campus TriMet (bus or Max) Woman 63 3 23 None Junior 3 1 20 Accounting On campus Walk Woman 64 3 23 Kia Junior 3 1 100 Marketing Portland city/urban area, not on campus Car Woman 65 6 23 None Senior 4 1 10 Finance Portland city/urban area, not on campus Walk Woman 66 3 25 Kia Junior 3 1 50 Marketing West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman 67 3 21 BMW Junior 3 1 18 Marketing Vancouver area Car Woman 68 6 21 Honda Junior 3 1 40 Human Resources Portland city/urban area, not on campus TriMet (bus or Max) Woman 69 3 24 Lexus Junior 3 2 5 Human Resources On campus Walk Man 70 3 19 Nissan Junior 4 1 25 Management Portland city/urban area, not on campus Bike Man 71 3 22 None Junior 3 1 50 Marketing South suburbs (Lake Oswego, West Linn, etc.) TriMet (bus or Max) Woman 72 6 25 None Senior 3 1 40 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman 73 6 24 Mercedes Junior 4 1 20 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man 74 6 19 None Sophomore 4 1 60 Accounting South suburbs (Lake Oswego, West Linn, etc.) TriMet (bus or Max) Woman 75 6 27 Volkswagen Junior 3 1 100 Marketing West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 76 6 21 Mazda Junior 3 1 150 Human Resources West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman 77 3 27 Pontiac Junior 3 1 20 Accounting East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman 78 3 28 Toyota Junior 4 1 10 Marketing Portland city/urban area, not on campus Bike Man 79 3 28 Toyota Junior 4 1 10 Marketing Portland city/urban area, not on campus Bike Man 80 6 25 None Senior 4 1 25 Finance Portland city/urban area, not on campus TriMet (bus or Max) Woman 81 6 19 None Sophomore 6 1 50 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman 82 6 22 Subaru Sophomore 3 2 100 Accounting Portland city/urban area, not on campus Bike Woman 83 3 22 None Sophomore 3 1 100 Finance Portland city/urban area, not on campus Walk Woman 84 3 46 Dodge Senior 3 1 20 Supply & Logistics South suburbs (Lake Oswego, West Linn, etc.) Car Not Listed 85 3 29 Mazda Senior 3 1 20 Management Portland city/urban area, not on campus TriMet (bus or Max) Man 86 3 24 Jeep Senior 4 0 25 Management South suburbs (Lake Oswego, West Linn, etc.) Car Woman 87 6 45 Nissan Junior 3 1 100 Accounting On campus Other Woman 88 6 21 None Junior 4 2 10 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman 89 6 21 None Junior 4 2 10 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman 90 3 23 Lexus Sophomore 4 1 5 Accounting On campus Walk Man 91 2 23 Lexus Sophomore 4 1 5 Accounting On campus Walk Man 92 6 24 BMW Senior 3 1 20 Marketing West suburbs (Beaverton, Hillsboro, etc.) Car Woman 93 6 21 Holden Junior 3 1 25 Accounting Portland city/urban area, not on campus Walk Man 94 6 20 Nissan Sophomore 4 1 75 Marketing East suburbs (Gresham, Milwaukie, etc.) Car Man 95 2 21 Ford Junior 3 1 40 Marketing East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman 96 6 22 None Senior 4 1 2 Accounting Portland city/urban area, not on campus Walk Woman 97 6 52 None Senior 4 1 2 Accounting Portland city/urban area, not on campus Walk Woman 98 6 22 None Senior 4 1 2 Accounting Portland city/urban area, not on campus Walk Woman 99 3 28 Honda Senior 3 1 15 Finance Vancouver area TriMet (bus or Max) Man 100 6 21 Volkswagen Junior 3 0 200 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman 101 6 22 None Senior 4 1 2 Accounting Portland city/urban area, not on campus Walk Woman 102 3 23 None Junior 3 1 0 Marketing Portland city/urban area, not on campus Walk Man 103 6 20 Jeep Sophomore 3 1 20 Marketing Portland city/urban area, not on campus Walk Man 104 6 19 Toyota Sophomore 4 1 25 Marketing On campus Walk Woman 105 6 55 None Senior 4 1 20 Finance Portland city/urban area, not on campus TriMet (bus or Max) Woman 106 6 19 Toyota Sophomore 2 0 30 Management On campus Walk Woman 107 3 22 Audi Senior 3 1 40 Management Portland city/urban area, not on campus TriMet (bus or Max) Man 108 6 40 Honda Junior 3 1 200 Accounting East suburbs (Gresham, Milwaukie, etc.) Car Woman 109 3 29 Chevrolet Senior 3 1 500 Accounting On campus Walk Man 110 3 22 Subaru Junior 3 0 20 Human Resources Portland city/urban area, not on campus TriMet (bus or Max) Woman 111 6 20 None Junior 4 0 20 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 112 6 25 None Senior 4 1 20 Finance Portland city/urban area, not on campus TriMet (bus or Max) Man 113 6 22 Volkswagen Senior 4 0 20 Marketing West suburbs (Beaverton, Hillsboro, etc.) Car Woman 114 6 46 Honda Post-Bac 3 0 5 Accounting Other Car Woman 115 2 21 Honda Junior 3 1 20 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Woman 116 6 32 Toyota Senior 3 1 75 Marketing On campus Walk Woman 117 3 28 Honda Junior 3 1 15 Accounting West suburbs (Beaverton, Hillsboro, etc.) Car Man 118 6 43 Chevrolet Senior 1 1 20 Management Portland city/urban area, not on campus TriMet (bus or Max) Man 119 6 25 None Senior 4 1 20 Finance Portland city/urban area, not on campus TriMet (bus or Max) Woman 120 6 35 None Senior 3 1 40 Accounting Portland city/urban area, not on campus Walk Woman 121 6 23 Buick Junior 3 1 20 Marketing West suburbs (Beaverton, Hillsboro, etc.) Car Man 122 3 31 Volkswagen Junior 3 1 30 Marketing On campus Walk Woman 123 3 21 Mazda Junior 4 1 200 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man 124 3 28 Nissan Junior 4 1 100 Finance Portland city/urban area, not on campus Car Woman 125 6 22 Toyota Senior 3 1 25 Marketing Portland city/urban area, not on campus Walk Woman 126 3 24 Volkswagen Junior 4 2 30 Finance Portland city/urban area, not on campus Car Man 127 3 28 Jeep Junior 3 1 50 Accounting South suburbs (Lake Oswego, West Linn, etc.) Car Woman 128 6 38 Toyota Senior 3 0 30 Accounting East suburbs (Gresham, Milwaukie, etc.) Car Man 129 6 21 None Junior 3 1 20 Finance On campus Walk Man 130 2 21 Toyota Junior 2 2 80 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman 131 2 25 Mazda Senior 3 1 10 Management Portland city/urban area, not on campus Other Man 132 6 27 Volkswagen Junior 3 1 53 Marketing West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 133 6 46 Ford Junior 3 1 30 Finance On campus Walk Man 134 6 20 Ford Junior 3 1 30 Finance On campus Walk Man 135 6 20 Jeep Sophomore 3 1 20 Marketing On campus Walk Man 136 6 21 Volkswagen Senior 3 1 20 Accounting Portland city/urban area, not on campus Walk Man 137 6 35 Jeep Sophomore 3 1 20 Marketing On campus Walk Man 138 6 22 Honda Senior 3 1 15 Finance Vancouver area TriMet (bus or Max) Man 139 6 22 Subaru Sophomore 3 1 100 Accounting Portland city/urban area, not on campus Car Woman 140 2 25 Hyundai Junior 3 2 100 Finance Portland city/urban area, not on campus Car Woman 141 2 26 Acura Junior 2 2 150 Management East suburbs (Gresham, Milwaukie, etc.) Car Woman 142 2 20 Subaru Junior 3 2 100 Management West suburbs (Beaverton, Hillsboro, etc.) Car Woman 143 2 32 Mercedes Junior 3 3 5 Supply & Logistics West suburbs (Beaverton, Hillsboro, etc.) Car Man 144 2 35 Chevrolet Sophomore 1 1 1 Supply & Logistics East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman 145 2 37 Toyota Junior 3 2 10 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 146 2 26 Mitsubishi Post-Bac 2 2 20 Human Resources Portland city/urban area, not on campus Car Woman 147 2 33 Honda Post-Bac 3 3 100 Human Resources Portland city/urban area, not on campus TriMet (bus or Max) Woman 148 3 30 Volkswagen Junior 3 1 40 Marketing Portland city/urban area, not on campus Car Man 149 2 23 Honda Junior 3 2 15 Management East suburbs (Gresham, Milwaukie, etc.) Car Woman 150 2 21 Honda Junior 3 2 200 Management West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman 151 2 20 Acura Junior 4 2 200 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman 152 3 39 Nissan Senior 1 1 10 Accounting East suburbs (Gresham, Milwaukie, etc.) TriMet (bus or Max) Woman 153 2 23 Subaru Junior 2 2 30 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man 154 2 26 Dodge Junior 3 3 20 Accounting Other Car Man 155 2 19 Mazda Sophomore 4 1 200 Marketing Portland city/urban area, not on campus Walk Man 156 2 19 None Junior 3 1 40 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Man 157 2 19 None Junior 3 1 45 Accounting Portland city/urban area, not on campus TriMet (bus or Max) Man 158 6 23 Lexus Sophomore 4 2 5 Accounting On campus Walk Man 159 2 23 Volkswagen Junior 3 1 50 Marketing Portland city/urban area, not on campus Car Man 160 2 20 Toyota Sophomore 3 2 200 Supply & Logistics Portland city/urban area, not on campus TriMet (bus or Max) Man 161 2 40 Ford Post-Bac 2 2 5 Supply & Logistics West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 162 2 26 Mazda Junior 2 2 50 Management Portland city/urban area, not on campus Car Woman 163 2 19 None Sophomore 3 1 50 Marketing Portland city/urban area, not on campus Walk Man 164 2 21 Volkswagen Junior 2 1 1 Finance West suburbs (Beaverton, Hillsboro, etc.) Car Man 165 3 22 Ford Junior 3 3 20 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 166 2 26 BMW Junior 3 2 5 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man 167 2 25 Toyota Sophomore 3 3 200 Accounting Portland city/urban area, not on campus Car Man 168 2 33 Ford Junior 2 2 60 Accounting Portland city/urban area, not on campus Walk Man 169 2 26 Hyundai Junior 3 2 100 Finance Portland city/urban area, not on campus Car Woman 170 2 25 None Senior 3 1 6 Accounting West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman 171 2 21 None Junior 3 2 5 Management Portland city/urban area, not on campus TriMet (bus or Max) Woman 172 2 42 Subaru Senior 3 2 25 Supply & Logistics Portland city/urban area, not on campus Car Man 173 2 28 Honda Senior 3 2 40 Management Portland city/urban area, not on campus Car Woman 174 2 22 Volkswagen Junior 4 3 80 Finance On campus TriMet (bus or Max) Woman 175 2 22 BMW Junior 4 3 80 Finance On campus TriMet (bus or Max) Woman 176 2 20 Scion Sophomore 5 2 500 Marketing West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Woman 177 2 42 Toyota Senior 3 2 25 Supply & Logistics Portland city/urban area, not on campus Car Man 178 2 26 Chevrolet Junior 4 1 4 Finance Other Car Man 179 2 20 Lexus Sophomore 4 1 40 Marketing On campus Man 180 2 19 Mazda Sophomore 4 1 150 Marketing Portland city/urban area, not on campus Other Man 181 2 19 Toyota Sophomore 3 2 100 Supply & Logistics Portland city/urban area, not on campus TriMet (bus or Max) Man 182 2 23 Subaru Junior 3 3 30 Finance West suburbs (Beaverton, Hillsboro, etc.) Car Man 183 2 26 BMW Junior 3 2 10 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man 184 2 24 Volkswagen Senior 3 2 50 Finance South suburbs (Lake Oswego, West Linn, etc.) Car Man 185 2 20 None Junior 3 1 20 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Woman 186 2 23 Volkswagen Junior 2 2 3 Accounting Portland city/urban area, not on campus Car Woman 187 2 25 Subaru Junior 3 3 40 Finance West suburbs (Beaverton, Hillsboro, etc.) Car Man 188 2 21 None Junior 3 3 10 Management Portland city/urban area, not on campus TriMet (bus or Max) Woman 189 2 21 Ford Junior 3 3 25 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 190 2 21 Ford Junior 3 2 100 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 191 2 22 None Junior 3 2 40 Marketing Portland city/urban area, not on campus TriMet (bus or Max) Man 192 2 21 None Junior 3 2 100 Finance West suburbs (Beaverton, Hillsboro, etc.) TriMet (bus or Max) Man 193 2 40 Toyota Junior 4 1 30 Accounting Other Car Woman 194 6 45 Nissan Junior 3 1 456 Accounting On campus Other Woman 195 2 19 Mazda Sophomore 4 1 400 Marketing South suburbs (Lake Oswego, West Linn, etc.) Car Woman 196 2 20 Honda Junior 3 2 15 Accounting South suburbs (Lake Oswego, West Linn, etc.) TriMet (bus or Max) Man 197 3 19 Toyota Junior 3 0 25 Management West suburbs (Beaverton, Hillsboro, etc.) Car Woman 198 2 33 Subaru Junior 3 1 10 Management West suburbs (Beaverton, Hillsboro, etc.) Car Man
- Which of the sections has the highest average (mean) age? Provide that average and the average for each of the other sections. What is the Standard Deviation for the section with the highest mean?
- Which of the sections has the highest median age? Provide that median and the median for each of the other sections. Which is a "better" average, and why?
- Find a significant descriptive statistical difference between the different sections and describe it. How might it be useful in deciding how to teach that class differently?
- What is the most common car brand in Section 002? Create a column chart showing the number of owners of each car brand in Section 002. Include the chart in your submission, and include the "none" category in your data.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
