Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card)
Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card)
8th Edition
ISBN: 9781337114172
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

LMI Aerospace0.008012
Alpha & Omega Semiconductor0.055369
Olympic Steel0.059279
Kimball International0.144127
International Shipholding0.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

LMI Aerospace0.008012
Alpha & Omega Semiconductor0.055369
Olympic Steel0.059279
Kimball International0.144127
International Shipholding0.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.

  • 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:

Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card), 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!
Students have asked these similar questions
The data needed to answer this question is given in the following link (file is on view only so if you would like to make a copy to make it easier for yourself feel free to do so) https://docs.google.com/spreadsheets/d/1aV5rsxdNjHnkeTkm5VqHzBXZgW-Ptbs3vqwk0SYiQPo/edit?usp=sharing
The following relates to Problems 4 and 5. Christchurch, New Zealand experienced a major earthquake on February 22, 2011. It destroyed 100,000 homes. Data were collected on a sample of 300 damaged homes. These data are saved in the file called CIEG315 Homework 4 data.xlsx, which is available on Canvas under Files. A subset of the data is shown in the accompanying table. Two of the variables are qualitative in nature: Wall construction and roof construction. Two of the variables are quantitative: (1) Peak ground acceleration (PGA), a measure of the intensity of ground shaking that the home experienced in the earthquake (in units of acceleration of gravity, g); (2) Damage, which indicates the amount of damage experienced in the earthquake in New Zealand dollars; and (3) Building value, the pre-earthquake value of the home in New Zealand dollars. PGA (g) Damage (NZ$) Building Value (NZ$) Wall Construction Roof Construction Property ID 1 0.645 2 0.101 141,416 2,826 253,000 B 305,000 B T 3…
Rose Par posted Apr 5, 2025 9:01 PM Subscribe To: Store Owner From: Rose Par, Manager Subject: Decision About Selling Custom Flower Bouquets Date: April 5, 2025 Our shop, which prides itself on selling handmade gifts and cultural items, has recently received inquiries from customers about the availability of fresh flower bouquets for special occasions. This has prompted me to consider whether we should introduce custom flower bouquets in our shop. We need to decide whether to start offering this new product. There are three options: provide a complete selection of custom bouquets for events like birthdays and anniversaries, start small with just a few ready-made flower arrangements, or do not add flowers. There are also three possible outcomes. First, we might see high demand, and the bouquets could sell quickly. Second, we might have medium demand, with a few sold each week. Third, there might be low demand, and the flowers may not sell well, possibly going to waste. These outcomes…

Chapter 7 Solutions

Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card)

Ch. 7.3 - The following data are from a simple random...Ch. 7.3 - Prob. 12ECh. 7.3 - 13. A sample of 5 months of sales data provided...Ch. 7.3 - 14. Morningstar publishes ratings data on 1208...Ch. 7.3 - The National Football League (NFL) polls fans to...Ch. 7.3 - 16. A sample of 426 U.S. adults age 50 and older...Ch. 7.3 - 17. One of the questions in the Pew Internet &...Ch. 7.5 - 18. A population has a mean of 200 and a standard...Ch. 7.5 - A population has a mean of 200 and a standard...Ch. 7.5 - 20. Assume the population standard deviation is σ...Ch. 7.5 - 21. Suppose a random sample of size 50 is selected...Ch. 7.5 - Sampling Distribution for Electronic Associates,...Ch. 7.5 - Finding Probabilities for Electronic Associates,...Ch. 7.5 - Barrons reported that the average number of weeks...Ch. 7.5 - Prob. 25ECh. 7.5 - Prob. 26ECh. 7.5 - The Economic Policy Institute periodically issues...Ch. 7.5 - 28. The state of California has a mean annual...Ch. 7.5 - 29. The mean preparation fee H&R Block charged...Ch. 7.5 - To estimate the mean age for a population of 4000...Ch. 7.6 - A sample of size 100 is selected from a population...Ch. 7.6 - 32. A population proportion is .40. A sample of...Ch. 7.6 - Prob. 33ECh. 7.6 - 34. The population proportion is .30. What is the...Ch. 7.6 - Orders from First-Time Customers. The president of...Ch. 7.6 - The Wall Street Journal reported that the age at...Ch. 7.6 - Prob. 37ECh. 7.6 - Unnecessary Medical Care. According to Readers...Ch. 7.6 - Prob. 39ECh. 7.6 - 40. The Grocery Manufacturers of America reported...Ch. 7.6 - 41. The Food Marketing Institute shows that 17% of...Ch. 7 - Shadow Stocks. Jack Lawler, a financial analyst,...Ch. 7 - The latest available data showed health...Ch. 7 - 44. Foot Locker uses sales per square foot as a...Ch. 7 - Allegiant Airlines charges a mean base fare of 89....Ch. 7 - After deducting grants based on need, the average...Ch. 7 - Prob. 47SECh. 7 - Survey Research Results. A researcher reports...Ch. 7 - Production Quality Control. A production process...Ch. 7 - Australians and Smoking. Reuters reports that 15...Ch. 7 - 51. A market research firm conducts telephone...Ch. 7 - Advertisers contract with Internet service...Ch. 7 - The proportion of individuals insured by the...Ch. 7 - Lori Jeffrey is a successful sales representative...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.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
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
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