60.1K

Verified Solution

Link Copied!

PLEASE HELP I have to answer this using excel and it is due in a few hours

This homework assignment is to be completed in Excel. You will also be interpreting your answers using textboxes near your Excel work.. Use Excel to find the numerical answers for each problem. Your Excel columns and work need 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 (rate of change = derivative of revenue R'(x)) in thousands of dollars that an additional $100 spent on advertising, at various levels, can be expected to generate. Advertising Expenditures (hundreds of S) 25 50 75 100 125 150 175 R'(x) Rate of change of Revenue (thousands of $) 5 60 95 105 104 79 34 a) [10 pts. Use Excel and the data given to find a good approximation of the accumulated revenue for this company when spending between $2500 and $17,500 on advertising, Show all your work in Excel and state your answers in a text box region. b) [5 pts] Use Excel to graph the data for R'(x) and find a regression model for the data above using one of the six functions we use in Business Calculus. Round coefficients to 4 decimal places and place the equation on the graph. c) [10 pts] 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 found in part b. manually find the R"(x) equation and put this is a text region. Next produce an input/output table of R"(x) in Excel and use solver to find where R"(x) = 0 and changes sign, to find the x value of the point of diminishing return of the revenue function R(x). Interpret the meaning of this value using a complete sentence. This homework assignment is to be completed in Excel. You will also be interpreting your answers using textboxes near your Excel work.. Use Excel to find the numerical answers for each problem. Your Excel columns and work need 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 (rate of change = derivative of revenue R'(x)) in thousands of dollars that an additional $100 spent on advertising, at various levels, can be expected to generate. Advertising Expenditures (hundreds of S) 25 50 75 100 125 150 175 R'(x) Rate of change of Revenue (thousands of $) 5 60 95 105 104 79 34 a) [10 pts. Use Excel and the data given to find a good approximation of the accumulated revenue for this company when spending between $2500 and $17,500 on advertising, Show all your work in Excel and state your answers in a text box region. b) [5 pts] Use Excel to graph the data for R'(x) and find a regression model for the data above using one of the six functions we use in Business Calculus. Round coefficients to 4 decimal places and place the equation on the graph. c) [10 pts] 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 found in part b. manually find the R"(x) equation and put this is a text region. Next produce an input/output table of R"(x) in Excel and use solver to find where R"(x) = 0 and changes sign, to find the x value of the point of diminishing return of the revenue function R(x). Interpret the meaning of this value using a complete sentence

Answer & Explanation Solved by verified expert

See Answer