Question
Can someone walk me through step by step. I am new to SPSS The purpose of this assignment is to apply simple regression concepts, interpret
Can someone walk me through step by step. I am new to SPSS
The purpose of this assignment is to apply simple regression concepts, interpret simple regression analysis models, and justify business predictions based upon the analysis.
You will use SPSS to analyze the data set and address the questions presented.
The business characteristics of n = 250 U.S. trucking and delivery companies for calendar year 2011 were recorded. Among the characteristics studied were the number of drivers and the number of trucks (power units) each company employed.
Part 1:
Given that the data consists of counts and range of counts is large, a natural log transformation is usually performed to improve the linear model results. Apply a natural log transform to both variables and then plot the Y = ln(Trucks) vs. X = ln(Drivers).
Is there a linear relationship? Justify your answer by providing the SPSS output as an illustration.
Part 2:
Build a simple linear model by regressing Y on X and testing whether or not a relationship exists between the number of drivers and the number of trucks. Address the following questions in your written response:
- After fitting the model, plot the standardized residuals (on vertical axis) vs. the standardize predictions (on horizontal axis). Is there a pattern? How would you interpret the pattern or lack of pattern?
- After fitting the model, derive the normal probability plot and interpret what the plot means.
- What is the coefficient of determination, R2, of the model? How would you interpret the R2?
- What is the estimate of ?1? How would you interpret the estimate of ?1?
- Is the estimate of ?1significantly different than 0? Assume an ? = 0.01.
- What is a 95% confidence interval for ?1? How would you interpret the 95% confidence interval for ?1?
- If a new trucking and delivery company with 4,900 drivers were to be formed, how many trucks would you expect the company would employ based on the model?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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