exel -pivot table exercise

profilegysgtclarke
PivotTableexercise.xlsx
Home>Mathematics homework help>exel -pivot table exercise

Raw Data

Final GPAs of the Graduating Class of 2017 and 2018.
Student Name Graduation Year GPA Major Re-coded GPA
2017 259 BehSciLO 2.59 Instructions:
2018 340 GeoSci 3.40 1) Notice the re-coded GPA column (in yellow), converting to the appropriate data format (i.e. on a typical 0 to 4 scale).
2018 213 MSS 2.13 2) Check the next Worksheet, "Pivot Table" for a Pivot Table that was previously created for you. (Using "Insert… Pivot Table…")
2018 317 Management 3.17
2017 323 SysEngr 3.23 Questions:
2018 283 Management 2.83 A) Find the average GPA for each Major for the combined year groups, sorted by Major. Copy this as VALUES into blank columns to the right.
2018 355 AeroEngr 3.55 B) Sort the results by GPA (for both Graduating Classes combined), highest-to-lowest. Copy this into blank column farther to the right.
2018 356 Economics 3.56 C) Find the average GPA for each Major in the 2017 and 2018 Graduating Class in separate columns, sorted by Major. Copy this as TEXT into blank columns to the right.
2018 314 AeroEngr 3.14 D) Change the Values displayed from AVERAGE GPA to COUNT. Copy the 2017 and 2018 results to new columns.
2018 264 Management 2.64
2018 243 Management 2.43 Decisions:
2017 334 BehSci 3.34 1) Which students perform the best? Worst?
2017 385 Physics 3.85 2) Is there a trend in average Class GPA over time?
2017 250 PolSci 2.50 3) Are any degree programs significant rising or falling over time?
2018 223 BehSci 2.23 4) Are any degree programs growing significantly? decreasing significantly?
2018 345 CivEngr 3.45
2018 320 SysEngr 3.20
2017 248 BehSci 2.48
2017 262 SysEngr 2.62
2017 268 Meteor 2.68
2017 251 CompSciCW 2.51
2017 285 AeroEngr 2.85
2018 351 AeroEngr 3.51
2018 323 BehSci 3.23
2017 331 BehSci 3.31
2017 348 Biology 3.48
2018 260 CivEngr 2.60
2018 334 CompSciCW 3.34
2018 267 PolSci 2.67
2017 264 Management 2.64
2018 347 AstroEngr 3.47
2018 284 ElEngr 2.84
2017 224 Management 2.24
2017 320 MatChem 3.20
2017 337 HistoryMil 3.37
2017 372 Biology 3.72
2018 252 Biology 2.52
2017 374 CivEngr 3.74
2018 258 Economics 2.58
2018 297 CompEngr 2.97
2017 238 Economics 2.38
2018 326 MechEngr 3.26
2017 258 CivEngr 2.58
2017 390 BioChem 3.90
2017 331 CivEngr 3.31
2018 293 SysEngr 2.93
2018 332 BioChem 3.32
2018 328 CompEngr 3.28
2017 298 SysEngr 2.98
2017 375 BehSci 3.75
2017 233 Management 2.33
2018 333 CompEngr 3.33
2017 297 Chemistry 2.97
2017 324 BehSci 3.24
2018 325 SysEngr 3.25
2018 302 Management 3.02
2018 341 CompSci 3.41
2018 304 Economics 3.04
2018 282 SysEngr 2.82
2017 240 Management 2.40
2017 313 ElEngr 3.13
2017 270 English 2.70
2017 293 CivEngr 2.93
2017 259 Biology 2.59
2018 278 Economics 2.78
2017 327 MSS 3.27
2017 304 Management 3.04
2018 369 AeroEngr 3.69
2017 351 CivEngr 3.51
2017 260 BehSciLO 2.60
2017 332 BehSci 3.32
2017 370 ElEngr 3.70
2017 321 SysEngr 3.21
2017 256 Management 2.56
2017 381 PolSci 3.81
2018 283 HistoryMil 2.83
2018 226 CivEngr 2.26
2017 303 Biology 3.03
2018 305 OpsRsch 3.05
2017 317 Chemistry 3.17
2017 312 Management 3.12
2017 297 Management 2.97
2017 333 Economics 3.33
2018 339 Biology 3.39
2018 259 Biology 2.59
2017 249 SysEngr 2.49
2017 281 Economics 2.81
2018 265 SysEngr 2.65
2018 385 Management 3.85
2017 264 OpsRsch 2.64
2018 287 GeoSci 2.87
2017 368 MSS 3.68
2017 237 Management 2.37
2018 313 PolSci 3.13
2017 262 Management 2.62
2018 304 Management 3.04
2018 299 OpsRsch 2.99
2017 295 Economics 2.95
2017 334 CompEngr 3.34
2017 280 BehSci 2.80
2017 309 SysEngr 3.09
2018 237 Management 2.37
2018 332 LegalStu 3.32
2018 350 Economics 3.50
2017 286 Management 2.86
2018 302 AeroEngr 3.02
2018 220 GeoSci 2.20
2018 316 BehSci 3.16
2017 269 Management 2.69
2018 227 Management 2.27
2018 292 Management 2.92
2018 221 Management 2.21
2018 308 Management 3.08
2018 256 CompSciCW 2.56
2018 280 AeroEngr 2.80
2018 297 LegalStu 2.97
2017 315 LegalStu 3.15
2017 341 Economics 3.41
2017 268 Biology 2.68
2018 247 Management 2.47
2018 373 AeroEngr 3.73
2018 297 Economics 2.97
2018 304 Chemistry 3.04
2017 333 PolSci 3.33
2017 304 ElEngr 3.04
2018 243 SpaceOps 2.43
2017 219 Management 2.19
2018 364 SysEngr 3.64
2018 312 BioChem 3.12
2017 223 Management 2.23
2017 321 AeroEngr 3.21
2018 259 Management 2.59
2017 260 Economics 2.60
2018 242 Management 2.42
2018 312 PolSci 3.12
2017 273 Economics 2.73
2018 282 Management 2.82
2017 284 Biology 2.84
2017 273 English 2.73
2018 363 BehSci 3.63
2017 232 PolSci 2.32
2018 290 Biology 2.90
2017 339 Biology 3.39
2017 333 SysEngr 3.33
2017 338 AeroEngr 3.38
2018 252 Management 2.52
2018 274 Biology 2.74
2018 252 CivEngr 2.52
2018 375 GeoSci 3.75
2018 318 CompEngr 3.18
2017 330 Physics 3.30
2017 335 AeroEngr 3.35
2017 214 CompSci 2.14
2018 293 HistoryMil 2.93
2017 273 PolSci 2.73
2017 338 LegalStu 3.38
2017 245 Management 2.45
2017 245 Management 2.45
2017 365 MechEngr 3.65
2017 227 Management 2.27
2017 264 Management 2.64
2017 332 CivEngr 3.32
2017 296 Management 2.96
2018 222 SocSci 2.22
2017 352 MechEngr 3.52
2018 209 SocSci 2.09
2018 341 Biology 3.41
2018 343 PolSci 3.43
2018 377 MechEngr 3.77
2018 288 Management 2.88
2017 300 CompSci 3.00
2017 278 Management 2.78
2017 268 CivEngr 2.68
2018 288 Management 2.88
2017 314 Management 3.14
2017 299 CompSci 2.99
2017 337 Biology 3.37
2018 268 SysEngr 2.68
2017 323 PolSci 3.23
2017 298 BioChem 2.98
2018 234 Management 2.34
2017 340 AeroEngr 3.40
2017 283 Management 2.83
2018 245 Economics 2.45
2017 322 CivEngr 3.22
2018 388 GeoSci 3.88
2018 249 SocSci 2.49
2018 306 BehSci 3.06
2017 326 Management 3.26
2018 304 SysEngr 3.04
2018 313 GeoSci 3.13
2017 310 SysEngr 3.10
2018 279 CivEngr 2.79
2017 284 Management 2.84
2017 292 AeroEngr 2.92
2018 297 Meteor 2.97
2018 211 SocSci 2.11
2018 349 AeroEngr 3.49
2018 378 HistoryMil 3.78
2018 293 Management 2.93
2018 327 PolSci 3.27
2018 266 SpaceOps 2.66
2017 277 HistoryInt 2.77
2018 246 SysEngr 2.46
2018 297 Management 2.97
2017 332 FAS-PolSci 3.32
2018 249 BehSci 2.49
2018 328 CivEngr 3.28
2017 249 CivEngr 2.49
2017 337 MathApp 3.37
2017 262 BehSci 2.62
2018 295 SysEngr 2.95
2018 274 Biology 2.74
2018 328 Biology 3.28
2018 240 Management 2.40
2018 300 English 3.00
2018 229 Management 2.29
2017 353 AstroEngr 3.53
2017 363 Biology 3.63
2017 296 BehSciLO 2.96
2017 232 MSS 2.32
2018 266 Management 2.66
2018 241 AeroEngr 2.41
2018 239 Management 2.39
2018 246 Biology 2.46
2017 314 AstroEngr 3.14
2018 238 Management 2.38
2018 217 SysEngr 2.17
2018 249 SysEngr 2.49
2018 285 CivEngr 2.85
2017 271 CivEngr 2.71
2017 305 English 3.05
2018 320 PolSci 3.20
2017 292 Management 2.92
2017 232 Management 2.32
2017 323 Management 3.23
2018 311 Management 3.11
2018 396 AstroEngr 3.96
2018 231 SysEngr 2.31
2018 264 PolSci 2.64
2018 365 Math 3.65
2018 268 SysEngr 2.68
2018 318 OpsRsch 3.18
2018 331 Biology 3.31
2017 293 PolSci 2.93
2018 268 Management 2.68
2017 368 BehSci 3.68
2018 323 SysEngr 3.23
2018 394 Economics 3.94
2017 330 HistoryMil 3.30
2017 285 MechEngr 2.85
2018 340 Biology 3.40
2017 238 Management 2.38
2018 213 Management 2.13
2017 283 BehSci 2.83
2017 380 AeroEngr 3.80
2017 255 Management 2.55
2018 367 AeroEngr 3.67
2018 307 Economics 3.07
2017 230 Management 2.30
2018 304 BehSci 3.04
2018 265 BasSci 2.65
2017 229 Management 2.29
2017 252 HistoryMil 2.52
2018 380 AstroEngr 3.80
2017 272 Management 2.72
2017 276 Biology 2.76
2017 241 Management 2.41
2018 338 AeroEngr 3.38
2017 238 Management 2.38
2018 330 SysEngr 3.30
2017 291 HistoryInt 2.91
2018 289 Economics 2.89
2018 363 AeroEngr 3.63
2018 362 AeroEngr 3.62
2018 283 Biology 2.83
2017 317 SysEngr 3.17
2018 384 PolSci 3.84
2017 393 SysEngr 3.93
2017 300 GeoSci 3.00
2018 273 English 2.73
2017 281 Management 2.81
2017 395 Biology 3.95
2018 329 PolSci 3.29
2017 256 BehSci 2.56
2017 297 EnvEngr 2.97
2018 247 LegalStu 2.47
2017 371 LegalStu 3.71
2018 278 BasSci 2.78
2018 351 FAS-Geo 3.51
2018 256 SysEngr 2.56
2018 289 BehSci 2.89
2017 245 Management 2.45
2017 324 CompEngr 3.24
2017 291 AeroEngr 2.91
2017 335 Management 3.35
2018 233 SysEngr 2.33
2017 320 BehSci 3.20
2018 212 BachSci 2.12
2018 343 FAS-MSS 3.43
2017 387 AstroEngr 3.87
2017 251 GeoSci 2.51
2018 253 GeoSci 2.53
2017 226 CivEngr 2.26
2018 322 SysEngr 3.22
2018 272 Management 2.72
2017 240 Management 2.40
2018 241 Management 2.41
2018 337 OpsRsch 3.37
2017 331 AeroEngr 3.31
2018 209 SocSci 2.09
2017 345 Biology 3.45
2017 299 English 2.99
2017 286 Economics 2.86
2018 264 LegalStu 2.64
2018 260 Economics 2.60
2018 246 Management 2.46
2017 365 OpsRsch 3.65
2018 225 SocSci 2.25
2017 308 Management 3.08
2018 278 FAS-PolSci 2.78
2017 330 BehSciLO 3.30
2017 230 SysEngr 2.30
2018 290 Management 2.90
2017 389 MechEngr 3.89
2017 305 CivEngr 3.05
2017 275 Management 2.75
2018 333 FAS-PolSci 3.33
2018 352 OpsRsch 3.52
2017 341 Biology 3.41
2018 309 SysEngr 3.09
2017 311 Biology 3.11
2017 397 AstroEngr 3.97
2018 289 Physics 2.89
2017 320 AeroEngr 3.20
2017 363 SysEngr 3.63
2018 258 Biology 2.58
2018 266 CivEngr 2.66
2017 279 Meteor 2.79
2017 261 FAS-PolSci 2.61
2018 378 Meteor 3.78
2017 315 Biology 3.15
2017 379 AstroEngr 3.79
2018 324 SysEngr 3.24
2018 293 SysEngr 2.93
2018 386 BehSci 3.86
2017 380 SysEngr 3.80
2017 264 CivEngr 2.64
2017 289 HistoryMil 2.89
2017 252 CompSciCW 2.52
2017 337 AeroEngr 3.37
2017 257 AeroEngr 2.57
2017 278 Economics 2.78
2018 363 Economics 3.63
2017 296 SysEngr 2.96
2018 300 AeroEngr 3.00
2018 378 AstroEngr 3.78
2017 257 CompSci 2.57
2017 329 MechEngr 3.29
2018 277 Management 2.77
2017 380 AeroEngr 3.80
2018 317 MechEngr 3.17
2017 257 MSS 2.57
2017 307 Management 3.07
2018 254 Management 2.54
2017 310 PolSci 3.10
2017 285 Management 2.85
2018 371 AstroEngr 3.71
2018 223 SocSci 2.23
2018 265 PolSci 2.65
2017 241 Biology 2.41
2017 285 LegalStu 2.85
2018 326 AeroEngr 3.26
2017 271 OpsRsch 2.71
2018 261 PolSci 2.61
2018 273 MechEngr 2.73
2018 273 Management 2.73
2018 364 Biology 3.64
2018 216 SysEngr 2.16
2017 344 OpsRsch 3.44
2017 263 BehSciHF 2.63
2018 209 MSS 2.09
2018 308 MSS 3.08
2018 247 BehSciHF 2.47
2017 283 BehSci 2.83
2017 246 SysEngr 2.46
2018 268 CompSci 2.68
2018 306 BehSciHF 3.06
2018 283 SysEngr 2.83
2018 222 Management 2.22
2018 388 Management 3.88
2017 240 Management 2.40
2018 237 Management 2.37
2017 316 AstroEngr 3.16
2017 268 BehSci 2.68
2017 310 CivEngr 3.10
2018 287 Biology 2.87
2017 244 Management 2.44
2018 253 PolSci 2.53
2018 331 Economics 3.31
2017 319 AeroEngr 3.19
2017 227 FAS-Geo 2.27
2018 245 Management 2.45
2018 322 MathApp 3.22
2018 281 Management 2.81
2018 218 BachSci 2.18
2018 358 MathApp 3.58
2018 362 Economics 3.62
2017 294 Management 2.94
2018 223 Management 2.23
2017 377 PolSci 3.77
2017 381 FAS-Hist 3.81
2017 304 BasSci 3.04
2018 310 Management 3.10
2018 376 MechEngr 3.76
2018 268 FAS-PolSci 2.68
2018 267 BasSci 2.67
2018 273 Management 2.73
2017 365 CompSci 3.65
2017 380 Management 3.80
2017 370 MatChem 3.70
2018 256 BehSci 2.56
2018 234 Management 2.34
2017 246 Economics 2.46
2017 367 AeroEngr 3.67
2017 296 Physics 2.96
2018 319 Economics 3.19
2018 311 OpsRsch 3.11
2018 341 AeroEngr 3.41
2017 261 Management 2.61
2018 273 CivEngr 2.73
2017 322 MechEngr 3.22
2018 306 SysEngr 3.06
2018 266 SysEngr 2.66
2018 362 AeroEngr 3.62
2018 304 Chemistry 3.04
2018 338 BasSci 3.38
2018 275 BehSci 2.75
2018 317 BehSci 3.17
2018 344 ElEngr 3.44
2018 325 ElEngr 3.25
2018 396 AeroEngr 3.96
2018 351 Management 3.51
2017 257 FAS-PolSci 2.57
2018 312 SysEngr 3.12
2018 389 OpsRsch 3.89
2018 321 GeoSci 3.21
2018 210 Management 2.10
2018 295 CivEngr 2.95
2017 236 Management 2.36
2017 309 Management 3.09
2018 342 MechEngr 3.42
2017 336 Management 3.36
2018 253 Management 2.53
2018 307 BehSci 3.07
2018 259 Management 2.59
2017 364 CompSciCW 3.64
2018 301 SysEngr 3.01
2018 363 MechEngr 3.63
2017 243 English 2.43
2018 245 LegalStu 2.45
2017 286 HistoryMil 2.86
2018 315 GeoSci 3.15
2017 300 History 3.00
2017 310 Economics 3.10
2018 351 MSS 3.51
2017 311 MechEngr 3.11
2017 390 Management 3.90
2017 288 AeroEngr 2.88
2018 275 Biology 2.75
2018 354 LegalStu 3.54
2018 351 AeroEngr 3.51
2018 273 CompSciCW 2.73
2018 293 CompSciCW 2.93
2017 241 Management 2.41
2017 303 Biology 3.03
2017 269 Biology 2.69
2018 336 Economics 3.36
2018 282 Management 2.82
2018 316 English 3.16
2017 307 LegalStu 3.07
2018 290 SysEngr 2.90
2017 282 SysEngr 2.82
2018 240 Management 2.40
2018 363 SysEngr 3.63
2018 247 Economics 2.47
2017 333 SysEngr 3.33
2017 303 English 3.03
2018 294 Management 2.94
2018 365 CompSciCW 3.65
2018 264 FAS-Geo 2.64
2018 270 GeoSci 2.70
2017 228 BehSci 2.28
2018 313 AeroEngr 3.13
2017 246 SysEngr 2.46
2018 223 Management 2.23
2017 225 FAS-Hist 2.25
2018 296 MechEngr 2.96
2017 383 ElEngr 3.83
2017 315 CompSciCW 3.15
2017 309 SysEngr 3.09
2017 321 Biology 3.21
2017 249 Management 2.49
2017 325 Economics 3.25
2018 336 Biology 3.36
2018 342 FAS-Hist 3.42
2017 303 Management 3.03
2018 274 AeroEngr 2.74
2017 295 Management 2.95
2018 335 AeroEngr 3.35
2017 284 CivEngr 2.84
2017 251 Management 2.51
2017 309 BehSci 3.09
2017 233 BehSciHF 2.33
2017 366 GeoSci 3.66
2017 278 SysEngr 2.78
2017 289 GeoSci 2.89
2017 306 Biology 3.06
2017 308 Economics 3.08
2018 244 SysEngr 2.44
2017 249 PolSci 2.49
2018 255 Management 2.55
2017 226 Management 2.26
2018 297 Management 2.97
2018 305 Management 3.05
2017 368 Economics 3.68
2017 279 MatChem 2.79
2017 373 AeroEngr 3.73
2017 244 SysEngr 2.44
2018 299 BehSci 2.99
2017 321 ElEngr 3.21
2017 344 AeroEngr 3.44
2018 315 EnvEngr 3.15
2017 287 Management 2.87
2018 285 AeroEngr 2.85
2018 285 Economics 2.85
2017 338 HistoryInt 3.38
2018 271 Management 2.71
2018 237 Management 2.37
2017 308 Physics 3.08
2018 239 SysEngr 2.39
2018 217 Management 2.17
2018 300 ElEngr 3.00
2017 256 CompEngr 2.56
2018 337 Management 3.37
2018 223 SysEngr 2.23
2018 223 Management 2.23
2018 315 CompEngr 3.15
2017 300 HistoryInt 3.00
2017 309 Management 3.09
2017 289 MechEngr 2.89
2018 309 Biology 3.09
2018 324 Physics 3.24
2018 324 Economics 3.24
2017 305 BehSciHF 3.05
2018 251 Economics 2.51
2018 272 MechEngr 2.72
2018 288 AeroEngr 2.88
2018 279 AstroEngr 2.79
2017 267 Management 2.67
2017 231 Management 2.31
2018 310 AeroEngr 3.10
2018 317 BehSci 3.17
2018 309 GenEngr 3.09
2018 271 BehSci 2.71
2017 301 AeroEngr 3.01
2017 254 CompEngr 2.54
2018 311 HistoryMil 3.11
2017 246 SocSci 2.46
2018 318 Management 3.18
2018 266 BehSci 2.66
2018 341 Biology 3.41
2017 276 BehSci 2.76
2017 324 Management 3.24
2017 269 Economics 2.69
2018 243 Management 2.43
2018 357 BehSci 3.57
2018 375 Economics 3.75
2018 224 EnvEngr 2.24
2018 304 Biology 3.04
2017 258 Management 2.58
2017 297 CivEngr 2.97
2018 304 Management 3.04
2017 302 Management 3.02
2018 223 BehSciHF 2.23
2017 300 Management 3.00
2018 382 CompEngr 3.82
2017 320 CompSciCW 3.20
2017 245 OpsRsch 2.45
2017 242 Management 2.42
2017 286 SysEngr 2.86
2017 356 SysEngr 3.56
2018 334 Biology 3.34
2017 269 LegalStu 2.69
2018 249 BehSci 2.49
2017 241 Economics 2.41
2017 363 BehSciHF 3.63
2017 232 Management 2.32
2018 293 Biology 2.93
2018 221 MSS 2.21
2017 355 Economics 3.55
2018 255 Humanities 2.55
2017 334 SysEngr 3.34
2017 349 Biology 3.49
2018 259 BehSci 2.59
2017 239 AstroEngr 2.39
2018 224 Management 2.24
2017 301 Economics 3.01
2017 275 PolSci 2.75
2017 335 Management 3.35
2018 243 PolSci 2.43
2018 365 CivEngr 3.65
2017 282 Economics 2.82
2017 227 Management 2.27
2017 326 LegalStu 3.26
2017 260 GeoSci 2.60
2018 396 Biology 3.96
2018 249 LegalStu 2.49
2017 333 GeoSci 3.33
2018 298 OpsRsch 2.98
2017 338 SysEngr 3.38
2018 341 Economics 3.41
2018 254 GeoSci 2.54
2018 301 Management 3.01
2018 205 SocSci 2.05
2017 313 MechEngr 3.13
2017 368 AeroEngr 3.68
2017 322 LegalStu 3.22
2018 240 GeoSci 2.40
2018 385 AstroEngr 3.85
2017 268 HistoryInt 2.68
2018 281 PolSci 2.81
2017 213 SocSci 2.13
2018 308 Biology 3.08
2018 331 CivEngr 3.31
2017 249 CompSci 2.49
2017 244 Management 2.44
2017 356 BioChem 3.56
2017 366 OpsRsch 3.66
2017 285 CompSci 2.85
2017 374 FAS-Geo 3.74
2017 373 Management 3.73
2018 351 SysEngr 3.51
2017 280 MechEngr 2.80
2018 327 AeroEngr 3.27
2017 212 SysEngr 2.12
2017 337 SysEngr 3.37
2017 281 Management 2.81
2018 350 MechEngr 3.50
2018 278 AstroEngr 2.78
2017 287 Management 2.87
2018 342 Biology 3.42
2018 307 MechEngr 3.07
2017 267 Biology 2.67
2017 244 FAS-PolSci 2.44
2018 283 LegalStu 2.83
2017 262 LegalStu 2.62
2018 293 Management 2.93
2017 346 Management 3.46
2017 360 Biology 3.60
2017 321 BehSci 3.21
2018 230 Management 2.30
2017 326 Management 3.26
2017 340 Humanities 3.40
2018 299 PolSci 2.99
2018 375 CivEngr 3.75
2017 334 OpsRsch 3.34
2017 306 MechEngr 3.06
2017 272 Management 2.72
2017 314 Physics 3.14
2018 298 AstroEngr 2.98
2018 306 Biology 3.06
2018 256 Management 2.56
2017 288 CivEngr 2.88
2017 331 PolSci 3.31
2017 299 Management 2.99
2018 340 OpsRsch 3.40
2017 279 PolSci 2.79
2017 348 Biology 3.48
2018 343 BehSci 3.43
2017 327 AstroEngr 3.27
2018 289 LegalStu 2.89
2018 317 Management 3.17
2017 314 Management 3.14
2017 299 CompEngr 2.99
2018 277 CivEngr 2.77
2018 288 Economics 2.88
2017 275 English 2.75
2017 241 BasSci 2.41
2018 333 Economics 3.33
2018 377 AstroEngr 3.77
2018 306 SysEngr 3.06
2017 371 GeoSci 3.71
2017 258 SysEngr 2.58
2018 247 SysEngr 2.47
2017 355 SysEngr 3.55
2018 228 Economics 2.28
2018 359 LegalStu 3.59
2017 250 SocSci 2.50
2018 267 BasSci 2.67
2017 306 AeroEngr 3.06
2017 262 HistoryInt 2.62
2017 284 BehSci 2.84
2017 241 BioChem 2.41
2017 253 BasSci 2.53
2017 256 SysEngr 2.56
2018 350 CivEngr 3.50
2017 219 Management 2.19
2017 270 SysEngr 2.70
2018 258 Management 2.58
2017 326 Biology 3.26
2018 313 CivEngr 3.13
2017 300 English 3.00
2017 353 Management 3.53
2017 370 CivEngr 3.70
2017 281 CompSciCW 2.81
2017 272 Biology 2.72
2018 269 FAS-PolSci 2.69
2018 327 CivEngr 3.27
2017 281 English 2.81
2017 359 CivEngr 3.59
2018 273 Physics 2.73
2018 277 SysEngr 2.77
2017 339 MechEngr 3.39
2017 356 Economics 3.56
2018 333 AstroEngr 3.33
2018 263 BehSciLO 2.63
2017 239 Management 2.39
2017 263 Management 2.63
2017 303 LegalStu 3.03
2017 339 BehSci 3.39
2017 315 CompSciCW 3.15
2017 254 Management 2.54
2018 351 CivEngr 3.51
2018 292 Management 2.92
2017 255 SysEngr 2.55
2018 314 SysEngr 3.14
2017 302 SysEngr 3.02
2018 238 Management 2.38
2017 324 PolSci 3.24
2017 281 Physics 2.81
2017 336 MechEngr 3.36
2018 287 Management 2.87
2018 331 GeoSci 3.31
2018 312 ElEngr 3.12
2017 278 PolSci 2.78
2017 345 GeoSci 3.45
2018 302 Biology 3.02
2017 270 Management 2.70
2018 282 Economics 2.82
2017 238 Management 2.38
2018 339 English 3.39
2017 311 Biology 3.11
2018 354 BehSci 3.54
2017 252 CivEngr 2.52
2018 355 PolSci 3.55
2017 266 CompEngr 2.66
2017 295 PolSci 2.95
2017 261 Physics 2.61
2017 261 Management 2.61
2017 377 Management 3.77
2017 370 MSS 3.70
2017 238 HistoryInt 2.38
2017 282 Economics 2.82
2017 221 SysEngr 2.21
2017 302 Management 3.02
2017 385 English 3.85
2018 374 Chemistry 3.74
2017 357 GeoSci 3.57
2017 340 Biology 3.40
2017 259 ElEngr 2.59
2017 339 Management 3.39
2017 307 Management 3.07
2017 234 SysEngr 2.34
2018 312 Management 3.12
2018 263 AeroEngr 2.63
2018 273 GeoSci 2.73
2018 293 Biology 2.93
2018 293 Management 2.93
2018 275 BehSci 2.75
2018 230 BehSci 2.30
2017 299 Management 2.99
2018 302 MechEngr 3.02
2017 309 Physics 3.09
2018 217 SysEngr 2.17
2018 245 SysEngr 2.45
2017 275 ElEngr 2.75
2018 258 BehSci 2.58
2018 258 Management 2.58
2018 365 AstroEngr 3.65
2017 326 OpsRsch 3.26
2018 274 AeroEngr 2.74
2018 315 BehSci 3.15
2017 359 MatChem 3.59
2018 395 Biology 3.95
2018 364 OpsRsch 3.64
2018 321 Biology 3.21
2017 301 Management 3.01
2018 241 PolSci 2.41
2017 268 BehSciHF 2.68
2017 293 Economics 2.93
2018 319 MechEngr 3.19
2017 272 BehSci 2.72
2018 305 CivEngr 3.05
2017 354 OpsRsch 3.54
2017 382 Meteor 3.82
2018 231 Management 2.31
2017 249 Management 2.49
2017 323 AeroEngr 3.23
2017 226 Management 2.26
2017 323 AeroEngr 3.23
2018 367 ElEngr 3.67
2017 239 Management 2.39
2017 302 EnvEngr 3.02
2017 270 FAS-PolSci 2.70
2018 303 SysEngr 3.03
2017 258 CompSciCW 2.58
2018 248 Economics 2.48
2018 287 PolSci 2.87
2017 299 GeoSci 2.99
2018 379 PolSci 3.79
2018 286 MechEngr 2.86
2018 301 Management 3.01
2018 356 MechEngr 3.56
2018 377 Physics 3.77
2018 301 LegalStu 3.01
2017 270 CompSciCW 2.70
2017 300 GeoSci 3.00
2017 293 Management 2.93
2018 271 AeroEngr 2.71
2017 260 CivEngr 2.60
2018 307 Economics 3.07
2017 393 AeroEngr 3.93
2017 259 CompSciCW 2.59
2017 375 Economics 3.75
2018 237 Biology 2.37
2018 269 BehSci 2.69
2018 257 Management 2.57
2017 257 CivEngr 2.57
2018 288 FAS-Geo 2.88
2018 364 MatChem 3.64
2017 304 AstroEngr 3.04
2017 337 GeoSci 3.37
2017 285 MathApp 2.85
2018 298 Chemistry 2.98
2018 335 SysEngr 3.35
2017 374 SysEngr 3.74
2018 305 Economics 3.05
2018 265 SocSci 2.65
2018 332 MechEngr 3.32
2017 255 Management 2.55
2017 267 LegalStu 2.67
2017 290 Economics 2.90
2018 333 Biology 3.33
2018 269 Management 2.69
2017 292 Management 2.92
2018 307 Economics 3.07
2018 252 PolSci 2.52
2017 319 Economics 3.19
2017 289 Economics 2.89
2018 234 Management 2.34
2017 294 Management 2.94
2017 267 Management 2.67
2017 347 MechEngr 3.47
2018 393 ElEngr 3.93

Pivot Table

Pivot Table Created from "Raw Data" of 2017 and 2018 Graduating Classes.
HELP: Click anywhere in the Pivot Table to open the PivotTable Tools menu.
Drag available data fields into FILTERS, ROWS, COLUMNS or VALUES.
Use the drop-down menus to change VALUE FIELD SETTING such as AVERAGE, SUM, COUNT, etc.
Use the Row Labels drop-down menu to FILTER or SORT the data fields.
NOTE -- if your original data changes, you MUST refresh the Pivot Table to update it ! This does NOT happen automatically. Right-click on Pivot Table and select REFRESH.
PASTE answer to Question A here. PASTE answer to Question B here. PASTE answer to Question C here. PASTE answer to Question D here.
Row Labels Average of Re-coded GPA
AeroEngr 3.26 MAJOR Average of Re-coded GPA MAJOR Average of Re-coded GPA MAJOR 2017 2018 Grand Total MAJOR 2017 2018 Grand Total
AstroEngr 3.43
BachSci 2.15
BasSci 2.77
BehSci 2.97
BehSciHF 2.76
BehSciLO 2.82
BioChem 3.22
Biology 3.13
Chemistry 3.16
CivEngr 3.01
CompEngr 3.09
CompSci 2.86
CompSciCW 2.94
Economics 3.03
ElEngr 3.25
English 2.97
EnvEngr 2.85
FAS-Geo 3.01
FAS-Hist 3.16
FAS-MSS 3.43
FAS-PolSci 2.79
GenEngr 3.09
GeoSci 3.07
History 3.00
HistoryInt 2.82
HistoryMil 3.07
Humanities 2.98
LegalStu 2.99
Management 2.73
MatChem 3.38
Math 3.65
MathApp 3.26
MechEngr 3.25
Meteor 3.21
MSS 2.86
OpsRsch 3.25
Physics 3.12
PolSci 2.99
SocSci 2.27
SpaceOps 2.55
SysEngr 2.91
(blank)
Grand Total 2.98