Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if
she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday?
Assume she works only on weekdays.
Pages
423
Day
Monday
Tuesday
Wednesday
Thursday 466
Friday
473
432
The intercept is
448
A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line?
The slope is
B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday?