Linear Regression Practical Session - Part - 1

SAS Analytics Linear Regression-Case Study & Practical session
7 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.69
List Price:  €92.43
You save:  €27.73
£55.43
List Price:  £79.19
You save:  £23.76
CA$95.13
List Price:  CA$135.91
You save:  CA$40.77
A$107.14
List Price:  A$153.07
You save:  A$45.92
S$94.18
List Price:  S$134.55
You save:  S$40.37
HK$547.43
List Price:  HK$782.07
You save:  HK$234.64
CHF 62.84
List Price:  CHF 89.78
You save:  CHF 26.93
NOK kr751.54
List Price:  NOK kr1,073.68
You save:  NOK kr322.13
DKK kr482.54
List Price:  DKK kr689.37
You save:  DKK kr206.83
NZ$116.52
List Price:  NZ$166.47
You save:  NZ$49.94
د.إ257.02
List Price:  د.إ367.19
You save:  د.إ110.16
৳7,678.03
List Price:  ৳10,969.08
You save:  ৳3,291.05
₹5,840.96
List Price:  ₹8,344.59
You save:  ₹2,503.62
RM330.70
List Price:  RM472.45
You save:  RM141.75
₦101,485.50
List Price:  ₦144,985.50
You save:  ₦43,500
₨19,524.27
List Price:  ₨27,893.01
You save:  ₨8,368.74
฿2,545.92
List Price:  ฿3,637.18
You save:  ฿1,091.26
₺2,250.25
List Price:  ₺3,214.78
You save:  ₺964.53
B$350.11
List Price:  B$500.17
You save:  B$150.06
R1,326.68
List Price:  R1,895.34
You save:  R568.65
Лв126.54
List Price:  Лв180.78
You save:  Лв54.24
₩93,996.51
List Price:  ₩134,286.49
You save:  ₩40,289.97
₪254.44
List Price:  ₪363.51
You save:  ₪109.06
₱3,940.01
List Price:  ₱5,628.83
You save:  ₱1,688.82
¥10,588.86
List Price:  ¥15,127.59
You save:  ¥4,538.73
MX$1,172.70
List Price:  MX$1,675.35
You save:  MX$502.65
QR255.26
List Price:  QR364.67
You save:  QR109.41
P962.26
List Price:  P1,374.71
You save:  P412.45
KSh9,253.37
List Price:  KSh13,219.67
You save:  KSh3,966.30
E£3,317.72
List Price:  E£4,739.80
You save:  E£1,422.08
ብር3,958.28
List Price:  ብር5,654.93
You save:  ብር1,696.64
Kz58,409.75
List Price:  Kz83,446.08
You save:  Kz25,036.32
CLP$68,721.78
List Price:  CLP$98,178.18
You save:  CLP$29,456.40
CN¥504.86
List Price:  CN¥721.26
You save:  CN¥216.40
RD$4,133.68
List Price:  RD$5,905.51
You save:  RD$1,771.83
DA9,439.74
List Price:  DA13,485.92
You save:  DA4,046.18
FJ$159.61
List Price:  FJ$228.03
You save:  FJ$68.41
Q545.63
List Price:  Q779.50
You save:  Q233.87
GY$14,636.18
List Price:  GY$20,909.73
You save:  GY$6,273.54
ISK kr9,633.42
List Price:  ISK kr13,762.62
You save:  ISK kr4,129.20
DH706.50
List Price:  DH1,009.33
You save:  DH302.83
L1,238.76
List Price:  L1,769.74
You save:  L530.97
ден3,978.99
List Price:  ден5,684.52
You save:  ден1,705.52
MOP$563.50
List Price:  MOP$805.03
You save:  MOP$241.53
N$1,332.69
List Price:  N$1,903.92
You save:  N$571.23
C$2,574.90
List Price:  C$3,678.58
You save:  C$1,103.68
रु9,361.10
List Price:  रु13,373.57
You save:  रु4,012.47
S/258.10
List Price:  S/368.73
You save:  S/110.63
K264.08
List Price:  K377.28
You save:  K113.19
SAR262.49
List Price:  SAR375
You save:  SAR112.51
ZK1,838.05
List Price:  ZK2,625.89
You save:  ZK787.84
L321.59
List Price:  L459.43
You save:  L137.84
Kč1,635.36
List Price:  Kč2,336.33
You save:  Kč700.97
Ft25,680.27
List Price:  Ft36,687.67
You save:  Ft11,007.40
SEK kr741.17
List Price:  SEK kr1,058.86
You save:  SEK kr317.69
ARS$59,823.40
List Price:  ARS$85,465.66
You save:  ARS$25,642.26
Bs483.41
List Price:  Bs690.61
You save:  Bs207.20
COP$273,068.76
List Price:  COP$390,114.95
You save:  COP$117,046.19
₡35,548.01
List Price:  ₡50,785.04
You save:  ₡15,237.03
L1,727.31
List Price:  L2,467.69
You save:  L740.38
₲513,086.33
List Price:  ₲733,011.89
You save:  ₲219,925.56
$U2,640.59
List Price:  $U3,772.44
You save:  $U1,131.84
zł278.67
List Price:  zł398.12
You save:  zł119.44
Already have an account? Log In

