Answered step by step
Verified Expert Solution
Question
1 Approved Answer
...unable to include regression model since chegg says my question is too long. is there an email I can send w/the excel for regression? A
...unable to include regression model since chegg says my question is too long. is there an email I can send w/the excel for regression?
A regression model to predict Y, the state burglary rate per 100,000 people for 2005, used the following four state predictors: Xq = median age in 2005, X2 = number of 2005 bankruptcies, X3 = 2004 federal expenditures per capita (a leading predictor), and X = 2005 high school graduation percentage Click here for the Excel Data File (a) Using the sample size of 50 people, calculate the tcalc and p-value in the table given below. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "O" wherever required. Round your answers to 4 decimal places.) Predictor Coefficient tcale p-value Intercept 4,198,5808 799.3395 AgeMed -27 3540 12.5687 Bankrupt 17.4893 12.4033 FedSpend -0.0124 0.0176 HSGrad% -29.0314 7.1268 SE (6-1) What is the critical value of Student's t in Appendix D for a two-tailed test at a = .01? (Round your answer to 3 decimal places.) t-value = 1 (b-2) Choose the correct option. Only HSGrad% differs significantly from zero. Only Bankrupt differs significantly from zero. Only Fed Spend differs significantly from zero. A regression model to predict Y, the state burglary rate per 100,000 people for 2005, used the following four state predictors: Xq = median age in 2005, X2 = number of 2005 bankruptcies, X3 = 2004 federal expenditures per capita (a leading predictor), and X = 2005 high school graduation percentage Click here for the Excel Data File (a) Using the sample size of 50 people, calculate the tcalc and p-value in the table given below. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "O" wherever required. Round your answers to 4 decimal places.) Predictor Coefficient tcale p-value Intercept 4,198,5808 799.3395 AgeMed -27 3540 12.5687 Bankrupt 17.4893 12.4033 FedSpend -0.0124 0.0176 HSGrad% -29.0314 7.1268 SE (6-1) What is the critical value of Student's t in Appendix D for a two-tailed test at a = .01? (Round your answer to 3 decimal places.) t-value = 1 (b-2) Choose the correct option. Only HSGrad% differs significantly from zero. Only Bankrupt differs significantly from zero. Only Fed Spend differs significantly from zeroStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started