Purchase Solution

Calculating Probability in Excel

Not what you're looking for?

Ask Custom Question

How would you solve this:

A cola dispensing machine is set to dispense on average 7.00 ounces of cola per cup. The standard deviation is 0.10 ounces. The distribution amounts dispensed follows a normal distribution.
a. What is the probability that the machine will dispense between 7.10 and 7.25 ounces of cola.
b. What is the probability that the machine will dispense 7.25 ounces of cola or more.
c. What is the probability that the machine will dispense between 6.80 and 7.25 ounces of cola.

Purchase this Solution
Solution Summary

This solution gives calculations for probability in Excel.

Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

View More Free Quizzes
Related BrainMass Solutions

  • A PERT problem: calculating variance of critical path

    What is the likelihood (probability) of completing the project in 42 weeks? Hi The attached excel file contains the solution procudure for the above stated PERT problem.

  • calculating probability using classical probability model

    561897 The solution gives detailed steps on calculating probability using classical probability model. I would like to have the response to the following problems in excel format so that I can see the formulas used. Thank you 33.

  • Calculating mean profit and probability

    Please see the attached file Simulation utilizing Excel functions has been used for calculating mean profit and probability.

  • Simple Probability with Contagious Diseases

    This solution addresses the binomial probability questions by calculating the probability that at least 3 of the families will be quarantined. All workings are shown in an Excel file.

  • Probability of Loss

    This option is highlighted in yellow in the Excel table. This solution calculates the optimal level of safety expenditures given the probability of loss.

  • Calculating Expected Return from a Stock's Distribution

    Please refer to the EXCEL for calculation expected return = SUM(Return Rate*Probability) = 23.4% Variance = SUM[(Return Rate-Expected rate)^2 *Probability]] = 0.0295 Standard deviation = SQRT(Variance) = 17.2% coefficient of variation = Standard deviation

  • Finance : Expected Return and Risk

    (Excel: Calculating means, standard deviations, covariance, and correlation) Given the probability distributions of returns for stock X and stock Y, compute: a.

  • Probability Problem for Job Satisfaction

    The solution includes a word document that explains the steps of calculating probabilities, while the excel sheet shows calculations

  • Salary: Calculating Descriptive Statistics and Percentiles

    631681 Salary: Calculating Descriptive Statistics and Percentiles Refer to the Excel file Salary (attached to the assignment) to address all the questions below: What is the probability for: a.)

View More Related Solutions