Excel Question

Anonymous
timer Asked: Nov 9th, 2016

Question description

I want you do homework on excel through 9 hours

Assignment 10 This assignment is going to continue on with having you create and fine tune a chart from scratch. You will also look at adding data bars and sparklines to highlight trends in existing data. Begin by opening the file Assignment 10 Original File from the Canvas Assignment. Problem 1) Click on the Problem 1 worksheet. You will see data that examines the locations that SVSU students have come from in 2012 - 2013. From scratch, create the following chart. You will need to work with many of the chart properties to get your chart to look exactly like this one, so be prepared to experiment. Problem 2) Click on the Problem 2 worksheet which shows the various class sizes at SVSU. Widen Column B and then add Data Bars (Gradient Purple just for something different) to show the relative counts of the class sizes compared to one another. Problem 3) Click on the Problem 3 worksheet which has the population changes in Michigan and the 83 Michigan counties from 2008 through 2012. In Column G, add Spark Lines (Columns) to show the increase/decrease for each year for the state and each county. Print the Chart you created from Problem 1 and print the spreadsheets and data bars/sparklines for Problems 2 and 3 (you can force Problem 3 to fit to one sheet that has a portrait orientation). Print all of the worksheets to PDF files, and upload both the Excel and the PDF files to the Canvas Assignment.
2012 - 2013 SVSU Student Origins Origin Location 2012 Saginaw County 2,506 Bay County 1,179 Midland County 565 Tuscola County 434 Genesee County 683 Huron County 219 Macomb County 694 Oakland County 619 Wayne County 675 Other Michigan Counties 2,297 Other U.S. 58 International/Canadian 623 Source: SVSU OIR 2013 2,412 1,181 549 447 669 211 644 580 662 2,176 82 632 SVSU 2013 Undergraduate Class Size Class Size 2-9 10-19 20-29 30-39 40-49 50-99 100+ Source: SVSU OIR Count 112 355 470 359 56 44 1 Michigan Population by County 2008 - 2012 2008 2009 2010 2011 Michigan Alcona Alger Allegan Alpena Antrim Arenac Baraga Barry Bay Benzie Berrien Branch Calhoun Cass Charlevoix Cheboygan Chippewa Clare Clinton Crawford Delta Dickinson Eaton Emmet Genesee Gladwin Gogebic Grand Traverse Gratiot Hillsdale Houghton Huron Ingham Ionia Iosco Iron Isabella Jackson Kalamazoo Kalkaska Kent Keweenaw Lake Lapeer 2012 9,946,889 9,901,591 9,877,670 9,876,801 9,883,360 11,286 11,106 10,899 10,787 10,635 9,647 9,334 9,554 9,580 9,541 111,589 111,252 111,472 111,591 112,039 30,119 29,755 29,551 29,352 29,234 24,047 23,796 23,511 23,408 23,406 16,547 16,243 15,873 15,622 15,477 8,822 8,874 8,838 8,821 8,683 59,788 59,469 59,062 58,936 58,990 108,320 107,913 107,723 107,273 106,935 17,733 17,564 17,517 17,489 17,465 157,380 157,059 156,799 156,489 156,067 46,305 45,378 45,147 43,902 43,868 137,313 136,301 136,075 135,529 135,099 52,684 52,362 52,197 52,574 52,242 26,280 26,068 25,909 26,003 26,023 26,738 26,330 26,096 25,974 25,835 39,247 39,174 38,482 38,776 38,917 31,064 30,856 30,993 30,955 30,753 74,302 74,828 75,400 75,838 76,001 14,379 14,157 14,040 14,012 14,009 37,409 37,059 37,068 36,955 36,884 26,622 26,357 26,137 26,094 26,220 108,021 107,430 107,878 107,970 108,008 32,852 32,765 32,663 32,800 32,915 433,082 427,989 425,152 422,053 418,408 25,956 25,738 25,702 25,800 25,484 16,499 16,390 16,386 16,127 16,084 86,209 86,767 87,034 88,294 89,112 42,774 42,285 42,439 42,139 42,063 46,951 46,735 46,603 46,565 46,229 36,292 36,378 36,694 36,712 36,520 33,504 33,269 33,063 32,704 32,463 281,315 280,889 280,882 281,806 281,723 65,167 63,858 63,883 63,898 63,941 26,542 26,174 25,806 25,523 25,357 12,081 11,959 11,799 11,761 11,587 69,328 70,026 70,321 70,636 70,617 160,825 160,114 160,226 159,810 160,309 246,862 249,023 250,729 252,328 254,580 17,546 17,223 17,133 17,156 17,099 599,234 601,437 602,982 608,106 614,462 2,119 2,131 2,142 2,231 2,215 11,629 11,593 11,510 11,484 11,498 89,914 88,774 88,187 88,081 88,173 Leelanau Lenawee Livingston Luce Mackinac Macomb Manistee Marquette Mason Mecosta Menominee Midland Missaukee Monroe Montcalm Montmorency Muskegon Newaygo Oakland Oceana Ogemaw Ontonagon Osceola Oscoda Otsego Ottawa Presque Isle Roscommon Saginaw St. Clair St. Joseph Sanilac Schoolcraft Shiawassee Tuscola Van Buren Washtenaw Wayne Wexford Source: Michigan Department of Community Health 21,731 21,724 21,677 21,646 21,607 101,169 100,250 99,646 99,340 98,987 181,171 181,082 180,999 182,299 182,838 6,680 6,614 6,598 6,534 6,522 11,248 11,159 11,091 11,083 11,137 837,857 839,435 841,291 842,881 847,383 24,960 24,818 24,566 24,747 24,672 66,539 66,765 67,116 67,563 67,906 28,668 28,656 28,715 28,642 28,680 42,683 42,621 42,815 43,296 43,318 24,317 24,118 23,984 23,970 23,815 83,605 83,639 83,637 84,015 83,822 15,028 14,898 14,822 14,947 15,031 152,806 152,296 151,960 151,609 151,048 63,635 63,496 63,320 63,236 63,097 9,922 9,794 9,765 9,590 9,476 173,846 172,755 171,969 170,021 170,182 49,153 48,649 48,394 48,432 47,959 1,199,545 1,200,890 1,203,036 1,211,357 1,220,657 27,120 26,779 26,527 26,442 26,310 21,885 21,856 21,647 21,547 21,437 6,922 6,828 6,746 6,608 6,413 23,662 23,522 23,515 23,455 23,276 8,963 8,717 8,614 8,659 8,592 24,378 24,190 24,161 24,127 24,020 261,906 262,879 264,117 266,176 269,099 13,701 13,505 13,307 13,198 13,129 24,856 24,499 24,463 24,310 24,106 201,966 200,835 199,940 198,990 198,353 165,959 164,011 162,717 161,559 160,644 62,083 61,417 61,259 61,016 60,796 44,177 43,319 43,044 42,671 42,268 8,471 8,487 8,484 8,489 8,343 71,523 70,710 70,610 69,934 69,232 56,512 55,901 55,665 55,342 54,662 76,501 76,581 76,182 76,025 75,454 341,595 343,520 345,350 348,637 350,946 1,865,058 1,837,536 1,815,598 1,801,789 1,792,365 32,765 32,658 32,766 32,675 32,608

Tutor Answer

(Top Tutor) Studypool Tutor
School: UCLA
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors