use the Excel to write the function of the following questions.
A Nielsen study indicates that the average American watches 15 hours per week streaming content on Netflix, Hulu, and Amazon. Assume that the amount of time streaming videos a week is normally distributed and the standard deviation is 2.5 hours. Reference the hours watched or percentage in the correct formula or function to answer each question. IMPORTANT: For many of the following questions there is more than one way to compute the correct answer. If you choose a method that requires computation of a z-score first, compute the z-score to the right of the gray column. If not, leave those cells blank. (Z-scores in that table will not be graded; only the answers will be grade.) Show all answers to 2 decimal places. If used, reference ALL values to calculate z-scores and reference those Z-scores to calculate your answers. 15.00 Population Mean Population Standard Deviation 2.50 Questions Percentile) Answers Hours Watched 19 10% 15 15% 84% 21 1. If an American watches this many hours, how many standard deviations are they from the mean? 2. How many hours is the bottom 10%? 3. What is the median? (reference answer value) 4. What percentage of Americans watch this many hours or less? 5. How many hours watched is at the top 15%? 6. How many hours watched is this percentile? 7. What percentage of Americans view this many hours or more? 8. What percentage of Americans watch between these hours? 9. How many hours watched is this percentile or above? 10. How many hours watched is equal to this percentile? 11. What percentage of Americans watch less than the first amount and more than the second? 12. What percentage of Americans watch between these number of hours? 13. How many hours watched is this percentile or greater? 14. What percentage of Americans watch this many hours or less? 18 21 58% 25% 9 19 10 16 75% 13 15. Your answers for #10 and #13 above should be the same. Why does this make sense? A. The population mean is the same, so every percentile will result in the same number of hours. B. The number of hours is the dividing point between the top and bottom percentiles, which add to 100%. C. The population standard deviation is the only factor that drives the number of hours. A Nielsen study indicates that the average American watches 15 hours per week streaming content on Netflix, Hulu, and Amazon. Assume that the amount of time streaming videos a week is normally distributed and the standard deviation is 2.5 hours. Reference the hours watched or percentage in the correct formula or function to answer each question. IMPORTANT: For many of the following questions there is more than one way to compute the correct answer. If you choose a method that requires computation of a z-score first, compute the z-score to the right of the gray column. If not, leave those cells blank. (Z-scores in that table will not be graded; only the answers will be grade.) Show all answers to 2 decimal places. If used, reference ALL values to calculate z-scores and reference those Z-scores to calculate your answers. 15.00 Population Mean Population Standard Deviation 2.50 Questions Percentile) Answers Hours Watched 19 10% 15 15% 84% 21 1. If an American watches this many hours, how many standard deviations are they from the mean? 2. How many hours is the bottom 10%? 3. What is the median? (reference answer value) 4. What percentage of Americans watch this many hours or less? 5. How many hours watched is at the top 15%? 6. How many hours watched is this percentile? 7. What percentage of Americans view this many hours or more? 8. What percentage of Americans watch between these hours? 9. How many hours watched is this percentile or above? 10. How many hours watched is equal to this percentile? 11. What percentage of Americans watch less than the first amount and more than the second? 12. What percentage of Americans watch between these number of hours? 13. How many hours watched is this percentile or greater? 14. What percentage of Americans watch this many hours or less? 18 21 58% 25% 9 19 10 16 75% 13 15. Your answers for #10 and #13 above should be the same. Why does this make sense? A. The population mean is the same, so every percentile will result in the same number of hours. B. The number of hours is the dividing point between the top and bottom percentiles, which add to 100%. C. The population standard deviation is the only factor that drives the number of hours
