Instructions The cultural project has 2 sections

Instructions

The cultural project has 2 sections.

Using the 2010 and 2020 Census data provided for Montana, Idaho, and Wyoming complete the following steps.  

1. Create a single Pivot Table that filters the total population of the three states in 2010 and in 2020 and totals individuals self-identifying as Native American or Alaska Native alone and another that totals those individuals self-identifying as Native American or Alaska Native alone or in combination with 1 or more other ethnicities/races.  

2. Create a PivotChart report based on the information above.

3. Create a chart and graph that notes the percentage change from 2010 to 2020 in the individuals self-identifying as Native American or Alaska Native alone and another that totals those individuals self-identifying as Native American or Alaska Native in combination with 1 or more other ethnicities/races.  (Do not repeat the same style of graph used earlier.)

1. 1. What did you take away after analyzing the data?

1. 2. Why did you select each graph you used?  What information did you hope to share using your graph?

1. 3. How could this information be of use to businesses in each state?  

1. 4. How can you use Excel to analyses data in other Business classes?