EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780136880844
Author: Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 2, Problem 2PE
The Excel file Syringe Samples provides data for
Expert Solution & Answer
To determine
To define the range names for each of these samples and then use the range names in formulas to find the average values of each samples.
Explanation of Solution
Given:
The Syringe samples data for the fifteen samples in the excel file is as follows:
| Sample | Sample Observations | ||||
| S1 | 4.9600 | 4.9460 | 4.9500 | 4.9560 | 4.9580 |
| S2 | 4.9580 | 4.9270 | 4.9350 | 4.9400 | 4.9500 |
| S3 | 4.9710 | 4.9290 | 4.9650 | 4.9520 | 4.9380 |
| S4 | 4.9400 | 4.9820 | 4.9700 | 4.9530 | 4.9600 |
| S5 | 4.9640 | 4.9500 | 4.9530 | 4.9620 | 4.9560 |
| S6 | 4.9690 | 4.9510 | 4.9550 | 4.9660 | 4.9540 |
| S7 | 4.9600 | 4.9440 | 4.9570 | 4.9480 | 4.9510 |
| S8 | 4.9690 | 4.9490 | 4.9630 | 4.9520 | 4.9620 |
| S9 | 4.9840 | 4.9280 | 4.9600 | 4.9430 | 4.9550 |
| S10 | 4.9700 | 4.9340 | 4.9610 | 4.9400 | 4.9650 |
| S11 | 4.9750 | 4.9590 | 4.9620 | 4.9710 | 4.9680 |
| S12 | 4.9450 | 4.9770 | 4.9500 | 4.9690 | 4.9540 |
| S13 | 4.9760 | 4.9640 | 4.9700 | 4.9680 | 4.9720 |
| S14 | 4.9700 | 4.9540 | 4.9640 | 4.9590 | 4.9680 |
| S15 | 4.9820 | 4.9620 | 4.9680 | 4.9750 | 4.9630 |
Formulas used:
Let the range names be
| S1 | S2 | S3 | S4 | S5 | S6 | S7 | S8 | S9 | S10 | S11 | S12 | S13 | S14 | S15 |
And the formulas used for the average is:
=AVERAGE(S1), =AVERAGE(S2), and so on for fifteen samples.
Calculation:
We will apply the formula of the average in each of the samples to find out the result.
Thus, the outcome of the result is as follows:
| Sample | Sample Observations | Average | ||||
| 1 | 4.9600 | 4.9460 | 4.9500 | 4.9560 | 4.9580 | 4.9540 |
| 2 | 4.9580 | 4.9270 | 4.9350 | 4.9400 | 4.9500 | 4.9420 |
| 3 | 4.9710 | 4.9290 | 4.9650 | 4.9520 | 4.9380 | 4.9510 |
| 4 | 4.9400 | 4.9820 | 4.9700 | 4.9530 | 4.9600 | 4.9610 |
| 5 | 4.9640 | 4.9500 | 4.9530 | 4.9620 | 4.9560 | 4.9570 |
| 6 | 4.9690 | 4.9510 | 4.9550 | 4.9660 | 4.9540 | 4.9590 |
| 7 | 4.9600 | 4.9440 | 4.9570 | 4.9480 | 4.9510 | 4.9520 |
| 8 | 4.9690 | 4.9490 | 4.9630 | 4.9520 | 4.9620 | 4.9590 |
| 9 | 4.9840 | 4.9280 | 4.9600 | 4.9430 | 4.9550 | 4.9540 |
| 10 | 4.9700 | 4.9340 | 4.9610 | 4.9400 | 4.9650 | 4.9540 |
| 11 | 4.9750 | 4.9590 | 4.9620 | 4.9710 | 4.9680 | 4.9670 |
| 12 | 4.9450 | 4.9770 | 4.9500 | 4.9690 | 4.9540 | 4.9590 |
| 13 | 4.9760 | 4.9640 | 4.9700 | 4.9680 | 4.9720 | 4.9700 |
| 14 | 4.9700 | 4.9540 | 4.9640 | 4.9590 | 4.9680 | 4.9630 |
| 15 | 4.9820 | 4.9620 | 4.9680 | 4.9750 | 4.9630 | 4.9700 |
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
A researcher wishes to estimate, with 90% confidence, the population proportion of adults who support labeling
legislation for genetically modified organisms (GMOs). Her estimate must be accurate within 4% of the true proportion.
(a) No preliminary estimate is available. Find the minimum sample size needed.
(b) Find the minimum sample size needed, using a prior study that found that 65% of the respondents said they support
labeling legislation for GMOs.
(c) Compare the results from parts (a) and (b).
...
(a) What is the minimum sample size needed assuming that no prior information is available?
n =
(Round up to the nearest whole number as needed.)
The table available below shows the costs per mile (in cents) for a sample of automobiles. At a = 0.05, can you conclude that at least one mean
cost per mile is different from the others?
Click on the icon to view the data table.
Let Hss, HMS, HLS, Hsuv and Hмy represent the mean costs per mile for small sedans, medium sedans, large sedans, SUV 4WDs, and minivans
respectively. What are the hypotheses for this test?
OA. Ho: Not all the means are equal.
Ha Hss HMS HLS HSUV HMV
B. Ho Hss HMS HLS HSUV = μMV
Ha: Hss *HMS *HLS*HSUV * HMV
C. Ho Hss HMS HLS HSUV =μMV
= =
H: Not all the means are equal.
D. Ho Hss HMS
HLS HSUV HMV
Ha Hss HMS
HLS =HSUV = HMV
Question: A company launches two different marketing campaigns to promote the same product in two different regions. After one month, the company collects the sales data (in units sold) from both regions to compare the effectiveness of the campaigns.
The company wants to determine whether there is a significant difference in the mean sales between the two regions. Perform a two sample T-test
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.
(2 points = 0.5 x 4 Answers)
Each of these is worth 0.5 points. However, showing the calculation is must. If calculation is missing, the whole answer won't get any credit.
Chapter 2 Solutions
EBK BUSINESS ANALYTICS
Ch. 2 - The Excel file Syringe Samples provides data for...Ch. 2 - Convert the Store and Regional Sales database to...Ch. 2 - Convert the Purchase Orders database to an Excel...Ch. 2 - Prob. 6PECh. 2 - Prob. 8PECh. 2 - In the Excel file Automobile Quality, search for...Ch. 2 - Prob. 10PECh. 2 - Conduct a Pareto analysis for the number of...Ch. 2 - Use Excels filtering capability in the Purchase...Ch. 2 - In the Sales Transactions database, use Excels...
Ch. 2 - Filter the data in the Bicycle Inventory database...Ch. 2 - Use the Excel file Credit Risk Data that was...Ch. 2 - Apply the Advanced Filter to the Credit Risk Data...Ch. 2 - Prob. 17PECh. 2 - For the Bicycle Inventory database, use database...Ch. 2 - For the Bicycle Inventory database, write a...Ch. 2 - The Excel file SP500 provides open, high, low, and...Ch. 2 - In the Purchase Orders database, we need to find...Ch. 2 - An auditor found an expense receipt for 179.24...Ch. 2 - Use PivotTables to find the number of sales...
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
- Binomial Prob. Question: A new teaching method claims to improve student engagement. A survey reveals that 60% of students find this method engaging. If 15 students are randomly selected, what is the probability that: a) Exactly 9 students find the method engaging?b) At least 7 students find the method engaging? (2 points = 1 x 2 answers) Provide answers in the yellow cellsarrow_forwardIn a survey of 2273 adults, 739 say they believe in UFOS. Construct a 95% confidence interval for the population proportion of adults who believe in UFOs. A 95% confidence interval for the population proportion is ( ☐, ☐ ). (Round to three decimal places as needed.)arrow_forwardFind the minimum sample size n needed to estimate μ for the given values of c, σ, and E. C=0.98, σ 6.7, and E = 2 Assume that a preliminary sample has at least 30 members. n = (Round up to the nearest whole number.)arrow_forward
- In a survey of 2193 adults in a recent year, 1233 say they have made a New Year's resolution. Construct 90% and 95% confidence intervals for the population proportion. Interpret the results and compare the widths of the confidence intervals. The 90% confidence interval for the population proportion p is (Round to three decimal places as needed.) J.D) .arrow_forwardLet p be the population proportion for the following condition. Find the point estimates for p and q. In a survey of 1143 adults from country A, 317 said that they were not confident that the food they eat in country A is safe. The point estimate for p, p, is (Round to three decimal places as needed.) ...arrow_forward(c) Because logistic regression predicts probabilities of outcomes, observations used to build a logistic regression model need not be independent. A. false: all observations must be independent B. true C. false: only observations with the same outcome need to be independent I ANSWERED: A. false: all observations must be independent. (This was marked wrong but I have no idea why. Isn't this a basic assumption of logistic regression)arrow_forward
- Business discussarrow_forwardSpam filters are built on principles similar to those used in logistic regression. We fit a probability that each message is spam or not spam. We have several variables for each email. Here are a few: to_multiple=1 if there are multiple recipients, winner=1 if the word 'winner' appears in the subject line, format=1 if the email is poorly formatted, re_subj=1 if "re" appears in the subject line. A logistic model was fit to a dataset with the following output: Estimate SE Z Pr(>|Z|) (Intercept) -0.8161 0.086 -9.4895 0 to_multiple -2.5651 0.3052 -8.4047 0 winner 1.5801 0.3156 5.0067 0 format -0.1528 0.1136 -1.3451 0.1786 re_subj -2.8401 0.363 -7.824 0 (a) Write down the model using the coefficients from the model fit.log_odds(spam) = -0.8161 + -2.5651 + to_multiple + 1.5801 winner + -0.1528 format + -2.8401 re_subj(b) Suppose we have an observation where to_multiple=0, winner=1, format=0, and re_subj=0. What is the predicted probability that this message is spam?…arrow_forwardConsider an event X comprised of three outcomes whose probabilities are 9/18, 1/18,and 6/18. Compute the probability of the complement of the event. Question content area bottom Part 1 A.1/2 B.2/18 C.16/18 D.16/3arrow_forward
- John and Mike were offered mints. What is the probability that at least John or Mike would respond favorably? (Hint: Use the classical definition.) Question content area bottom Part 1 A.1/2 B.3/4 C.1/8 D.3/8arrow_forwardThe details of the clock sales at a supermarket for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. The simple moving average value of k is set at 2. What is the simple moving average root mean square error? Round to two decimal places. Week Units sold 1 88 2 44 3 54 4 65 5 72 6 85 Question content area bottom Part 1 A. 207.13 B. 20.12 C. 14.39 D. 0.21arrow_forwardThe details of the clock sales at a supermarket for the past 6 weeks are shown in the table below. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects. The simple moving average value of k is set at 2. If the smoothing constant is assumed to be 0.7, and setting F1 and F2=A1, what is the exponential smoothing sales forecast for week 7? Round to the nearest whole number. Week Units sold 1 88 2 44 3 54 4 65 5 72 6 85 Question content area bottom Part 1 A. 80 clocks B. 60 clocks C. 70 clocks D. 50 clocksarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
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...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License