Hits: 0
Trendlines and Regression Analysis Assignment
Instructions: Please submit your work in one single Excel file with one tab/worksheet for each problem.
Simple Linear Regression, Residual Analysis and Regression Assumptions
- (30 points) The Excel file National Football League provides various data on professional football for one season.
- Construct a scatter diagram for points/game and yards/game in the Excel file. Does there appear to be a linear relationship?
- Use the Regression tool to develop a model for predicting points/game as a function of yards/game. Explain the statistical significance of the model and Trendlines and Regression Analysis Assignment Help
- Analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any possible outliers exist.
Building Good Regression Models
Trendlines and Regression Analysis Assignment Help
- (40 points) Use the data in the Excel file Job Satisfaction to find the best multiple regression model to predict the overall satisfaction as a function of the other variables.
- Show your steps to build the best regression model.
- What managerial implications does your result have?
Regression with Categorical Independent Variables
- (30 points) A national homebuilder builds single-family homes and condominium-style townhouses. The Excel file House Sales provides information on the selling price, lot cost, type of home, and region of the country (M = Midwest, S = South) for closings during on month. Trendlines and Regression Analysis Assignment Help
- Develop a multiple regression model for sales price as a function of lot cost and type of home without any interaction term.
- Determine if an interaction exists between lot cost and type of home and find the best model.
- What is the predicted price for either a single-family home or a townhouse with a lot cost of $30,000?
For Trendlines and Regression Analysis Assignment Help please click here