Question

erk Technical College :: Lo... ® 1.4 Histograms and Freq.. Homepage - Probability & St... Google York Technical College Probability & Statistics - Sectio... 000 000 Course Home Start Here Assignments Communicate Progress M < 1.4 Histograms and Frequency Tables with Technology - Excel An employee at a pizza restaurant asks 20 randomly selected people to name their favorite pizza topping. The responses are below. Favorite Pizza Topping Pepperoni None Sausage Sausage Mushrooms Onions Peppers Sausage Pepperoni Copy to clipboard O Help Download CSV Use Excel to create a relative frequency distribution for the data. What is the relative frequency of a person whose favorite topping is sausage? Provide your answer below: <

Answer 1

C3 Relative Frequency of Favourite Pizza Topping A B D E F PivotTable Fields X ACTIVE ALL Choose fields to add to report: Search 2 3 Row Labels 4 Mushrooms 5 None 6 Onions 7 Pepperoni 8 Peppers 9 Sausage 10 Grand Total 11 12 13 Count of Favourite Pizza Topping Relative Frequency of Favourite Pizza Topping 1 0.11 1 0.11 1 0.11 2 0.22 1 0.11 Range ✓ Favourite Pizza Topping 3 0.33 9 1.00 14 Drag fields between areas below: Y FILTERS III COLUMNS Σ Values 15 16 17 18 19 20 21 22 23 24 25 ROWS E VALUES Favourite Pizza Topping Count of Favourite Pizza Topping Relative Frequency of Favourite ... 26

Relative Frequency of Sausage is .33.