1. The Excel file Internet Usage provides data about users of the Internet. Construct stacked bar charts that will allow you to compare any differences due to age or educational attainment and draw any conclusions that you can. Would another type of chart be more appropriate? 2. Construct an appropriate chart to show the relative value of funds in each investment category in the Excel file Retirement Portfolio. 3. In the Excel file Banking Data, apply the following data visualization tools: Use data bars to visualize the relative values of median home value. Use color scales to visualize the relative values of median household wealth. Use an icon set to show high, medium, and low average bank balances, where high is above $30,000, low is below $10,000, and medium is anywhere in between. 4. Use a PivotTable to develop a frequency distribution with six bins for the age of individuals in the Base Data worksheet in the Credit Risk Data file. Compute and chart the relative and cumulative relative frequencies. 5. Find the first, second, and third quartiles for the sales amounts in the Sales Transactions database and interpret the results. 6. Use a PivotTable to construct a cross-tabulation for marital status and housing type for the Base Data worksheet in the Excel file Credit Risk Data