1. What % of restaurants are rated very good or better and have average wait time under 10 minutes? State answer with 1 decimal digit and without the % sign (for example, 12.3, not 12.3%)
2. Given that a restaurant is rated "very good," what is the probability the average price at this restaurant is at least $30? Give the decimal number rounded to 3 decimal digits (for example, 0.123, not 12.3%).?

Transcribed Image Text:

Quality Rating Average of Wait Time (min) Average of Meal Price ($) Count of Restaurant Count of Restaurant2 Good Very Good Excellent Grand Total 2.5 12.3 32.1 13.9 $19.73 84 28% $25.63 150 50% $34.35 66 22% $25.90 300 100% External Data Connections have bee Rows: Quality Rating Values: Wait Time (min) Right-click (Ctrl-click) anywhere on any of the data values in the pivot table to get the shortcut menu Shortcut menu: Summarize Values by: Average Shortcut menu: Number Format... Click on Number then Select 1 for Decimal Places, OK (Note: Do not use Format Cells) Values: Meal Price Summarize Values by: Average Number Format... select Currency Values: Restaurant (or any other field) Summarize Values by: Count Value: Restaurant (can choose any field) Summarize Value by: Count Show Value as: % of Grand Total Go to Number Format to show 0 decimal digit Note: Numeric field: Default summary is Sum Non-numeric (text) field: Default summary is Count. To get a count of rows satisfying some criterion, drag any non- numeric field into Values area. (But if you chose a numeric field, just change summary to Count.) To move Excellent row to the bottom Right-click on Excellent Select Move and click Move "Excellent" to End (or hover around the border of the Excellent cell to get a "move" cursor - cross with arrows or hand - then drag) To Change "Row Labels" to the appropriate field name: Design tab > Report Layout > Choose Outline Form or Tabular Form (Or just type over it) Quality Rating Average of Wait Time (min) Average of Meal Price ($) Count of Restaurant Count of Restaurant2 Good Very Good Excellent Grand Total 2.5 12.3 32.1 13.9 $19.73 84 28% $25.63 150 50% $34.35 66 22% $25.90 300 100% External Data Connections have bee Rows: Quality Rating Values: Wait Time (min) Right-click (Ctrl-click) anywhere on any of the data values in the pivot table to get the shortcut menu Shortcut menu: Summarize Values by: Average Shortcut menu: Number Format... Click on Number then Select 1 for Decimal Places, OK (Note: Do not use Format Cells) Values: Meal Price Summarize Values by: Average Number Format... select Currency Values: Restaurant (or any other field) Summarize Values by: Count Value: Restaurant (can choose any field) Summarize Value by: Count Show Value as: % of Grand Total Go to Number Format to show 0 decimal digit Note: Numeric field: Default summary is Sum Non-numeric (text) field: Default summary is Count. To get a count of rows satisfying some criterion, drag any non- numeric field into Values area. (But if you chose a numeric field, just change summary to Count.) To move Excellent row to the bottom Right-click on Excellent Select Move and click Move "Excellent" to End (or hover around the border of the Excellent cell to get a "move" cursor - cross with arrows or hand - then drag) To Change "Row Labels" to the appropriate field name: Design tab > Report Layout > Choose Outline Form or Tabular Form (Or just type over it)

Answer rating: 100% (QA)

Detailed Explanation Answer 1 To find the percentage of restaurants that are rated very good or better and have an average wait time under 10 minutes ... View the full answer