Homework Help is Here – Start Your Trial Now!
Math
Probability
As an engineer working for a water bottling company, you collect the following data in order to test the performance of the bottling systems. Assume the normal distrib --including answers submitted in WebAssign.) Milliliters of Water in the Bottle Frequency 485 490 495 500 505 510 515 What is the mean (in milliliters)? milliliters 500 What is the standard deviation (in milliliters)? 11.3557 x milliliters What is the z value corresponding to 495 milliliters? 2047025 x Referring to this table, determine the A value. A=0.1808 19 222 22 23 30 45 29 24 20 Determine the probability that a bottle would be filled with less than 495 milliliters. probability 0.6808 x

As an engineer working for a water bottling company, you collect the following data in order to test the performance of the bottling systems. Assume the normal distrib --including answers submitted in WebAssign.) Milliliters of Water in the Bottle Frequency 485 490 495 500 505 510 515 What is the mean (in milliliters)? milliliters 500 What is the standard deviation (in milliliters)? 11.3557 x milliliters What is the z value corresponding to 495 milliliters? 2047025 x Referring to this table, determine the A value. A=0.1808 19 222 22 23 30 45 29 24 20 Determine the probability that a bottle would be filled with less than 495 milliliters. probability 0.6808 x

A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
See similar textbooks
icon
Related questions
Question
100%

#9 I really need this fixed in excel if possible please. I'm not familiar with R coding yet. 

 

As an engineer working for a water bottling company, you collect the following data in order to test the performance of the bottling systems. Assume the normal distrib -including answers submitted in WebAssign.) Milliliters of Water in the Bottle Frequency Milliliters of Water in the bottle 485 x 485 490 495 500 505 510 515 #'s 490 495 What is the mean (in milliliters)? 500 ✔milliliters What is the standard deviation (in milliliters)? 11.3557 X milliliters Refer to tables in problem examples for A Mean Z A₂1 P 500 What is the z value corresponding to 495 milliliters? z = -0.47025 505 510 515 19 23 30 45 29 24 20 Referring to this table, determine the A value. A= 0.1808 X Determine the probability that a bottle would be filled with less than 495 milliliters. probability 0.6808 x 500.34 19 -0.470246702 23 0.1808 0.6808 30 45 Frequency (Mean) x*f xbar x-xbar (x-xbar)²*f 9215 500.34 -15.34 4472.092556 11270 500.34 -10.34 2459.953247 -5.34 856.0705676 -0.34 5.259697567 4.66 629.2442837 9.66 2238.702608 14.66 4297.209438 14850 500.34 22500 500.34 14645 500.34 12240 500.34 10300 500.34 29 24 20 standard deviation 11.3557 Answers I currently have in excel Milliliters of Water in the bottle 485 490 495 500 505 510 515 Refer to tables in problem examples for A #'s Frequency 19 23 30 45 29 24 20 Mean Z A₂1 Р (Mean) xf =A144 8144 =A145 B145 =A146*B146 =A147 B147 =A148 B148 =A149 8149 =A150 B150 500.34188034188 =(495-500.34)/F152 0.1808 20.510154 xbar x-xbar -SUM(C$52:C$58)/117-A144-D144 -SUM(C$52:C$58)/117=A145-D145 =SUM(C$52:C$58)/117-A146-D146 -SUM(C$52:C$58)/117=A147-D147 -SUM(C$52:C$58)/117=A148-D148 -SUM(C$52:C$58)/117-A149-D149 -SUM(C$52:C$58)/117=A150-D150 (x-xbar) f =E144^2 8144 =E145^2*8145 =E146^2 B146 =E147^2*B147 =E148^2*8148 =E149^2 8149 =E150^2*8150 standard deviation SQRT(SUM(F Formulas placed in
Transcribed Image Text:As an engineer working for a water bottling company, you collect the following data in order to test the performance of the bottling systems. Assume the normal distrib -including answers submitted in WebAssign.) Milliliters of Water in the Bottle Frequency Milliliters of Water in the bottle 485 x 485 490 495 500 505 510 515 #'s 490 495 What is the mean (in milliliters)? 500 ✔milliliters What is the standard deviation (in milliliters)? 11.3557 X milliliters Refer to tables in problem examples for A Mean Z A₂1 P 500 What is the z value corresponding to 495 milliliters? z = -0.47025 505 510 515 19 23 30 45 29 24 20 Referring to this table, determine the A value. A= 0.1808 X Determine the probability that a bottle would be filled with less than 495 milliliters. probability 0.6808 x 500.34 19 -0.470246702 23 0.1808 0.6808 30 45 Frequency (Mean) x*f xbar x-xbar (x-xbar)²*f 9215 500.34 -15.34 4472.092556 11270 500.34 -10.34 2459.953247 -5.34 856.0705676 -0.34 5.259697567 4.66 629.2442837 9.66 2238.702608 14.66 4297.209438 14850 500.34 22500 500.34 14645 500.34 12240 500.34 10300 500.34 29 24 20 standard deviation 11.3557 Answers I currently have in excel Milliliters of Water in the bottle 485 490 495 500 505 510 515 Refer to tables in problem examples for A #'s Frequency 19 23 30 45 29 24 20 Mean Z A₂1 Р (Mean) xf =A144 8144 =A145 B145 =A146*B146 =A147 B147 =A148 B148 =A149 8149 =A150 B150 500.34188034188 =(495-500.34)/F152 0.1808 20.510154 xbar x-xbar -SUM(C$52:C$58)/117-A144-D144 -SUM(C$52:C$58)/117=A145-D145 =SUM(C$52:C$58)/117-A146-D146 -SUM(C$52:C$58)/117=A147-D147 -SUM(C$52:C$58)/117=A148-D148 -SUM(C$52:C$58)/117-A149-D149 -SUM(C$52:C$58)/117=A150-D150 (x-xbar) f =E144^2 8144 =E145^2*8145 =E146^2 B146 =E147^2*B147 =E148^2*8148 =E149^2 8149 =E150^2*8150 standard deviation SQRT(SUM(F Formulas placed in
Expert Solution
steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer