Question for Data Analyst

[96asiah]

I would like to ask few questions. I have a set of data set and how do I find this using excel. 

1. How long is the second purchase from the first?
2. How often do customers return?
3. What’s the average time between purchases?
4. Suggested metrics to track based on the Part 1 Analysis

Please give me an idea. Thank you

[Reeza]

Are you trying to do your work in Excel or SAS?

A CSV file is a "comma separated value" file, stored in a text format and is not an Excel file.

[96asiah]

Hi,
The data is in excel. I already transfer it to sas and planning to do the analysis in SAS

[PaigeMiller]

---

@96asiah wrote:

I have a set of data set and how do I find this using excel. 

---

Did you mean to say "How do I find this using SAS"?

[96asiah]

Hi,
Yes. I have a set of the data as you can see in the attachment. I want to make it visualise and find the answer