DataFilesforAssignment2.zip
PivotTable 3.xlsx
Sheet1
| TV Brands Sold |
| Sony |
| Mitsubishi |
| Sony |
| Sony |
| Panasonic |
| Mitsubishi |
| Panasonic |
| Sony |
| RCA |
| RCA |
| Sony |
| Panasonic |
| Sony |
| Sharp |
| Sharp |
| Panasonic |
| Sony |
| Sony |
| Panasonic |
| Mitsubishi |
| RCA |
| Panasonic |
| Sony |
| Panasonic |
| Sony |
| Panasonic |
| Mitsubishi |
| Mitsubishi |
| Sony |
| Sharp |
| Sharp |
| Panasonic |
| Sony |
| RCA |
| Sony |
| Panasonic |
| Panasonic |
| Sony |
| Panasonic |
| Sony |
| Sony |
| Panasonic |
| Mitsubishi |
| Sharp |
| Sharp |
| Mitsubishi |
| Sony |
| Panasonic |
| Sony |
| Panasonic |
| Panasonic |
| Sharp |
| Sharp |
| Sony |
| Sony |
| RCA |
| Sharp |
| Panasonic |
| Sony |
| Panasonic |
| Panasonic |
| Panasonic |
| Sony |
| Panasonic |
| Sony |
| Sony |
| Panasonic |
| Mitsubishi |
| Sharp |
| Sharp |
| Mitsubishi |
| Sony |
| Panasonic |
| Sony |
| Panasonic |
| Panasonic |
| Sharp |
| Sharp |
| Panasonic |
| Sanyo |
| Sanyo |
| Sanyo |
| Mitsubishi |
| RCA |
| Panasonic |
| Sony |
| Panasonic |
| Sony |
| Sony |
| Panasonic |
| Sony |
| Sony |
| Panasonic |
| Sony |
| Sony |
| Panasonic |
| Sony |
| Sony |
| Panasonic |
| Panasonic |
| Sony |
| Sharp |
| Sharp |
| Panasonic |
| Sony |
| Sony |
| Sanyo |
| Sanyo |
| Sanyo |
| Panasonic |
| Sony |
| Panasonic |
| Sony |
| Panasonic |
| Mitsubishi |
| Mitsubishi |
| Sony |
| Sharp |
| Sharp |
| Panasonic |
| Sony |
| Mitsubishi |
| Sony |
| Sony |
| Panasonic |
| Mitsubishi |
| Panasonic |
| Sony |
| RCA |
| RCA |
| Sanyo |
| Sanyo |
| Sanyo |
| Sanyo |
| Panasonic |
| Mitsubishi |
| Mitsubishi |
| Sony |
| Sharp |
| Sharp |
| Panasonic |
| Sanyo |
| Sanyo |
| Sanyo |
| Panasonic |
| Mitsubishi |
| Mitsubishi |
| Sony |
| Panasonic |
| Panasonic |
Pivot Table 2.xlsx
Sheet1
| Gender | Major | Employment Status |
| Male | 1 | Employed |
| Female | 2 | Self-employed |
| Male | 1 | Employed |
| Male | 4 | Self-employed |
| Male | 5 | Employed |
| Female | 3 | Employed |
| Male | 1 | Employed |
| Female | 1 | Employed |
| Male | 2 | Employed |
| Female | 2 | Employed |
| Male | 2 | Employed |
| Male | 2 | Employed |
| Female | 2 | Employed |
| Female | 3 | Employed |
| Female | 3 | Employed |
| Male | 3 | Employed |
| Male | 3 | Employed |
| Male | 3 | Employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Male | 4 | Employed |
| Female | 4 | Employed |
| Male | 4 | Employed |
| Male | 5 | Employed |
| Male | 5 | Employed |
| Female | 5 | Employed |
| Male | 5 | Employed |
| Female | 5 | Employed |
| Male | 5 | Employed |
| Female | 4 | Employed |
| Male | 2 | Employed |
| Male | 2 | Employed |
| Female | 3 | Self-employed |
| Female | 3 | Self-employed |
| Female | 3 | Self-employed |
| Male | 4 | Employed |
| Male | 4 | Employed |
| Male | 4 | Employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Male | 4 | Employed |
| Female | 3 | Employed |
| Male | 2 | Employed |
| Female | 5 | Employed |
| Male | 1 | Employed |
| Male | 2 | Employed |
| Female | 4 | Employed |
| Female | 5 | Employed |
| Female | 3 | Employed |
| Male | 4 | Employed |
| Female | 3 | Employed |
| Female | 3 | Employed |
| Female | 3 | Employed |
| Male | 3 | Employed |
| Female | 3 | Employed |
| Male | 1 | Employed |
| Female | 4 | Employed |
| Male | 5 | Employed |
| Male | 3 | Self-employed |
| Female | 2 | Self-employed |
| Female | 1 | Self-employed |
| Female | 5 | Employed |
| Male | 4 | Employed |
| Female | 3 | Employed |
| Female | 2 | Employed |
| Female | 1 | Employed |
| Male | 5 | Employed |
| Female | 3 | Employed |
| Male | 2 | Employed |
| Female | 3 | Employed |
| Male | 1 | Employed |
| Male | 1 | Self-employed |
| Female | 3 | Self-employed |
| Female | 3 | Self-employed |
| Female | 3 | Self-employed |
| Male | 2 | Self-employed |
| Female | 2 | Self-employed |
| Male | 2 | Self-employed |
| Female | 4 | Self-employed |
| Male | 4 | Self-employed |
| Male | 4 | Self-employed |
| Female | 4 | Self-employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Male | 2 | Employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Female | 3 | Employed |
| Male | 2 | Employed |
| Female | 3 | Employed |
| Male | 2 | Employed |
| Female | 3 | Employed |
| Male | 2 | Employed |
| Male | 2 | Employed |
| Male | 5 | Employed |
| Female | 5 | Employed |
| Male | 5 | Employed |
| Female | 5 | Employed |
| Male | 5 | Employed |
| Male | 5 | Employed |
| Female | 5 | Employed |
| Female | 5 | Employed |
| Female | 4 | Employed |
| Male | 4 | Employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Male | 4 | Employed |
| Female | 4 | Employed |
| Male | 2 | Employed |
| Female | 3 | Employed |
| Male | 2 | Employed |
| Male | 2 | Employed |
| Male | 3 | Employed |
| Female | 2 | Employed |
| Female | 4 | Employed |
| Female | 3 | Employed |
| Male | 5 | Employed |
| Female | 3 | Employed |
| Male | 2 | Employed |
| Female | 3 | Self-employed |
| Male | 1 | Self-employed |
| Male | 1 | Self-employed |
| Male | 4 | Self-employed |
| Female | 5 | Self-employed |
| Male | 2 | Self-employed |
| Female | 3 | Self-employed |
| Male | 3 | Self-employed |
| Male | 4 | Self-employed |
| Female | 5 | Employed |
| Female | 2 | Employed |
| Female | 1 | Employed |
| Male | 4 | Employed |
| Female | 1 | Employed |
| Female | 5 | Employed |
| Male | 4 | Employed |
| Female | 3 | Employed |
| Female | 2 | Employed |
| Female | 3 | Employed |
| Male | 4 | Employed |
| Female | 5 | Self-employed |
| Male | 2 | Self-employed |
| Female | 5 | Self-employed |
| Male | 1 | Employed |
| Male | 2 | Employed |
| Male | 1 | Employed |
| Female | 4 | Employed |
| Male | 5 | Employed |
| Female | 3 | Employed |
| Male | 4 | Employed |
| Male | 4 | Employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Female | 4 | Employed |
| Male | 4 | Self-employed |
| Female | 4 | Self-employed |
| Female | 4 | Self-employed |
| Male | 4 | Self-employed |
| Female | 4 | Self-employed |
| Male | 4 | Self-employed |
| Male | 4 | Self-employed |
| Male | 4 | Self-employed |
| Female | 5 | Employed |
| Male | 2 | Employed |
| Female | 3 | Employed |
| Male | 2 | Employed |
| Female | 5 | Employed |
| Male | 4 | Employed |
| Male | 4 | Employed |
| Female | 4 | Employed |
| Female | 1 | Employed |
| Female | 3 | Employed |
| Male | 3 | Employed |
| Male | 2 | Self-employed |
| Male | 2 | Self-employed |
| Female | 4 | Self-employed |
| Female | 4 | Employed |
| Male | 5 | Employed |
| Male | 5 | Employed |
| Female | 5 | Employed |
| Male | 3 | Employed |
| Male | 3 | Employed |
| Male | 2 | Employed |
| Female | 3 | Employed |
| Male | 4 | Employed |
| Female | 5 | Employed |
| Male | 4 | Employed |
| Female | 2 | Self-employed |
| Male | 4 | Self-employed |
| Male | 5 | Self-employed |
| Female | 4 | Employed |
| Female | 3 | Employed |
| Female | 2 | Employed |
| Male | 1 | Employed |
| Male | 3 | Employed |
| Male | 2 | Employed |
| Female | 5 | Employed |
| Female | 3 | Employed |
| Male | 4 | Employed |
| | Majors: | 1=Computer Science |
| | | 2=Engineering |
| | | 3=Business |
| | | 4=Social Sciences |
| | | 5=Other |
PivotTable 1.xlsx
Sheet1
| Lifetime (Hours) |
| 314 |
| 276 |
| 430 |
| 340 |
| 322 |
| 325 |
| 343 |
| 322 |
| 309 |
| 271 |
| 276 |
| 416 |
| 306 |
| 387 |
| 375 |
| 277 |
| 359 |
| 370 |
| 215 |
| 373 |
| 330 |
| 253 |
| 253 |
| 298 |
| 242 |
| 282 |
| 203 |
| 325 |
| 246 |
| 302 |
| 329 |
| 360 |
| 279 |
| 304 |
| 346 |
| 366 |
| 363 |
| 357 |
| 277 |
| 280 |
| 371 |
| 286 |
| 378 |
| 330 |
| 331 |
| 315 |
| 373 |
| 252 |
| 302 |
| 331 |
| 379 |
| 337 |
| 414 |
| 302 |
| 413 |
| 345 |
| 243 |
| 314 |
| 313 |
| 339 |
| 365 |
| 344 |
| 306 |
| 311 |
| 236 |
| 328 |
| 297 |
| 345 |
| 260 |
| 374 |
| 288 |
| 273 |
| 262 |
| 280 |
| 309 |
| 409 |
| 339 |
| 348 |
| 300 |
| 349 |
| 267 |
| 385 |
| 376 |
| 318 |
| 344 |
| 319 |
| 276 |
| 373 |
| 292 |
| 355 |
| 356 |
| 298 |
| 372 |
| 287 |
| 283 |
| 312 |
| 323 |
| 257 |
| 322 |
| 363 |
| 307 |
| 349 |
| 308 |
| 358 |
| 418 |
| 353 |
| 333 |
| 317 |
| 231 |
| 336 |
| 302 |
| 390 |
| 303 |
| 368 |
| 299 |
| 266 |
| 297 |
| 291 |
| 304 |
| 297 |
| 371 |
| 269 |
| 339 |
| 354 |
| 328 |
| 336 |
| 257 |
| 307 |
| 338 |
| 312 |
| 263 |
| 215 |
| 346 |
| 281 |
| 335 |
| 383 |
| 333 |
| 358 |
| 282 |
| 274 |
| 297 |
| 304 |
| 368 |
| 406 |
| 393 |
| 384 |
| 367 |
| 289 |
| 372 |
| 354 |
| 364 |
| 382 |
| 331 |
| 329 |
| 330 |
| 289 |
| 299 |
| 409 |
| 410 |
| 334 |
| 291 |
| 319 |
| 289 |
| 369 |
| 267 |
| 298 |
| 296 |
| 363 |
| 226 |
| 329 |
| 337 |
| 329 |
| 362 |
| 309 |
| 376 |
| 294 |
| 302 |
| 337 |
| 390 |
| 359 |
| 398 |
| 283 |
| 344 |
| 254 |
| 305 |
| 398 |
| 349 |
| 340 |
| 365 |
| 345 |
| 361 |
| 306 |
| 366 |
| 310 |
| 260 |
| 370 |
| 384 |
| 347 |
| 332 |
| 330 |
sty1219179471
