Problem Details

In $2011,34\%$ of investors rated gold the best long$-$term investment, $21\%$ rated Real Estate the best long$-$term

investment, $19\%$ rated Stocks and Mutual Funds the best long$-$term investment, $15\%$ rated Savings and CDs as the best

long$-$term investment, $11\%$ rated Bonds the best long$-$term investment strategy $($news$.$gallup.com$/$poll$).$ Have investor

opinions changed? Suppose $1000$ investors randomly sampled in $2024$ provided their preference regarding the best

long$-$term investment strategy. Those preferences are recorded in the worksheet titled $2.$ Preferred Invest$$ found in

the Group Case #$1$ Data file.

Requirements $($See the detailed Problem $2$ Rubric below$)$

$1.$ Is there evidence in the $2024$ sample data that opinions about the value of the various long$-$term investments

have changed since $2011?$ Provide an analysis of the change in investor preferences using a $95\%$ confidence

interval estimates for the $5$ options.

$2.$ Provide clear conclusions reached as a result of your analyses.

$3.$ Use the PLAN$-$DO$-$REPORT structure to detail your work and results.

Remember, $5$ of the $50$ points are allocated to formatting and general construction of the

document. $(19$ pts$)$

PLAN

Briefly summarize the objective of the analysis, important variable$($s$),$ data collection and

characteristics. This should be written as though the reader has no prior knowledge of the

problem specifics, but it cannot simply be a $$Copy and Paste$$ of the case problem.

Identify analysis type

State and check required data conditions. Include any graphs and numerical summary needed.

$2$ points

$3$ points

$4$ points

DO

Complete all relevant analysis utilizing the pre$-$programmed statistical software $($StatCrunch or

Excel Data Analysis Add$-$In$).$

Problem #$2$ data are saved in the Excel file titled $$Group Case #$1$ Data$$ posted on Carmen $>$

Modules $>$ Cases $>$ Group Case #$1.$

Any equations created manually must be processed with the Equation Editor. Failure to do so

will result in a deduction from the FORMAT points.

$5$ points

REPORT

Use the Memo format as shown in the class notes and the Guided Examples in the Sharpe, et$.$al$.$

textbook.

Your report must begin with a brief summary of the purpose of the analysis and report.

Write a brief but comprehensive summary of your analysis, findings and conclusion. Include

specific numerical information to connect the statistical results with your recommendation.

Include any qualifications you feel are warranted.

$(1$ point

general formatting$)$

$1$ point

$4$ points Investment Preference:

Gold Real Estate Real Estate Real Estate Real Estate Gold Real Estate CDs CDs Real Estate Stocks Bonds Stocks Stocks Real Estate Real Estate Real Estate Real Estate Real Estate CDs Stocks Real Estate Crypto Stocks Stocks Stocks Real Estate Real Estate Stocks Gold Real Estate Crypto Gold CDs Real Estate Real Estate Stocks Real Estate Gold Real Estate Real Estate Real Estate Stocks Stocks Stocks CDs Stocks Gold Real Estate Real Estate Real Estate Gold Stocks Gold Real Estate CDs Gold CDs Stocks Real Estate Real Estate Real Estate Gold Stocks Real Estate Bonds Stocks Real Estate Real Estate Stocks Real Estate Real Estate Stocks Bonds Stocks Stocks Real Estate Stocks Gold Gold Real Estate Real Estate Stocks Real Estate Real Estate Real Estate Gold Real Estate Real Estate Real Estate Real Estate Real Estate Real Estate Stocks Real Estate Gold Gold Real Estate Real Estate Real Estate CDs CDs Real Estate Stocks Real Estate Crypto Real Estate Real Estate Real Estate Stocks CDs CDs Real Estate Gold Gold Stocks Stocks Real Estate Gold CDs Gold Gold Real Estate Bonds Bonds Crypto Stocks Gold Real Estate Gold CDs Stocks Stocks Stocks Real Estate Real Estate Stocks Gold Real Estate Real Estate Bonds Real Estate Real Estate Stocks Real Estate Real Estate Stocks Real Estate Real Estate Real Estate Stocks CDs Bonds Real Estate Real Estate Gold Stocks Real Estate Stocks Gold Real Estate Stocks Real Estate Real Estate Bonds Gold Real Estate Stocks Stocks Gold Gold Real Estate Gold Real Estate Real Estate Bonds Gold CDs Gold Stocks Stocks Real Estate Stocks Gold Stocks CDs Real Estate Stocks Gold Stocks Stocks CDs CDs Gold Stocks Real Estate Real Estate Stocks Bonds Real Estate Real Estate Stocks Real Estate Gold Real Estate Real Estate Gold Gold Stocks CDs Real Estate Stocks Gold Real Estate CDs Gold Real Estate Real Estate Gold Gold Real Estate Stocks Bonds Stocks Real Estate Gold Gold Real Estate CDs Real Estate Stocks Real Estate Stocks Real Estate Gold Bonds Stocks Stocks Bonds Real Estate Gold Gold CDs CDs Stocks Real Estate Stocks CDs Stocks Stocks Real Estate Stocks Real Estate Real Estate Real Estate Stocks Bonds Real Estate CDs CDs Crypto Gold Stocks Real Estate Real Estate Real Estate Stocks Real Estate Stocks Real Estate Gold Real Estate Stocks Real Estate Stocks Stocks Gold Stocks Crypto Stocks Gold Stocks Stocks Stocks Crypto Real Estate Gold Bonds Real Estate Gold Stocks Gold Gold CDs Stocks Stocks Real Estate Gold Bonds Gold Bonds Crypto Real Estate Stocks Stocks Stocks Gold C