Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

...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 zero

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions