I need an explanation how to get the formulas to resolve each direction attach in my picture my homework is in excel. Thank you

Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF shoppers (1) Home Insert Draw Page Layout Formulas Data Review View Times New Roman v 12 A A E E ab v General Conditional Form Format as Table Paste B I UV Y 27 v $ ~ % " Cell Styles * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. H2 4 X V fx A B D E F G H K Customer Day Browser Time (min) Pages Viewed Amount Spent ($) time interval time bins time frecuency time % frequ W N Mon Internet Explorer 12.0 4 54.52 N Wed Other 19.5 6 94.90 Mon Internet Explorer 8.5 4 26.68 Tue Firefox 11.4 2 44.73 6 Wed Internet Explorer 11.3 66.27 Sat Firefox 10.5 67.80 Sun Internet Explorer 11.4 IWON 36.04 8 Fri Firefox 4.3 55.96 10 9 Wed Firefox 12.7 70.94 11 10 Tue Internet Explorer 24.7 68.73 12 11 Sat Other 13.3 54.04 13 12 Sun Firefox 14.3 48.05 14 13 Sun Other 11.7 64.16 15 14 Mon Firefox 24.4 10 158.51 16 15 Fri Internet Explorer 8.4 3 84.12 17 16 Thu Internet Explorer 9.6 59.20 18 17 Thu Internet Explorer 23.3 91.62 19 18 Mon Internet Explorer 14.0 126.40 20 19 Fri Other 5.6 68.45 21 20 Wed Internet Explorer 15.1 32.69 21 Sat Firefox 16.3 78.58 22 22 Tue Internet Explorer 10.2 74.43 24 Internet Explorer 8.0 32.73 Sun 25 23 24 Firefox 48.66 Tue 8.0 54.66 26 25 Fri Firefox 9.6 40.54 27 28 26 Wed Internet Explorer 11.0 27 Sat Internet Explorer 16.9 34.69 29 Firefox 6.0 27.91 28 Sat 155.30 30 29 Fri Firefox 32.9 O J A UI N W N W a U U A 120.25 31 30 Mon Other 11.8 Data Sheet1 + Workbook Statistics 18,140 4 20 F6 F7 esc F2 F3 F4 F5 F1Help shoppers (1) Chap X Micro X Mind X Excel X C Micro X Mind x Mind X . Ceng x Mind x Mind instructure.com/courses/15064/assignments/287884?module_item_id=523927 Le Quiz: PHS 111-WO... YouTube 9 Maps M Gmail SAM SAM - launchAssi.. Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago the company developed a website and began selling its products over the Internet. Website sales have exceeded the company's expectations, and management is now considering strategies to increase sales even further. To learn more about the website customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month's sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the website, the number of website pages viewed, and the amount spent by each of the 50 customers are contained in the file named Shoppers. Heavenly Chocolates would like to use the sample data to determine if online shoppers who spend more time and view more pages also spend more money during their visit to the website. The company would also like to investigate the effect Online that the day of the week and the type of browser have on sales. 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 pages 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 week. 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. 8,149 9 W 4 DII DD 20 868 F9 F3 F5 F6 F8 F 10 F4 F7 & @ % 8 O 3 4 5 6 2 T O P W E RHistory Bookmarks People Tab Window Help shoppers (1) hap x Micro X Mind x Excel X & Micro x Mind x Mind x Ceng x Mind x| Mind ucture.com/courses/15064/assignments/287884?module_item_id=523927 Quiz: PHS 171-WO. YouTube Maps M Gmail SAM SAM - launchAssi... 1. Graphical and numerical summaries for the length of time the shopper spends on the website, the number of pages 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 week. 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 Case studies submitted past the deadline are subject to a 10% penalty per day, up to a maximum of 50%. Next Previous 9 149 4 DII DD F10 F8 F9 20 F7 F 4 F5 F6 F3 & X- O 6