Due to increasing use of Internet, Capecari consulting has collected a sample of consumer search data on used cars from North American used car markets. The data consists of information about customer id (column ‘panid'), number of used cars owned in the past (column ‘EUC'), gender, number of models considered by consumer (column 3 ‘NOMODEL'), total time spent online to search (units in hours) for used cars and total time spent offline to search for used cars (unit in hours).

a.) Capecari expects that number of used cars owned in past, gender, number of models considered by a consumer and total time spent in online search influence the total time spent in offline search. Analyze this expected relationship using a suitable technique and answer the following:

i. List the variables that significantly influence offline search. What criteria do you use to identify these variables? Interpret the impact of these variables.

ii. Comment on the goodness of fit of the technique you have used.

b.) Considering prior trends, it is well known that men and women employ different search strategies to search for used cars. It is expected that the effect of online search time on total time spent to search offline depends on the gender of a consumer.

i. Use a suitable technique to analyze the relationship presented in the scenario above and present your results?

ii. Based on your analysis, what is the magnitude of impact of online search time on total time spent to search offline.

Attachment:- caperi.xlsx