Answered Essay: You have written a stock trading book that guarantees vast riches for anyone who utilizes its

You have written a stock trading book that guarantees vast riches for anyone who utilizes its strategies. To publish the book you can either use Drexel publishing or you can self-publish.

If the book is published with Drexel, there may be an opportunity to go on a book tour. If you go on the book tour and if the book is successful, it is estimated that it will sell 30,000 copies. If you go on the book tour and the book is not successful, sales are estimated at 2000 copies. If you do not go on a book tour (no matter if you self-publish or use Drexel), then the estimated sales for a successful book are 20,000 copies and the estimated sales for an unsuccessful book are 1000 copies.

If you choose Drexel as your publisher you will receive a $2000 signing bonus and $1 for each book sold. The first thing Drexel will do is send the book out for review. Due to their clout in the industry, the book will receive generally positive reviews with a probability of 0.7. With a probability of 0.3, the book will receive generally negative reviews. Given that the book has received negative reviews, the probability that the book is a success is only 0.2 and the probability that the book is not successful is 0.8. If you receive positive reviews, then you may decide if you would like to go on a book tour. If you go on the book tour, the probability of a successful book is 0.85, while if you do not go on the book tour, the probability of a successful book is 0.75. Because you dislike travel, you assess a cost of $2000 to the book tour.

If you self-publish you will earn $2 for each book sold, however, there is very little impactful marketing that you can do. Based on the evidence at your disposal, you estimate a probability of the book being successful at 0.585 and the probability of the book not being successful at 0.415.

C. You are strongly considering using Drexel to publish the book, but would like to investigate the situation more carefully before committing. In particular, you wish to simulate the process of book review, book success, and book sales. Note, you have decided that you will definitely go on the book tour if the review is positive, so there is no need to simulate that decision. Develop a simulation of 100 instances and determine the average number of books sold. In particular, you simulation should

Determine if the book receives positive or negative reviews (use the probabilities from part A of the problem).

Determine if the book will be successful or not, based on the book’s reviews (use the probabilities from part A of the problem).

Determine the book sales, based on the books success (or lack thereof). Assume that book sales are normally distributed. In cases where the reviews were negative, assume that the mean sales are 20,000 with a standard deviation of 2000 for a successful book; for an unsuccessful book, assume that mean sales are 1000 with a standard deviation of 200. In cases where the reviews are positive, assume that the mean sales are 30,000 with a standard deviation of 2000 for a successful book; for an unsuccessful book, assume that the mean sales are 2000 with a standard deviation of 300.

Expert Answer

Simulation model is as follows

Formulae:

B20 =IF(RAND()<=$D$7,$C$7,$C$13)

C20 =IF(B20=$C$7,IF($C$17=$E$7,IF(RAND()<=$G$7,$F$7,$F$8),IF(RAND()<=$G$10,$F$10,$F$11)),IF(RAND()<=$G$13,$F$13,$F$14))

D20 =IF(B20=$C$7,IF($C$17=$E$7,IF(C20=$F$7,NORMINV(RAND(),$H$7,$I$7),NORMINV(RAND(),$H$8,$I$8)),IF(C20=$F$10,NORMINV(RAND(),$H$10,$I$10),NORMINV(RAND(),$H$11,$I$11))),IF(C20=$F$13,NORMINV(RAND(),$H$13,$I$13),NORMINV(RAND(),$H$14,$I$14)))

J19 =COUNTIF(B20:B119,C7)/COUNT(A20:A119)

J22 =COUNTIF(B20:B119,C13)/COUNT(A20:A119)

L19 =COUNTIF(E20:E119,I19&” and “&K19)/COUNT(A20:A119)/J19

L20 =COUNTIF(E20:E119,I19&” and “&K20)/COUNT(A20:A119)/J19

L22 =COUNTIF(E20:E119,I22&” and “&K22)/COUNT(A20:A119)/J22

L23 =COUNTIF(E20:E119,I22&” and “&K23)/COUNT(A20:A119)/J22

Buy Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Help Me Write My Essay - Reasons:

Best Online Essay Writing Service

We strive to give our customers the best online essay writing experience. We Make sure essays are submitted on time and all the instructions are followed.

Our Writers are Experienced and Professional

Our essay writing service is founded on professional writers who are on stand by to help you any time.

Free Revision Fo all Essays

Sometimes you may require our writers to add on a point to make your essay as customised as possible, we will give you unlimited times to do this. And we will do it for free.

Timely Essay(s)

We understand the frustrations that comes with late essays and our writers are extra careful to not violate this term. Our support team is always engauging our writers to help you have your essay ahead of time.

Customised Essays &100% Confidential

Our Online writing Service has zero torelance for plagiarised papers. We have plagiarism checking tool that generate plagiarism reports just to make sure you are satisfied.

24/7 Customer Support

Our agents are ready to help you around the clock. Please feel free to reach out and enquire about anything.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

HOW OUR ONLINE ESSAY WRITING SERVICE WORKS

Let us write that nagging essay.

STEP 1

Submit Your Essay/Homework Instructions

By clicking on the "PLACE ORDER" button, tell us your requires. Be precise for an accurate customised essay. You may also upload any reading materials where applicable.

STEP 2

Pick A & Writer

Our ordering form will provide you with a list of writers and their feedbacks. At step 2, its time select a writer. Our online agents are on stand by to help you just in case.

STEP 3

Editing (OUR PART)

At this stage, our editor will go through your essay and make sure your writer did meet all the instructions.

STEP 4

Receive your Paper

After Editing, your paper will be sent to you via email.