Modern Business Statistics with Microsoft Excel (MindTap Course List)
5th Edition
ISBN: 9781285433301
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 7, Problem 38SE
a.
To determine
Draw a random sample of 5 restaurants for Person B.
a.
Expert Solution
Answer to Problem 38SE
The random sample of 5 restaurants for Person B is tabulated below:
| Restaurant |
Random Number |
| Thoroughbreds | 0.012825 |
| The Marker | 0.020815 |
| Officers Club | 0.03058 |
| Sea Blue | 0.062942 |
| Crickets | 0.06914 |
Explanation of Solution
Calculation:
Answers may vary. One of the possible answers is given below:
The given data represent 44 locally owned restaurants.
Step-by-step procedure to obtain a simple random sample:
- Open the data file Dining.
- Sort the random numbers and corresponding company names into ascending order.
- Select the companies associated with the first five smallest random numbers.
Thus, the random sample of 5 restaurants for Person B is tabulated below:
| Restaurant |
Random Number |
| Thoroughbreds | 0.012825 |
| The Marker | 0.020815 |
| Officers Club | 0.03058 |
| Sea Blue | 0.062942 |
| Crickets | 0.06914 |
b.
To determine
Generate a new simple random sample and compare it with the sample in Part (a).
b.
Expert Solution
Answer to Problem 38SE
The random sample of 5 restaurants for Person B is tabulated below:
| Restaurant |
Random Number |
| Caffe Latte | 0.819538 |
| Southern Market | 0.209004 |
| Bubba's Fish Shack | 0.338619 |
| Finn McCools Irish Pub | 0.609635 |
| Flo's Place | 0.699761 |
The random samples in these data set do not match with the random samples of Part (a).
Explanation of Solution
Calculation:
A new simple random sample has to be obtained.
Software procedure:
Step-by-step software procedure to obtain a random sample using EXCEL:
- Open the EXCEL.
- Enter company names in Column A.
- Generate a new set of random numbers using the formula “=RAND()” in Column B.
- Sort the random numbers and corresponding company names into ascending order.
- Select the companies associated with the first five smallest random numbers.
The output obtained using EXCEL software is as follows:
Therefore, the random sample of 5 restaurants for Person B is tabulated below:
| Restaurant |
Random Number |
| Caffe Latte | 0.819538 |
| Southern Market | 0.209004 |
| Bubba's Fish Shack | 0.338619 |
| Finn McCools Irish Pub | 0.609635 |
| Flo's Place | 0.699761 |
Here, it is observed that the restaurants in new random samples do not match with the restaurants in the random sample of Part (a).
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Stem1: 1,4
Stem 2: 2,4,8
Stem3: 2,4
Stem4: 0,1,6,8
Stem5: 0,1,2,3,9
Stem 6: 2,2
What’s the Min,Q1, Med,Q3,Max?
Are the t-statistics here greater than 1.96? What do you conclude?
colgPA= 1.39+0.412 hsGPA
(.33) (0.094)
Find the P value
A poll before the elections showed that in a given sample 79% of people vote for candidate C. How many people should be interviewed so that the pollsters can be 99% sure that from 75% to 83% of the population will vote for candidate C? Round your answer to the whole number.
Chapter 7 Solutions
Modern Business Statistics with Microsoft Excel (MindTap Course List)
Ch. 7.2 - Consider a finite population with five elements...Ch. 7.2 - Assume a finite population has 10 elements. Number...Ch. 7.2 - The 2012 American League consists of 14 baseball...Ch. 7.2 - The U.S. Golf Association has instituted a ban on...Ch. 7.2 - In this section we used a two-step procedure to...Ch. 7.2 - 10. Indicate which of the following situations...Ch. 7.3 - 11. The following data are from a simple random...Ch. 7.3 - Prob. 8ECh. 7.3 - Prob. 9ECh. 7.3 - 14. Morningstar publishes ratings data on 1208...
Ch. 7.3 - 15. The National Football League (NFL) polls fans...Ch. 7.3 - Prob. 12ECh. 7.3 - 17. One of the questions in the Pew Internet &...Ch. 7.3 - In this section we showed how a simple random...Ch. 7.5 - 19. A population has a mean of 200 and a standard...Ch. 7.5 - Prob. 16ECh. 7.5 - 21. Suppose a random sample of size 50 is selected...Ch. 7.5 - Refer to the EAI sampling problem. Suppose a...Ch. 7.5 - In the EAI sampling problem (see Figure 7.8), we...Ch. 7.5 - 24. Barron’s reported that the average number of...Ch. 7.5 - Prob. 21ECh. 7.5 - Federal Income Tax Returns. The Wall Street...Ch. 7.5 - 27. The Economic Policy Institute periodically...Ch. 7.5 - State Rainfalls. The state of California has a...Ch. 7.5 - The mean preparation fee H&R Block charged retail...Ch. 7.5 - 30. To estimate the mean age for a population of...Ch. 7.6 - 31. A sample of size 100 is selected from a...Ch. 7.6 - 32. A population proportion is .40. A sample of...Ch. 7.6 - Prob. 29ECh. 7.6 - 34. The population proportion is .30. What is the...Ch. 7.6 - Prob. 31ECh. 7.6 - 36. The Wall Street Journal reported that the age...Ch. 7.6 - Prob. 33ECh. 7.6 - Unnecessary Medical Care. According to Reader’s...Ch. 7.6 - Prob. 35ECh. 7.6 - Prob. 36ECh. 7.6 - 41. The Food Marketing Institute shows that 17% of...Ch. 7 - Prob. 38SECh. 7 - 43. The latest available data showed health...Ch. 7 - 44. Foot Locker uses sales per square foot as a...Ch. 7 - 45. Allegiant Airlines charges a mean base fare of...Ch. 7 - 46. After deducting grants based on need, the...Ch. 7 - Prob. 43SECh. 7 - Prob. 44SECh. 7 - Production Quality Control. A production process...Ch. 7 - Prob. 46SECh. 7 - Prob. 47SECh. 7 - Prob. 48SECh. 7 - Prob. 49SECh. 7 - 54. Lori Jeffrey is a successful sales...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Suppose a random sample of 459 married couples found that 307 had two or more personality preferences in common. In another random sample of 471 married couples, it was found that only 31 had no preferences in common. Let p1 be the population proportion of all married couples who have two or more personality preferences in common. Let p2 be the population proportion of all married couples who have no personality preferences in common. Find a95% confidence interval for . Round your answer to three decimal places.arrow_forwardA history teacher interviewed a random sample of 80 students about their preferences in learning activities outside of school and whether they are considering watching a historical movie at the cinema. 69 answered that they would like to go to the cinema. Let p represent the proportion of students who want to watch a historical movie. Determine the maximal margin of error. Use α = 0.05. Round your answer to three decimal places. arrow_forwardA random sample of medical files is used to estimate the proportion p of all people who have blood type B. If you have no preliminary estimate for p, how many medical files should you include in a random sample in order to be 99% sure that the point estimate will be within a distance of 0.07 from p? Round your answer to the next higher whole number.arrow_forward
- A clinical study is designed to assess the average length of hospital stay of patients who underwent surgery. A preliminary study of a random sample of 70 surgery patients’ records showed that the standard deviation of the lengths of stay of all surgery patients is 7.5 days. How large should a sample to estimate the desired mean to within 1 day at 95% confidence? Round your answer to the whole number.arrow_forwardA clinical study is designed to assess the average length of hospital stay of patients who underwent surgery. A preliminary study of a random sample of 70 surgery patients’ records showed that the standard deviation of the lengths of stay of all surgery patients is 7.5 days. How large should a sample to estimate the desired mean to within 1 day at 95% confidence? Round your answer to the whole number.arrow_forwardIn the experiment a sample of subjects is drawn of people who have an elbow surgery. Each of the people included in the sample was interviewed about their health status and measurements were taken before and after surgery. Are the measurements before and after the operation independent or dependent samples?arrow_forward
- iid 1. The CLT provides an approximate sampling distribution for the arithmetic average Ỹ of a random sample Y₁, . . ., Yn f(y). The parameters of the approximate sampling distribution depend on the mean and variance of the underlying random variables (i.e., the population mean and variance). The approximation can be written to emphasize this, using the expec- tation and variance of one of the random variables in the sample instead of the parameters μ, 02: YNEY, · (1 (EY,, varyi n For the following population distributions f, write the approximate distribution of the sample mean. (a) Exponential with rate ẞ: f(y) = ß exp{−ßy} 1 (b) Chi-square with degrees of freedom: f(y) = ( 4 ) 2 y = exp { — ½/ } г( (c) Poisson with rate λ: P(Y = y) = exp(-\} > y! y²arrow_forward2. Let Y₁,……., Y be a random sample with common mean μ and common variance σ². Use the CLT to write an expression approximating the CDF P(Ỹ ≤ x) in terms of µ, σ² and n, and the standard normal CDF Fz(·).arrow_forwardmatharrow_forward
- Compute the median of the following data. 32, 41, 36, 42, 29, 30, 40, 22, 25, 37arrow_forwardTask Description: Read the following case study and answer the questions that follow. Ella is a 9-year-old third-grade student in an inclusive classroom. She has been diagnosed with Emotional and Behavioural Disorder (EBD). She has been struggling academically and socially due to challenges related to self-regulation, impulsivity, and emotional outbursts. Ella's behaviour includes frequent tantrums, defiance toward authority figures, and difficulty forming positive relationships with peers. Despite her challenges, Ella shows an interest in art and creative activities and demonstrates strong verbal skills when calm. Describe 2 strategies that could be implemented that could help Ella regulate her emotions in class (4 marks) Explain 2 strategies that could improve Ella’s social skills (4 marks) Identify 2 accommodations that could be implemented to support Ella academic progress and provide a rationale for your recommendation.(6 marks) Provide a detailed explanation of 2 ways…arrow_forwardQuestion 2: When John started his first job, his first end-of-year salary was $82,500. In the following years, he received salary raises as shown in the following table. Fill the Table: Fill the following table showing his end-of-year salary for each year. I have already provided the end-of-year salaries for the first three years. Calculate the end-of-year salaries for the remaining years using Excel. (If you Excel answer for the top 3 cells is not the same as the one in the following table, your formula / approach is incorrect) (2 points) Geometric Mean of Salary Raises: Calculate the geometric mean of the salary raises using the percentage figures provided in the second column named “% Raise”. (The geometric mean for this calculation should be nearly identical to the arithmetic mean. If your answer deviates significantly from the mean, it's likely incorrect. 2 points) Starting salary % Raise Raise Salary after raise 75000 10% 7500 82500 82500 4% 3300…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Sampling Methods and Bias with Surveys: Crash Course Statistics #10; Author: CrashCourse;https://www.youtube.com/watch?v=Rf-fIpB4D50;License: Standard YouTube License, CC-BY
Statistics: Sampling Methods; Author: Mathispower4u;https://www.youtube.com/watch?v=s6ApdTvgvOs;License: Standard YouTube License, CC-BY