Please submit your Excel file and highlight your answers in color.Brief CaseHas Gold Lost its Luster?In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment.However, in April of 2013 Gallup surveyed a random sample of U.S. adults. Respondents were asked toselect the best long-term investment from a list of possibilities. Only 241 of the 1005 respondents chosegold as the best long-term investment. With 95% confidence, compute the margin of error of the sample proportion. Compute and describe a 95% confidence interval in the context of the case. Do you think opinions about the value of gold as a long-term investment have really changedfrom the old 34% favorable rate, or do you think this is a sample variability? Explain your answerusing the calculated statistics. Suppose the Gallup organization wants to offer a new investment option and wants to estimate,to within 5%, the proportion of customers who are likely to make this new investment with 95%confidence. How large a sample do they need? Please step by step and show on excel sheet

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question

Please submit your Excel file and highlight your answers in color.
Brief Case
Has Gold Lost its Luster?
In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment.
However, 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 the best long-term investment.
 With 95% confidence, compute the margin of error of the sample proportion.
 Compute and describe a 95% confidence interval in the context of the case.
 Do you think opinions about the value of gold as a long-term investment have really changed
from the old 34% favorable rate, or do you think this is a sample variability? Explain your answer
using the calculated statistics.
 Suppose the Gallup organization wants to offer a new investment option and wants to estimate,
to within 5%, the proportion of customers who are likely to make this new investment with 95%
confidence. How large a sample do they need?

Please step by step and show on excel sheet

AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON