8. a) Using Excel's 'series fill' function make a column of data from -10 to 10 with each cell increasing in value by 0.1 b) Using Excel's normal distribution function, NORM.DIST(x,mean.stdev.cumulative), make 3 columns of values for the normal distribution using the column from part 'a' as x and the following values for and o (use FALSE for cumulative): a. = 0, o=1 b. = 0, o=2 %3D c. = 5, o=1 Plot all of these data series with respect to x in a single smooth line scatter plot in Excel (be sure to format the axes properly and include a legend, no title or caption is required). Describe in word the differences among the three curves

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
100%
8. a) Using Excel's 'series fill' function make a column of data from -10 to 10 with
each cell increasing in value by 0.1
b) Using Excel's normal distribution function,
NORM.DIST(x,mean.stdev.cumulative), make 3 columns of values for the normal
distribution using the column from part 'a' as x and the following values for <x>
and o (use FALSE for cumulative):
a. <x> = 0, 0=1
b. <x> = 0, o=2
c. <x> = 5, o=1
Plot all of these data series with respect to x in a single smooth line scatter
plot in Excel (be sure to format the axes properly and include a legend, no
title or caption is required). Describe in word the differences among the
three curves
Transcribed Image Text:8. a) Using Excel's 'series fill' function make a column of data from -10 to 10 with each cell increasing in value by 0.1 b) Using Excel's normal distribution function, NORM.DIST(x,mean.stdev.cumulative), make 3 columns of values for the normal distribution using the column from part 'a' as x and the following values for <x> and o (use FALSE for cumulative): a. <x> = 0, 0=1 b. <x> = 0, o=2 c. <x> = 5, o=1 Plot all of these data series with respect to x in a single smooth line scatter plot in Excel (be sure to format the axes properly and include a legend, no title or caption is required). Describe in word the differences among the three curves
Expert Solution
steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON