Pie Charts

.docx

School

Ivy Tech Community College, Indianapolis *

*We aren’t endorsed by this school

Course

123

Subject

Mathematics

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by JusticeHippopotamus12050 on coursehero.com

Math 123 Quantitative Reasoning Excel Assignment Inserting Charts in Excel 1. The following data is from http://www.stats.indiana.edu and breaks down from the 2016 census. ages 0 - 4 421,987 Ages 5 - 17 1,153,465 ages 18 - 24 661,254 ages 25 - 44 1,674,571 ages 45 - 64 1,730,213 over 65 991,563 i. Open Excel and enter this data. ii. Highlight your data and insert a pie-chart. iii. Format your chart so that both the percent and labels for each age range are visible.

Math 123 Quantitative Reasoning Excel Assignment iv. Write at least two sentences on the observations of Indiana’s age distributions. The age group 0-4 has the smallest percentage of the state’s population. There is only a 1% difference between the 25-44 age group and the 45-64 age group. v. When might this information be useful? This information might be useful when conducting community surveys that involve development within. A city’s might focus on developing engagement within the 0-4 age group due to having the lowest percentage in population.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help