Case

Question 1:

| Time(min) | Pages Viewed | Amount Spent($) |

Total | 640.5 | 241 | 3406.41 |

Mean | 12.8 | 4.82 | 68.13 |

Median | 11.4 | 4.5 | 62.15 |

Max | 32.9 | 10 | 158.51 |

Min | 4.3 | 2 | 17.84 |

Range | 28.6 | 8 | 140.67 |

Mode | 9.6 | 4 | #N/A |

Variance | 36.76 | 4.15 | 1046.12 |

Standard Deviation | 6.06 | 2.04 | 32.34 |

Q1 | 8.48 | 3 | 43.85 |

Q2 | 11.4 | 4.5 | 62.15 |

Q3 | 15.3 | 6 | 84.13 |

* According to the statistics, the length of time the shoppers spend on the website range from the minimum time of 4.3minutes to the maximum time of 32.9 minutes while the average time a shopper spends is 12.8 minutes.

* This indicates that the time spent on the website shows an uneven distribution. To be specific, shoppers tend to spend less than 20 minutes on the website, which can be seen from the graph.

* Regarding the average number of pages viewed by a shopper, it is 4.8 pages while the median number is 4.5 pages.

* The difference between the minimum and maximum is only 8 pages, which suggests that most shoppers are inclined to visit about 5 pages.

* The costumers only open 4.5 on average and 40% of the costumers or 20 out of 50 transaction open 5 pages. The least page the costumers open is 3 pages, which is 26% of the recorded transactions.

* From the histogram, the frequency of 4 to 5 account for a large proportion.

* The average amount a shopper spends is $68.13. The range is $140.67 with a minimum amount of $17.84 and the maximum of $158.51.

* he most frequent transaction spent 72 dollars with the recorded of 13 out of 50 transactions.

* The histogram of amount shows that the statistics tend to distribute on the right.

* It indicates that people are unwilling to spend too much on it so the company can make a strategy to control the cost.

Question 2:

Day | Frequency | Total Amount | Mean Amount |

Mon | 9 | 813.38 | 90.38 |

Tue | 7 | 414.86 | 59.27 |

Wed | 6 | 341.82 |...