Question

1.         The frequency distribution below was constructed from data collected on the quarts of soft drinks consumed...

1.         The frequency distribution below was constructed from data collected on the quarts of soft drinks consumed per week by 20 students.

                        Quarts of Soft Drink                        Frequency

                                    0 -   3                                             4

                                    4 -   7                                             5

                                    8 - 11                                             6

                                   12 - 15                                            3

                                   16 - 19                                            2

            a.   Construct a relative frequency distribution.

            b.   Construct a cumulative frequency distribution

c.   Construct a cumulative relative frequency distribution.

Can you provide the solution in excel format?

Homework Answers

Answer #1

The first column is the midpoints of the intervals. I hope you understand how to calculate these values.

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
10. Absolute (actual) frequency distribution is a tabular summary of a set of data showing the...
10. Absolute (actual) frequency distribution is a tabular summary of a set of data showing the relative frequencies a graphical form of representing data a tabular summary of a set of data showing the actual number of items in each of several nonoverlapping classes a graphical device for presenting categorical data 11. If several frequency distributions are constructed from the same data set, the distribution with the widest class width will have the fewest classes most classes same number of...
(2) Data is collected, which represents the HEIGHT (centimeters) of a random sample of 50 PACE...
(2) Data is collected, which represents the HEIGHT (centimeters) of a random sample of 50 PACE U. students:                                    CLASS          FREQUENCY 150 TO < 156       4 156 TO < 162       7 162 TO < 168     15 168 TO < 174     11 174 TO < 180     10 180 TO < 186      3                  ∑ f = 50 Please summarize this data by constructing a RELATIVE FREQUENCY CUMULATIVE “ LESS THAN “ DISTRIBUTION. WHAT PERCENTAGE of sampled students are 168 cm OR...
The data represent the​ time, in​ minutes, spent reading a political blog in a day. Construct...
The data represent the​ time, in​ minutes, spent reading a political blog in a day. Construct a frequency distribution using 5 classes. In the​ table, include the​ midpoints, relative​ frequencies, and cumulative frequencies. Which class has the greatest frequency and which has the least​ frequency? 19 29 21 0 6 4 16 25 23 1 7 2 9 14 25 27 9 12 15 15
1. for the given frequency distribution below find the mean, median and standard deviation X f(X)...
1. for the given frequency distribution below find the mean, median and standard deviation X f(X) 2 4 3 7 4 5 5 7 6 5 7 2 a) List the relative and cumulative relative frequency for each interval the table above 2. Identify the level of the following variables a. heights of male students b. the first three finisher of a car race c. temperature in fahrenheit. d. the types of cars in a parking lot 3. find the...
Question 1 A soft drink bottler is analyzing the vending machine service routes in his distribution...
Question 1 A soft drink bottler is analyzing the vending machine service routes in his distribution system. He is interested in predicting the amount of time required by the route driver to service the vending machines in an outlet. The industrial engineer responsible for the study has suggested that the two most important variables affecting the delivery time (Y) are the number of cases of product stocked (X1) and the distance walked by the route driver (X2). The engineer has...
Suppose that the following frequency table contains data on the number of absences in a school...
Suppose that the following frequency table contains data on the number of absences in a school year due to illness or injury for 100 randomly selected high school students. Use the table to determine the median number of absences for these 100 students. Provide your answer with precision to one decimal place. Number of absences 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 Frequency 25, 10, 10, 5, 9, 12, 9, 9, 4, 2, 3, 2...
1. Joint frequency distributions are used to display: Select one: a. the cumulative distribution of a...
1. Joint frequency distributions are used to display: Select one: a. the cumulative distribution of a variable with two possible outcomes. b. the histograms of two variables analyzed simultaneously. c. the relative frequency of two variables. d. the number of occurrences at each of the possible joint occurrences of two variables. 2.For which data collection method is it most important to have a polished-looking survey form? Select one: a. Telephone survey b. Experimental design c. Written questionnaire d. Personal interview...
Data was collected for 364 randomly selected 10 minute intervals. For each ten-minute interval, the number...
Data was collected for 364 randomly selected 10 minute intervals. For each ten-minute interval, the number of people entering the atrium of a large mall were recorded. The data is summarized in the table below. Number   of Guests      Frequency    220 – 239 83 240 – 259 95 260 – 279 47 280 – 299 43 300 – 319 96 What is the class width for this GFDT? Class width = The number of students in the tutoring center was recorded...
Question 4: Consider the soft drink delivery time data (data-ex-3-1 (Delivery Time).csv). a) Find the simple...
Question 4: Consider the soft drink delivery time data (data-ex-3-1 (Delivery Time).csv). a) Find the simple correlation between cases (x1) and distance (x2). b) Find the variance inflation factors. c) Find the condition number of XT X. Is there evidence of multicollinearity in these data? Observation Delivery Time, y Number of Cases, x1 Distance, x2 (ft) 1 16.68 7 560 2 11.5 3 220 3 12.03 3 340 4 14.88 4 80 5 13.75 6 150 6 18.11 7 330...
You have collected data on the processing speed for 20 supercomputers, both before and after a...
You have collected data on the processing speed for 20 supercomputers, both before and after a newly designed chip was implemented. (a) Construct and interpret an 80% confidence interval for the difference between the average computing speed before and after the implementation of the new chip. Provide support for both your choice of interval and the validity of the underlying assumptions. (b) Provide the R code which verifies your findings in (a). "","x" "1",0.0458835170914729 "2",0.186357728205621 "3",0.261930461196287 "4",0.121678145570879 "5",0.190702709369361 "6",0.244160178413892 "7",1.12384053562444...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT