A restaurant has a large table that seats a party of ten. Each person places an order of a main dish, a side order (except if a vegetarian dish is ordered), and a salad. Forty percent of people order beef, thirty percent order chicken, twenty percent order seafood, and the rest order vegetarian. Choices for a side include a veggie (25%), baked potato (34%), mashed potatoes (20%), or rice (21%). Sixty-five percent of people order the House salad as opposed to the Caesar salad. Each person tips between $1 to $4 (equally likely). Simulate a table of ten with each person’s complete order and tip. Find the total tip left at the table. Replicate this value 300 times and calculate the probability of the waitress making a tip larger than $25. please show excel functions
A restaurant has a large table that seats a party of ten. Each person places an order of a main dish, a side order (except if a vegetarian dish is ordered), and a salad. Forty percent of people order beef, thirty percent order chicken, twenty percent order seafood, and the rest order vegetarian. Choices for a side include a veggie (25%), baked potato (34%), mashed potatoes (20%), or rice (21%). Sixty-five percent of people order the House salad as opposed to the Caesar salad. Each person tips between $1 to $4 (equally likely). Simulate a table of ten with each person’s complete order and tip. Find the total tip left at the table. Replicate this value 300 times and calculate the probability of the waitress making a tip larger than $25. please show excel functions
A restaurant has a large table that seats a party of ten. Each person places an order of a main dish, a side order (except if a vegetarian dish is ordered), and a salad. Forty percent of people order beef, thirty percent order chicken, twenty percent order seafood, and the rest order vegetarian. Choices for a side include a veggie (25%), baked potato (34%), mashed potatoes (20%), or rice (21%). Sixty-five percent of people order the House salad as opposed to the Caesar salad. Each person tips between $1 to $4 (equally likely). Simulate a table of ten with each person’s complete order and tip. Find the total tip left at the table. Replicate this value 300 times and calculate the probability of the waitress making a tip larger than $25. please show excel functions
A restaurant has a large table that seats a party of ten. Each person places an order of a main dish, a side order (except if a vegetarian dish is ordered), and a salad. Forty percent of people order beef, thirty percent order chicken, twenty percent order seafood, and the rest order vegetarian. Choices for a side include a veggie (25%), baked potato (34%), mashed potatoes (20%), or rice (21%). Sixty-five percent of people order the House salad as opposed to the Caesar salad. Each person tips between $1 to $4 (equally likely). Simulate a table of ten with each person’s complete order and tip. Find the total tip left at the table. Replicate this value 300 times and calculate the probability of the waitress making a tip larger than $25.
please show excel functions
Expression, rule, or law that gives the relationship between an independent variable and dependent variable. Some important types of functions are injective function, surjective function, polynomial function, and inverse function.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
