Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What % of restaurants are rated very good or better and have average wait time under 10 minutes? State answer with 1 decimal digit and

  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%).?
imageimageimage

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)

Step by Step Solution

3.44 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elements Of Chemical Reaction Engineering

Authors: H. Fogler

6th Edition

013548622X, 978-0135486221

More Books

Students also viewed these Finance questions

Question

CL I P COL Astro- L(1-cas0) Lsing *A=2 L sin(0/2)

Answered: 1 week ago