Answered step by step
Verified Expert Solution
Question
1 Approved Answer
begin{tabular}{|c|c|c|c|} hline & A & B & C hline & & & Meal 1 & Restaurant & Quality Rating & Price ($)
\begin{tabular}{|c|c|c|c|} \hline & A & B & C \\ \hline & & & Meal \\ 1 & Restaurant & Quality Rating & Price (\$) \\ \hline 2 & 1 & Good & 18 \\ \hline 3 & 2 & Very Good & 22 \\ \hline 4 & 3 & Good & 28 \\ \hline 5 & 4 & Excellent & 28 \\ \hline 6 & 5 & Very Good & 38 \\ \hline 7 & 6 & Good & 33 \\ \hline 8 & 7 & Very Good & 28 \\ \hline 9 & 8 & Very Good & 19 \\ \hline 10 & 9 & Very Good & 11 \\ \hline 11 & 10 & Good & 23 \\ \hline \end{tabular} Which of the following functions can be used to count how many restaurants are between rows 12 and 153 (including 12 and 153)? =countif(B12:B153,"VeryGood")=counta(C12:C153)=counta(B12:B153)=count(A12:A153)=countif(A12:A153)=count(B12:B153) Question 18 1 pts Suppose we wanted to put a running total of the meal prices in column E of the spreadsheet. So the value in E2 would be 18, the value in E3 would be 40 (18+22), the value in E4 would be 68(18+22+28), etc. We want to enter one formula in cell E2 and then copy (or autofill) that formula down to all of the rest of the cells in column E. What would the formula in cell E2 be? =sum(C2:$C2)=sum($C$2:$C$2)=sum($C2:C2)=sum(C$2:C$2)=sum($C$2:C2) Refer to the context of the previous question. No matter what your answer to the previous question, suppose that the formula entered in cell E2 is = Sum(C2:C2). If you were to insert a new column in front of column E (so that column E is now blank), what formula would be in cell F2? =sum(C3:C3) It will be blank (no formula will be there). =sum(D2:D2) =sum(C2:C2) It will just have a number (18) and no formula. Question 20 1 pts Use conditional formatting to find the top (highest) 5% of wait times. How many wait times are highlighted? (I won't make you answer it, but why do you think the answer is not just 5%300=15 ?) Question 21 1 pts If the data set represents a random sample of restaurants, what do you estimate the probability to be that a restaurant has a "Good" rating? Enter your answer to 2 decimal places
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started