Question

Please use ONLY one Excel file to complete the case study and upload the Excel file to the submission link. Please clearly ma

0 0
Add a comment Improve this question Transcribed image text
Answer #1
  • TRADITIONAL METHOD
    given that,
    possibile chances (x)=241
    sample size(n)=1005
    success rate ( p )= x/n = 0.24
    I.
    sample proportion = 0.24
    standard error = Sqrt ( (0.24*0.76) /1005) )
    = 0.013

    II.
    margin of error = Z a/2 * (stanadard error)
    where,
    Za/2 = Z-table value
    level of significance, α = 0.05
    from standard normal table, two tailed z α/2 =1.96
    margin of error = 1.96 * 0.013
    = 0.026
    III.
    CI = [ p ± margin of error ]
    confidence interval = [0.24 ± 0.026]
    = [ 0.213 , 0.266]
    -----------------------------------------------------------------------------------------------
    DIRECT METHOD

  • given that,
    possibile chances (x)=241
    sample size(n)=1005
    success rate ( p )= x/n = 0.24
    CI = confidence interval
    confidence interval = [ 0.24 ± 1.96 * Sqrt ( (0.24*0.76) /1005) ) ]
    = [0.24 - 1.96 * Sqrt ( (0.24*0.76) /1005) , 0.24 + 1.96 * Sqrt ( (0.24*0.76) /1005) ]
    = [0.213 , 0.266]
    -----------------------------------------------------------------------------------------------
    interpretations:
    1. We are 95% sure that the interval [ 0.213 , 0.266] contains the true population proportion
    2. If a large number of samples are collected, and a confidence interval is created
    for each sample, 95% of these intervals will contains the true population proportion

    [ANSWERS]
    a. standard error = 0.013
    b. [0.213 , 0.266]
    c. long term investment value is changed from old 34% since it does n;t lies in the
    interval achived

Add a comment
Know the answer?
Add Answer to:
Please use ONLY one Excel file to complete the case study and upload the Excel file to the submission link. Please clea...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Has Gold Lost Its Luster? Please use ONLY one Excel file to complete the case study...

    Has Gold Lost Its Luster? Please use ONLY one Excel file to complete the case study and upload the Excel file to the submission link (Week 3 Case Study) for grading. Please clearly mark your answers (either highlight or font colors) and grammar counts. No credit will be granted for problems that are not completed using Excel. In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment. In April of 2013 Gallup surveyed a random...

  • When the gallup organization polled investors, 34% rated gold the best long-term investment.... Q...

    When the gallup organization polled investors, 34% rated gold the best long-term investment.... Question: In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investm... In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment. But in April of 2013 Gallup surveyed a random sample of U.S. adults. Respondents were asked to select the best long-term investment from a list of possibilities. Only 241 of the 1005 respondents chose gold as...

  • Statistics

    In 2011, when the Gallup organization polled investors, 32% rated gold the best long-term investment.  But in April of 2013 Gallup surveyed a random sample of U.S. adults.  Respondents were asked to select the best long-term investment from a list of possibilities.  Only 168 of the 650 respondents chose gold as the best long-term investment.  By contrast, only 83 chose bonds.Using excel determine answers on below questions:a.       Compute the standard error for each sample proportion.  Compute and describe a 99%...

  • Please do not use excel or spreadsheet! An insurance company is interested in estimating the percentage...

    Please do not use excel or spreadsheet! An insurance company is interested in estimating the percentage of auto accidents that involve teenage drivers. Suppose the percentage of auto accidents that involved teenage drivers last year was 15%. The company wants to know if the percentage has changed this year. They check the records of 600 accidents selected at random from this year and note that teenagers were at the wheel in 60 of them. (a) Create a 90% confidence interval...

  • Directions: Please complete the case study by following the prompted directions and answering the...

    Directions: Please complete the case study by following the prompted directions and answering the following questions. Many questions are asking for your opinion on the analysis of data/graphs, therefore many answers are considered acceptable with a proper explanation. You hould turn in any graphs/questions that are asked for; if I do not ask for a graph or explanation it is not necessary. The solutions should be numbered based on the question you are answering The solutions may be hand written...

  • PLEASE WITH EXCEL MICROSOFT PROGRAM!!!!!!! Objective: This activity has the purpose of helping students calculate the...

    PLEASE WITH EXCEL MICROSOFT PROGRAM!!!!!!! Objective: This activity has the purpose of helping students calculate the benefit - cost ratio of each alternative and select the best alternative using the software Microsoft Excel. (Objective 4) Student Instructions: Read example to be used to compute the Benefit - Cost ratio. Textbook problem 10 - 4 (Sullivan W., Wicks E., and Patrick C.), page 468: A retrofitted space- heating system is being considered for a small office building. The system can be...

  • Case Study: Managers Challenge When Dealing With Change Ying was struck when one of the lecturers...

    Case Study: Managers Challenge When Dealing With Change Ying was struck when one of the lecturers on her postgraduate module talked about how managers often struggle when companies undergo changes such as mergers, and how they often fail to address their own difficulties. Since it was time for her to start thinking about her postgraduate research project, she thought that understanding the challenges managers face in looking after the organization and its employees during change processes would be a worthwhile...

  • use the information in chapter one to complete it ( in case you do not have...

    use the information in chapter one to complete it ( in case you do not have the book, i post a picture). write a few sentences in each box explaining the extent to which the statements in the left column apply to each of the theories. thank you! Themes and theories Constructivism (Piaget) Social constructivism (Vygotsky) Bioecological systems theory (Bronfenbrenner) nta The environment plays an important role in development Innate factors drive development Development follows a smooth continuous path ning...

  • Develop a case study analysis in the following format Relevance of the case study to my...

    Develop a case study analysis in the following format Relevance of the case study to my work environment - application - learning impact CASE 4-1 Tambrands Overcoming Cultural Resistance Tampax, Tambrands's only product, is the best-selling tampon in their virginity if they use a tampon. When they go to the beach in the world, with 44 pencent of the global market North America and tiny bikinis, tampons arent their choike. Instead, hordes of women Europe account for 90 percent of...

  • please use python and provide run result, thank you! click on pic to make it bigger...

    please use python and provide run result, thank you! click on pic to make it bigger For this assignment you will have to investigate the use of the Python random library's random generator function, random.randrange(stop), randrange produces a random integer in the range of 0 to stop-1. You will need to import random at the top of your program. You can find this in the text or using the online resources given in the lectures A Slot Machine Simulation Understand...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT