Question: ...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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!