For this assignment, you will start with the following excel document. ExcelAssignment$2.$xlax

Date Step Count

$1-$Sep $.2158$

$2-$Sep $5265$

$3-$sep $9330$

$4-$sep $7308$

$5-$sep $10690$

$6-$sep $4317$

$7-$sep $3968$

$8-$sep $7872$

$9-$sep $2884$

$10-$sep $10574$

$11-$sep $6192$

$12-$sep $9584$

$13-$sep $9984$

$14-$ sep $2601$

$15-$sep $8442$

$16-$sep $10973$

$17-$sep $8666$

$18-$sep $2791$

$19-$sep $4156$

$20-$sep $3781$

$21-$sep $9894$

$22-$sep $3423$

$23-$sep $5222$

$24-$sep $10222$

$25-$sep $3503$

$26-$sep $6865$

$27-$sep $7376$

$28-$sep $8139$

$29-$sep $105441$

$30-$sep $10447$

This document contains data on step counts for the month of September. Do the following

Create a line chart using the given data. The horizontal axis should contain the dates, and the verfical aris should contain the step counts for the corresponding days.

Edit the chart title to say "Step Count for Septembor".

Add horizontal and vertical axes labels. The horizontal axis should be labeled "Dates", and the vertical axis should be lateled "Step Count".

Add a linear trend line to the chart.

In cell A$32,$ add the string "Total Steps", and in cell B$32$ 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 "Sume. 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 parenthesis to complete the functon. After pressing enter, the total step count should be displayed in cell B$32.$

In cell A$33,$ add the string "Average Steps", and in cell B$33$ find the average number of steps per day for the given month. Here you wll use the Average function in Excel and follow the same steps from part $5.$

In cell A$34,$ 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, decrease, or stay the same? Explain.

Excel Assignment $2$