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
Suppose you have a text file named admission.txt that consists of applicants who have applied for admission in an IT institute. Data of file consist of multiple rows and each row represents one record separated by comma character in the following order.
First Name
Last Name
CNIC
Inter marks Percentage
Age
Phone Number
Subjects in Inter (Major Subjects)
There are 200 available seats for current session and first come first served model will be followed. Admission Eligibility criteria is:
Percentage must be greater than 60
Age must be less than 30
Candidate must have studied Math/Stat or Computer in Inter.
You are required to read and process the text file in a way that data of qualified candidates should be copied in a file qualified.txt. The data of new file must be comma separated…
Assume a file named “tiobeIndex” containing the ratings of programming languages as follows.There are six fields in each line separated by comma. The first filed is the ranking in Septemberthis year. The second filed is the ranking in September last year. The first row shows the meaningfor each field, the remained rows show the rating information for the top 10 programminglanguages. Write commandsto finish following tasks.
Sep 2020, Sep 2019, Change, Programming Language, Ratings, Change
1, 1, , Java, 12.687%, -5.55%
1) Output only the two fields: ranking in September this year and name of programminglanguage using awk.Note: add text "Ranked" before the rank, and put a colon between the rank and the name.E.g. The info for Java should be displayed asRanked 1:Java
2) Change the plus sign in the third field to text "increase".E.g. Info for PHP should be changed to6, 7, increase, PHP, 2.210%, -0.64%
(a) Consider the student data file (st.txt) Data in the following format Name, District, Age, Gender.
(1) Write a PIG Script to display Names of all male students.
(ii) Write a PIG Script to find the number of students from US country.
(iii) Write a PIG Script to display Country wise count of all female students.
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
- Correct answer will be upvoted else Multiple Downvoted. Don't submit random answer. Computer science. Stage an is lexicographically more modest than change b (they have a similar length n), if in the main file I wherein they vary, a[i]<b[i]. For instance, the change [1,3,2,4] is lexicographically more modest than the stage [1,3,4,2], on the grounds that the initial two components are equivalent, and the third component in the principal stage is more modest than in the second. The following change for a stage an of length n — is the lexicographically littlest stage b of length n that lexicographically bigger than a. For instance: for change [2,1,4,3] the following stage is [2,3,1,4]; for change [1,2,3] the following stage is [1,3,2]; for stage [2,1] next change doesn't exist. You are given the number n — the length of the underlying stage. The underlying stage has the structure a=[1,2,… ,n]. At the end of the day, a[i]=i (1≤i≤n). You really want to handle q…arrow_forwardHere are file entry points. I'm curious about their pros and cons.arrow_forwardOnly C programing Your answer file name will be your school number-Q1.cpp (ex: 190201231-Q1.cpp) Engineering Faculty wants to employ research assistants. The information of the candidates who want to be employed as research assistants are written in the sequential access file (candidate.txt) by the registration office, respectively, name, surname, school graduation grade, Academic Personnel and Postgraduate Education Entrance Exam score and foreign language level exam score. All numerical information is being written as decimal numbers(float). Engineering Faculty is to use that candidate.txt file to calculate the total scores of each candidate. When calculating the candidate's total score, 25% of the school graduation grade, 50% of the Academic Personnel and Postgraduate Education Entrance Exam score, and 25% of the language score are being taken into consideration. Write a program that reads the entire candidate.txt file and calculates the total score of each candidate, prints the…arrow_forward
- IN SCALA COULD YOU COMPLETE THE FUNCTIONS: get_january_data, get_first_price, get_prices, get_delta, get_deltas, yearly_yield, compound_yield AND investment val blchip_portfolio = List("GOOG", "AAPL", "MSFT", "IBM", "FB", "AMZN", "BIDU")val rstate_portfolio = List("PLD", "PSA", "AMT", "AIV", "AVB", "BXP", "CCI", "DLR", "EQIX", "EQR", "ESS", "EXR", "FRT", "HCP") // (1) The function below takes a stock symbol and a year as arguments.// It should read the corresponding CSV-file and then extract the January // data from the given year. The data should be collected in a list of// strings (one entry for each line in the CSV-file). import io.Sourceimport scala.util._ def get_january_data(symbol: String, year: Int) : List[String] = ??? // (2) From the output of the get_january_data function, the next function // should extract the first line (if it exists) and the corresponding// first trading price in that year with type Option[Double]. If no…arrow_forwardSuppose that the file inData.txt contains the following data: Giselle Robinson Accounting 5600 5 30 450 9 75 1.5 The first line contains a person's first name, last name, and the department the person works in. In the second line, the first number represents the monthly gross salary, the bonus (as a percent), and the taxes (as a percent). The third line contains the distance traveled and the traveling time. The fourth line contains the number of coffee cups sold and the cost of each coffee cup. Write statements so that after the program executes, the contents of the file outData.txt are as shown below. If necessary, declare additional variables. Your statements should be general enough so that if the content of the input file changes and the program is run again (without editing and recompiling), it outputs the appropriate results. Write statements that close the input and output files. The file inData.txt is provided for you with the following data: Giselle Robinson Accounting 5600 5…arrow_forward6. Output Delivery System Fill in the blanks in the following program to complete the program and answer the questions: ods listing; ods html _______________ = 'steel.html'; ods _______________ file = 'steel.xml'; proc sort data=sashelp.steel out=steel; by date; run; proc print data=steel; run; proc freq data=steel; tables date; run; ods _all_ _______________; ods listing; a. How many destinations are open in the program? b. How many reports are sent to the open destinations? arrow_forward
- 1) Add new user info.2) Print complete report.3) Print conditional report.4) Sort the data by Name.5) Sort the data by Salary.6) Search for Name.7) Save (saving info into a binary file)8) Load (Loading info from a binary file)9) Quit (Option 2) If the user Selects option 2) Print complete report the following output should appear. This is an example report assuming three users were input. Name Phone Number Salary Larry Atwood 701-555-1234 25000.00Terry Frank 701-555-5555 65000.95Chris Olien 605-555-4444 55500.00 (Option 3) If the user Selects option 3) Print conditional report the following question should be asked, followed by the report. This report assumes the same three user from above. Print user with a salary greater than -> 50000 Name Phone…arrow_forwardIN MATLAB SOFTWARE asnwer the task 4 I need the codes to be use Task 3 The following data where obtained from five samples of an unknown substance. The mass and volume are measured in grams and milliliter, respectively. Create a CSV file in Excel using these data and use filename Experiment. Import that data as a table in MATLAB. Display the contents of that table. Mass Volume 1.50 1.80 1.26 1.50 1.36 1.65 1.67 2.00 1.48 1.78 Task 4 Continuing Task 3, append another column to the Experiment table containing the density for each sample in g/mL. Use Density as table variable name for that new column. Create a variable containing the value of the average density; use avgDensity as variable name.arrow_forwardOther from being immutable, what other extended file attributes are available to choose from?arrow_forward
- 82. The best file organization in which one has to process all data records in a file called a. Indexed b. Sequential c. Direct access d. Random accessarrow_forwardTrying to figure C++ program coding using the following: File IO Control structures Looping Operator precedence Error checking (bad data, filestream fail state, etc.) Use of proper data types; type coersion and/or explict type conversion Exact output Write a program that will calculate numerical and letter grades for a student and output a report: The information will be in the provided data file txt. The data file consists of several rows of data containing a student name and information for 3 types of assignments: First Name, Last Name, number of homework grades, values for homework grades, percentage of total grade, number of program grades, values for program grades, percental of total grade, number of exam grades, values for exam grades, percentage of exam grades. For example, the first row of the data file contains the following: Sherlock Holmes 3 100 100 100 0.15 3 75 80 90 0.40 3 60 70 70 0.45 The student, Sherlock Holmes, has three homework grades, each…arrow_forwardFunction and presentation of a file extension must be kept distinct.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
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