Question

In: Statistics and Probability

LARKIN CORPORATION Larkin Corporation conducted a test designed to evaluate the effectiveness of a new television...

LARKIN CORPORATION Larkin Corporation conducted a test designed to evaluate the effectiveness of a new television advertisement for one of its household products. The particular television advertisement was shown in a test market for a two-week period. In a follow-up study, randomly selected individuals were contacted by telephone and asked a series of questions to determine whether they could recall the message in the television advertisement and how likely they were to purchase the product. The test market study provided the following probabilities: Individual could recall the message 0.40 Individual could not recall the message 0.60 Further, response to the question of how likely they were to purchase the product provided the following probabilities: IF Purchase Definitely No Uncertain Definitely Yes Could recall the message 0.30 0.30 0.40 Could not recall the message 0.50 0.40 0.10 For example, if an individual could not recall the message there is a 10% chance that they would definitely purchase the household product. Larkin Corporation management is interested in knowing what is the overall probability of an individual answering “definitely yes” to the likelihood of purchase question using simulation for 1,000 trials. Note: Please give the answer in the form of Simulation in Excel sheet. I used a decision tree and came up with an answer of 0.22 so 220 out of 1000 would definitely say yes to buy. Correct??? and how do I set up in Excel?

Solutions

Expert Solution

Let following be the events

  • R= An individual can Recall the message
  • NR= An individual can not Recall the message
  • N=An individual would respond, Definitely No, to if Purchase
  • U=An individual would respond, Uncertain, to if Purchase
  • Y=An individual would respond, Definitely Yes, to if Purchase

We know the following probabilities


the overall probability of an individual answering “definitely yes” to the likelihood of purchase question is

The above is the theoretical probability.

Using the simulation we will get an approximation which will be close to 0.22, but not exactly 0.22. As we increase the number of simulations, the standard error of this estimate decreases and we get better estimates

To simulate if an individual can recall or not recall the message.

  • Generate a random number from uniform distribution in the interval (0,1), using =RAND()
  • If the random number is less than 0,4 then the individual could recall, else the individual could not recall in this trial of the simulation

Based on if the individual can recall or not recall, we do one of the following

If the individual can recall in this trial then do the following

To simulate if an individual purchases given that the individual can recall the message.

First get the cumulative probabilities and the random number intervals

Recall=Yes
Random number interval
Purchase Conditional probability Cumulative probability From To Purchase
Definitely No 0.3 0.3 0 0.3 N
Uncertain 0.3 0.6 0.3 0.6 U
Definitely Yes 0.4 1 0.6 1 Y
  • Generate a random number from uniform distribution in the interval (0,1), using =RAND()
  • Check the random number interval in which the generated random number falls in and get the corresponding purchase decision.
    • For example if the random number generated is 0.45, then it falls in the interval 0.3 to 0.6 and hence the purchasing decision is Uncertain

If the individual can not recall in this trial then do the following

To simulate if an individual purchases given that the individual can not recall the message.

First get the cumulative probabilities and the random number intervals

Recall=No
Random number interval
Purchase Conditional probability Cumulative probability From To Purchase
Definitely No 0.5 0.5 0 0.5 N
Uncertain 0.4 0.9 0.5 0.9 U
Definitely Yes 0.1 1 0.9 1 Y
  • Generate a random number from uniform distribution in the interval (0,1), using =RAND()
  • Check the random number interval in which the generated random number falls in and get the corresponding purchase decision.
    • For example if the random number generated is 0.45, then it falls in the interval 0.0 to 0.5 and hence the purchasing decision is Definitely No

Now prepare the following sheet

Copy the rows from A9 to D1008 to make 1000 trails. Paste the columns as values to avoid changes

The rest of the columns

get this

Now the overall probability of an individual answering “definitely yes” to the likelihood of purchase question is

Prepare the following

Get this

The estimated probability using the simulation is 0.211 and this is close enough to the theoretical probability of 0.22


Related Solutions

LARKIN CORPORATION Larkin Corporation conducted a test designed to evaluate the effectiveness of a new television...
LARKIN CORPORATION Larkin Corporation conducted a test designed to evaluate the effectiveness of a new television advertisement for one of its household products. The particular television advertisement was shown in a test market for a two-week period. In a follow-up study, randomly selected individuals were contacted by telephone and asked a series of questions to determine whether they could recall the message in the television advertisement and how likely they were to purchase the product. The test market study provided...
To test the effectiveness of a new drug (Phasomaxtrin) designed to treat Quarantinitis, researchers conducted a...
To test the effectiveness of a new drug (Phasomaxtrin) designed to treat Quarantinitis, researchers conducted a clinical trial. The subjects were 512 adult American volunteers with advanced Quarantinitis. Half were randomly assigned to take the drug and the other half were randomly assigned to take a placebo. Neither the subjects nor the doctors who evaluated them knew who was in which group. After three years, 32 percent of those who got Phasomaxtrin were no longer afraid to keep staying inside,...
A randomized experimental study was conducted to evaluate the effectiveness of a new cancer vaccine. One-thousand...
A randomized experimental study was conducted to evaluate the effectiveness of a new cancer vaccine. One-thousand healthy adults were randomized to receive either the new vaccine (500 adults) or the old vaccine (500 adults). The adults were followed for 10 years to monitor the incidence of colon cancer. At the end of the study, the risk ratio for developing colon cancer was 0.5 among the adults who received the new vaccine compared to adults who received the old vaccine. The...
3. An experiment was conducted to evaluate the effectiveness of a treatment for tapeworm in the...
3. An experiment was conducted to evaluate the effectiveness of a treatment for tapeworm in the stomachs of sheep. A random sample of 24 worm-infected lambs of approximately the same age and health was randomly divided into two groups. Twelve of the lambs were injected with the drug and the remaining twelve were left untreated. After 6 months, the lambs were slaughtered and the following worm counts were recorded. Assume the counts are approximately normally distributed. Drug-treatedsheep 18, 43, 28,...
An experiment was conducted to evaluate the effectiveness of a treatment for tapeworm in the stomachs...
An experiment was conducted to evaluate the effectiveness of a treatment for tapeworm in the stomachs of sheep. A random sample of 24 worm-infected lambs of approximately the same age and health was randomly divided into two groups. Twelve of the lambs were injected with the drug and the remaining twelve were left untreated. After 6 months, the lambs were slaughtered and the following worm counts were recorded. Assume the counts are approximately normally distributed. Drug-treatedsheep 18 43 28 50...
An experiment was conducted to evaluate the effectiveness of a treatment for tapeworm in the stomachs...
An experiment was conducted to evaluate the effectiveness of a treatment for tapeworm in the stomachs of sheep. A random sample of 24 worm-infected lambs of approximately the same age and health was randomly divided into two groups. Twelve of the lambs were injected with the drug and the remaining twelve were left untreated. After 6 months, the lambs were slaughtered and the following worm counts were recorded. Assume the counts are approximately normally distributed. Drug-treated sheep 18, 43, 28,...
A clinical trial is conducted to test a new medication designed to lower systolic blood pressure...
A clinical trial is conducted to test a new medication designed to lower systolic blood pressure (SBP). Participants are randomly assigned to receive the new medication or a placebo. The outcome is clinically significant SBP reduction after 30 days. The data are shown below. Compute the totals. Significant Reduction in SBP No Significant Reduction in SBP Total New Medication 44 76 Placebo 21 99 Total Compute the proportion of participants who experienced a significant reduction in SBP, given they received...
A clinical trial was conducted to test the effectiveness of a drug for treating insomnia in...
A clinical trial was conducted to test the effectiveness of a drug for treating insomnia in older subjects. Before​ treatment, 18 subjects had a mean wake time of 103.0 min. After​ treatment, the 18 subjects had a mean wake time of 78.4 min and a standard deviation of 20.7 min. Assume that the 18 sample values appear to be from a normally distributed population and construct a 95 ​% confidence interval estimate of the mean wake time for a population...
In 1954, an experiment was conducted to test the effectiveness of the Salk Vaccine as protection...
In 1954, an experiment was conducted to test the effectiveness of the Salk Vaccine as protection against the devastating effects of polio. Approximately 200,000 children were injected with an ineffective salt solution, and 200,000 other children were injected with the vaccine. The experiment was "double blind". Only 30 of the 200,000 vaccinated children later developed paralytic polio, whereas 120 of the 200,000 injected with the salt solution later developed paralytic polio. a) Estimate the 95% confidence interval for the relative...
A clinical trial was conducted to test the effectiveness of a drug for treating insomnia in...
A clinical trial was conducted to test the effectiveness of a drug for treating insomnia in older subjects. Before​ treatment, 15 subjects had a mean wake time of 105.0 min. After​ treatment, the 15 subjects had a mean wake time of 99.7 min and a standard deviation of 24.3 min. Assume that the 15 sample values appear to be from a normally distributed population and construct a 95​% confidence interval estimate of the mean wake time for a population with...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT