Invest sample size countaa2a21 20 2 yes response of

This preview shows page 7 - 8 out of 8 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Business Analytics: Data Analysis & Decision Making
The document you are viewing contains questions related to this textbook.
Chapter 11 / Exercise C.4
Business Analytics: Data Analysis & Decision Making
Albright/Winston
Expert Verified
Invest?Sample Size=COUNTA(A2:A21)202YesResponse of Interestyesyes3NoCount of Response=COUNTIF(A2:A21,D2)54noSample Proportion=D3/D10.255no6noHypothesized Value0.20.27no8yesStandard Error=SQRT(D6*(1-D6)/D1)0.089442729noTest Statistic=(D4-D6)/D80.5590169910no11nop-value (Lower Tail)=NORMSDIST(D9)0.71192497312nop-value (Upper Tail)=1-NORMSDIST(D9)0.28807502713nop-value (TwoTail)=2*MIN(D11,D12)0.57615005314no15noDo not reject H0, .57615 > .05, there is not sufficient evidence at = .05 to conclude that the proportion of 18-24 year-old Americans who invest in stocks has changed.25. ANS: a. = 12.138 - 0.6277x b. Yes, at $1,934 26. ANS: xy212396877867592SUMMARY OUTPUT Regression StatisticsMultiple R 0.918558654R Square 0.84375
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Business Analytics: Data Analysis & Decision Making
The document you are viewing contains questions related to this textbook.
Chapter 11 / Exercise C.4
Business Analytics: Data Analysis & Decision Making
Albright/Winston
Expert Verified
Adjusted R Square 0.8125Standard Error 1.369306394Observations 7ANOVA dfSSMSFSignificance FRegression 150.62550.625270.00348Residual 59.3751.875Total 660 CoefficientsStandard Errort StatP-valueLower 95%Intercept 13.751.3983419.8330820.00018530910.1555x -1.1250.216506-5.196150.003478165-1.68155a. y = 13.75 - 1.125x b. Since the p-value 0.003478165 < .05, reject Ho. Therefore, xand yare related. c. Since the p-value 0.00348 < .05, reject Ho. d. R Square = 0.84375; 84.375% of the variation in yis explained by the variation in x

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture