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.
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
Related questions
Question
Please follow the instructions on the second pic and answer the first pic questions showing the correct formulas in excel.

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.

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step 1: Describe the given information
VIEWStep 2: Determine the probability that a household views television less than 5 hours a day
VIEWStep 3: Determine the probability that a household views television more than 6 hours a day
VIEWStep 4: Determine the probability that a household views television between 5 and 10 hours a day
VIEWStep 5: Determine the watching hours needed for any household to be in the top 3% of all viewers
VIEWSolution
VIEWStep by step
Solved in 6 steps with 36 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman