Microsoft Neural Networks Question

1) Scaling of Inputs

Is the standarization of the inputs done automatically when running the Microsoft Neural Network algorithm or I should be transforming the variables before running the algorithm?

2) Predicted Probabilities

How do I create a table with the actual predicted probabilities of the model for each observation? In the Mining Model Prediction tab the output would be either 0 or 1, my question is how can I obtain the actual value of the estimated probability?

1) Yes, using z-score ((value -mean)/StdDev), so there is no reason for transformation.

2) Use a prediction function.

PredictProbability will return the probability of the actual prediction. PredictHistogram wil return all the probabilities (for all target states). The actual prediction is, of course, the state from the histogram having the largest probability

|||

Thanks for this. I assume that for categotical variables standarization is also done automatically by some other appropriate transformation, right?

Cheers,

Leo.

|||It sure is. Enjoy!

Metadata Definition ?

Hello, i would like to know if it's possible to generate automatically a word document or an excel document that will contain all the metadata definition, for example containing the source columns names, their datatype, and the destination with their datatypes, so that it would easy to create a data dictionnary .

Thank you in advance.

Microsoft have talked about a tool called "SQL Dcoumenter" that will do this. No news about when it will be released though.

-Jamie

|||Thank you for your answer, i will do that manually.