Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    Chapter 3-Tutorial Content

    Uploaded by

    Jana Rizk

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Chapter 3-Tutorial Content

    Uploaded by

    Jana Rizk
    19 views6 pages

    Original Title

    chapter 3-Tutorial content

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    19 views6 pages

    Chapter 3-Tutorial Content

    Uploaded by

    Jana Rizk

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 6

    STAT 201-Chapter 3 (Describing Data: NUMERICAL MEASURES)

    LAB Tutorial

    Example /Page 64
    Table 2–4 on page 26 shows the profit on the sales of 180 vehicles at Applewood Auto Group.
    Determine the mean and the median selling price.

    Q21/Page 63. The unemployment rate in the state of Alaska by month is given in the table below:

    a. What is the arithmetic mean of the Alaska unemployment rates?


    b. Find the median and the mode for the unemployment rates.
    c. Compute the arithmetic mean and median for just the winter (Dec–Mar) months. Is it much
    different?

    1|Page
    Q22/Page 64. Big Orange Trucking is designing an information system for use in “in-cab”
    communications. It must summarize data from eight sites throughout a region to describe typical
    conditions. Compute an appropriate measure of central location for the variables wind direction,
    temperature, and pavement.

    Example Page 71/72:


    The chart below shows the number of cappuccinos sold at the Starbucks in the Orange County
    airport and the Ontario, California, airport between 4 and 5 p.m. for a sample of 5 days last month.

    2|Page
    Determine the mean, median, range, and variance for each location. Comment on the similarities
    and differences in these measures.

    Q39/Page 73. Ten young adults living in California rated the taste of a newly developed sushi
    pizza topped with tuna, rice, and kelp on a scale of 1 to 50, with 1 indicating they did not like the
    taste and 50 that they did. The ratings were:

    In a parallel study, 10 young adults in Iowa rated the taste of the same pizza. The ratings were:

    As a market researcher, compare the potential for sushi pizza in the two markets.

    3|Page
    Q51/Page 79. The Houston, Texas, Motel Owner Association conducted a survey regarding
    weekday motel rates in the area. Listed below is the room rate for business-class guests for a
    sample of 10 motels.

    a. Compute the sample variance.


    b. Determine the sample standard deviation.

    Important Definitions

    ❖ Measure of dispersion A value that shows the spread of a data set. The range, variance, and
    standard deviation are measures of dispersion.
    ❖ Measure of location A single value that is typical of the data. It pinpoints the center of a
    distribution. The arithmetic mean, weighted mean, median, mode, and geometric mean are
    measures of location.
    ❖ Median The value of the middle observation after all the observations have been arranged from
    low to high. For example, if observations 6, 9, 4 are rearranged to read 4, 6, 9, the median is 6, the
    middle value.
    ❖ Mode The value that appears most frequently in a set of data. For grouped data, it is the midpoint
    of the class containing the largest number of values.
    ❖ Range A measure of dispersion found by subtracting the minimum value from the maximum value.

    4|Page
    ❖ Variance A measure of dispersion based on the average squared differences from the arithmetic
    mean.

    Some Important Calculation Formulas:

    5|Page
    Excel formulas:
    calculation Excel formula
    Mean =Average(selection of cell Range of values)
    Median =Median(selection of cell Range of values)
    Range =Max(selection of cell Range of values)-Min((selection of cell Range of
    values)
    Population variance =VAR.P(selection of cell Range of values)
    Sample variance =VAR.S(selection of cell Range of values)
    Population standard =STDEV.P(selection of cell Range of values) or
    deviation =SQRT(variance value calculated for population)
    Sample standard =STDEV.S(selection of cell Range of values) OR
    deviation =SQRT(variance value calculated for sample)

    6|Page

    You might also like