Use Excel's Analysis ToolPak, with a seed of 1, to simulate 906 random observations of a normally distributed random variable with H= 8.08 and o= 0.36. Report the mean and standard deviation of the 906 observations, How many of the 906 observations have a value less than 8? (Round your answers to 2 decimal places.) Mean Standard deviation Number of observations

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

Pls help with below homework.

Use Excel's Analysis ToolPak, with a seed of 1, to simulate 906 random observations of a normally distributed random variable with
H= 8.08 and o= 0.36. Report the mean and standard deviation of the 906 observations. How many of the 906 observations have a
value less than 8? (Round your answers to 2 decimal places.)
Mean
Standard deviation
Number of observations
Transcribed Image Text:Use Excel's Analysis ToolPak, with a seed of 1, to simulate 906 random observations of a normally distributed random variable with H= 8.08 and o= 0.36. Report the mean and standard deviation of the 906 observations. How many of the 906 observations have a value less than 8? (Round your answers to 2 decimal places.) Mean Standard deviation Number of observations
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer