A. If a customer is randomly selected from the sample, what is the probability the customer is using Chrome Web browser ?
B. What is the probability a customer is using Firefox web browser, given that the customer is visiting the website on a Friday ?
C. What proportion of customers using Google Chrome spend10 minutes or more on the website ?
D. What proportion of customers in the sample visited the website on Friday and spent more than $50 ?
E. What proportion of customers who visited the website on Friday spent more than $50?
F. What proportion of customers who spent more than $50 visited the website on Friday?
*USE EXCEL FORMULAS TO COMPUTE ANSWER
AutoSave OFF Q AF ? C ... Online MBA HeavenlyChocolates Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman 12 AA D Wrap Text v General Insert v x Delete Paste BIUV A Merge & Center v v % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format Q v Filter Select Data 141 X V fx B D E G H K M N O P Q1. Part 1 Select a Random Sample of 45 rows from the dataset to use for this assignment Q1. Part 2 Respond to the following questions about the dataset and variables W N - Customer Day Browser Time (min) Pages Viewed Amount Spent ($) A How many variables does this dataset have ? 300 Values Mon Chrome 12.0 54.52 Wed Other 19.5 94.90 B How many observations does the complete dataset have ? 50 Observations Mon Chrome 8.5 26.68 Tue Firefox 11.4 44.73 How many observations does your random sample have ? 45 Observations Wed Chrome 11.3 66.27 NANGANA Sat Firefox 105 67.80 c Variable Types Sun Chrome 11.4 36.04 Fri Firefox 4.3 55.96 Day Categorical Wed Firefox 12.7 70.94 Tue Chrome 24.7 68.73 Browser Categorical Sat Other 13.3 54.04 Sun Firefox 14.3 18.05 Time (min) Quantitative Sun Other 11.7 64.16 Mon Firefox 24.4 158.51 Pages Viewed Quantitative 15 JAWS VU Fri Chrome 8.4 34.12 16 Thu Chrome 9.6 9.20 Amount Spent (S) Quantitative 17 Thu Chrome 23.3 91.62 18 Mon Chrome 14.0 126-40 Q1. Part 3 Probability Questions Fri Other 5.6 8.45 Wed Chrome 15.1 12.69 If a customer is randomly selected from the sample, what is the Sat Firefox 16.3 78.58 probability the customer is using Chrome Web browser ? Tue Chrome 10.2 74.43 Sun Chrome 8.0 $2.73 B What is the probability a customer is using Firefox web browser, Tue Firefox 8.0 48.66 given that the customer is visiting the website on a Friday ? Fri Firefor 9.6 54.66 Wed Chrome 11.0 10.54 What proportion of customers using Google Chrome spend 10 Sat Chrome 6.9 34.69 minutes or more on the website ? Sat Firefox 6.0 27.91 Fri Firefox 2.9 155.3 What proportion of customers in the sample visited the website on Mon Other 11.8 120.25 Friday and spent more than $50 ? The Chrome 7.1 41.20 Fri Firefox 18.0 134.40 What proportion of customers who visited the website on Friday Sun Chrome 11.8 37.17 spent more than $50 ? ( So from those who visited on Friday, what proportion spent more than Fri Chrome 9.1 52.09 Tue Chrome 7.8 71.81 What proportion of customers who spent more than $50 visited the Mon Firefox 16.5 59.99 website on Friday ? ( So from those who spent more than $50, what proportion visited on 37 Thu Firefox 6.2 84.17 38 Sat Chrome 11.3 55.58 0 39 Tue Chrome 10.6 JAUNAA 39.06 40 Wed Chrome 5.0 36.48 Tue Other 15.9 7.44 Sat Chrome 18.1 60.14 Fri Firefox 10.8 70.38 Mon Chrome 13.3 110.65 Mon Chrome 30.1 104.23 README Data Q1 Q2 Q3 Q4 Q6 + Ready 82%
