Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MUST USE EXCEL AND WRITE DOWN THE STEPS IN FINDING, AND PASTE THE excel functions, here is the data set, the google spreadsheet link, i

MUST USE EXCEL AND WRITE DOWN THE STEPS IN FINDING, AND PASTE THE excel functions, here is the data set, the google spreadsheet link, i dont know how to prepare the two way table

https://docs.google.com/spreadsheets/d/1xYVei7P6GmHNWAIV9T507YBiXjQ07vixNa3iXczdtr8/edit?usp=sharing

image text in transcribed
1. Refer to the Restaurants dataset. The dataset captures information on 300 restaurants and their quality rating and meal price (in dollars). Answer the following questions: (a) The intention here is to cross tabulate Quality Rating (Good, Very Good, Excellent) and Meal Price (4 categories: Under $20, $20 to under $30, $30 to under $40, $40 and over). In other words, use Excel's Pivot Table to create a 2-way table with Quality Rating and Meal Price as the two categorical variables. Your table must show the marginal counts as well. [Explanation: Marginal counts are the totals on the margin (also called marginal distribution). In a 2-way table, you can add up the totals for each row and columns. Those totals are called marginal counts.] (b) What percentage of meals under $20 are classified as Very Good? (c) What percentage of Excellent restaurants have meals under $20? (d) Using your values in part (a), create a side-by-side bar chart for the restaurant data with meal price on the horizontal axis and the count of restaurant on the vertical axis

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Mathematical Applications For The Management, Life And Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

12th Edition

978-1337625340

More Books

Students also viewed these Mathematics questions

Question

=+a. (**) Suppose Gibsons workers take 4 hours to replace a fender.

Answered: 1 week ago