i just need the excel part please!

1. Ms. Liu shares her web data with you, which shows that she has an average of 500 daily page views during the weekdays, and an average of 1,200 daily page views on the weekends. Each time someone loads one of her pages, it counts as a page view. If each page viewer peruses an average of two pages per visit on weekdays and three pages per visit on weekends, then how many weekly visits (i.e., the number of users, including repeating visitors that came to her website) does she obtain on weekdays and weekends? B 1 Page Views # of Days Pages/Visit Visits D NaN O 2250 on weekdays, 1200 on weekends O 2000 on weekdays, 1100 on weekends 1250 on weekdays, 800 on weekends O 1750 on weekdays, 1000 on weekends 1500 on weekdays, 900 on weekends 2. Ms. Liu tells you that on each weekday, visitors return to her website an average of twice, and on weekends, visitors return four times per day. She adds that these two groups of users are different. She wants to know how many unique visitors (ie., the number of users who visit the site, regardless of the number of their visits) visit her site on weekdays and weekends. Please note that if a particular visitor comes to the site every day or several times a day, it still counts as only one visit. Unique # of Days of Visits NaN D Visits Visitors 2 O 150 on weekdays, 110 on weekends 125 on weekdays, 100 on weekends O200 on weekdays, 140 on weekends O 175 on weekdays, 120 on weekends O 225 on weekdays, 160 on weekends 3. Ms. Llu wants to add more information to her website about her handicrafts and the origin and location of the minority Chinese groups who make them, but she doesn't know if this is feasible. She thinks that this may depend on the average visit duration that users spend on the site. She asks you to calculate how much time users spend on the site during each visit. Google metrics show that on weekdays, unique visitors spent 12.5 hours on the site and on weekends, unique visitors spent 15 hours on the site. Note: While website owners want users to spend a long time on their site, the average time spent is generally three to five minutes or less. 1 Total Hours Change to Minutes Unique Visitors 60 D Time Spent Each Visit 2 6 minutes on weekdays, 9 minutes on weekends O 15 minutes on weekdays, 12 minutes on weekends 9 minutes on weekdays, 10 minutes on weekends 18 minutes on weekdays, 14 minutes on weekends O 12 minutes on weekdays, 11 minutes on weekends 4. Not all of the unique visitors are real shoppers, and 55 percent of them "bounce" off of the page. A bouncer is someone who visits the site and elther decides that he or she is in the wrong place, or feels that he or she is experiencing "surf shock" and leaves. Ms. Llu wants to know the number of real potential shoppers who visit the site on weekdays and on weekends. B c Unique % of Real # of Real Visitors Shoppers Shoppers 1 2 56 on weekdays, 45 on weekends 73 on weekdays, 65 on weekends 0 60 on weekdays, 50 on weekends 69 on weekdays, 55 on weekends 64 on weekdays, 55 on weekends 5. Ms. Liu wants to focus on building a consumer base and is seeking repeat customers. She is less interested in newcomers to the site. Google metrics show that the percentage of first-time users is 20 percent. What is the number of repeat customers on weekdays and on weekends? 1 Unique Visitors % of Repeat Customers of Repeat Customers 2 100 on weekdays, 80 on weekends O 150 on weekdays, 90 on weekends O 250 on weekdays, 110 on weekends 300 on weekdays, 120 on weekends 25 on weekdays, 20 on weekends