BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 48

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.