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
he 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.