Model building using Training data and predoction of Target set with test data

URGENT ! need help to build the Predictiive Model


Need some help to solve the problem using right s/w(SPSS or execl) and approach .

I have a raw attribute data for 430 restaurants.

Training Data: The set contains information about 430 restaurants. The target variable for every row is the aggregated weekly footfall named ‘Total’. I need to build their model using this training set.

Test Data: This set has the all the attributes except the target variable (Total Guest count) information. I have to predict the target variable based on the test set

The goal is to make the appropriate model using training data set and then predict the guest count at additional restaurants given in test data (70 restaurants) set using this model and finally to make recommendations to improve footfall

Thanks in advance
Last edited: