Create a bar chart to the right of the data, with a title of Marketing Campaign Results. You can choose the colors that you want for each city ' s results, but make sure that you show the Y-axis labels to the right and the X-axis labels on the bottom, along with the word City as their label. STEP 5: Line Chart Using the LineChart1 worksheet, calculate the average income for the ages listed. Then create a line chart, with a title of Average Income by Age, with appropriate labels on the X and Y axis. Your chart should be placed to the right of your data, on the same sheet. STEP 6: Average and Median, With Line Chart This step is very similar to the previous worksheet, except that there is an additional summary statistic and you are working with multiple variables. Calculate the average and median for both Income and Rent. As you look at your results, do you notice the difference between the results? Does this better explain the difference between average and median for you? To the right of the data, on the same sheet, produce a line graph of the Income and Rent. Again, the color of the lines is your choice. Use a chart heading of Average Income / Rent by Age. Be sure to show your Income and Rent labels to the right of the chart, and a label of Age on the X axis and Amount($ 000) on the Y axis. STEP 7: Regression Analysis and Scatter Graph The data here is very simple, and not really a good example of using regression analysis, but the process behind the exercise is the most important issue. 1. Create a scatter chart of the data, below the data, with a title of Revenue Growth. 2. Draw a trendline associated with the data points. Be sure to select the inclusion of the Equation and R-squared values on the chart. 3. Perform a regression analysis on the data set. Remember to identify which of the variables are dependent( Y axis) and independent( X axis) so as not to get confused on your input values. Place the regression results, starting at cell I1, instead of using the default, which is a separate sheet. Be sure to identify and highlight on