Applied Statistics in Business and Economics
5th Edition
ISBN: 9780077837303
Author: David Doane, Lori Seward Senior Instructor of Operations Management
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 4, Problem 12CR
a.
To determine
Write the mathematical formula for the standardized variable.
b.
To determine
Write the EXCEL formula for standardizing the data value in cell F17 from an array with mean Mu and standard deviation Sigma.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A study was performed looking at the effect of mean ozone exposure on change in pulmonary function. Forty-seven hikers were recruited into the study, 25 study participants hiked on days with high ozone exposure, and 22 hiked on days with low-ozone exposure. The change in pulmonary function after a 4-hour hike was recorded for each participant. The results are given below.
Ozone level Mean change in FEV SD N
High 0.22 0.3 21
Low. 0.06 0.2 31
(a) Find out using an appropriate hypothesis test, which test can be used to determine whether the mean change in Forced expiratory volume (FEV) differs between the high-ozone and low-ozone days for 0.01 level of significance?
(b) Carry out the test that true average FEV between the high ozone and low ozone days differs for 0.01 level of significance.
For both parts (a) and (b), answer below.
(i) Specify…
If we multiply the data values by a constant (say, c), how this will affect the geometric mean? Use the equation in image to prove it, and give an example.
Factor V is a protein involved in the forming of blood clots. The higher the level of factor V, the faster the blood clots. A Blood Transfusions Service is interested in the effects of sterilization of blood plasma because factor V is unstable and may break down during sterilization. The table below gives measured levels of factor V in blood samples from nine donors. Both pre- and post-sterilization measurements are given for each person. Test whether the mean factor V levels are different post-sterilization. Run the test at a 5% level of significance. Give each of the following 1) the appropriate null and alternative hypotheses; 2) the appropriate test; 3) the decision rule; 4) the calculation of the test statistic; and 5) your conclusion including a comparison to alpha or the critical value. Factor V measurements
Donor number
Pre-Sterilization
Post-Sterilization
1
1025
985
2
1060
1030
3
953
923
4
847
892
5
750
650
6
855
759…
Chapter 4 Solutions
Applied Statistics in Business and Economics
Ch. 4.2 - Prob. 1SECh. 4.2 - For each data set, is the mode a good measure of...Ch. 4.2 - For each data set, is the mode a good measure of...Ch. 4.2 - For each data set, which best indicates a typical...Ch. 4.2 - For each data set, which best indicates a typical...Ch. 4.2 - Days on the market are shown for the 36 most...Ch. 4.2 - Scores are shown for the most recent state civil...Ch. 4.2 - Prob. 8SECh. 4.2 - CitiBank recorded the number of customers to use a...Ch. 4.2 - Prob. 10SE
Ch. 4.2 - Prob. 11SECh. 4.2 - Prob. 12SECh. 4.2 - (a) Write the Excel function for the 10 percent...Ch. 4.2 - Prob. 14SECh. 4.2 - Prob. 15SECh. 4.2 - Spirit Airlines kept track of the number of empty...Ch. 4.2 - CitiBank recorded the number of customers to use a...Ch. 4.2 - On Friday night, the owner of Chez Pierre in...Ch. 4.2 - Prob. 19SECh. 4.2 - Prob. 20SECh. 4.3 - (a) Find the mean and standard deviation for each...Ch. 4.3 - For each data set: (a) Find the mean. (b) Find the...Ch. 4.3 - In fuel economy tests in city driving conditions,...Ch. 4.3 - Over the past month, Bobs bowling score mean was...Ch. 4.3 - Prob. 25SECh. 4.3 - Prob. 26SECh. 4.3 - (a) Find the coefficient of variation for prices...Ch. 4.3 - Prob. 28SECh. 4.3 - Noodles and Company tested consumer reaction to...Ch. 4.4 - (a) By Chebyshevs Theorem, at least how many...Ch. 4.4 - An exam has a mean of 70 with a standard deviation...Ch. 4.4 - Prob. 32SECh. 4.4 - The mean collection period for accounts receivable...Ch. 4.4 - Prob. 34SECh. 4.4 - Prob. 35SECh. 4.4 - Prob. 36SECh. 4.4 - Find the original data value corresponding to each...Ch. 4.4 - CitiBank recorded the number of customers to use a...Ch. 4.4 - Prob. 39SECh. 4.5 - Scores on an accounting exam ranged from 42 to 96,...Ch. 4.5 - In 2007, total compensation (in thousands of...Ch. 4.5 - Waiting times (minutes) for a table at Joeys BBQ...Ch. 4.5 - Coffee temperatures (degrees Fahrenheit) at a...Ch. 4.5 - Prob. 44SECh. 4.5 - On San Martin Boulevard, embedded sensors kept...Ch. 4.5 - Prob. 46SECh. 4.5 - Prob. 47SECh. 4.6 - For each X-Y data set (n = 12): (a) Make a scatter...Ch. 4.6 - Your laptop gets warm (even hot) when you place it...Ch. 4.6 - Prob. 50SECh. 4.6 - Prob. 51SECh. 4.7 - Estimate the mean from this table of grouped data...Ch. 4.7 - Estimate the mean from the following table of...Ch. 4 - What are descriptive statistics? How do they...Ch. 4 - Explain each concept: (a) center, (b) variability,...Ch. 4 - Prob. 3CRCh. 4 - List strengths and weaknesses of each measure of...Ch. 4 - Prob. 5CRCh. 4 - (a) What is a bimodal distribution? (b) Explain...Ch. 4 - Prob. 7CRCh. 4 - Prob. 8CRCh. 4 - (a) Which standard deviation formula (population,...Ch. 4 - (a) To what kind of data does Chebyshevs Theorem...Ch. 4 - Prob. 11CRCh. 4 - Prob. 12CRCh. 4 - Prob. 13CRCh. 4 - Prob. 14CRCh. 4 - (a) Explain the method of medians for calculating...Ch. 4 - (a) What is a box plot? What does it tell us? (b)...Ch. 4 - Prob. 17CRCh. 4 - Prob. 18CRCh. 4 - Prob. 19CRCh. 4 - (a) What is kurtosis? (b) Sketch a platykurtic...Ch. 4 - Prob. 54CECh. 4 - If the mean asset turnover for retail firms is...Ch. 4 - Prob. 56CECh. 4 - During a rock concert, the noise level (in...Ch. 4 - Bags of jelly beans have a mean weight of 396 gm...Ch. 4 - Based on experience, the Ball Corporations...Ch. 4 - SAT scores for the entering class of 2010 at...Ch. 4 - Prob. 61CECh. 4 - The average time a Boulder High varsity lacrosse...Ch. 4 - Prob. 63CECh. 4 - Below are monthly rents paid by 30 students who...Ch. 4 - How many days in advance do travelers purchase...Ch. 4 - The durations (minutes) of 26 electric power...Ch. 4 - The U.S. Postal Service will ship a Priority Mail...Ch. 4 - Prob. 68CECh. 4 - Prob. 69CECh. 4 - Prob. 70CECh. 4 - Prob. 71CECh. 4 - A plumbing suppliers mean monthly demand for vinyl...Ch. 4 - Prob. 73CECh. 4 - Prob. 74CECh. 4 - Prob. 75CECh. 4 - Caffeine content in a 5-ounce cup of brewed coffee...Ch. 4 - Prob. 77CECh. 4 - Prob. 78CECh. 4 - Prob. 79CECh. 4 - Prob. 80CECh. 4 - Prob. 81CECh. 4 - The median waiting time for a liver transplant in...Ch. 4 - A small suburban community agreed to purchase...Ch. 4 - A companys contractual trigger point for a union...Ch. 4 - Prob. 85CECh. 4 - (a) Enter the Excel function...Ch. 4 - Note: In each of the following tables, the upper...Ch. 4 - Prob. 88CECh. 4 - The self-reported number of hours worked per week...Ch. 4 - How long does it take to fly from Denver to...Ch. 4 - (a) Make an Excel scatter plot of X = 1990 assault...Ch. 4 - (a) Make an Excel scatter plot of X = airspeed...Ch. 4 - Prob. 95CECh. 4 - Prob. 1ERQCh. 4 - Which is not an ethical obligation of a...Ch. 4 - Prob. 3ERQCh. 4 - Prob. 4ERQCh. 4 - Give the type of measurement (nominal, ordinal,...Ch. 4 - Prob. 6ERQCh. 4 - To choose a sample of 12 students from a...Ch. 4 - Which of the following is not a reason for...Ch. 4 - Which statement is correct? Why not the others? a....Ch. 4 - Prob. 10ERQCh. 4 - The management of a theme park obtained a random...Ch. 4 - Which one of the following is true? Why not the...Ch. 4 - Prob. 13ERQCh. 4 - Prob. 14ERQCh. 4 - Here are the ages of a random sample of 20 CEOs...Ch. 4 - Prob. 16ERQCh. 4 - Prob. 17ERQCh. 4 - Prob. 18ERQCh. 4 - Which is not a characteristic of using a log scale...
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
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardHigh levels of cockpit noise in an aircraft can damage the hearing of pilots who are exposed to this hazard for many hours. Cockpit noise in a jet aircraft is mostly due to airflow at hundreds of miles per hour. This 3 x 3 contingency table shows 61 observations of data collected by an airline pilot using a handheld sound meter in a certain aircraft cockpit. Noise level is defined as "low" (under 88 decibels), "medium" (88 to 91 decibels), or "high" (92 decibels or more). There are three flight phases (climb, cruise, descent). Noise Level Low (L) Medium (M) High (H) Column Total Cockpit Noise i P(B) ii P(L) iii P(H|C) iv P(HID) v P(L and B) vi P(L and C) Climb (B) 7 17 6 30 Flight Phase Cruise Descent (C) (D) 6 7 3 3 2 11 10 20 Click here for the Excel Data File (a) Calculate the following probabilities: (Round your answers to 4 decimal places.) 0.4918 Row Total 20 23 18 61arrow_forwardCompute the standard scores for the values 0.49, 0.18,and 0.90. Interpret these scores. What conclusions can you make about these data values based on their standard scoresarrow_forward
- Body mass index (BMI) is a measure of body composition, which can be used to assess if someone is underweight, healthy weight, overweight but not obese, or obese. It is calculated as a person’s weight (measured in Kilograms) divided by his/her height (measured in meters) squared. We recorded 5 students’ BMI values and the numbers of hours they exercised in the past week, as following: BMI 18.4 19.6 20.5 27.6 30.6 Hours of exercise 3.0 2.5 4.0 2.7 0.5 What is the value of r?arrow_forwardIdentify the symbols used for each of the following: (a) sample standard deviation; (b) population standard deviation; (c) sample variance; (d) population variance. If sample data consist of weights measured in grams, what units are used for these statistics and parameter a. The symbol for sample standard deviation is b. The symbol for population standard deviation is c. The symbol for sample variance is d. The symbol for population variance is If sample data consist of weights measured in grams, then correctly complete the following sentences. a. The unit for sample standard deviation would be b. The unit for population standard deviation would be C. The unit for sample variance would be ▼ d. The unit for population variance would be ▼ Carrow_forwardNeil Berman, owner of the Bakery company, stated that his company's average weekly production level was 11398 loaves of bread, with a variance of 49729 loaves of bread squared. Whether the data used to calculate the results were collected within 32 weeks; a. during how many weeks was the production level below 11175 loaves of bread? b. For how many weeks was the production level above 11844 loaves of bread? Select one: Or a. Rta a: 5 weeks approximately below 11175 Rta b: 2 weeks approximately above 11844 bars of bread Or b. Rta a: 7.11 weeks approximately below 11175 Rta b: 5 weeks approximately above 11844 bars bread Oc. Rta a: 2 weeks approximately below 11175 Rta b: 5 weeks approximately above 11844 bars bread Or d. Rta a: 7.11 weeks approximately below 11175 Rta b: 2 weeks approximately above 11844 bars breadarrow_forward
- The manager of a fleet of automobiles is testing two brands of radial tires. She assigns one tire of each brand at random to the two rear wheels of eight cars and runs the cars until the tires wear out. The data are shown here (in kilometers). Find a 99% CI on the difference in mean life. Which brand would you prefer, based on this calculation? Car 1 2 3 4 Brand 1 36,925 45,300 36,240 32,100 Brand 2 34,318 42,280 35,500 31,950 Car Brand 1 5 37,210 6 48,360 7 8 Brand 2 38,015 47,800 38,200 37,810 33,500 33,215arrow_forwardIdentify the symbols used for each of the following: (a) sample standard deviation; (b) population standard deviation; (c) sample variance; (d) population variance. If sample data consist of weights measured in grams, what units are used for these statistics and parameters? s COu mso a. The symbol for sample standard deviation is b. The symbol for population standard deviation is c. The symbol for sample variance is d. The symbol for population variance isarrow_forwardA study was carried out to determine the influence of a trace elementfound in soil on the yield of potato plants grown in that soil, defined asthe weight of potatoes produced at the end of the season. A large fieldwas divided up into 14 smaller sections for this experiment. For eachsection, the experimenter recorded the amount of the trace elementfound (in milligrams per metre squared) and the corresponding weightof the potatoes produced (in kilograms). This information is presentedin the worksheet ‘Dataset5’ in the Excel document. Define X as thetrace element amount and Y as the yield.1. Draw a scatterplot of your data set.Page 52. Calculate the coefficients of a linear equation to predict the yieldY as a function of X.3. Calculate the correlation coefficient for the paired data values.4. Set up the framework for an appropriate statistical test to establish if there is a correlation between the amount of the trace element and the yield. Explain how having the scatterplot referredto…arrow_forward
- A physical therapist wanted to know whether the mean step pulse of men was less than the mean step pulse of women. She randomly selected 59 men and 73 women to participate in the study. Each subject was required to step up and down a 6-inch platform. The pulse of each subject was then recorded. The following results were obtained. SE Mean 1.5 1.7 SIDev 11.2 Mean 112.7 Men Women 99% CI for mu Men - mu Women -11.89, 0.09) T-Test mu Men mu Women (vs<) T= -2.61 P=0.0051 DF 129 59 73 118.6 14.8 Two sample T for Men vs Women State the researcher's condlusion. Which of the following is correct? O A Reject Ha, there is sufficient evidence to condlude that the mean step pulse of men was less than the mean step pulse of women the mean step pulse of women O B. Reject Ha, there is not sufficient evidence to condlude that the mean step pulse of men was less OC. Fail to reject Ho, there is sufficient evidence to conclude that the mean step pulse of men was less than the mean steg pulse of women O D.…arrow_forwardThe manager of a fleet of automobiles is testing two brands of radial tires. She assigns one tire of each brand at random to the two rear wheels of eight cars and runs the cars until the tires wear out. The data are shown here (in km). Find a 99% CI on the difference in mean life. Which brand would you prefer, based on this calculation? Car Brand 1 Brand 2 1 36925 34318 2 45300 42280 3 36240 35500 4 32100 31950 5 37210 38015 6 48360 47800 7 38200 37810 8 33500 33215arrow_forwardAssume that the wavelengths of photosynthetically active radiations (PAR) are uniformly distributed at integer nanometers in the red spectrum from 640 to 665 nm. What is the mean and variance of the wavelength distribution for this radiation? Round your answers to one decimal place (e.g. 98.7). Mean = i Variance = iarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License