Chapter 8 Trendlines and Regression Analysis
Directions: Please submit your work in a single single Excel file with one tab/worksheet for every drawback.
Easy Linear Regression, Residual Analysis and Regression Assumptions
1. (30 factors) The Excel file Nationwide Soccer League supplies varied knowledge on skilled soccer for one season.
a. Assemble a scatter diagram for factors/sport and yards/sport within the Excel file. Does there look like a linear relationship?
b. Use the Regression device to develop a mannequin for predicting factors/sport as a operate of yards/sport. Clarify the statistical significance of the mannequin and worth.
c. Analyze the residuals to find out if the assumptions underlying the regression Assessment are legitimate. As well as, use the usual residuals to find out if any doable outliers exist.
Constructing Good Regression Fashions
2. (40 factors) Use the information within the Excel file Job Satisfaction to search out the perfect a number of regression mannequin to foretell the general satisfaction as a operate of the opposite variables.
a. Present your steps to construct the perfect regression mannequin.
b. What managerial implications does your consequence have?
Regression with Categorical Impartial Variables
three. (30 factors) A nationwide homebuilder builds single-family properties and condominium-style townhouses. The Excel file Home Gross sales supplies data on the promoting worth, lot value, sort of dwelling, and area of the nation (M = Midwest, S = South) for closings throughout on month.
a. Develop a a number of regression mannequin for gross sales worth as a operate of lot value and sort of dwelling with none interplay time period.
b. Decide if an interplay exists between lot value and sort of dwelling and discover the perfect mannequin.
c. What’s the predicted worth for both a single-family dwelling or a townhouse with quite a bit value of $30,000?
———–
Trendlines and Regression Analysis in Chapter 8
Please submit your work in a single Excel file with one tab/worksheet for every drawback.
Regression Assumptions, Residual Analysis, and Easy Linear Regression
1. Formalized paraphrase (30 factors) The Nationwide Soccer League Excel file comprises varied knowledge on skilled soccer for a single season.
a. Within the Excel file, create a scatter diagram for factors/sport and yards/sport. Is there a transparent linear relationship?
b. Utilizing the Regression device, create a mannequin for predicting factors per sport as a operate of yards per sport. Clarify the mannequin’s and worth’s statistical significance.
c. Study the residuals to see if the assumptions underpinning the regression Assessment are appropriate. As well as, use the usual residuals to find out if any doable outliers exist.
Constructing Good
