Applied Statistics in Business and Economics
5th Edition
ISBN: 9781259329050
Author: DOANE
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 2, Problem 72CE
You can test Excel’s algorithm for selecting random integers with a simple experiment. Enter =RANDBETWEEN(1,2) into cell A1 and then copy it to cells A1:E20. This creates a data block of 100 cells containing either a one or a two. In cell G1 type =COUNTIF(A1:E20,“=1”) and in cell G2 type =COUNTIF(A1:E20,“=2”). Highlight cells G1 and G2 and create a column chart. Click on the vertical axis scale and set the lower limit to 0 and upper limit to 100. Then hold down the F9 key and observe the chart. Are you convinced that, on average, you are getting about 50 ones and 50 twos? Ambitious Students: Generalize this experiment to integers 1 through 5.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Business
https://www.hawkeslearning.com/Statistics/dbs2/datasets.html
NC Current Students - North Ce X | NC Canvas Login Links - North ( X
Final Exam Comprehensive x Cengage Learning
x
WASTAT - Final Exam - STAT
→
C
webassign.net/web/Student/Assignment-Responses/submit?dep=36055360&tags=autosave#question3659890_9
Part (b)
Draw a scatter plot of the ordered pairs.
N
Life
Expectancy
Life
Expectancy
80
70
600
50
40
30
20
10
Year of
1950
1970 1990
2010 Birth
O
Life
Expectancy
Part (c)
800
70
60
50
40
30
20
10
1950
1970 1990
W
ALT
林
$
#
4
R
J7
Year of
2010 Birth
F6
4+
80
70
60
50
40
30
20
10
Year of
1950 1970 1990
2010 Birth
Life
Expectancy
Ox
800
70
60
50
40
30
20
10
Year of
1950 1970 1990 2010 Birth
hp
P.B.
KA
&
7
80
% 5
H
A
B
F10
711
N
M
K
744
PRT SC
ALT
CTRL
Chapter 2 Solutions
Applied Statistics in Business and Economics
Ch. 2.1 - What type of data (categorical, discrete...Ch. 2.1 - What type of data (categorical, discrete...Ch. 2.1 - What type of data (categorical, discrete...Ch. 2.1 - (a) Give three original examples of discrete data,...Ch. 2.1 - Which type of data (cross-sectional or time...Ch. 2.1 - Which type of data (cross-sectional or time...Ch. 2.1 - Prob. 7SECh. 2.1 - Give an original example of a time series variable...Ch. 2.2 - Which measurement level (nominal, ordinal,...Ch. 2.2 - Which measurement level (nominal, ordinal,...
Ch. 2.2 - Which measurement level (nominal, ordinal,...Ch. 2.2 - Which measurement level (nominal, ordinal,...Ch. 2.2 - Vail Resorts uses various types of scales and...Ch. 2.2 - (a) Would the measurement level for the data...Ch. 2.3 - Would you use a sample or a census to measure each...Ch. 2.3 - Would you use a sample or a census to measure each...Ch. 2.3 - The target population is all stocks in the SP 500...Ch. 2.4 - The target population is all students in your...Ch. 2.4 - Prob. 19SECh. 2.4 - Suppose you want to study the number of e-mail...Ch. 2.4 - In Excel, type a list containing names for 10 of...Ch. 2.6 - What sources of error might you encounter if you...Ch. 2.6 - What kind of survey (mail, telephone, interview,...Ch. 2.6 - What kind of survey (mail, telephone, interview,...Ch. 2.6 - Prob. 27SECh. 2.6 - What problems are evident in the wording of these...Ch. 2 - Define (a) data, (b) data set (c) observation, and...Ch. 2 - How do business data differ from scientific...Ch. 2 - Distinguish (a) univariate, bivariate, and...Ch. 2 - Define the four measurement levels and give an...Ch. 2 - Prob. 5CRCh. 2 - (a) List three reasons why a census might be...Ch. 2 - Prob. 7CRCh. 2 - (a) List four methods of random sampling. (b) List...Ch. 2 - List five (a) steps in a survey, (b) issues in...Ch. 2 - Prob. 10CRCh. 2 - Prob. 29CECh. 2 - Prob. 30CECh. 2 - Prob. 31CECh. 2 - Which measurement level (nominal, ordinal,...Ch. 2 - Below are five questions from a survey of MBA...Ch. 2 - Below are five questions from a survey of MBA...Ch. 2 - Below are five questions from a survey of MBA...Ch. 2 - Prob. 36CECh. 2 - Identify the following data as either time series...Ch. 2 - Would you use a sample or a census to measure each...Ch. 2 - Would you use a sample or census to measure each...Ch. 2 - Is each of the following a parameter or a...Ch. 2 - Prob. 41CECh. 2 - Prob. 42CECh. 2 - Prob. 43CECh. 2 - Prob. 44CECh. 2 - The IRS estimates that the average taxpayer spent...Ch. 2 - The General Accounting Office conducted random...Ch. 2 - Arsenic (a naturally occurring, poisonous metal)...Ch. 2 - Prob. 48CECh. 2 - Would you expect Noodles Company to use a sample...Ch. 2 - Prob. 50CECh. 2 - Examine each of the following statistics. Which...Ch. 2 - The National Claims History (NCH) contains records...Ch. 2 - Prior to starting a recycling program, a city...Ch. 2 - A university wanted to survey alumni about their...Ch. 2 - To protect baby scallops and ensure the survival...Ch. 2 - Prob. 56CECh. 2 - Households can sign up for a telemarketing no-call...Ch. 2 - What level of measurement (nominal, ordinal,...Ch. 2 - Insurance companies are rated by several rating...Ch. 2 - A tabletop survey by a restaurant asked the...Ch. 2 - Give two original examples of (a) discrete data...Ch. 2 - Prob. 64CECh. 2 - Below are 64 names of employees at NilCo. Colors...Ch. 2 - From the display below, pick five cards (without...Ch. 2 - Prob. 69CECh. 2 - You can test Excels algorithm for selecting random...
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
- Harvard University California Institute of Technology Massachusetts Institute of Technology Stanford University Princeton University University of Cambridge University of Oxford University of California, Berkeley Imperial College London Yale University University of California, Los Angeles University of Chicago Johns Hopkins University Cornell University ETH Zurich University of Michigan University of Toronto Columbia University University of Pennsylvania Carnegie Mellon University University of Hong Kong University College London University of Washington Duke University Northwestern University University of Tokyo Georgia Institute of Technology Pohang University of Science and Technology University of California, Santa Barbara University of British Columbia University of North Carolina at Chapel Hill University of California, San Diego University of Illinois at Urbana-Champaign National University of Singapore McGill…arrow_forwardName Harvard University California Institute of Technology Massachusetts Institute of Technology Stanford University Princeton University University of Cambridge University of Oxford University of California, Berkeley Imperial College London Yale University University of California, Los Angeles University of Chicago Johns Hopkins University Cornell University ETH Zurich University of Michigan University of Toronto Columbia University University of Pennsylvania Carnegie Mellon University University of Hong Kong University College London University of Washington Duke University Northwestern University University of Tokyo Georgia Institute of Technology Pohang University of Science and Technology University of California, Santa Barbara University of British Columbia University of North Carolina at Chapel Hill University of California, San Diego University of Illinois at Urbana-Champaign National University of Singapore…arrow_forwardA company found that the daily sales revenue of its flagship product follows a normal distribution with a mean of $4500 and a standard deviation of $450. The company defines a "high-sales day" that is, any day with sales exceeding $4800. please provide a step by step on how to get the answers in excel Q: What percentage of days can the company expect to have "high-sales days" or sales greater than $4800? Q: What is the sales revenue threshold for the bottom 10% of days? (please note that 10% refers to the probability/area under bell curve towards the lower tail of bell curve) Provide answers in the yellow cellsarrow_forward
- Find the critical value for a left-tailed test using the F distribution with a 0.025, degrees of freedom in the numerator=12, and degrees of freedom in the denominator = 50. A portion of the table of critical values of the F-distribution is provided. Click the icon to view the partial table of critical values of the F-distribution. What is the critical value? (Round to two decimal places as needed.)arrow_forwardA retail store manager claims that the average daily sales of the store are $1,500. You aim to test whether the actual average daily sales differ significantly from this claimed value. You can provide your answer by inserting a text box and the answer must include: Null hypothesis, Alternative hypothesis, Show answer (output table/summary table), and Conclusion based on the P value. Showing the calculation is a must. If calculation is missing,so please provide a step by step on the answers Numerical answers in the yellow cellsarrow_forwardShow all workarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Mathematics For Machine TechnologyAdvanced MathISBN:9781337798310Author:Peterson, John.Publisher:Cengage Learning,
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Elementary Linear Algebra (MindTap Course List)AlgebraISBN:9781305658004Author:Ron LarsonPublisher:Cengage Learning
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:9781305658004
Author:Ron Larson
Publisher:Cengage Learning
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Graph Theory: Euler Paths and Euler Circuits; Author: Mathispower4u;https://www.youtube.com/watch?v=5M-m62qTR-s;License: Standard YouTube License, CC-BY
WALK,TRIAL,CIRCUIT,PATH,CYCLE IN GRAPH THEORY; Author: DIVVELA SRINIVASA RAO;https://www.youtube.com/watch?v=iYVltZtnAik;License: Standard YouTube License, CC-BY