## Multiple Regression Analysis

Occasional Contributor
Posts: 9

# Multiple Regression Analysis

Hello I really need some help. Here are my assignment instructions.

Perform a Multiple Regression Analysis paralleling the HBAT analysis performed in the textbook and in class, but now use the HATCO dataset (see HATCO_X1-X14_Tabs data file).

Include the following analyses:

• Consider the overall general Model X9 = X1 X2 X3 X4 X5 X6 X7
• Perform a Correlation Analysis
• Fit and Analyze the best single independent (simple) regression analysis
• Perform a Stepwise Regression Analysis to select the best subset model using Alpha = 0.05
• Perform a Full Model (Confirmatory) Regression Analysis using Alpha = 0.05
• Using the best subset from the Stepwise Regression Analysis now include variable X8 (Firm Size) and analyze its effect and the new resultant model
• Analyze and Discuss the Multiple Regression Analysis Assumptions, e.g., Linearity, Normality, Homoscedasticity, and Independence using Residual and other Graphical/Statistical measures and tests for all Model Analyses
• Similarly Analyze and Discuss any Influential observations with recommendations, as well as the Model’s Multicollinearity.

Here is what I've done so far for my code:

FILENAME REFFILE "/home/tmaciver7840/my_content/HATCO X1-X14.txt" TERMSTR=CR;

PROC IMPORT DATAFILE=REFFILE
DBMS=tab
OUT=WORK.IMPORT;
GETNAMES=YES;
RUN;

PROC CONTENTS DATA=WORK.IMPORT; RUN;
Input ID X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 X11 X12 X13 X14;
Data WORK.IMPORT;
Set WORK.IMPORT (Keep = ID X1 X2 X3 X4 X5 X6 X7 X9);
Label ID = 'ID - Identification Number'

X1 = 'X1'

X2 = 'X2'

X3 = 'X3'

X4 = 'X4'

X5 = 'X5'

X6 = 'X6'

X7 = 'X7'

X8 = 'X8'

X9 = 'X9'

X10 = 'X10'

X11 = 'X11'

X12 = 'X12'

X13 = 'X13'

X14 = 'X14';

Proc Print Data = WORK.IMPORT;

*;

*;

* Correlation Matrix - All Variables;

*;

Proc Corr Data = WORK.IMPORT;

Var X1 X2 X3 X4 X5 X6 X7 X9;

Plot NQQ.*R. NPP.*R.; * NQQ.*R and NPP.*R request specific separate

Normal Quantile and Normal Probability Plots;

*;

How do I perform the rest of the regression analyses?  I really appreciate any help! (Attached is the dataset)

SAS Employee
Posts: 35

## Re: Multiple Regression Analysis

This is not the right forum for this question. You should try a more appropriate forum.

Occasional Contributor
Posts: 9

## Re: Multiple Regression Analysis

Which forum should I try? Data Management?
SAS Employee
Posts: 35