Question

DHL recently selected a random sample of packages and weigh them. The weights for the samples...

DHL recently selected a random sample of packages and weigh them. The weights for the samples are given below.

  1. Use Excel to develop a frequency distribution using classes having equal widths.
  2. Use Excel to develop a relative frequency and a cumulative relative frequency distribution for the weights using the same classes created in part b.
  3. What percent of the sampled crates have weights greater than 96 pounds?
DHL
89
91
86
93
94
91
95
83
84
92
80
88
87
79
97
89
92
93
95
89
94
101
87
88
77
87
89
86
86
93
88
98
99
96
92
89
86
92
94
98
88
94
86
90
86
95
90
94
85

Note: please attach screenshots of answers in excel with explanation.

Homework Answers

Answer #1

a and b)

Range frequency cumulative frequency relative frequency
77 to 81 3 3 0.06
82 to 86 9 12 0.18
87 to 91 16 28 0.33
92 to 96 16 44 0.33
97 to 101 5 49 0.10

c)

For weights greater than 96, we do have 5 such values out of 49.

The percentage comes around 10%.

Know the answer?
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
Similar Questions
Since we are attempting to examine the behavior of a class of students, the behavior of...
Since we are attempting to examine the behavior of a class of students, the behavior of an individual (as we calculated in objective 1) is really of little concern to us. Assuming that there are 30 students enrolled for a typical class, use the central limit theorem to calculate the following:    •   What would be the shape of the distribution of the average class grade of these 30 students?    •   What would be the average class average of...
The Data A central tenet to being a good instructor, I believe, is to be a...
The Data A central tenet to being a good instructor, I believe, is to be a reflective practitioner of your craft. From time to time I find it to be necessary to review and reflect on my work as an instructor from a grade perspective. On our moodle page you will find a link to a second word document titled “300 Grades”. This data sheet contains both the alphanumeric grade (page 1) and the numerical equivalent (page 2) for every...
n=40 samples of IQ 85, 94, 97, 86, 86, 107, 91, 99, 115, 50, 93, 98,...
n=40 samples of IQ 85, 94, 97, 86, 86, 107, 91, 99, 115, 50, 93, 98, 100, 94, 73, 76, 72, 76, 95, 89, 96, 108, 74, 72, 90, 100, 91, 98, 91, 85, 97, 91, 78, 82, 93, 89, 94, 88, 83, 76 1) Construct a histogram of the IQ data from your sample. Describe the shape of the histogram and write a sentence or two detailing what the histogram seems to tell you.
Below are the final exam scores of 25 introductory statistics students. 42, 53, 63, 76, 76,...
Below are the final exam scores of 25 introductory statistics students. 42, 53, 63, 76, 76, 78, 80, 85, 86, 86, 87, 87, 88, 88, 89, 89, 90, 91, 92, 94, 95, 95, 96, 96, 97 Create a box plot of the distribution of these scores.Please indicate the values the boundaries and the middle line of the box represent respectively, use the 1.5 IQR rule to identify outlier(s) if any, and show how you determine the values the two whiskers...
Below represent scores on an exam, each entry one score for one student 40 99 59...
Below represent scores on an exam, each entry one score for one student 40 99 59 98 63 63 64 65 67 35 67 67 68 70 71 71 71 46 72 72 60 73 74 74 74 75 97 75 62 76 76 76 76 76 77 57 77 98 77 63 78 78 78 79 79 80 80 80 80 80 81 81 92 81 93 82 82 83 83 83 83 83 83 83 84 84 84...
Question 9-15 are based on the random sample below which is obtained to test the following...
Question 9-15 are based on the random sample below which is obtained to test the following hypothesis about the population mean. Test the hypothesis that the mean is less than 80. 80 100 81 93 80 57 98 90 71 56 58 78 59 55 55 77 72 78 56 94 98 59 93 86 89 62 60 66 59 71 96 97 94 69 64 77 87 77 64 90 90 95 98 99 56 69 72 81 95...
Make a relative frequency histogram using 6 classes; between what two values could you expect to...
Make a relative frequency histogram using 6 classes; between what two values could you expect to find 88.9% of the data, according to Chebyshev. Sample scores: 84, 67,80, 74, 81, 91, 95, 85, 82, 99, 77, 78, 88, 94, 82, 95, 71, 77, 91, 88, 96, 85, 70, 82, 88, 75, 90, 85, 89, 95, 85, 65, 86, 91
Student Grades Student Test Grade 1 76 62 2 84 90 3 79 68 4 88...
Student Grades Student Test Grade 1 76 62 2 84 90 3 79 68 4 88 84 5 76 58 6 66 79 7 75 73 8 94 93 9 66 65 10 92 86 11 80 53 12 87 83 13 86 49 14 63 72 15 92 87 16 75 89 17 69 81 18 92 94 19 79 78 20 60 71 21 68 84 22 71 74 23 61 74 24 68 54 25 76 97...
2. Last year the average grade on the inference test was 82. A random sample of...
2. Last year the average grade on the inference test was 82. A random sample of this year’s student scores on the same test produced the results below. Test at the .02 significance level to see whether the scores have increased significantly from last year? 83 87 98 92 91 100 88 89 93 81 94 96
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades...
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the​ model? If a student scores 7878 on the​ midterm, what would you predict her grade on the final exam to​ be? Student Midterm Final Exam 1 75 64 2 85 91 3 80 68 4 88 83 5 76 60 6 67 80 7 78 74 8 95 94 9 67 61 10 93 87 11...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT