Question

4.15 construct a box plot for the data in exercise 4.1

down, then across Table 4B Electronic Component Failure Time 127 125 131 124 123 120 121 136 140 118 131 125 56 Chapter 4 Sta


Table 4E. Continued 119 128 133 137 124 142 123 137 125 124 128 129 130 122 133 124 129 121 142 151 160 125 141 125 140 131 1

0 0
Add a comment Improve this question Transcribed image text
Answer #1

First of all, we will arrange the data in excel.

After that, we will find the Lower Quartile, Median, Min, Max & Upper Quartile for the data.

We will use the below mentioned formula to find the desired result.

Lower Quartile = QUARTILE.INC(Data Range,1)

Upper Quartile = QUARTILE.INC(Data Range,3)

Minimum = Min(Data Range)

Maximum = Max(Data Range)

Median = Median(Data Range)

Below will be the result.-

Lower Quartile 124
Minimum 118
Median 128
Maximum 160
Upper Quartile 133.75

After that we will prepare the Box & Whisker chart.

Below will be the Chart.

Abhishek Rai -O × Book2 Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do P15 0 F

Add a comment
Know the answer?
Add Answer to:
4.15 construct a box plot for the data in exercise 4.1 down, then across Table 4B...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please do NOT use Minitab - show all calculations for creating the probability plot. Using Excel...

    Please do NOT use Minitab - show all calculations for creating the probability plot. Using Excel is okay. Reconsider Problem 3 in Homework 3. Is the set of measurements well described by a normal distribution? Show all the calculations. The measurements of a temperature sensor (in °F) are shown below. 124 118 131 125 133 123 120 119 128 133 127 125 131 124 129 121 142 151 160 125 121 136 140 137 125 124 128 129 130 141...

  • The measurements of a temperature sensor (in °F) are provided. Is the set of measurements well...

    The measurements of a temperature sensor (in °F) are provided. Is the set of measurements well described by a normal distribution? Calculate the R^2 and R^2 adjusted values. Show all the calculations. Order Temperature (F) 1 118 2 119 3 120 4 121 5 121 6 122 7 123 8 123 9 124 10 124 11 124 12 124 13 125 14 125 15 125 16 125 17 125 18 126 19 127 20 128 21 128 22 129 23...

  • (Use Excel) italy common for people to put on weight when they quit smoking While a...

    (Use Excel) italy common for people to put on weight when they quit smoking While a small weight gain is normal c e weight gain can create new health concerns that brode the benefits of not smoking. The accompanying table shows a portion of the weight data for 50 women before quitting and six months after quitting Use Table 2 Weight Before Quilling 140 144 138 Weight After Quilling 155 142 163 146 129 149 136 127 158 145 118...

  • a. Calculate the sample average. b. Calculate the sample standard deviation. 4. The time to failure...

    a. Calculate the sample average. b. Calculate the sample standard deviation. 4. The time to failure in hours of an electronic component subjected to an accelerated life test is shown in Table 3E.1. To accelerate the failure test, the units were tested at an elevated temperature (read down, then across). a. Calculate the sample average and standard deviation. b. Construct a histogram. c. Construct a stem-and-leaf plot. d. Find the sample median and the lower and upper quartiles. TABLE 3E.1...

  • Section II – Suppose we gathered the data below by an unbiased method. (The data is...

    Section II – Suppose we gathered the data below by an unbiased method. (The data is sorted DOWN the columns.) Use the data to create a histogram using six (6) classes. First class should start at 111. Give the Five-number summary of the data. Describe the data set. Be specific and note any gaps and/or outliers. Use the 1.5-IQR test to locate outliers. What description of center would be appropriate for the data set? Explain why? Draw a box plot....

  • How do I plot a series graph with this data provided? Month 1987 1988 1989 1990...

    How do I plot a series graph with this data provided? Month 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 Jan 95 104 101 88 132 125 111 127 119 147 Feb 94 100 96 110 109 118 123 129 147 146 Mar 98 99 82 129 101 121 121 132 164 133 Apr 96 88 84 113 111 140 139 108 135 148 May 95 89 85 114 140 141 119 115 124 141 Jun 115 108...

  • Q1. A stimulus is being examined to determine its effect on systolic blood pressure. 18 men...

    Q1. A stimulus is being examined to determine its effect on systolic blood pressure. 18 men participate in the study. Each man’s systolic blood pressure is measured both before and after the stimulus is applied. The following statements input the data: SBPbefore 120 124 130 118 140 128 140 135 126 130 126 127 129 133 136 128 120 125 SBPafter 128 131 131 127 132 125 141 137 118 132 129 135 133 134 133 134 130 140 Is...

  • Grambling State University Department of Mathematies and Physics Probability and Statisties 1,SPLING 2019 Exam I, 01/23/2019...

    Grambling State University Department of Mathematies and Physics Probability and Statisties 1,SPLING 2019 Exam I, 01/23/2019 Please show all the details I. The amount of protein(in grams) for a variety of some fast food reported here. 1. Construct a frequency distribution using 6 cl a histogram, a frequency polygon, and an ogive for the data. 123, 130, 120, 127, 144, 126, 135, 120, 129, 129, 125, 115, 118, 127, 119, 122, 112, 126, 134, 115, 127, 135, 126, 143, 135,...

  • Maintaining a healthy weight is important for women’s health. Some physicians recommend being back to your...

    Maintaining a healthy weight is important for women’s health. Some physicians recommend being back to your pre-pregnancy weight six months after giving birth. Public health officials are interested in whether this is a realistic goal. Do the women in North Carolina weigh more than their pre-pregnancy weight six months postpartum? In other words, is the six months post-pregnancy weight greater than their pre-pregnancy weight? Use a paired samples t-test to compare pst6wght (variable 1) and prewght (variable 2). This uses...

  • Need help on the last column This table shows the distribution of winning times in the...

    Need help on the last column This table shows the distribution of winning times in the Kentucky Derby (a horse race) over 84 years Kentucky Derby Winning Times, 1930-2014 (seconds) From 119 120 121 122 123 124 125 126 127 0 120 121 122 123 124 125 126 127 128 Total 19 27 12 10 84 er cel Data File (a) Fill in the highlighted cells in the table below. (Round your answers to 2 decimal places.) Midpoint Frequency fm...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT