Assignment - 3 Intro to BA

.xlsx

School

University of Scranton *

*We aren’t endorsed by this school

Course

571

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

8

Uploaded by AdmiralQuetzal3056 on coursehero.com

Year Year as number Birthrate 1965 65 19.4 a.) 1970 70 18.4 1975 75 14.8 1980 80 15.9 1985 85 15.6 1990 90 16.4 1995 95 14.8 2000 100 14.4 2005 105 14 2010 110 13 1978 78 16.7397575757576 2012 112 12.9111515151515 2050 150 8.63212121212121 Regression analysis SUMMARY OUTPUT Regression Statistics Multiple R 0.864407483 R Square 0.747200296 Adjusted R Square 0.715600333 Standard Error 1.051679753 Observations 10 ANOVA df Regression 1 Residual 8 Total 9 Coefficients Intercept 25.5230303 X Variable 1 -0.11260606 RESIDUAL OUTPUT Observation Predicted Y 1 18.20363636 2 17.64060606 3 17.07757576 4 16.51454545 60 70 80 0 5 10 15 20 25 f(x) = − 0.1126060606 Scatter p Birthrate
5 15.95151515 6 15.38848485 7 14.82545455 8 14.26242424 9 13.69939394 10 13.13636364 b.) The equation of regression line is: Y = a + bx Here, Y is birthrate a is intercept b is slope of the regression line x is the year as number So the equation is, Birthrate = 25.523030 + (-0.112606 c.) Regression Statistics Multiple R 0.864407483 R Square 0.747200296 Adjusted R Square 0.715600333 Standard Error 1.051679753 Observations 10 d.) Intepret the slope of the line Slope of the line = -0.11260606 e.) Estimte the birthrate for 1978: Estimated birthrate = 25.523030 + ( 16.73975758 Estimated birthrate for 1978 is 16.7 f.) The residual value for 1978 is: Residual = Actual birtharte - Predict Here, Actual birthrate is 15.0 And Predicted birthrate is 16.73975 Residual = -16.7397576 Residual for the year 1978 is -1.7397 g.) Birthrate in 2012: Birthrate in 2012 = 12.91115152 Comment on this prediction: 12.9111515 births are anticipated in Regarding the confidence in this esti making predictions with linear regre The dependent variable (birthrate) a related in linear regression.
h.) Birthrate in 2050: Birthrate in 2050 = 8.632121212 Comment on this prediction: related in linear regression. The regression line in this instance i not be able to detect rapid changes As a result, although if the projectio it should be regarded with caution. In addition, more recent data as we analyzing birthrate trends for 2012 a 8.63212121 births are anticipated in Regarding the confidence in this esti making predictions with linear regre The dependent variable (birthrate) a related in linear regression. The regression line in this instance i not be able to detect rapid changes As a result, although if the projectio it should be regarded with caution. In addition, more recent data as we analyzing birthrate trends for 2012 a
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help