excel: Create Pivot Tables and Charts

profilethonolan
downloads.rar
Home>Information Systems homework help>excel: Create Pivot Tables and Charts

Source-Employment.xlsx

Sheet1

Employees on nonfarm payrolls by industry supersector, 12 largest metropolitan areas, not seasonally adjusted (numbers in thousands)
Area and Industry Aug. June July Aug. Change from Aug.
2013 2014 2014 2014(p) 2013 to Aug. 2014(p)
Number Percent
Atlanta-Sandy Springs-Marietta, GA
Total nonfarm 2,419.20 2,463.90 2,464.70 2,470.60 51.4 2.1
Mining and logging 1.2 1.2 1.2 1.2 0 0
Construction 94.3 97.5 97.7 98.1 3.8 4
Manufacturing 149.3 153.2 153.7 154.2 4.9 3.3
Trade, transportation, and utilities 538.2 548.6 551 549.5 11.3 2.1
Information 85.2 86.7 87.4 87.2 2 2.3
Financial activities 157.9 160 162.3 161.5 3.6 2.3
Professional and business services 439.8 453.6 458.2 457.4 17.6 4
Education and health services 294.5 292.2 291.8 295.8 1.3 0.4
Leisure and hospitality 252.9 263.7 264.4 261.4 8.5 3.4
Other services 94.2 92.3 92.2 92.6 -1.6 -1.7
Government 311.7 314.9 304.8 311.7 0 0
Boston-Cambridge-Quincy, MA-NH
Total nonfarm 2,551.80 2,622.00 2,610.80 2,591.90 40.1 1.6
Mining and logging 0.6 0.6 0.6 0.6 0 0
Construction 95.8 93 96.5 96 0.2 0.2
Manufacturing 194.2 195.5 195.2 195.4 1.2 0.6
Trade, transportation, and utilities 409.5 421.3 418.9 405.4 -4.1 -1
Information 75.3 78.6 79.4 79.8 4.5 6
Financial activities 175.2 174.2 176.1 176.2 1 0.6
Professional and business services 441.4 447.3 450.9 451 9.6 2.2
Education and health services 522.8 539.5 543.8 541 18.2 3.5
Leisure and hospitality 259.8 262.5 265 267 7.2 2.8
Other services 101.8 103 104.7 104.1 2.3 2.3
Government 275.4 306.5 279.7 275.4 0 0
Chicago-Joliet-Naperville, IL-IN-WI
Total nonfarm 4,472.30 4,527.30 4,505.70 4,510.60 38.3 0.9
Mining and logging 1.6 1.4 1.4 1.4 -0.2 -12.5
Construction 160.4 163.1 167 167.3 6.9 4.3
Manufacturing 411.2 405.9 407.8 408.9 -2.3 -0.6
Trade, transportation, and utilities 900.1 904.5 903 903.4 3.3 0.4
Information 80.7 80.6 80.9 80.6 -0.1 -0.1
Financial activities 291.9 290.7 291.7 290.6 -1.3 -0.4
Professional and business services 780.4 790.8 794.5 799 18.6 2.4
Education and health services 670.3 683.5 673.7 673.7 3.4 0.5
Leisure and hospitality 446.5 451.3 449 452.4 5.9 1.3
Other services 193.9 196.1 194.5 194.1 0.2 0.1
Government 535.3 559.4 542.2 539.2 3.9 0.7
Dallas-Fort Worth-Arlington, TX
Total nonfarm 3,107.50 3,216.60 3,202.80 3,209.00 101.5 3.3
Mining, logging, and construction 180.5 191.1 191.2 193 12.5 6.9
Manufacturing 258.6 257.9 258.6 258.7 0.1 0
Trade, transportation, and utilities 643.2 663.7 664.3 665.2 22 3.4
Information 80.2 81 80.5 80.2 0 0
Financial activities 256.4 255.5 256.3 257.5 1.1 0.4
Professional and business services 489.7 522.3 525.4 529.5 39.8 8.1
Education and health services 384.2 392.4 389.9 390.7 6.5 1.7
Leisure and hospitality 323.1 338.7 337.1 333.2 10.1 3.1
Other services 112.6 114.4 115.1 114.4 1.8 1.6
Government 379 399.6 384.4 386.6 7.6 2
Detroit-Warren-Livonia, MI
Total nonfarm 1,867.80 1,896.90 1,865.10 1,870.50 2.7 0.1
Mining, logging, and construction 62.4 62.9 64.5 65.8 3.4 5.4
Manufacturing 232.5 238.4 230.8 237 4.5 1.9
Trade, transportation, and utilities 350.5 355.9 354.2 353.1 2.6 0.7
Information 27.4 27.4 27.4 27.3 -0.1 -0.4
Financial activities 104.5 98.3 98.1 97.8 -6.7 -6.4
Professional and business services 360.2 365.3 359.3 366.2 6 1.7
Education and health services 294.6 298.5 297.4 293.7 -0.9 -0.3
Leisure and hospitality 185.2 186.2 185.7 183.2 -2 -1.1
Other services 78.3 77 76.5 76.3 -2 -2.6
Government 172.2 187 171.2 170.1 -2.1 -1.2
Houston-Sugar Land-Baytown, TX
Total nonfarm 2,789.00 2,895.30 2,892.70 2,896.40 107.4 3.9
Mining and logging 108.9 114.6 116.4 117.8 8.9 8.2
Construction 190.5 196.6 195.7 201.4 10.9 5.7
Manufacturing 252.8 260.5 261.5 262.2 9.4 3.7
Trade, transportation, and utilities 570.8 583.1 585.4 584.8 14 2.5
Information 32.8 33.2 33.3 33.3 0.5 1.5
Financial activities 144.4 145.5 146.5 147.1 2.7 1.9
Professional and business services 431.6 443.1 446.1 447.6 16 3.7
Education and health services 335.4 347.6 348.5 354.4 19 5.7
Leisure and hospitality 276.9 290 291.3 287.6 10.7 3.9
Other services 98.9 102.6 103.5 102.4 3.5 3.5
Government 346 378.5 364.5 357.8 11.8 3.4
Los Angeles-Long Beach-Santa Ana, CA
Total nonfarm 5,551.50 5,687.80 5,622.80 5,638.50 87 1.6
Mining and logging 5.2 5.4 5.5 5.6 0.4 7.7
Construction 198.4 210 207.8 209.5 11.1 5.6
Manufacturing 525.9 510.3 511 511.3 -14.6 -2.8
Trade, transportation, and utilities 1,031.90 1,043.00 1,041.70 1,041.40 9.5 0.9
Information 224.6 231.6 229 230 5.4 2.4
Financial activities 326 322.5 321.2 321.8 -4.2 -1.3
Professional and business services 859 884.1 887.9 894.8 35.8 4.2
Education and health services 890.6 922 909.8 916.8 26.2 2.9
Leisure and hospitality 636.2 649.2 650.3 649.4 13.2 2.1
Other services 191.2 197.9 196.5 197.3 6.1 3.2
Government 662.5 711.8 662.1 660.6 -1.9 -0.3
Miami-Fort Lauderdale-Pompano Beach, FL
Total nonfarm 2,336.30 2,391.20 2,379.50 2,401.90 65.6 2.8
Mining and logging 0.6 0.6 0.6 0.6 0 0
Construction 96 101.5 101 102.8 6.8 7.1
Manufacturing 78 79.3 78.4 78.6 0.6 0.8
Trade, transportation, and utilities 545.6 563.2 563.9 564 18.4 3.4
Information 46.2 46.6 46.5 46.7 0.5 1.1
Financial activities 165.5 168.9 169.3 168.6 3.1 1.9
Professional and business services 371.8 384.6 382.9 384.2 12.4 3.3
Education and health services 343.8 351.3 349.3 351 7.2 2.1
Leisure and hospitality 279.8 297.4 291.7 288.8 9 3.2
Other services 110.2 115.5 115.6 115.1 4.9 4.4
Government 298.8 282.3 280.3 301.5 2.7 0.9
New York-Northern New Jersey-Long Island, NY-NJ-PA
Total nonfarm 8,679.70 8,918.70 8,873.80 8,836.20 156.5 1.8
Mining, logging, and construction 334.7 330.9 334.8 334.3 -0.4 -0.1
Manufacturing 357.2 358.5 354.3 356.1 -1.1 -0.3
Trade, transportation, and utilities 1,592.50 1,647.20 1,632.90 1,634.00 41.5 2.6
Information 280 272.9 275.4 276.4 -3.6 -1.3
Financial activities 747.3 742.1 747.8 745.9 -1.4 -0.2
Professional and business services 1,405.10 1,425.00 1,430.20 1,435.10 30 2.1
Education and health services 1,568.80 1,656.80 1,636.70 1,632.40 63.6 4.1
Leisure and hospitality 820.1 849.6 854.6 845.2 25.1 3.1
Other services 383 392.1 390.7 389.6 6.6 1.7
Government 1,191.00 1,243.60 1,216.40 1,187.20 -3.8 -0.3
Philadelphia-Camden-Wilmington, PA-NJ-DE-MD
Total nonfarm 2,726.40 2,798.10 2,763.90 2,751.10 24.7 0.9
Mining, logging, and construction 106.8 110.5 115.3 114.3 7.5 7
Manufacturing 180.6 179.7 179.8 178.9 -1.7 -0.9
Trade, transportation, and utilities 505.6 515 512.5 512.5 6.9 1.4
Information 47.6 46.4 46.2 46.1 -1.5 -3.2
Financial activities 204.8 205.2 206.4 206.5 1.7 0.8
Professional and business services 438.4 446.2 447.9 444.1 5.7 1.3
Education and health services 556.4 574.9 571.2 568.4 12 2.2
Leisure and hospitality 252.4 259.8 256.3 254 1.6 0.6
Other services 122 123.1 120.7 120.4 -1.6 -1.3
Government 311.8 337.3 307.6 305.9 -5.9 -1.9
San Francisco-Oakland-Fremont, CA
Total nonfarm 2,112.30 2,166.50 2,160.70 2,170.10 57.8 2.7
Mining and logging 1.3 1.2 1.2 1.2 -0.1 -7.7
Construction 97.6 100.2 103.1 106.1 8.5 8.7
Manufacturing 117 117.7 118.5 118 1 0.9
Trade, transportation, and utilities 345.6 350.7 352.2 353.7 8.1 2.3
Information 74.2 76.2 76.9 76.8 2.6 3.5
Financial activities 126.8 127 127.3 127.2 0.4 0.3
Professional and business services 423.2 433.3 436.3 437.2 14 3.3
Education and health services 312.7 324 321.9 322 9.3 3
Leisure and hospitality 245.4 252.2 251.7 255 9.6 3.9
Other services 80.3 80.3 80.3 81.1 0.8 1
Government 288.2 303.7 291.3 291.8 3.6 1.2
Washington-Arlington-Alexandria, DC-VA-MD-WV
Total nonfarm 3,073.90 3,121.40 3,108.00 3,084.20 10.3 0.3
Mining, logging, and construction 150.8 150.7 150.5 151.7 0.9 0.6
Manufacturing 48.4 46 45.8 46.4 -2 -4.1
Trade, transportation, and utilities 389.3 396.5 397.5 395.1 5.8 1.5
Information 77.6 74.1 74 73.6 -4 -5.2
Financial activities 152.1 155.1 156.8 156.5 4.4 2.9
Professional and business services 713.3 712.8 713.3 707.9 -5.4 -0.8
Education and health services 385.9 391.8 390.6 387 1.1 0.3
Leisure and hospitality 302.7 314.1 312.9 310.7 8 2.6
Other services 190.2 192.8 193.6 192.9 2.7 1.4
Government 663.6 687.5 673 662.4 -1.2 -0.2
(p) preliminary

Sheet2

Sheet3

Source-Sales.xlsx

Sheet1

Excel sample data workbook
OrderDate Region Rep Item Units Cost Total
1/6/12 East Jones Pencil 95 1.99 189.05
1/23/12 Central Kivell Binder 50 19.99 999.5
2/9/12 Central Jardine Pencil 36 4.99 179.64
2/26/12 Central Gill Pen 27 19.99 539.73
3/15/12 West Sorvino Pencil 56 2.99 167.44
4/1/12 East Jones Binder 60 4.99 299.4
4/18/12 Central Andrews Pencil 75 1.99 149.25
5/5/12 Central Jardine Pencil 90 4.99 449.1
5/22/12 West Thompson Pencil 32 1.99 63.68
6/8/12 East Jones Binder 60 8.99 539.4
6/25/12 Central Morgan Pencil 90 4.99 449.1
7/12/12 East Howard Binder 29 1.99 57.71
7/29/12 East Parent Binder 81 19.99 1,619.19
8/15/12 East Jones Pencil 35 4.99 174.65
9/1/12 Central Smith Desk 2 125 250
9/18/12 East Jones Pen Set 16 15.99 255.84
10/5/12 Central Morgan Binder 28 8.99 251.72
10/22/12 East Jones Pen 64 8.99 575.36
11/8/12 East Parent Pen 15 19.99 299.85
11/25/12 Central Kivell Pen Set 96 4.99 479.04
12/12/12 Central Smith Pencil 67 1.29 86.43
12/29/12 East Parent Pen Set 74 15.99 1,183.26
1/15/13 Central Gill Binder 46 8.99 413.54
2/1/13 Central Smith Binder 87 15 1,305.00
2/18/13 East Jones Binder 4 4.99 19.96
3/7/13 West Sorvino Binder 7 19.99 139.93
3/24/13 Central Jardine Pen Set 50 4.99 249.5
4/10/13 Central Andrews Pencil 66 1.99 131.34
4/27/13 East Howard Pen 96 4.99 479.04
5/14/13 Central Gill Pencil 53 1.29 68.37
5/31/13 Central Gill Binder 80 8.99 719.2
6/17/13 Central Kivell Desk 5 125 625
7/4/13 East Jones Pen Set 62 4.99 309.38
7/21/13 Central Morgan Pen Set 55 12.49 686.95
8/7/13 Central Kivell Pen Set 42 23.95 1,005.90
8/24/13 West Sorvino Desk 3 275 825
9/10/13 Central Gill Pencil 7 1.29 9.03
9/27/13 West Sorvino Pen 76 1.99 151.24
10/14/13 West Thompson Binder 57 19.99 1,139.43
10/31/13 Central Andrews Pencil 14 1.29 18.06
11/17/13 Central Jardine Binder 11 4.99 54.89
12/4/13 Central Jardine Binder 94 19.99 1,879.06
12/21/13 Central Andrews Binder 28 4.99 139.72
http://www.contextures.com/SampleData.zip

Sheet2

Sheet3

Source-Enrollments.xlsx

Sheet1

List of United States university campuses by enrollment
2013–14 enrollment
Ten largest public university campuses by enrollment during the 2013–14 academic year
Ranking University Location Enrollment
1 Arizona State University Tempe, Arizona 60,168
2 University of Central Florida Orlando, Florida 59,770
3 Ohio State University Columbus, Ohio 57,466
4 Florida International University Miami, Florida 52,980
5 Texas A&M University College Station, Texas 52,449
6 University of Texas at Austin Austin, Texas 51,145
7 Michigan State University East Lansing, Michigan 49,300
8 University of Florida Gainesville, Florida 49,042
9 University of Minnesota Minneapolis/Saint Paul, Minnesota 48,308
10 Indiana University Bloomington, Indiana 46,817
2012–13 enrollment
Ten largest public university campuses by enrollment during the 2012–13 academic year
Ranking University Location Enrollment
1 Arizona State University Tempe, Arizona 60,169
2 University of Central Florida Orlando, Florida 60,048
3 Texas A&M University College Station, Texas 58,804
4 Ohio State University Columbus, Ohio 57,466
5 University of Texas at Austin Austin, Texas 52,186
6 University of Minnesota Minneapolis/Saint Paul, Minnesota 51,853
7 Florida International University Miami, Florida 50,396
8 University of Florida Gainesville, Florida 49,913
9 Michigan State University East Lansing, Michigan 48,906
10 Pennsylvania State University University Park, Pennsylvania 45,351
2011–12 enrollment
Ten largest public university campuses by enrollment during the 2011–12 academic year
Ranking University Location Enrollment
1 Arizona State University Tempe, Arizona 59,794
2 University of Central Florida Orlando, Florida 58,587
3 Ohio State University Columbus, Ohio 58,587
4 University of Minnesota Minneapolis/Saint Paul, Minnesota 52,557
5 Texas A&M University College Station, TX 51,895
6 University of Texas at Austin Austin, Texas 51,112
7 University of Florida Gainesville, Florida 49,589
8 Florida International University Miami, Florida 47,966
9 Michigan State University East Lansing, Michigan 47,800
10 Pennsylvania State University University Park, Pennsylvania 44,485
2010–11 enrollment
Ten largest public university campuses by enrollment during the 2010–11 academic year
Ranking University Location Enrollment
1 Arizona State University Tempe, Arizona 58,000
2 University of Central Florida Orlando, Florida 56,235
3 Ohio State University Columbus, Ohio 56,064
4 University of Minnesota Minneapolis/Saint Paul, Minnesota 51,721
5 University of Texas at Austin Austin, Texas 51,195
6 University of Florida Gainesville, Florida 49,827
7 Texas A&M University College Station, Texas 49,129
8 Michigan State University East Lansing, Michigan 47,131
9 Pennsylvania State University University Park, Pennsylvania 44,034
10 Florida International University Miami, Florida 44,010
2009–10 enrollment
Ten largest public university campuses by enrollment during the 2009–10 academic year
Ranking University Location Enrollment
1 Arizona State University Tempe, Arizona 55,552
2 Ohio State University Columbus, Ohio 55,014
3 University of Central Florida Orlando, Florida 53,537
4 University of Minnesota Minneapolis/Saint Paul, Minnesota 51,659
5 University of Texas at Austin Austin, Texas 51,032
6 University of Florida Gainesville, Florida 50,691
7 Texas A&M University College Station, Texas 48,885
8 Michigan State University East Lansing, Michigan 47,100
9 Pennsylvania State University University Park, Pennsylvania 44,832
10 Indiana University Bloomington Bloomington, Indiana 42,347
http://en.wikipedia.org/wiki/Arizona_State_University http://en.wikipedia.org/wiki/Indiana_University_Bloomington http://en.wikipedia.org/wiki/Tempe,_Arizona http://en.wikipedia.org/wiki/Orlando,_Florida http://en.wikipedia.org/wiki/Columbus,_Ohio http://en.wikipedia.org/wiki/Miami,_Florida http://en.wikipedia.org/wiki/College_Station,_Texas http://en.wikipedia.org/wiki/Austin,_Texas http://en.wikipedia.org/wiki/East_Lansing,_Michigan http://en.wikipedia.org/wiki/Gainesville,_Florida http://en.wikipedia.org/wiki/Bloomington,_Indiana http://en.wikipedia.org/wiki/University_of_Central_Florida http://en.wikipedia.org/wiki/Arizona_State_University http://en.wikipedia.org/wiki/University_of_Central_Florida http://en.wikipedia.org/wiki/Texas_A%26M_University http://en.wikipedia.org/wiki/Ohio_State_University http://en.wikipedia.org/wiki/University_of_Texas_at_Austin http://en.wikipedia.org/wiki/University_of_Minnesota http://en.wikipedia.org/wiki/University_of_Florida http://en.wikipedia.org/wiki/Michigan_State_University http://en.wikipedia.org/wiki/Pennsylvania_State_University http://en.wikipedia.org/wiki/Tempe,_Arizona http://en.wikipedia.org/wiki/Ohio_State_University http://en.wikipedia.org/wiki/Orlando,_Florida http://en.wikipedia.org/wiki/College_Station,_Texas http://en.wikipedia.org/wiki/Columbus,_Ohio http://en.wikipedia.org/wiki/Austin,_Texas http://en.wikipedia.org/wiki/Miami,_Florida http://en.wikipedia.org/wiki/Gainesville,_Florida http://en.wikipedia.org/wiki/East_Lansing,_Michigan http://en.wikipedia.org/wiki/University_Park,_Pennsylvania http://en.wikipedia.org/wiki/University_of_Central_Florida http://en.wikipedia.org/wiki/Ohio_State_University http://en.wikipedia.org/wiki/Florida_International_University http://en.wikipedia.org/wiki/University_of_Minnesota http://en.wikipedia.org/wiki/University_of_Texas_at_Austin http://en.wikipedia.org/wiki/University_of_Florida http://en.wikipedia.org/wiki/Florida_International_University http://en.wikipedia.org/wiki/Michigan_State_University http://en.wikipedia.org/wiki/Pennsylvania_State_University http://en.wikipedia.org/wiki/University_Park,_Pennsylvania http://en.wikipedia.org/wiki/East_Lansing,_Michigan http://en.wikipedia.org/wiki/Miami,_Florida http://en.wikipedia.org/wiki/Gainesville,_Florida http://en.wikipedia.org/wiki/Texas_A%26M_University http://en.wikipedia.org/wiki/Austin,_Texas http://en.wikipedia.org/wiki/College_Station,_TX http://en.wikipedia.org/wiki/Columbus,_Ohio http://en.wikipedia.org/wiki/Orlando,_Florida http://en.wikipedia.org/wiki/Tempe,_Arizona http://en.wikipedia.org/wiki/Arizona_State_University http://en.wikipedia.org/wiki/University_of_Central_Florida http://en.wikipedia.org/wiki/Ohio_State_University http://en.wikipedia.org/wiki/University_of_Minnesota http://en.wikipedia.org/wiki/University_of_Texas_at_Austin http://en.wikipedia.org/wiki/University_of_Texas_at_Austin http://en.wikipedia.org/wiki/University_of_Florida http://en.wikipedia.org/wiki/Texas_A%26M_University http://en.wikipedia.org/wiki/Michigan_State_University http://en.wikipedia.org/wiki/Pennsylvania_State_University http://en.wikipedia.org/wiki/Florida_International_University http://en.wikipedia.org/wiki/Tempe,_Arizona http://en.wikipedia.org/wiki/Orlando,_Florida http://en.wikipedia.org/wiki/Columbus,_Ohio http://en.wikipedia.org/wiki/Austin,_Texas http://en.wikipedia.org/wiki/Gainesville,_Florida http://en.wikipedia.org/wiki/Michigan_State_University http://en.wikipedia.org/wiki/College_Station,_Texas http://en.wikipedia.org/wiki/East_Lansing,_Michigan http://en.wikipedia.org/wiki/University_Park,_Pennsylvania http://en.wikipedia.org/wiki/Miami,_Florida http://en.wikipedia.org/wiki/Arizona_State_University http://en.wikipedia.org/wiki/Ohio_State_University http://en.wikipedia.org/wiki/University_of_Central_Florida http://en.wikipedia.org/wiki/University_of_Minnesota http://en.wikipedia.org/wiki/University_of_Texas_at_Austin http://en.wikipedia.org/wiki/University_of_Florida http://en.wikipedia.org/wiki/University_of_Florida http://en.wikipedia.org/wiki/Texas_A%26M_University http://en.wikipedia.org/wiki/Michigan_State_University http://en.wikipedia.org/wiki/Pennsylvania_State_University http://en.wikipedia.org/wiki/Indiana_University_Bloomington http://en.wikipedia.org/wiki/Bloomington,_Indiana http://en.wikipedia.org/wiki/University_Park,_Pennsylvania http://en.wikipedia.org/wiki/East_Lansing,_Michigan http://en.wikipedia.org/wiki/College_Station,_Texas http://en.wikipedia.org/wiki/Gainesville,_Florida http://en.wikipedia.org/wiki/Austin,_Texas http://en.wikipedia.org/wiki/University_of_Minnesota http://en.wikipedia.org/wiki/Orlando,_Florida http://en.wikipedia.org/wiki/Columbus,_Ohio http://en.wikipedia.org/wiki/Tempe,_Arizona

Sheet2

Sheet3

Transforms-1.xlsx

Sheet1

OrderDate Location Employment University Enrollments Rep Item Units Cost Total

Sheet2

Sheet3

Lookups.xlsx

Sheet1

Column1 Column2 Column3 Column4 Column5
Region Metro University Employment Enrollments
East Atlanta-Sandy Springs-Marietta, GA University of Central Florida [note 2] 2.1 59,770
Central Chicago-Joliet-Naperville, IL-IN-WI Ohio State University 0.9 57,466
West Dallas-Fort Worth-Arlington, TX University of Texas at Austin 3.3 51,145

Sheet2

Sheet3