Reference no: EM13832799
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
|
How has level and direction of fdi changed over the past
: How has the level and direction of FDI changed over the past two to three decades overall, and in terms of annual outflows and inflows? Why is this information relevant to managers today? Provide examples in your discussionNAFTA was approved by the U..
|
|
What is the net book value of the store equipment
: Stockholders' Equity: Contributed Capital and Retained Earnings. What is the net book value of the store equipment. Explain what this value means.
|
|
Price elasticity of market demand for retail gasoline
: Suppose the own price elasticity of market demand for retail gasoline is -0.6, the Rothschild index is 0.4, and a typical gasoline retailer enjoys sales of $1,800,000 annually. What is the price elasticity of demand for a representative gasoline reta..
|
|
The credit policy of spurling products
: The credit policy of Spurling Products is "1.5/10, net 35." At present 30% of the customers take the discount, 62% pay within the net period, and the rest pay within 45 days of invoice. What would receivables be if all customers took the cash discoun..
|
|
Analyze the relationship presented in the scenario
: Analyze the relationship presented in the scenario above and present your results - what is the magnitude of impact of online search time on total time spent to search offline.
|
|
What was the amount he withdrew at the end of eighth year
: Mr. Smith has saved $ 1200 each year for 25 years. A year after the saving period ended, Mr. Smith withdrew $ 4500 each year for a period of 5 years. In the sixth and seventh year, he only withdrew $ 3000 pre year. In the eighth year, he decided to w..
|
|
What is the usage in units
: If EOQ = 360 units, order costs are $5 per order, and carrying costs are $.20 per unit, what is the usage in units?
|
|
Prepare an analysis of pizza huts social media presence
: Students are required to prepare a research report of approximately 2000 words. Students are required to select from a list of organisations and prepare an analysis of the organisation's social media presence and strategy.
|
|
Compliance and risk management
: Planning the AML/CTF program involves an understanding of both compliance and risk management. Compliance is about meeting obligations which in this case are mandated by the AML/CTF Act. Risk management involves: a. the identification of different ..
|