Business Analytics
3rd Edition
ISBN: 9780135231715
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
Make a histogram graph and make table of required data .
When exposed to an infection, a person typically develops antibodies. The extent to which theantibodies respond can be measured by looking at a persons titer, which is a measure of the number of antibodies present. The higher the titer is, the more antibodies that are present. The data in Table represent the titers of 11 ill people and 11 healthy people exposed to the tularemia virus in Vermont. Is the level of titer in the ill group greater than the level of titer in the healthy group? Use the α = 0.10 level of significance.
what data do into spss to receive the answers?
Chapter 2 Solutions
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
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardThe following DBH values were collected from a pine plantation. Please find the population, range, mean, median and mode. 9, 10, 12, 12, 13, 11, 12, 10, 12, 11, 11, 12 Population = A Range %3D A Mean = A Median = Mode =arrow_forwardCalculate 90th percentile for Z.arrow_forward
- Identify the type of data: Weight of a pillow. quantitative continuous? quantitative discrete? qualitative?arrow_forwardThe price drivers pay for gasoline often varies a great deal across regions throughout the United States. The following data show the price per gallon for regular gasoline for a random sample of gasoline service stations for three major brands of gasoline (Shell, BP, and Marathon) located in eleven metropolitan areas across the upper Midwest region (OhioGasPrices.com website, March 18, 2012). Click on the datafile logo to reference the data. Use = .05 to test for any significant difference in the mean price of gasoline for the three brands. Round SS to 6 decimals, MS to 6 decimals, F to 2 decimals and p to 3 decimals, if necessary. If your answer is zero, enter "0". Source DF SS MS F p Metropolitan Area Brand Error Total The p-value is - Select your answer -less than .05between .05 and .125between .025 and .05between .05 and .10greater than .05Item 16 . What is your conclusion?- Select your answer -Conclude that there is a…arrow_forwardA newspaper infographic titled "Baby's First Photo Reveal" summarized data from a survey of 1,000 mothers with children under the age of 2. The infographic stated that 84% of moms post new baby photos from the delivery room. This information could be used to provide an estimate of the proportion of new mothers who post pictures on social media from the delivery room. Assume that the sample is representative of the population of mothers with children under the age of 2 years. Use the five-step process for estimation problems (EMC3) to construct a 99% confidence interval for the proportion of mothers of children under the age of 2 years who post pictures of their new baby on social media from the delivery room. (Use a table or SALT. Round your answers to three decimal places.)arrow_forward
- Question #1 pleasearrow_forwardThe histogram displays the number of 2008 births among U.S. women ages 10 to 50 . Each bin represents an interval of two years, and the height of each bin represents the frequency with which the data fall within that interval. A histogram for the number of births by mother’s age for 2008. Height of 62 for ages 14 to 16, height of 202 for ages 16 to 18, height of 369 for ages 18 to 20, height of 415 for ages 20 to 22, height of 441 for ages 22 to 24, height of 470 for ages 24 to 26, height of 487 for ages 26 to 28, height of 460 for ages 28 to 30, height of 403 for ages 30 to 32, height of 326 for ages 32 to 34, height of 252 for ages 34 to 36, height of 177 for ages 36 to 38, height of 99 for ages 38 to 40, height of 46 for ages 40 to 42, height of 17 for ages 42 to 44, and height of 4 for ages 44 to 46. Use the provided histogram to answer questions about the number of births for each age group. How many births occurred among women over the age of 38 ? number of births:What percentage…arrow_forwardThe average price for one square metre of land is recorded for seven different locations in Melbourne, Australia. The following table shows the average prices for these zoom in 1 the distances from the centre of the Melbourne city. This data is also shown on the scatter diagram below. Distance from city centre, km (x) Price for 1 m² of land, in thousands AUD (y) 1.2 a 3.1 3.3 4.8 5.2 2.4 1.8 1.4 1.3 0.8 2.5 1.5 0.5 1 3 4 6 Distance (km) (a) Use the scatter diagram to find the value of a and b in the table. 15 16 (b) Calculate (i) the mean distance from the Melbourne city centre, ; 17 (ii) the mean 1 m² price, in thousands AUD, ğ; 18 (iii) the Pearson's product-moment correlation coefficient, r. 19 (c) Write down the equation of the regression line y on x. 20 (d) Use the line of the regression equation to estimate the price of 1 m² of the land 4 km from the Melbourne city centre. State whether your estimate is reliable and justify your answer. 21 22 1 m² price (thousand AUD)arrow_forward
- A survey is carried out at a university to estimate the percentage of undergraduates living at home during the current term. What is the population? the parameter?arrow_forwardA newspaper infographic titled "Baby's First Photo Reveal" summarized data from a survey of 1,050 mothers with children under the age of 2. The infographic stated that 84% of moms post new baby photos from the delivery room. This information could be used to provide an estimate of the proportion of new mothers who post pictures on social media from the delivery room. Assume that the sample is representative of the population of mothers with children under the age of 2 years. In USE SALT Use the five-step process for estimation problems (EMC°) to construct a 99% confidence interval for the proportion of mothers of children under the age of 2 years who post pictures of their new baby on social media from the delivery room. (Round your answers to three decimal places.) Interpret the interval. O We are 99% confident that the true proportion of mothers of children under the age of 2 years who post pictures of their new baby on social media from the delivery room falls within this interval.…arrow_forwardGive me a summary of how I should analyze my likert scale dataarrow_forward
arrow_back_ios
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
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
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
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