Situation:

The conference Board produces a Consumer Confidence Index (CCI) that reflects people's feelings about general business conditions, employment opportunities, and their own income prospects. Some researchers may feel that consumer confidence is a function of the median household income.

 

Action

Use the attached MS Excel spreadsheet containing the CCIs for nine years and the median household incomes for the same nine years published by the U.S. Census Bureau.

 

Perform a correlation and regression analysis to predict CCI using median household income. Discuss the following:

1. Scatter Diagram
2. R, R2 and 1-R2
3. The regression equation
4. Standard error of estimate
5. The test of hypothesis with the 5-step process. Use a .05 level of significance. Does median household income appear to be good predictor of the CCI? Why or why not?

 

I'm looking for the data in Microsoft Excel or Minitab format.

Thank you

• 1503076707-Question 4.xlsx

AccountingQueen

(3)

Status NEW Posted 18 Aug 2017 05:08 PM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)

• Buy Answer