Purchase Solution

Dave's Bottling Company

Not what you're looking for?

Ask Custom Question

Dave's Bottling Company has a filling machine that can be set to 8 ounces, twelve ounces or 24 ounces. The standard deviation of the fill volumes is supposed to be no more than .05 ounces. The production manager, Charlene Tibbs, is afraid the machine needs servicing and wants to test the production. The machine was set for 12 ounces and then produced 12,000 cans of Coca Cola Zero sugar. Charlene had the Quality Department take a random sample of 100 cans and carefully measure the volume of soda in each can. These data are in the file Dave's bottling, which is attached. Charlene asks you to provide her with:
1. A frequency distribution and histogram of the sample fill volumes.
2. Calculate the mean fill volume and the standard deviation of the fill volumes.

Do all your calculations and charts in Excel and title that file "YourNameExcelDavesBottling." In that document produce a report to Mrs. Tibbs that includes:
The frequency distribution and histogram of the data
The mean and standard deviation of the sample.

Attachments
Purchase this Solution
Solution Summary

The Excel file contains the computations needed for the frequency distribution, histogram, mean and standard deviation. The Word file contains the report.

Solution provided by:
J Pye, MSc
Education
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Inventory Cost Flows and Net Income

    Answers are given below the questions The solution examines inventory cost flows for Dave's electronics.

  • Dave's Company

    268736 Dave's Company Adjusting Entries Adjusting Journals Selected general ledger information for Dave's Company's October 31 month end is presented below.

  • Accounting- Bella Company

    Management also believes that the new bottling machine will save the company money because it is expected to be more reliable than other machines, and thus will reduce downtime.

  • General Ledgers: DAVE'S WILDLIFE RESORT

    The expert examines general ledger accounts for Dave's Wildlife resorts.

  • The production function

    Thus for every 3 units of bottling line hours used, the company should hire 4 labor hours. The company has 20 lines and so total hours of bottling available per week are 120*20 = 2400 hours.

  • Alternative performance measure to manager of plant A happier

    The parent company supplies each plant with the syrup. The bottling plants combine the syrup with carbonated soda to make and bottle the soft drinks.

  • Journal Entries

    Date Transaction Debit Credit Dave invested additional cash along with Example equipment into his business, Dave's 7 & 11 12 Automotive Supplies.

  • Hypothesis Testing:Crown Bottling Company

    441772 The Crown Bottling Company 2 The Crown Bottling Company has just installed a new bottling process that will fill 16-ounce bottles of the popular Crown Classic Cola soft drink.

  • Net cash flow

    Dave's Aquariums recently reported $15,000 of sales, $10,000 of operating costs other than depreciation, and $2,500 of depreciation.

View More Related Solutions