Question

Experience has taught Brenda that as the registration fee for the seminar increases, the number of attendees willing to pay decreases. Based data from other seminars, Brends has defined a relationship between attendance and registration fee, shown in the range R4:X21 on Budget worksheet. In cell B5 of the Budget worksheet, change the number of attendees for a given registration fee based on the valus in cell B6. (Hint: Look at the formulas in the range S6:S21 to learn how to translate this equation into Excel formula.)


`attendees = 1000 * e^-(fee/75)`

Answer 1

Granite Life Brenda Castro is an Events Coordinator for the Granite Life insurance company. One event that the company sponsors is a three-day educational seminar on insurance and investing, which will take place in Provo, Utah, this year. Brenda wants to estimate the number of attendees and predict the net income from the event.