5. Television viewing reached a new high when the Nielsen Company reported a mean daily viewing time of 8.35 hours per household. (USA Today, November 11, 2009). Use a normal probability distribution with a standard deviation of 2.5 hours to answer the following questions about daily television viewing per household. (a) What is the probability that a household views television less than 5 hours a day? (b) What is the probability that a household views television more than 6 hours a day? (c) What is the probability that a household views television between 5 and 10 hours a day? (d) How many hours of television viewing must a household have in order to be in the top 3% of all television viewing households.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Please follow the instructions on the second pic and answer the first pic questions showing the correct formulas in excel.
A
5. Television viewing reached a new high when the Nielsen Company reported a mean
daily viewing time of 8.35 hours per household. (USA Today, November 11, 2009).
Use a normal probability distribution with a standard deviation of 2.5 hours to answer
the following questions about daily television viewing per household.
(a) What is the probability that a household views television less than 5 hours a day?
(b) What is the probability that a household views television more than 6 hours a
day?
(c) What is the probability that a household views television between 5 and 10 hours
a day?
(d) How many hours of television viewing must a household have in order to be in
the top 3% of all television viewing households.
Transcribed Image Text:A 5. Television viewing reached a new high when the Nielsen Company reported a mean daily viewing time of 8.35 hours per household. (USA Today, November 11, 2009). Use a normal probability distribution with a standard deviation of 2.5 hours to answer the following questions about daily television viewing per household. (a) What is the probability that a household views television less than 5 hours a day? (b) What is the probability that a household views television more than 6 hours a day? (c) What is the probability that a household views television between 5 and 10 hours a day? (d) How many hours of television viewing must a household have in order to be in the top 3% of all television viewing households.
Page
10
Unit 7, Chapter 6 Lab
Lab Instructions - Solve the 5 problems posted in the Excel file. Enter your calculation in the yellow highlighted cells. Submit one file following
standard naming convention of last name, first initial lab 5.
Normal Distributions - There are an infinite number of normal distributions. A normal distribution is defined by a particular function in which two
values have been determined: the mean and the standard deviation. The mean is any real number that indicates the center of the distribution. The
standard deviation is a positive real number that is a measurement of how spread out the distribution is. Once we know the values of the mean,
standard deviation and the random variable (x), you can calculate the z value to determine the probability.
The standard normal distribution has a mean of 0 and a standard deviation
of 1. Any normal distribution can be standardized to the standard normal distribution by a simple formula. This is why typically the only normal
distribution with tabled values is that of the standard normal distribution. This type of table is sometimes referred to as a table of z-scores.
Excel use of NORM DIST - Used to find (p) probability
To compute the cumulative probability given a z value use NORM.S.DIST. To compute the cumulative probability given x use NORM.DIST.
NORM INV- Used to find z value or x
To find the z given probability use NORM.S.INV. To find x given probability use NORM.INV
➤
Calculation Rule - apply the same as manual calculations
If solving for less than , simply use the formula
If solving for in-between x or z use formula and take the difference between the highest and lowest value
If solving for use 1 - formula
ZOON
Transcribed Image Text:Page 10 Unit 7, Chapter 6 Lab Lab Instructions - Solve the 5 problems posted in the Excel file. Enter your calculation in the yellow highlighted cells. Submit one file following standard naming convention of last name, first initial lab 5. Normal Distributions - There are an infinite number of normal distributions. A normal distribution is defined by a particular function in which two values have been determined: the mean and the standard deviation. The mean is any real number that indicates the center of the distribution. The standard deviation is a positive real number that is a measurement of how spread out the distribution is. Once we know the values of the mean, standard deviation and the random variable (x), you can calculate the z value to determine the probability. The standard normal distribution has a mean of 0 and a standard deviation of 1. Any normal distribution can be standardized to the standard normal distribution by a simple formula. This is why typically the only normal distribution with tabled values is that of the standard normal distribution. This type of table is sometimes referred to as a table of z-scores. Excel use of NORM DIST - Used to find (p) probability To compute the cumulative probability given a z value use NORM.S.DIST. To compute the cumulative probability given x use NORM.DIST. NORM INV- Used to find z value or x To find the z given probability use NORM.S.INV. To find x given probability use NORM.INV ➤ Calculation Rule - apply the same as manual calculations If solving for less than , simply use the formula If solving for in-between x or z use formula and take the difference between the highest and lowest value If solving for use 1 - formula ZOON
Expert Solution
steps

Step by step

Solved in 6 steps with 36 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman