Question
i need help with determining the formula to get the values for x and y to plot the graph 4 You ve decided to start
i need help with determining the formula to get the values for x and y to plot the graph 4 You ve decided to start saving money for the down payment on a car In doing so you decide to save 20 10 every week Each week you record the amount that you deposit see table below Week 1 2 3 4 5 6 7 Amount S 19 87 25 77 12 30 15 89 27 88 23 10 19 55 Total S 19 87 45 64 57 94 73 83 101 71 124 81 144 36 Week 8 9 10 11 12 13 14 Amount S 12 66 29 33 26 10 24 15 15 85 23 14 20 10 Total S 157 02 186 35 212 45 236 60 252 45 275 59 295 69 Using Excel construct a plot days on the x axis and total savings on the y axis Right click on one of the data points in your plot left click on add trend line and check the box that says display equation on chart Using this y mx b equation that is displayed on your plot estimate how much money you will have saved after two years three years and four years Assume 365 days per year i e non leap years Approximately how much money per day will be saved based on this projection Approximately how many days will it take for you to save 1 000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started