Approximate the mean of the frequency distribution for the ages of the residents of a town.   Age      Frequency 0-9           28 10-19       36 20-29       18 30-39       27 40-49       20 50-59       50 60-69       42 70-79       19 80-89         7

??

Hi how would I step by step make a Histogram chart look like this on Excel with this data

What’s the mean age

Don't drink and drive: A highway safety council reported that there were 3970 fatalities among drivers in auto accidents in a particular year. Following is a frequency distribution of their ages. Approximate the mean age. Round your answer to one decimal place. Age Number of Fatalities 11-20 349 21-30 1569 31-40 851 41-50 665 51-60 409 61-70 127 Send data to Excel The mean is approximately X 5 B

Below is a table of frequencies. Find the mean, mode, and median. Limits     Frecuenci (f)110-115         15116-121          22122-127         19128-133          20134-139            9140-145           21146-151           11

A biologist exposed a certain type of bacteria to gamma radiation to see how long they would live. He gathered data on the survival time of a number of bacterial cells and organized the data into the histogram below. Use the histogram to construct a frequency table. (The relative frequencies should be in decimal form.) 60+ 50 40 30 10 440 282 Survival Time (in Seconds) 45 124 203 361 519 Survival Time of Bacteria upon Exposure to Gamma Radiation Frequency Survival Time (in Seconds) Relative Frequency 45-124 124-203 203-282 282-361 361-440 440-519 Frequency 20

The accompanying data represent the approximate population, in millions, of the 20 most populous cities in the world. Use these data to construct a frequency distribution with a first class of 7.0 -7.9. Fill in the missing classes and the frequency for each class below. Population (millions of people) 7.0 -7.9 □-□ 10.0 - 10.9 11.0-11.9 Number of Cities 13.5 11.5 10.1 8.3 7.7 13.4 11.3 10.1 8.2 7.6 13.3 10.8 9.5 8.2 7.6 13.3 10.5 9.2 7.7 7.2 20

Data was collected for 300 fish from the North Atlantic. The length of the fish (in mm) is summarized in the GFDT below.   Lengths (mm)      Frequency    180 - 184 1 185 - 189 16 190 - 194 71 195 - 199 108 200 - 204 83 205 - 209 18 210 - 214 3 What is the lower class limit for the sixth class?lower class limit =

In a student survey, forty-one part-time students were asked how many courses they were taking this term. The (incomplete) results are shown below: Please round your answer to 4 decimal places for the Relative Frequency if possible. # of Courses Frequency Relative Frequency Cumulative Frequency 1 15 0.3659 15 2 12 0.2927   ? 3   ?    ? 41  What percent of students take exactly one courses          ? %