Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
6th Edition
ISBN: 9781337589383
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 7, Problem 42SE
Shadow Stocks. Jack Lawler, a financial analyst, wants to prepare an article on the Shadow Stock portfolio developed by the American Association of Individual Investors (AAII). A list of the 30 companies in the Shadow Stock portfolio is contained in the file ShadowStocks. Jack would like to select a simple random sample of 5 of these companies for an interview concerning management practices.
- a. In the file ShadowStock, companies are listed in column A of an Excel worksheet. In column B we have generated a random number for each of the companies. Use these random numbers to select a simple random sample of 5 of these companies for Jack.
- b. Generate a new set of random numbers and use them to select a new simple random sample. Did you select the same companies?
a.
Expert Solution
To determine
Select a simple random sample of 5 of the given companies using the given random numbers.
Answer to Problem 42SE
The random sample of 5 of the given companies is tabulated below:
| Company |
Random Number |
| Company LA | 0.008012 |
| Company AO | 0.055369 |
| Company OS | 0.059279 |
| Company KI | 0.144127 |
| Company IS | 0.227759 |
Explanation of Solution
Calculation:
The given data represent the Shadow Stock of 30 companies.
Step-by-step procedure to obtain a simple random sample.
- Open the data file Shadow Stocks.
- Sort the random numbers and the corresponding company names into an ascending order.
- Select the companies associated with the first five smallest random numbers.
Thus, the random sample of 5 of the given companies is tabulated below:
| Company |
Random Number |
| Company LA | 0.008012 |
| Company AO | 0.055369 |
| Company OS | 0.059279 |
| Company KI | 0.144127 |
| Company IS | 0.227759 |
b.
Expert Solution
To determine
Generate a new random set of random numbers and select a new simple random sample.
Check whether the companies in the new simple random sample are the same as in Part (a).
Answer to Problem 42SE
The new simple random sample of the given companies is as follows:
| Company |
Random Number |
| Five Star Quality Care | 0.018590 |
| SigmaTron International | 0.085862 |
| CSS Industries | 0.097172 |
| REX American Resources Corp | 0.122113 |
| VOXX International Corp | 0.158389 |
The companies in the new random samples do not match with the companies in the random sample of Part (a).
Explanation of Solution
Calculation:
A new simple random sample is to be obtained.
Software procedure:
Step-by-step software procedure to obtain a random sample using EXCEL is given below:
- 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 the corresponding company names into an 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 of the given companies is as follows:
| Company |
Random Number |
| Five Star Quality Care | 0.018590 |
| SigmaTron International | 0.085862 |
| CSS Industries | 0.097172 |
| REX American Resources Corp | 0.122113 |
| VOXX International Corp | 0.158389 |
Here, it is observed that the companies in the new random sample do not match with the companies 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
math
Compute the median of the following data.
32, 41, 36, 42, 29, 30, 40, 22, 25, 37
Task 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…
Chapter 7 Solutions
Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
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 - AARP Survey. In a sample of 426 U.S. adults age 50...Ch. 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 - The average full-sized front-loading Energy Star...Ch. 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 - Seventy two percent of American adults have read a...Ch. 7.6 - Unnecessary Medical Care. According to Reader’s...Ch. 7.6 - Thirty-six percent of all Americans drink bottled...Ch. 7.6 - Prob. 36ECh. 7.6 - 41. The Food Marketing Institute shows that 17% of...Ch. 7.8 - Martina Levitt, director of marketing for the...Ch. 7.8 - Consider the Spontanversation sampling problem for...Ch. 7.8 - The Wall Street Journal reported that 37% of all...Ch. 7.8 - The vice president of sales for Blasterman...Ch. 7 - Shadow Stocks. Jack Lawler, a financial analyst,...Ch. 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. 47SECh. 7 - Prob. 48SECh. 7 - Production Quality Control. A production process...Ch. 7 - Prob. 50SECh. 7 - Prob. 51SECh. 7 - Prob. 52SECh. 7 - Prob. 53SECh. 7 - 54. Lori Jeffrey is a successful sales...Ch. 7 - Managerial Report
Prepare a managerial report that...
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
- Question 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_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forward
- 310015 K Question 9, 5.2.28-T Part 1 of 4 HW Score: 85.96%, 49 of 57 points Points: 1 Save of 6 Based on a poll, among adults who regret getting tattoos, 28% say that they were too young when they got their tattoos. Assume that six adults who regret getting tattoos are randomly selected, and find the indicated probability. Complete parts (a) through (d) below. a. Find the probability that none of the selected adults say that they were too young to get tattoos. 0.0520 (Round to four decimal places as needed.) Clear all Final check Feb 7 12:47 US Oarrow_forwardhow could the bar graph have been organized differently to make it easier to compare opinion changes within political partiesarrow_forwardDraw a picture of a normal distribution with mean 70 and standard deviation 5.arrow_forward
- What do you guess are the standard deviations of the two distributions in the previous example problem?arrow_forwardPlease answer the questionsarrow_forward30. An individual who has automobile insurance from a certain company is randomly selected. Let Y be the num- ber of moving violations for which the individual was cited during the last 3 years. The pmf of Y isy | 1 2 4 8 16p(y) | .05 .10 .35 .40 .10 a.Compute E(Y).b. Suppose an individual with Y violations incurs a surcharge of $100Y^2. Calculate the expected amount of the surcharge.arrow_forward
- 24. An insurance company offers its policyholders a num- ber of different premium payment options. For a ran- domly selected policyholder, let X = the number of months between successive payments. The cdf of X is as follows: F(x)=0.00 : x < 10.30 : 1≤x<30.40 : 3≤ x < 40.45 : 4≤ x <60.60 : 6≤ x < 121.00 : 12≤ x a. What is the pmf of X?b. Using just the cdf, compute P(3≤ X ≤6) and P(4≤ X).arrow_forward59. At a certain gas station, 40% of the customers use regular gas (A1), 35% use plus gas (A2), and 25% use premium (A3). Of those customers using regular gas, only 30% fill their tanks (event B). Of those customers using plus, 60% fill their tanks, whereas of those using premium, 50% fill their tanks.a. What is the probability that the next customer will request plus gas and fill the tank (A2 B)?b. What is the probability that the next customer fills the tank?c. If the next customer fills the tank, what is the probability that regular gas is requested? Plus? Premium?arrow_forward38. Possible values of X, the number of components in a system submitted for repair that must be replaced, are 1, 2, 3, and 4 with corresponding probabilities .15, .35, .35, and .15, respectively. a. Calculate E(X) and then E(5 - X).b. Would the repair facility be better off charging a flat fee of $75 or else the amount $[150/(5 - X)]? [Note: It is not generally true that E(c/Y) = c/E(Y).]arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Statistics 4.1 Point Estimators; Author: Dr. Jack L. Jackson II;https://www.youtube.com/watch?v=2MrI0J8XCEE;License: Standard YouTube License, CC-BY
Statistics 101: Point Estimators; Author: Brandon Foltz;https://www.youtube.com/watch?v=4v41z3HwLaM;License: Standard YouTube License, CC-BY
Central limit theorem; Author: 365 Data Science;https://www.youtube.com/watch?v=b5xQmk9veZ4;License: Standard YouTube License, CC-BY
Point Estimate Definition & Example; Author: Prof. Essa;https://www.youtube.com/watch?v=OTVwtvQmSn0;License: Standard Youtube License
Point Estimation; Author: Vamsidhar Ambatipudi;https://www.youtube.com/watch?v=flqhlM2bZWc;License: Standard Youtube License