The conference Board produces a Consumer Confidence Index (CCI) that reflects people's feelings about general business...

70.2K

Verified Solution

Question

Basic Math

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. Someresearchers may feel that consumer confidence is a function of themedian household income.

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

Perform a correlation and regression analysis to predict CCIusing 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 levelof significance. Does median household income appear to be goodpredictor of the CCI? Why or why not?
CCIMedian House Hold Income ($1,000)
116.837415
91.536770
68.535501
61.635047
65.934700
90.634942
10035887
104.636306
125.437005

Answer & Explanation Solved by verified expert
3.5 Ratings (634 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students