Transcript

Let's start our practical session before we start the practical session, first we need to get the data sets in our SAS environment. And for that we have to first execute our live name statement. So my code to execute the live name statement will be live name. My Library name is my live one I've given you can give any library any name for your library. Then I give double quotes here I have to give the part of my data sets. This is the path I have given the bug within double quotes and then I'm given semicolon.

As you know, every sass statement should end by a semicolon so without semicolon it cannot be executed. So now let's execute the zipline statement. So this is my explorer window. And inside the Maven library, these are my data sets. So I've got my data sets, my data set that the data set with which are going to work over here is linear underscore data underscore detail. So let's run the regression procedure.

Proc reg. Data equals my lib run is my library name. New underscore, reg. underscore retail Is my data set name I'm reading the classical linear regression model using the keyword model, my dependent variable is customer satisfaction, I have to write the variable names exactly the weight is given in the data set. Otherwise, SAS cannot identify them. So customer satisfaction is very dependent variable and all my independent variables and starting from product quality, delivery speed, so I will be giving the range of the independent variables instead of specifying each of them.

I'm giving the range of the independent variables. Starting from property that is my first independent variable delvia speech is my last independent variable. I'm using the key Va which stands for variance inflation factor to check for multicollinearity for all the independent variables let us run the code. So, this code is used to check the multicollinearity for all the independent variables starting from product quality to delivery speed, we are using the keyword variance inflation factor that is VA project for multicollinearity. So, let's run this code. So, these are the values of the variance inflation factor for all the independent variables to see, the variable delivery speed has got maximum value of a pet is 47 double one double eight.

So, this is the maximum value of the A for delivery speed. So, we will be excluding or we will be removing this variable for the next regression procedure. jackin multicollinearity again, because as we know that according to this absolute classical linear regression model, the independent variables of my data set should have minimum of multicollinearity. here that's been adjusted R square value values are displayed r squared is 0.802 that is 80% adjusted R squared is 79%. You know that we will always consider the value of adjusted R squared because that will that will bring the efficiency of the model and can only consider the significant variables that remove the redundancy. So, we will only consider adjusted R square this is me and I this is a variance table adjusted R square is only taken as the accurate measure for the goodness of fit and the total number of observations that are used throughout run this regression procedures 200 that is there are total 200 observations in data set.

Now, let's do the next regression procedure. We'll be doing the next regression procedure to check for multicollinearity for our data excluding the variable delivery speed, because delivery speed had maximum multicollinearity before so now we'll be excluding the variable delivery speed and check for multicollinearity. Again, for the rest of the independent variables of my data set. My procedure will be same. my dependent variable will be customer satisfaction and dependent variables will be from product one GE in price flexibility that we made last variable because we have excluded Let me repeat the chart the maximum value of the A. So long giving the range from protocol.

Price flexibility is flexible flexibility is a second last variable according to my data set and our delivery speed so my last variable over here we look at price flexibility. Again, I'm using the keyword var. So let's run the code and check for multicollinearity of the set of independent variables. The VA values for all the variables from product quality to price This video given to see the VA values are quite low compared to before. So now I want you doctor to have minimal multicollinearity in my data, I also got our spinner tested R squared value, which is the same. This is my analysis of variance table.

And we have used 200 observations. That is the total number of observations in our data set. All my VA values are within five. So generally five or 10 is taken as a critical threshold for VA. So now we can move for the next regression procedures. In this video, we'll be doing two here.

So for now, let's end the video over here. Thank you. Goodbye and see you all for the next video.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.