A regression model to predict Y, the state burglary rate per 100,000 people, used the following four state predictors: X1 = median age, X2 = number of bankruptcies per 1,000 population, X3 = federal expenditures per capita (a leading predictor), and X4 = 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 "0" wherever required. Round your answers to 4

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

A regression model to predict Y, the state burglary rate per 100,000 people, used the following four state predictors: X1 = median age, X2 = number of bankruptcies per 1,000 population, X3 = federal expenditures per capita (a leading predictor), and X4 = 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 "0" wherever required. Round your answers to 4 decimal places.)
  

 

 


(b-1) What is the critical value of Student's t in Appendix D for a two-tailed test at α = .01? (Round your answer to 3 decimal places.)
  

 
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Regression Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education