Explain what you think the shape of the linear trend line tells us about the step count trend.

For this assignment, you will start with the following excel document. (See upload files)

This document contains data on step counts for the month of September. Do the following
1. Create a line chart using the given data. The horizontal axis should contain the dates, and the vertical axis should contain the step counts for the corresponding days.
2. Edit the chart title to say ” step count for September ”
3. Add horizontal and vertical axes labels. The horizontal axis should be labeled ” Dates” and the vertical axis should be labeled ” step count”
4. Add a linear trend line to the chart
5. In cell A32, Add the string Total step and in cell B32 sum the total number of steps for the month. Use the sum function in excel to do this. Remember to start by typing in equal sign “=” and then entering the function name with an open parenthesis “Sum( ” You should then be able to use the mouse to select all of the cells containing the step data and then type in a close should be displayed in B32
6. In cell A33, add the string “Average steps ” and in cell B33 find the average number of steps per day for the given month. Here you will use the average function in excel and follow the same steps from part 5
7. In cell A34, explain what you think the shape of the linear trend line tells us about the step count trend. Do we expect the number of step counts to increase, decreacixse or stay the same? Explain

Last Completed Projects