Explore BrainMass

Explore BrainMass

    Performing basic statistical calculations using excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1)Two thousand six hundred frequent business travelers are asked which midwestern city they prefer: Indianapolis, Saint Louis, Chicago, or Milwaukee. 113 liked Indianapolis best, 455 liked Saint Louis, 1395 liked Chicago, and the remainder preferred Milwaukee. Develop a frequency table and a relative frequency table to summarize this information. (Round relative frequency to 3 decimal places.)

    City Frequency Relative Frequency
    Indianapolis

    St. Louis

    Chicago

    Milwaukee

    2)
    A small business consultant is investigating the performance of several companies. The fourth-quarter sales for last year (in thousands of dollars) for the selected companies were:

    Company Fourth-Quarter Sales
    ($ thousands)
    Hoden Building Products $ 1,645.2
    J & R Printing Inc. 4,757.0
    Long Bay Concrete Construction 8,913.0
    Mancell Electric and Plumbing 627.1
    Maxwell Heating and Air Conditioning 24,612.0
    Mizelle Roofing & Sheet Metals 191.9
    ________________________________________

    The consultant wants to include a chart in his report comparing the sales of the six companies.

    Identify a bar chart that compares the fourth-quarter sales of these corporations.

    3)
    The Quick Change Oil Company has a number of outlets in the metropolitan Seattle area. The daily number of oil changes at the Oak Street outlet in the past 20 days are:

    65 98 55 62 79 59 51 90 72 56
    70 62 66 80 94 79 63 73 71 85

    The data are to be organized into a frequency distribution.

    a. How many classes would you recommend?

    Number of classes

    d. Organize the number of oil changes into a frequency distribution. (Round relative frequency answers to 2 decimal places.)

    f Relative frequency
    50 up to 60

    up to

    up to

    up to

    up to

    ________________________________________ ________________________________________
    Total

    ________________________________________________________________________________ ________________________________________________________________________________
    ________________________________________


    4)
    The food services division of Cedar River Amusement Park Inc. is studying the amount that families who visit the amusement park spend per day on food and drink. A sample of 40 families who visited the park yesterday revealed they spent the following amounts:

    $77 $18 $63 $84 $38 $54 $50 $59 $54 $56 $36 $26 $50 $34 $44
    41 58 58 53 51 62 43 52 53 63 62 62 65 61 52
    60 60 45 66 83 71 63 58 61 71

    a. Organize the data into a frequency distribution, using seven classes and 15 as the lower limit of the first class. What class interval did you select? (Round your answer to the nearest whole number.)

    Class interval

    b. Where do the data tend to cluster? (Select all that apply.)

    $35 up to $45
    $45 up to $55
    $35 up to $45
    $55 up to $65
    $75 up to $85


    5)
    Ecommerce.com, a large Internet retailer, is studying the lead time (elapsed time between when an order is placed and when it is filled) for a sample of recent orders. The lead times are reported in days.

    Lead Time (days) Frequency
    0 up to 5 6
    5 up to 10 7
    10 up to 15 12
    15 up to 20 8
    20 up to 25 7
    ________________________________________
    Total 40
    ________________________________________________________________________________
    ________________________________________

    a. How many orders were studied?

    Number of orders

    b. What is the midpoint of the first class? (Round your answer to 1 decimal place.)

    Midpoint

    c. What are the coordinates of the first class for a frequency polygon assuming we draw a frequency polygon using the midpoints? (Round your answer to 1 decimal place.)

    x = , y =


    6)
    The following cumulative frequency polygon shows the selling price ($000) of houses sold in the Billings, Montana, area.

    a. How many homes were studied?

    Number of homes

    b. What is the class interval?

    Class interval

    c. One hundred homes sold for less than what amount?

    Sold price $
    approximately.

    d. About 75% of the homes sold for less than what amount?

    Sold price $
    approximately.

    e. Estimate the number of homes in the $150,000 up to $200,000 class.

    Amount

    f. About how many homes sold for less than $225,000?

    Amount

    © BrainMass Inc. brainmass.com November 24, 2021, 6:10 pm ad1c9bdddf
    https://brainmass.com/statistics/variance/performing-basic-statistical-calculations-excel-610409

    Attachments

    Solution Summary

    The solution gives detailed steps on performing basic statistical calculations using excel such as class width, frequency, relative frequency, bar chart, class interval and midpoint of class. I suggest to click each cell for formula used for calculation.

    $2.49

    ADVERTISEMENT