Multiple Linear Regression using Excel Data Analysis Toolpak

LearnAnalytics demonstrates use of Multiple Linear Regression on Excel 2010. (Data Analysis Toolpak). Data set referenced in video can be downloaded at www.learnanalytics.in/blog/wp-content/uploads/2014/02/car_sales.xlsx

---

Closed Caption:

alright so in this segment we're going
to cover how to monitor the patient's
only accept on some of you with no and
excited we have dances to back which
allows him to do a bit of skin analysis
you're interested in SPSS that being
said it's very basic and what I'm going
to do in this video is to show you how
wonderful innovation model using will be
except i will enable the analysis back
on your Excel spreadsheet go two by two
table is violent press options
options click on happens
manage excellent space bow and not just
one pocket this is not click click on
this is okay in the option on the
extreme right hand side you see about
that Madison Madison you see all the
tests go love it
test correlation detest for two-sample t
equal equal needed to travel here you
see the option population and i'm going
to show you a little addition of this
dataset scan the data set not so this is
not often 777 training data set of our
observations so we've got in terms
regarding the gods ichiro is in
particular model original you've got the
manufacturers cadillac chevrolet
specific model of because the sales
figures think the price will be not then
we got some information regarding the
passing of time the type you see it
distinguishes but we know what seems to
be like assume beings was modest
then we got the engine capacity or the
engine size 14.7 and so on but the
gospel are we got the characteristics of
the chassis with capacity and the
manager of the god this information more
than what we're going to do is we're
going to try predictive model of price
as a function of all of these minutes so
if i press are buying market price as a
function of only one medical that's
simple irrigation if i try to model
price the functional more than one
variable that's wonderful irrigation and
you can do wonderful linear equations in
the balance is something i can be very
happy to do some exploratory analysis
we're going to rely on for the dedicated
to my hand job like this or this piece
of mixing so people getting on the stool
back electrification the options over
here is ok thank whenever you see an
option called input line and connects
range they live age you'll have to input
the dependent variable available which
you were born in this case our who
function of rice spices prices be
regulated I need to select
so here in the next raid is set up your
independent variable which are going to
explain the variance and price now think
about the room back all of your
independent variable to be together so
you have any gaps within the independent
variables if you want . your sheet so
that all independent variables come one
after the other so i select from time
filler and video from all the master
element select all the rules as you see
that i have selected posterize when you
can make sure that the labels options
click in case i select from going to
like any more labels but the Arizona
with ordered all incredible is what so i
click on able to overhear confidence
interval or the other demands i did
before a person before adding an
additional foot if I wanted a more
constant resignation i can . 20
I don't need to do that made all the
difference populated you work should be
rewarded specifically tomorrow
engineering parent Riggins it's five
anywhere you want to specify i wanna
walk she is a building sector and even
for now and then see you deserve that
and we get to see automatically open the
new Bible the same sheet and I get the
results of my multiple media division
for those of you sighs of experiences
are you will see straight off the result
is very similar to what you would get
all the very good service to local
that's really need
so I got the basic no results regarding
the identity of moderation by see
multiple R&R squid pretty high so i'm
feeling in the hospital . a train or a
very personal variation can be explained
what is variable
just relax we're also very high so I
know there is no forfeiting scandalous
coming a 6.4 I get the anova tradition i
can check the p value of the ex-cop so
it's coming in people to raise your body
so i just shaved this moment I see you
know . references much more than 10 by
now this is my moral over here so i get
the Pacific party full and then I can
beat our students the scoop of each of
the variables over here and over even
against them
he started the be bothered so check
which variables are significant we
obviously need to look at the value of
available
IC make it easier to read
so almost all the variables of public
significant I could see in vase and MPG
r- they actually do not impact the price
because the female is much higher than
the cutoff IE these variables are
insignificant if you can see the mission
is actually know about this calculator
and in this case also the Commission
much more than the standard air and so
this variable that actually gotten back
to our place in march and I can actually
remove these variables and still in
development if I want to do some white
racial i can go back you know I can
order denounces to back and do it again
but i will actually remove variables
from the ignition but it got me if I go
back here input lines already that input
x rays i will- per gallon and I would be
other variable general removal is
wheelbase and probably visit between
variables like cannot select two
different sets available to meet
variable gonna determine movement let me
the movie database and put in the work
here and be based on mines per gallon
mother to variable which I want to
extract it goes it again nation and
worked explain it's already there is
required and protects French in this
case from all the way in capacity is
more the deliverables everything is the
same
it's okay i get money results of this
was the order i know the difference is
the people's titration I vnic the
variables up introduced by the variable
provides see that the r-squared has not
changed if you look at the previous
hospitals . 81 it's still . 81 in my
latest information
what is essentially is really from the
fact that removing those two variables
did not get back my my division at all
IC dual variables fuel capacity just
slightly out of 105 and maybe with which
I can try but the minion already cut off
you taking a while . 10 I candid and
these are be mission of bodies good
estimates and suitable little