mkt202

profileTim1111
Project3.docx
Home>Business & Finance homework help>Marketing homework help>mkt202

PME

　3.10

IPP

　4.10

OPP

　3.95

PMC

　5.00

First, I listed the four sets of data in the new excel, then listed the Bin Range. The third step is to calculate the Bin and Frequency of each column of data using the Histogram Tool. The fourth step is to calculate the proprobablity of each set of data. The step is to sort out the cumulative probability. The final step is to draw two graphs based on all the data. From the table, we can clearly see the four values we need, PMC, IPP, OPP, PME, and list these values. The price I recommend is 3.95, which is equivalent to OPP, so this price is the most suitable price.

Considered Expensive 0 0.25 0.5 0.75 1 1.25 1.5 1.75 2 2.25 2.5 2.75 3 3.25 3.5 3.75 4 4.25 4.5 4.75 5 5.25 5.5 5.75 6 6.25 6.5 6.75 7 7.25 7.5 7.75 8 8.25 8.5 8.75 9 9.25 9.5 9.75 10 0 0 0 0 0 0 0 0 0 0 0 0 6.2780269058295965E-2 6.2780269058295965E-2 7.1748878923766815E-2 8.520179372197309E-2 0.26905829596412556 0.30044843049327352 0.33632286995515692 0.36771300448430488 0.60538116591928248 0.6188340807174888 0.66816143497757852 0.66816143497757852 0.79820627802690591 0.79820627802690591 0.829 59641255605387 0.82959641255605387 0.91928251121076243 0.91928251121076243 0.92825112107623331 0.92825112107623331 0.95067264573991039 0.95067264573991039 0.95067264573991039 0.95067264573991039 0.97309417040358748 0.97309417040358748 0.97309417040358748 0.97309417040358748 1 1 Considered Cheap 0 0.25 0.5 0.75 1 1.25 1.5 1.75 2 2.25 2.5 2.75 3 3.25 3.5 3.75 4 4.25 4.5 4.75 5 5.25 5.5 5.75 6 6.25 6.5 6.75 7 7.25 7.5 7.75 8 8.25 8.5 8.75 9 9.25 9.5 9.75 10 1 0.98206278026905824 0.97309417040358737 0.95515695067264561 0.86547085201793705 0.85650224215246618 0.80717488789237646 0.80269058295964102 0.4843049327354258 0.46188340807174866 0.37668161434977554 0.36771300448430466 8.0717488789237402E-2 7.6233183856501976E-2 5.3811659192824851E-2 5.3811659192824851E-2 1.3452914798206018E-2 1.3452914798206018E-2 1.3452914798206018E-2 1.3452914798206018E-2 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 Expensive beyond consideration 0 0.25 0.5 0.75 1 1.25 1.5 1.75 2 2.25 2.5 2.75 3 3.25 3.5 3.75 4 4.25 4.5 4.75 5 5.25 5.5 5.75 6 6.25 6.5 6.75 7 7.25 7.5 7.75 8 8.25 8.5 8.75 9 9.25 9.5 9.75 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.2421524663677129E-2 2.2421524663677129E-2 4.932735426008969E-2 4.932735426008969E-2 0.20179372197309417 0.21524663677130046 0.24215246636771301 0.25112107623318386 0.41255605381165916 0.41255605381165916 0.43946188340807174 0.43946188340807174 0.5829596412556054 0.5829596412556054 0.62331838565022424 0.62331838565022424 0.77578475336322872 0.77578475336322872 0.81165919282511212 0.81165919282511212 0.8565022421524664 0.86547085201793728 0.86547085201793728 0.86547085201793728 0.94618834080717495 1 Cheap beyond consideration 0 0.25 0.5 0.75 1 1.25 1.5 1.75 2 2.25 2.5 2.75 3 3.25 3.5 3.75 4 4.25 4.5 4.75 5 5.25 5.5 5.75 6 6.25 6.5 6.75 7 7.25 7.5 7.75 8 8.25 8.5 8.75 9 9.25 9.5 9.75 10 1 0.97757847533632292 0.84753363228699552 0.820627802690583 0.33632286995515698 0.2914798206278027 0.2017937219730942 0.2017937219730942 4.4843049327354279E-2 4.4843049327354279E-2 1.7937219730941721E-2 1.7937219730941721E-2 4.4843049327354424E-3 4.4843049327354424E-3 4.4843049327354424E-3 4.4843049327354424E-3 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17

Considered Expensive 2.5 2.75 3 3.25 3.5 3.75 4 4.25 4.5 4.75 5 5.25 5.5 0 0 6.2780269058295965E-2 6.2780269058295965E-2 7.1748878923766815E-2 8.520179372197309E-2 0.26905829596412556 0.30044843049327352 0.33632286995515692 0.36771300448430488 0.60538116591928248 0.6188340807174888 0.66816143497757852 Considered Cheap 2.5 2.75 3 3.25 3.5 3.75 4 4.25 4.5 4.75 5 5.25 5.5 0.37668161434977554 0.36771300448430466 8.0717488789237402E-2 7.6233183856501976E-2 5.3811659192824851E-2 5.3811659192824851E-2 1.3452914798206018E-2 1.3452914798206018E-2 1.3452914798206018E-2 1.3452914798206018E-2 -2.6020852139652106E-16 -2.6020852139652106E-16 -2.6020852139652106E-16 Expensive beyond consideration 2.5 2.75 3 3.25 3.5 3.75 4 4.25 4.5 4.75 5 5.25 5.5 0 0 0 0 0 0 2.2421524663677129E-2 2.2421524663677129E-2 4.932735426008969E-2 4.932735426008969E-2 0.20179372197309417 0.21524663677130046 0.24215246636771301 Cheap beyond consideration 2.5 2.75 3 3.25 3.5 3.75 4 4.25 4.5 4.75 5 5.25 5.5 1.7937219730941721E-2 1.7937219730941721E-2 4.4843049327354424E-3 4.4843049327354424E-3 4.4843049327354424E-3 4.4843049327354424E-3 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17 1.6479873021779667E-17