An important quality characteristic of water is the concentration of suspended solid material. Following are 60 measurements on suspended solids from a certain lake. Construct a normal probability plot. Does it seem reasonable to assume that the concentration of suspended solids is normally distributed? 42.4 65.7 29.8 58.7 52.1 55.8 57.0 68.7 67.3 67.3 54.3 54.0 73.1 81.3 59.9 56.9 62.2 69.9 66.9 59.0 56.3 43.3 57.4 45.3 80.1 49.7 42.8 42.4 59.6 65.8 61.4 64.0 64.2 72.6 72.5 46.1 53.1 56.1 67.2 70.7 42.6 77.4 54.7 57.1 77.3 39.3 76.4 59.3 51.1 73.8 61.4 73.1 77.3 48.5 89.8 50.7 52.0 59.6 66.1 31.6

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...
icon
Related questions
Question

Please show the complete solution using Excel. Please answer in under 30 minutes thank you.

An important quality characteristic of water is the concentration of suspended solid material.
Following are 60 measurements on suspended solids from a certain lake.
Construct a normal probability plot. Does it seem reasonable to assume that the concentration of
suspended solids is normally distributed?
42.4 65.7 29.8 58.7 52.1 55.8 57.0 68.7 67.3 67.3
54.3 54.0 73.1 81.3 59.9 56.9 62.2 69.9 66.9 59.0
56.3 43.3 57.4 45.3 80.1 49.7 42.8 42.4 59.6 65.8
61.4 64.0 64.2 72.6 72.5 46.1 53.1 56.1 67.2 70.7
42.6 77.4 54.7 57.1 77.3 39.3 76.4 59.3 51.1 73.8
61.4 73.1 77.3 48.5 89.8 50.7 52.0 59.6 66.1 31.6
Transcribed Image Text:An important quality characteristic of water is the concentration of suspended solid material. Following are 60 measurements on suspended solids from a certain lake. Construct a normal probability plot. Does it seem reasonable to assume that the concentration of suspended solids is normally distributed? 42.4 65.7 29.8 58.7 52.1 55.8 57.0 68.7 67.3 67.3 54.3 54.0 73.1 81.3 59.9 56.9 62.2 69.9 66.9 59.0 56.3 43.3 57.4 45.3 80.1 49.7 42.8 42.4 59.6 65.8 61.4 64.0 64.2 72.6 72.5 46.1 53.1 56.1 67.2 70.7 42.6 77.4 54.7 57.1 77.3 39.3 76.4 59.3 51.1 73.8 61.4 73.1 77.3 48.5 89.8 50.7 52.0 59.6 66.1 31.6
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer