Hello I am needing help with Web Usage Mining on excel. I am mainly needing to know what functions I am needing to use and how the functions look like

AutoSave OFF Web Traffic Analysis Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments LE Share Calibri (Body) v 11 AA ab Wrap Text v General Ex AP - O. Paste BIUVV MA V Merge & Center v Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. Restart Now COUNTIES 4 X V fx =COUNTIFs($B$3:$B$9042,b2, Documentation!E17:|18) A B D E G H K L M N O P Q R S T U V w X Y Z AA This workbook has five sheets of data collected from a site with just four pages. The pages are as follows: JOVI AWN Home Page: When a user enters the site for the first time, the user can only land on the Home Page as a first page. Search Page: From the Home Page, the user can perform a search on the Search Page. Payment Page: From the Search Page, if the user clicks on a product, the user will get to the Payment 6 00 Page, where he or she is asked to provide payment information in order to buy that product. Confirmation Page: If the user decides to buy, he or she ends up on the Confirmation Page The company CEO isn't very happy with the volume of sales and, especially, of sales coming from new 12 users. Therefore, she asks you to investigate whether there is something wrong in the conversion 13 funnel or, in general, if you could suggest how conversion rate can be improved. 15 Read the directions on each page to complete the assignment. 16 18 Source: https://www.kaggle.com/aerodinamicc/ecommerce-website-funnel-analysis 19 20 23 24 25 26 27 28 29 36 37 38 39 40 41 42 Documentation Home Page Search Page Payment Page Confirmation Page Users + Point Accessibility: Investigate + 100%AutoSave OFF A A FOG... Web Traffic Analysis Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments LE Share Calibri (Body) v 11 AA ab Wrap Text v General LIX V Sort & Analyze Paste BIUVV MA V Merge & Center v $ ~ % 9 408 28 Conditional Format Cell Insert Delete Format Find & Formatting as Table Styles Filter Select Data Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. Restart Now COUNTIES 4 X V fx =COUNTIFs($B$3:$B$9042, b2, Documentation!E17:|18+'Home Page'!) C D E F G H I K L M N 0 P Q R S T U V W X Y Z AA A B User ID Page Accessed home page 17 |home_page Page"!) 28 home_page The real bounce rate is defined as the percentage of visits with a single pageview. Since visitors to this site always land on the Home 37 home_page Page before accessing any other pages, you can determine bounce 38 home_page rate by finding the difference between the total number of hits on 55 home_page the Home Page and total the number of hits on the Search Page. 10 00 72 home_page 112 home_page Remember to place all your formulas in a prominent location, even 10 136 home_page if that means moving this text box, and to label your results 139 home_page appropriately 158 home_page 198 home_page 1. Start by creating a formula that counts the total number of users who accessed the Home Page. 210 home_page 2. Create a formula in Column D for each user that indicates 212 home_page whether of not the user accessed the Search Page. You will need to 214 home_page use a combination of the IF, ISNA and MATCH functions. When 228 home_page there is a match between a user on the Home Page and one on the 18 239 home_page Search Page, the formula should display a 1, otherwise a 0. 19 242 home_page 3. Once you know which users proceeded to the Search Page, in 20 257 home_page other words, didn't bounce off the Home Page, create a formula to 261 home_page count the number of these users. 22 265 home_page 4. Finally, create a formula to calculate the percentage of users that DID NOT proceed to the Search Page. 23 270 home_page 24 278 home_page 25 290 home_page 26 294 home_page 27 303 home_page 28 307 home_page 29 317 home_page 30 348 home_page 31 365 home_page 32 389 home_page 33 395 home_page 34 396 home_page 35 401 home_page 36 411 home_page 37 430 home_page 38 432 home_page 39 454 home_page 40 455 home_page 41 459 home_page 42 470 home page Documentation Home Page Search Page Payment Page Confirmation Page Users + Accessibility: Investigate + 100% Point