Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
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.

  1. 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.
  2. 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
Check Mark
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 LA0.008012
Company AO0.055369
Company OS0.059279
Company KI0.144127
Company IS0.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 LA0.008012
Company AO0.055369
Company OS0.059279
Company KI0.144127
Company IS0.227759

b.

Expert Solution
Check Mark
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 Care0.018590
SigmaTron International0.085862
CSS Industries0.097172
REX American Resources Corp 0.122113
VOXX International Corp0.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:

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List), Chapter 7, Problem 42SE

Therefore, the random sample of 5 of the given companies is as follows:

Company

Random

Number

Five Star Quality Care0.018590
SigmaTron International0.085862
CSS Industries0.097172
REX American Resources Corp 0.122113
VOXX International Corp0.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!

Chapter 7 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

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
Background pattern image
Statistics
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.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Text book image
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
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