Purchase Solution

Normal Distribution using Excel

Not what you're looking for?

Ask Custom Question

I would like the response to sample problems below in excel format.

6.48
An orange juice producer buys all his oranges from a large orange grove. The amount of juice squeezed from each of these oranges is approximately normally distributed, with a mean of 4.70 ounces and a standard deviation of 0.40 ounce.

A. What is the probability that a randomly selected orange will contain between 4.70 and 5.00 ounces of juice?
B. What is the probability that a randomly selected orange will contain between 5.00 and 5.50 ounces of juice?
C. 77% of the oranges will contain at least how many ounces of juice?
D. 80% of the oranges contain between what two values (in ounces of juice), symmetrically distributed around the population mean?

6.53
The same article mentioned in Problem 6.52 also reported that the mean download time for H&R Block Web site, www.hrblock.com, is 2.5 seconds. Suppose that the download time is normally distributed, with a standard deviation of 0.5 second. What is the probability that a download time is

a. less than 1 second?
b. between 0.5 and 1.5 seconds?
c. above 0.5 second?
d. Above how many seconds are 99% of the download times?

Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of probability using the Z score. Formula for the calculation and Interpretations of the results are also included.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

Measures of Central Tendency

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

View More Free Quizzes
Related BrainMass Solutions

  • Important information about Normal distribution problems

    Area under a normal distribution can be extracted from normal tables and / or using excel (nowadays since the functionality is available in excel, most people use that).

  • Using EXCEL for Standard Normal Distribution Probabilities

    13483 Using EXCEL for Standard Normal Distribution Probabilities Please see the attached file for the full problem description. Let Z be a standard normal random variable.

  • Typical Seasonal Demand for Summer Highs

    Compute the standard deviation in Microsoft Excel using the data (raw data from years 1-4) 2. Generate a normal distribution of the data using Microsoft Excel. 3. Compare the range with the standard deviation of the data.

  • Plot standard normal distribution formula in excel

    Graph of the standard normal distribution ploted in excel. See attachment. This solution plots the standard normal distribution formula in excel.

  • Probability / Normal Distribution - Using excel

    380392 Probability / Normal Distribution - Using excel Please show example by using Excel Assume an examination has a mean of 84.2 and a standard deviation of 10.9 What is the probability of being above 100?

  • Normal distribution

    Ans: A) 0.6443 Explanation: Using the Excel function =NORMSDIST(0.37) we get P(z < 0.37) as 0.6443 4) Find the area under the standard normal distribution curve between z = -2.05 and z = 2.05.

  • Normal Distribution Curve/Chart Statistics

    477642 Normal Distribution Curve/Chart Statistics I need to know how to solve this question using the normal distribution curve / chart and how to answer using Excels Fx statistics function The first statistics exam had a mean of 65 and a standard

  • Frequency Distribution and a Z-scores using Microsoft Excel

    This solution is comprised of a detailed explanation of standard normal distribution or z score using the Microsoft Excel.

  • Using EXCEL to Create Plots of Normal Distributions

    It describes how to use the Excel sheet that is also attached. The Excel sheet can be used to create a plot of any gaussian distribution. This solution contains an Excel sheet that can be used to plot any normal (gaussian) distribution.

  • Tax preparation fee

    For Normal Distributions, P(x> 'Value') we calculate z = (value - mean) / std dev and then probability can either be looked up on normal table or using excel (i have done the problems using excel) Please see the attached file.

View More Related Solutions