$10-4$ Exercise

Separate each segment into a separate work sheet and label each work sheet accordingly. Each worksheet should contain segment $1$ and segment $2$ data.

Create $3$ columns, Price $$45,$ Price $$65,$ and Segment # for each worksheet.

Calculate the average response for each price, $$45$ and $$65.$

Create a six$-$column summary table for both Segments $1$&$2$ work sheets: Response, Price $$45,$ Price$$65,$ Discount Rate, Estimated number of customers Price $$45,$ and estimated number of customers Price $$65.$

The table columns in step $5$ will have $9$ rows, labeled Responses $1-7,$ one in each segment worksheet.

Calculate the number off each response for each row according to the row label:

$\backslash$table$[[$Response$,$Price $$45,$Price $$65,\backslash$table$[[$Discount$],[$Rate$]],$Price $$45,$Price $$65],[1,,,0\mathrm{.}01,,],[2,,,0\mathrm{.}02,,],[3,,,0\mathrm{.}05,,],[4,,,0\mathrm{.}1,,],[5,,,0\mathrm{.}25,,],[6,,,0\mathrm{.}5,,],[7,,,0\mathrm{.}75,,],[,$Sum,Sum,,Sum,Sum$]]$

Calculate the discount rate times the price for both $$45$ and $$65.$