Unit 4 Section Written Homework Assignment (25 points) This homework assignment is to be completed in Excel You will also be interpreting your answers using textboxes near your Excel work Use Exeed to find the numerical answers for each problem. Your Excel columes and weed to be clearly labeled 1. Many businesses spend money each year on advertising in order to stimulate sales of their products. The data given in the table below show the approximate increase in sales (tate of change derivative of revenue **) in thousands of dollars that an additional 100 spent on advertising various levels, can be expected to mere Advertising Expenditures R(X) (hundreds of 5) Rate of change of Revenue (thousands of 50 . 75 95 100 105 104 150 79 175 a) [10 pes] Use Excel and the data given to find a good approximation of the accumulated revenue for this company when spending between $2500 and 517.500 en advertising Show all your work in Ered and state na amma in a text has regio b) 5 pts] Use Excel to pragh the data for ') and find a regression model for the data above using ONLY of the six fonctions we use in Business Calculus. Round coefficients 104 decimal places and place the equation on the graph c)20 pes) Remember, the point of diminishing return is the point of inflection on the revenue function (which is NOT shown), where the second derivative would be zero. Using the R(x) equation that you find in part, manually find the "r) quation and put this is a text region. Next produce an input opettable of "(x) in Excel and use solver to find where ) and changes in to find the value of the painte diming retum of the revenue function Rear). Interpect the meaning of this value using a complete sentence 14 Unit 4 Section Written Homework Assignment (25 points) This homework assignment is to be completed in Excel You will also be interpreting your answers using textboxes near your Excel work Use Exeed to find the numerical answers for each problem. Your Excel columes and weed to be clearly labeled 1. Many businesses spend money each year on advertising in order to stimulate sales of their products. The data given in the table below show the approximate increase in sales (tate of change derivative of revenue **) in thousands of dollars that an additional 100 spent on advertising various levels, can be expected to mere Advertising Expenditures R(X) (hundreds of 5) Rate of change of Revenue (thousands of 50 . 75 95 100 105 104 150 79 175 a) [10 pes] Use Excel and the data given to find a good approximation of the accumulated revenue for this company when spending between $2500 and 517.500 en advertising Show all your work in Ered and state na amma in a text has regio b) 5 pts] Use Excel to pragh the data for ') and find a regression model for the data above using ONLY of the six fonctions we use in Business Calculus. Round coefficients 104 decimal places and place the equation on the graph c)20 pes) Remember, the point of diminishing return is the point of inflection on the revenue function (which is NOT shown), where the second derivative would be zero. Using the R(x) equation that you find in part, manually find the "r) quation and put this is a text region. Next produce an input opettable of "(x) in Excel and use solver to find where ) and changes in to find the value of the painte diming retum of the revenue function Rear). Interpect the meaning of this value using a complete sentence 14
