Use the following data to answer the questions that follow.

Sprint Day Remaining effort (story points)

1 75 2 55 3 45 4 0 5 0 6 0 7 0 8 0 Average velocity 5 (Remaining effort Day 1 2 Remaining effort Current Day)/

(Current Day 2 Day 1)

Estimated completion date 5 Current Day 1 (Remaining effort/Average velocity)

a. Create a burndown chart for the given data using Excel or the software of your choice.

(Hint: You can just create a line or column chart showing the Days on the horizontal axis and Remaining effort on the vertical axis. You do not need to show Ideal velocity.)

b. What is the average velocity for the project, in story points per day? (Assume the Current Day is Day 3).

c. What is the project’s expected completion date?