1 4 6. E (J) 1.99*10^6 6.3*10^7 1.99*10^9 6.3*10^10 1.99*10^12 6.3*10^13 1.99*10^15 5. In a spreadsheet, create a scatter plot of the points in your table. Adjust the viewing window so that all seven points are clearly visible. What do you see? Does your graph seem to convey the information in a good way? Why or why not? (Show your plot to your
Continuous Probability Distributions
Probability distributions are of two types, which are continuous probability distributions and discrete probability distributions. A continuous probability distribution contains an infinite number of values. For example, if time is infinite: you could count from 0 to a trillion seconds, billion seconds, so on indefinitely. A discrete probability distribution consists of only a countable set of possible values.
Normal Distribution
Suppose we had to design a bathroom weighing scale, how would we decide what should be the range of the weighing machine? Would we take the highest recorded human weight in history and use that as the upper limit for our weighing scale? This may not be a great idea as the sensitivity of the scale would get reduced if the range is too large. At the same time, if we keep the upper limit too low, it may not be usable for a large percentage of the population!
The given data is:
| M | E(J) | E(J) |
| 1 | 1.99*10^6 | 1990000 |
| 2 | 6.3*10^7 | 63000000 |
| 3 | 1.99*10^9 | 1.99E+09 |
| 4 | 6.3*10^10 | 6.3E+10 |
| 5 | 1.99*10^12 | 1.99E+12 |
| 6 | 6.3*10^13 | 6.3E+13 |
| 7 | 1.99*10^15 | 1.99E+15 |
To make a scatter plot in the EXCEL spreadsheet
1. Open an EXCEL spreadsheet.
2. Select column A, enter the values of M.
3. Select column B enter the values of E(J)
4. The values of E(J) have mathematical operators in them, so we select column C and in the cell adjacent to cell 2 of column B i.e., C2, and enter the value of B2 in C2 with an '=' sign before it and then press ENTER. We get the mathematical value equivalent to the value given in formula form in B2. Similarly, we get the other values of column C.
5. Now Select columns A and C, go to "Insert" < chats< scatter plot.
6. we get the scatter plot as
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
