Please use ONLY one Excel file to answer the below questions. ( including the formula using...

Please use ONLY one Excel file to answer the below questions. ( including the formula using for 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 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. By contrast, only 91 chose bonds.

Compute the standard error for each sample proportion. Compute and describe a 95% confidence interval in the context of the question.
Do you think opinions about the value of gold as a long-term investment have really changed from the old 34% favorability rate, or do you think this is just sample variability? Explain.
Suppose we want to increase the margin of error to 3%, what is the necessary sample size?
Based on the sample size obtained in part c, suppose 120 respondents chose gold as the best long-term investment. Compute the standard error for choosing gold as the best long-term investment. Compute and describe a 95% confidence interval in the context of the question.
Based on the results of part d, do you think opinions about the value of gold as a long-term investment have really changed from the old 34% favorability rate, or do you think this is just sample variability? Explain.

Thank you in advance!

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Answer the following problems in an Excel file. Please upload only one Excel file with all...

Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation rather than a calculation). All problems must be solved using the PV and FV functions in Excel. If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years? If I deposit $8,000 in a bank account that pays simple interest...

Please use ONLY one Excel file to complete this case study, and use one spreadsheet for...

Please use ONLY one Excel file to complete this case study, and use one spreadsheet for each problem. Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable. Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable. Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable. Which of these three models is the best? Use R-square values, Significance...

Please use ONLY one Excel file to complete case study one, and use one spreadsheet for...

Please use ONLY one Excel file to complete case study one, and use one spreadsheet for each problem. Finally, upload the Excel file to the submission link (Week 3 Case Study) for grading. No credit will be granted for problems that are not completed using Excel. In 2011, when the Gallup organization polled investors, 26% 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...

Please use ONLY one Excel file to complete case study one, and use one spreadsheet for...

Please use ONLY one Excel file to complete case study one, and use one spreadsheet for each problem. No credit will be granted for problems that are not completed using Excel. 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...

Please provide an excel file that can answer questions similiar to this one by chaning the...

Please provide an excel file that can answer questions similiar to this one by chaning the data and inputing new data 1.You sell short 100 shares of the GTY stock at $80 per share. Assume your broker requires an initial margin of 40% and a maintenance margin of 25%. 1)If the stock price drops to $70, what is the percentage margin? Initial total stock value: $80(100)=$8,000 If the stock price drops to $70, Total stock value: $70(100)=$7,000 Required margin deposit...

Please answer the following questions using the data in the attached Excel file. You are thinking...

Please answer the following questions using the data in the attached Excel file. You are thinking of investing in Abercrombie and Fitch Co. (ANF). The returns for ANF are embedded in an Excel document below (Source: yahoo.com). 1. For the investment in ANF that you are considering, for all of 2012 determine the following items: a) the mean return b) the median return c) the standard deviation d) the variance e) the coefficient of variation The weekly rates of return...

Case Study One Has Gold Lost Its Luster? Please use ONLY one Excel file to complete...

Case Study One 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...

please answer the question using Excel with formula please explain how the answer came 1. Many...

please answer the question using Excel with formula please explain how the answer came 1. Many drugs used to treat cancer are expensive. BusinessWeek reported on the cost per treatment of Herceptin, a drug used to treat breast cancer. Typical treatment costs (in dollars) for Herceptin are provided by a simple random sample of 10 patients. 5798744651195376549552374814657837175920 a. Develop a point estimate of the mean cost per treatment with Herceptin. b. Develop a point estimate of the standard deviation of...

Answer using excel and please provide excel instructions for all outputs meaning what formula was used...

Answer using excel and please provide excel instructions for all outputs meaning what formula was used to calculate the output and how was it implemented using excel and which excel functions to use. Thank you. Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founded over 70 years ago. Over the years, the company...

Please create an Excel file with the calculated answers to the questions to the Excel homework...

Please create an Excel file with the calculated answers to the questions to the Excel homework for this week. The questions are listed in the attached PDF file. Please also go over the Excel file attached to this assignment in order to familiarize yourself with the different ways Excel can be used to solve Time Value of Money problems when multiple cash flows are involved. There are three worksheets in the Excel file. This Excel file with examples is just...

Subjects