Please help me with this I need formulas because I'm working with excel spread sheet. Thanks

11:57 6 d d . 1 2020-09-04 23-4... . . . Managerial Report Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates website Include the following in your report. 1. Graphical and numerical summaries for the length of time the shopper spends on the website, the number of pa viewed, and the mean amount spent per transaction. Discuss what you learn about Heavenly Chocolates' online shoppers from these numerical summaries. 2. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of wee What observations can you make about Heavenly Chocolates' business based on the day of the week? Discuss. 3. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. What observations can you make about Heavenly Chocolate's business based on the type of browser? Discuss. 4. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between the time spent on the website and the dollar amount spent. Use the horizontal axis for the time spent on the website. Discuss. 5. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between the number of website pages viewed and the amount spent. Use the horizontal axis for the number of website pages viewed. Discuss. 6. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between the time spent on the website and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss. shoppers.xisx C Case studies submitted past the deadline are subject to a 10% penalty per day, up to a maximum of 50%. O