Chapter 1-3. Best Use the Data from the Excel file: Ages oscar winners- Actresse

Question

Chapter 1-3. Best Use the Data from the Excel file: Ages oscar winners- Actresses set to solve the following problems: 1. Use a calculator or software to find the following statistics values-mean, median, mode, range, midrange, and the standard deviation for the data set. 2. Organize the data set in a frequency table using bins with width 10, starting from 20-29, 30-39 and so on. Include columns for the relative and cumulative frequency 3. Construct a histogram based on the table of step 2. Analyze the distribution curve- number of peaks, the symmetry, and variation. 4. Use the frequency table and identify class midpoints and class boundaries. Calculate the mean, median and mode of the data set. Compare these values with the values you found in step 1

Explanation / Answer

Hi,

We didn't provide the data. So , I will try to explain all this concepts by taking 10 random ages. Please apply all this methods in order to get answers for your data set.

I entered this values for A1:A10

Mean = average(A1:A10)

Median =Median(A1:A10)

Mode =Mode(A1:A10)

Range =Max(A1:A10)-Min(A1:A10)

Midrange= Max(A1:A10)-Min(A1:A10)/2

Standard deviation = STDEV(A1:A10)

For setting bins

First fill a column with

20-29

30-39

40-49

Like this till the maximum age covered

then in the respective row of the next column enter the formula as follows

=COUNTIF(A1:A10,">20&<=29")

for the next row

=SUM(COUNTIF(A2:A11,{">=20",">=29"})*{1,-1})

Like this do for all values then you will get the frequency.

To construct histogram select the bin and frequency columns and in insert menu insert histogram.

To calculate mid points next to each bin write formula in repective row

=29-20/2

=39-30/2

..,...

then find mean,media,...by using erlier formula

ages 53 41 38 27 62 34 28 30 45 62

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.