A simple random sample of 220 university students were asked what pasta they usually order and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A simple random sample of 220 university students were asked what pasta they usually order and with which sauce. The preferences of these respondents are summarised below: Sauce Bolognese Pasta Spaghetti Gnocchi Carbonara Pesto Total 32 25 11 68 38 26 24 88 Ravioli 18 23 23 64 Total 88 74 58 220 (a) Use Excel to obtain a 100% stacked column chart for the data from the table. What does your chart suggest between the relationship between Pasta and Sauce? EXCEL Instructions: Refer to Topic 6 in the Excel Booklet for instructions on how to obtain 100% stacked column chart. (b) Use the contingency table to calculate the following probabilities; include an appropriate probability statement for each case: i. What is the probability that a respondent prefers Spaghetti? ii. What is the probability that a respondent prefers Gnocchi and Carbonara sauce? iii. What is the probability that a respondent prefers Ravioli or Pesto sauce? iv. Suppose the preferred sauce is Bolognese. What then is the probability the pasta ordered is Spaghetti? Suppose that the preferred Pasta is Ravioli. What then is the probability the sauce ordered is Carbonara? V. (c) Are the events Spaghetti and Sauce statistically independent or dependent? How do you know? Show all calculations that support your answer. A simple random sample of 220 university students were asked what pasta they usually order and with which sauce. The preferences of these respondents are summarised below: Sauce Bolognese Pasta Spaghetti Gnocchi Carbonara Pesto Total 32 25 11 68 38 26 24 88 Ravioli 18 23 23 64 Total 88 74 58 220 (a) Use Excel to obtain a 100% stacked column chart for the data from the table. What does your chart suggest between the relationship between Pasta and Sauce? EXCEL Instructions: Refer to Topic 6 in the Excel Booklet for instructions on how to obtain 100% stacked column chart. (b) Use the contingency table to calculate the following probabilities; include an appropriate probability statement for each case: i. What is the probability that a respondent prefers Spaghetti? ii. What is the probability that a respondent prefers Gnocchi and Carbonara sauce? iii. What is the probability that a respondent prefers Ravioli or Pesto sauce? iv. Suppose the preferred sauce is Bolognese. What then is the probability the pasta ordered is Spaghetti? Suppose that the preferred Pasta is Ravioli. What then is the probability the sauce ordered is Carbonara? V. (c) Are the events Spaghetti and Sauce statistically independent or dependent? How do you know? Show all calculations that support your answer.
Expert Answer:
Answer rating: 100% (QA)
Link for 100 stacked column chart is also being attached here httpsdrivegoog... View the full answer
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
A market researcher selects a simple random sample of n = 100 Twitter users from a population of over 100 million Twitter registered users. After analyzing the sample, she states that she has 95%...
-
Data set: ChiSq a. Take a simple random sample of size n = 40 from the ChiSq data. Create a bootstrap distribution of the median by taking 1000 resamples (with replacement). Describe the shape of the...
-
A market researcher selects a simple random sample of n = 100 Twitter users from a population of over 100 million Twitter registered users. After analyzing the sample, she states that she has 95%...
-
Below are three independent and unrelated errors. a. On December 31, 2020, Wolfe-Bache Corporation failed to accrue salaries expense of $1,800. In January 2021, when it paid employees for the...
-
A financial analyst has computed both accounting and NPV breakeven sales levels for a project using straight-line depreciation over a 6-year period. The project manager wants to know what will happen...
-
A rocket-engine nozzle is coated with a ceramic material having the following properties: k = 1.73 Btu/h ft F, = 0.35 ft 2 /h. The convective heat-transfer coefficient between the nozzle and the...
-
Five projects form the mutually exclusive, collectively exhaustive set under consideration. The cash flow profiles for the five projects are given in the table below. Information on each project was...
-
On January 1, 2014, Geffrey Corporation had the following stockholders equity accounts. Common Stock ($20 par value, 60,000 shares issued and outstanding) ......$1,200,000 Paid-in Capital in Excess...
-
23 Consider the following Java code: What will be printed when the following code is executed: new Cat().eat(); ? public class Animal ( } public void eat () { System.out.println("Animal is eating");...
-
Padini Concept Stores is a chain of clothing stores that caters to young adults. It publishes a quarterly catalog and operates a website that features attractively attired young males and females...
-
As a seller, how do you think price transparency affects your ability to obtain as high a price as possible for used products you auction through eBay?
-
Identify each of the labeled points ( indicated with letters ) or changes ( indicated with two letters separated 1 . The transition shown by the line from D to C is Blank. 2 . The transition shown by...
-
Calculation and Journal Entry for Employer Payroll Taxes Portions of the payroll register for La Panaderia for the week ended July 15 are shown below. The SUTA tax rate is 5.4%, and the FLUTA tax...
-
4. You are offered term life insurance by your employer. That means, if you die before you retire your family will receive $100.000. You have a safe profession so the chance of death before age 62 is...
-
At inception, the swap rate on a plain vanilla $100m interest rate swap was set at sp= 6% pa (simple rate). The previous reset date was 15th January when the 6-month LIBOR rate was 5.5% p.a. (simple...
-
Using quantitative reasoning decide what effect (increase, decrease or remain unchanged) the following situations would have on the outcome for the observed temperature at which crystallization...
-
1. One lb of water in a piston-cylinder assembly, initially a saturated liquid at 1 atm, undergoes a constant-pressure, internally reversible expansion to x = 90%. Determine the work and heat...
-
In Exercises discuss the continuity of each function. f(x) -3 1 x - 4 y 3 2 -1 -2 -3+ 3 X
-
The Wechsler Adult Intelligence Scale measures IQ scores with a test designed so that the mean is 100 and the standard deviation is 15. Consider the group of IQ scores that are unusual. What are the...
-
A study was conducted of 531 persons injured in bicycle crashes, and randomly selected sample results are summarized in the accompanying table. The TI-83/84 Plus calculator results also are shown. At...
-
The table lists the distance d (meters) above the ground for an object dropped in a vacuum from a height of 300 m. The time t (in sec) is the time after the object has been released. Construct a...
-
A researcher measured heart rate \((x)\) and oxygen uptake \((y)\) for one person under varying exercise conditions. He wishes to determine if heart rate, which is easier to measure, can be used to...
-
A researcher is investigating the relationship between yield of potatoes \((y)\) and level of fertilizer \((x\).\() She divides a eld into eight plots of equal\) size and applied fertilizer at a di...
-
The Police Department is interested in determining the e ect of alcohol consumption on driving performance. Twelve male drivers of similar weight, age, and driving experience were randomly assigned...
Study smarter with the SolutionInn App