Compute descriptive statistics for time pages viewed and


Use the "Shoppers" Excel file. Answer the following questions:

(1) Compute descriptive statistics for TIME, PAGES VIEWED, and AMOUNT SPENT [Hint: Use the DATA ANALYSIS tool in Excel; choose DESCRIPTIVE STATISTICS; in the Input Range, enter D1:F51 - Excel will compute desstats for the three variables simultaneously.]

(2) Compute the correlation coefficients among the three variables [Hint: Use the DATA ANALYSIS tool in Excel; choose CORRELATION; in the Input Range, enter D1:F51 - Excel will compute correlation coefficients for the three variables simultaneously.].

(3) Using the Excel results, summarize the data and comment on your findings. Carefully interpret the correlation coefficients.

Attachment:- Shoppers_Excel.xlsx

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Compute descriptive statistics for time pages viewed and
Reference No:- TGS01146454

Now Priced at $30 (50% Discount)

Recommended (92%)

Rated (4.4/5)