Isolate independent variables

[mawais31]

CONTENTS DELETED

The author has deleted this message.

[Melissa Ives]

And.....?? What do you need?  To link the files? Do they have any common variables?
My guess is that File 1 has one record per customer/car/claim that relates to 1 or more records in File 2 that each relate to 1 or more records in File 3.
You  will likely need to consider Table matches, and/or CasetoVars restructure and/or Aggregate.
More information is needed for any useful responses.

Melissa
-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of mawais31
Sent: Tuesday, July 10, 2012 4:23 AM
To: [hidden email]
Subject: [SPSSX-L] Isolate variables

Dear All!

I have one problem in research methodology and need some guidance from any one! We have a body and paint business for Cars.


We have a decrease in our business last year, as there were a decrease in Accidents for Cars ... I want to see which factors are influencing it  i.e.
weather condition, city safety installed in cars, insurance company, mileage and so on ...

I have data from insurance company for customer claims... and contains 3 files

File 1: Customer, claims and car information (contains... age driver, sex driver, car model, car type, insured, accident date, damage side, number of parts damaged) File 2: invoice information  and dealer information File 3: parts information (parts used in car)


Regards

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Isolate-variables-tp5714101.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[mawais31]

Thanks Melissa Ives! For quick reply!

Now here are claims/year

http://spssx-discussion.1045642.n5.nabble.com/file/n5714125/claims.png

Now I have to find that which factors or independent variables are involved
in decreasing the claims... i.e. weather conditions, city safety and so on
...

I have either to create a model or to use factor analysis technique or
correspondence analysis ... I am confused that how shall I start my
analysis?

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Isolate-independent-variables-tp5714101p5714125.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso]

Perhaps you should consider hiring a statistician and paying them to sort this out for you!
Your questions are WAY too general to address in an internet forum.
If you have SPECIFIC questions as to how to use SPSS this is a fine place to get help.
OTOH:  If you have been given data from your boss and really have NO idea of what to do with it you need to acquire a statistics book or multiple books which address issues such as regression, autocorrelation, time series, transfer functions and related topics, spend a month or two  studying it and then come back with specific questions. OR HIRE SOMEONE WITH the proper level of education and EXPERTISE!!!!!
Just because SPSS has an easy to use GUI and pops out cool tables and charts DOES NOT MEAN the proper use of statistics is an simple undertaking!!!!! It's DAMN hard to do correctly and unfortunately there are way too many misguided people who believe that simply because they own a copy of SPSS and can click a mouse implies that they are qualified to perform statistical modeling.
Just because someone knows how to use a wrench doesn't mean they know squat about being an auto mechanic.  I wouldn't let a house painter do my plumbing or my gardener do my cooking.
Why do people think they can get away with this sort of crap with statistics?
Oh..... Real Stats Real easy! What a crock (early 1990's SPSS sales mantra )!!!!!!!
Sorry for the RANT but this is the second time this same exact question was asked by OP this week and I know Art provided some specific guidance and OP doesn't seem to get it.
"Please provide me with extensive free consulting!!!"
I'm sure I'm going to receive some castigating private emails from a few of you accusing me of being insensitive and rude.  PLEASE don't waste your time!  This is something which needed to be said and someone had to say it!

-----

mawais31 wrote

Dear All!
 
I have one problem in research methodology and need some guidance from any one! We have a body and paint business for Cars.
 
 
We have a decrease in our business last year, as there were a decrease in Accidents for Cars ... I want to see which factors are influencing it  i.e. weather condition, city safety installed in cars, insurance company, mileage and so on ...
 
I have data from insurance company for customer claims... and contains 3 files
 
File 1: Customer, claims and car information
(contains... age driver, sex driver, car model, car type, insured, accident date, damage side, number of parts damaged)
File 2: invoice information  and dealer information
File 3: parts information (parts used in car)
 
 
Regards

[Bruce Weaver]

Hear hear!

David Marso wrote

Perhaps you should consider hiring a statistician and paying them to sort this out for you!
Your questions are WAY too general to address in an internet forum.
If you have SPECIFIC questions as to how to use SPSS this is a fine place to get help.
OTOH:  If you have been given data from your boss and really have NO idea of what to do with it you need to acquire a statistics book or multiple books which address issues such as regression, autocorrelation, time series, transfer functions and related topics, spend a month or two  studying it and then come back with specific questions. OR HIRE SOMEONE WITH the proper level of education and EXPERTISE!!!!!
Just because SPSS has an easy to use GUI and pops out cool tables and charts DOES NOT MEAN the proper use of statistics is an simple undertaking!!!!! It's DAMN hard to do correctly and unfortunately there are way too many misguided people who believe that simply because they own a copy of SPSS and can click a mouse implies that they are qualified to perform statistical modeling.
Just because someone knows how to use a wrench doesn't mean they know squat about being an auto mechanic.  I wouldn't let a house painter do my plumbing or my gardener do my cooking.
Why do people think they can get away with this sort of crap with statistics?
Oh..... Real Stats Real easy! What a crock (early 1990's SPSS sales mantra )!!!!!!!
Sorry for the RANT but this is the second time this same exact question was asked by OP this week and I know Art provided some specific guidance and OP doesn't seem to get it.
"Please provide me with extensive free consulting!!!"
I'm sure I'm going to receive some castigating private emails from a few of you accusing me of being insensitive and rude.  PLEASE don't waste your time!  This is something which needed to be said and someone had to say it!

-----

mawais31 wrote

Dear All!
 
I have one problem in research methodology and need some guidance from any one! We have a body and paint business for Cars.
 
 
We have a decrease in our business last year, as there were a decrease in Accidents for Cars ... I want to see which factors are influencing it  i.e. weather condition, city safety installed in cars, insurance company, mileage and so on ...
 
I have data from insurance company for customer claims... and contains 3 files
 
File 1: Customer, claims and car information
(contains... age driver, sex driver, car model, car type, insured, accident date, damage side, number of parts damaged)
File 2: invoice information  and dealer information
File 3: parts information (parts used in car)
 
 
Regards