Question & Answer: 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 ABC publishing or you can self-publish.

If the book is published with ABC, 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 ABC), then the estimated sales for a successful book are 20,000 copies and the estimated sales for an unsuccessful book are 1000 copies.

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: You have written a stock trading book that guarantees vast riches for anyone who utilizes its…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

If you choose ABC as your publisher you will receive a $2000 signing bonus and $1 for each book sold. The first thing ABC 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.

You are strongly considering using ABC 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, your simulation should:

i. Determine if the book receives positive or negative reviews (use the probabilities above).
ii. Determine if the book will be successful or not, based on the book’s reviews (use the probabilities above).
iii. 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.

Please provide a simulation in Excel and show all formulas used.

Expert Answer

Answer

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

Grand Paper Writers
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All papers are written by the best professional writers to ensure 100% originality. We always provide plagiarism reports whenever we deliver completed papers.

Free Revisions

All papers by Grand Paper Writers are completed and submitted on time. This timely delivery of papers gives you time to go through the paper before the official deadline.

Title-page

As an additional service, we will provide a title page that precedes the contents of your paper. Here, you will provide your personal details.

Bibliography

We also ensure that we provide an extra page for the references or bibliographies following referencing rules.

Originality & Security

At Grandpaperwriters.com, we guarantee students for the provision of security and original work. All your personal information is handled with confidentiality and is not shared with third parties. Additionally, we ensure that we provide original content with accompanying plagiarism reports to show originality.

24/7 Customer Support

Our customer support team is always available 24/7 to provide instant responses to any queries raised by students.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
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.

Our Services

Grandpaperwriters.com has the best professional essay writers for quality services.

Pricing

Flexible Pricing

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Communication

Admission Help & Client-Writer Contact

Grandpaperwriters.com provides an interactive portal where students can communicate directly to their writers.

Deadlines

Paper Submission

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Reviews

Customer Feedback

Grandpaperwriters.com appreciates feedback from our clients to help us improve the delivery of essay writing services. As such, we are constantly changing our policies to ensure maximum customer and writer satisfaction.