3. [9 points] Using Excel or Minitab, construct one graph showing the probability density functions from...

Transcribed Image Text:

3. [9 points] Using Excel or Minitab, construct one graph showing the probability density functions from 0 to 15 for the following three distributions: a. Hypergeometric, where n = 9, N = 50, D = 20 b. Binomial, where n = 75 and p = 0.1 c. Poisson, where np = 6 4. [23 points] Visual data displays and assessing normality a. [2 points] Using Excel or Minitab, generate 100 data points that follow a normal distribution with mean equal to 450 and standard deviation equal to 25. i. In Excel, you can use either the Data Analysis ToolPak or the Excel function "-NORMINV(RAND(), 450, 25)" ii. In Minitab, you click on "Calc > Random Data > Normal: You should ask for 100 rows of data in a column with mean equal to 450 and standard deviation equal to 25. b. [2 points] Using Excel or Minitab, generate 100 data points that follow a uniform distribution. Set the upper and lower limits to 525 and 375 respectively. i. In Excel, you can use either the Data Analysis ToolPak or the Excel function "=375+ (150*RAND())" where range is the upper limit - lower limit ii. In Minitab, you click on "Calc > Random Data > Uniform: generate 100 rows of data in a column. You input the above designated lower and upper limits. c. [15 points] Use the Stem-and-Leaf Plot, Histogram, and Box Plot functions in Minitab to assess both the normal and uniform data sets. Include the graphs with your response. d. [4 points] Use the Normal Probability Plot function in Minitab - click "Graph > Probability Plot > Single to evaluate normality for both the normal and uniform data sets. Include both graphs with your response. 3. [9 points] Using Excel or Minitab, construct one graph showing the probability density functions from 0 to 15 for the following three distributions: a. Hypergeometric, where n = 9, N = 50, D = 20 b. Binomial, where n = 75 and p = 0.1 c. Poisson, where np = 6 4. [23 points] Visual data displays and assessing normality a. [2 points] Using Excel or Minitab, generate 100 data points that follow a normal distribution with mean equal to 450 and standard deviation equal to 25. i. In Excel, you can use either the Data Analysis ToolPak or the Excel function "-NORMINV(RAND(), 450, 25)" ii. In Minitab, you click on "Calc > Random Data > Normal: You should ask for 100 rows of data in a column with mean equal to 450 and standard deviation equal to 25. b. [2 points] Using Excel or Minitab, generate 100 data points that follow a uniform distribution. Set the upper and lower limits to 525 and 375 respectively. i. In Excel, you can use either the Data Analysis ToolPak or the Excel function "=375+ (150*RAND())" where range is the upper limit - lower limit ii. In Minitab, you click on "Calc > Random Data > Uniform: generate 100 rows of data in a column. You input the above designated lower and upper limits. c. [15 points] Use the Stem-and-Leaf Plot, Histogram, and Box Plot functions in Minitab to assess both the normal and uniform data sets. Include the graphs with your response. d. [4 points] Use the Normal Probability Plot function in Minitab - click "Graph > Probability Plot > Single to evaluate normality for both the normal and uniform data sets. Include both graphs with your response.