Hello. I need help with creating a normal distribution for a pre-made dataset in excel? I mainly confused with the steps to complete the process.
Answers
Let's say your data is all in column A. Furthermore, we'll say we have 21 items in this column. Make sure this data column is sorted from smallest to largest. If this isn't done, then weird things will happen when it comes to connecting the dots later on.
Column B will be used later, but for now, let's move to cell C1. In this cell, type =AVERAGE(A1:A21)
The equal sign is important to tell Excel that we have a function here, and not just plain text. As the function implies, we're finding the average (aka mean) of values A1,A2,...,A20,A21. This computes the arithmetic mean.
In cell D1, type in =STDEV(A1:A21) to compute the sample standard deviation
There's nothing special about C1 or D1. We just need something off to the side. Think of it like scratch work.
-------------------------
Now move back to column B. In cell B1, type =NORMDIST(A1,$C$1,$D$1,FALSE)
The $C$1 and $D$1 refer to cells C1 and D1 respectively. The dollar signs lock in those rows and columns so they don't change. We don't want the mean and standard deviation to alter. The "False" at the end tells Excel that we don't want a cumulative normal distribution.
The first parameter A1 is the x value. Much like the curve y = x^2, we plug in various x values to find corresponding y values. We'll plot various (x,y) points to connect them with a curve. The more points, the more accurate the curve. Instead of the x^2 function, we're using the NORMDIST function.
Once cell B1 is filled out, click on the bottom right corner of the cell. You should see a very small square at this corner. Dragging this square down until you reach cell B21 will fill in the remaining 20 cells with the formula mentioned in bold; however, the A1 will change depending on what row you're on. Everything else stays the same hence the use of the dollar signs.
-------------------------
In figure 1 below, I'm showing an example of what I've discussed so far. Figure 1 shows the formulas in each cell. This is before they are evaluated.
Figure 2 shows what the formulas evaluate to. The data in column A can be anything you want. I randomly generated the data values between 2 and 17.
Once column B is figured out, you would insert a chart of (x,y) scatter points. Make sure to connect the dots so that a curve forms. This will complete the normal distribution graph. Again, the data in column A must be sorted or else the dots won't be connected properly.
To be perfectly honest, Excel doesn't really do a good job at drawing curves like this. In my opinion, programs like GeoGebra are better suited for the task. Though spreadsheet programs like Excel are still used in a lot of settings, which is why this is good practice.
Related Questions
5+ [14 + 5 - {6 (5 + 1 - 4)}]
simplify
Answers
Answer:
12
Step-by-step explanation:
1) 5+19−6(5+1−4)
2)5+19−6(6−4)
3)5+19−(6)(2)
4)5+19−12
5) 5+7
6) 12
A vault contains 3000 worth of nickels.
How many nickels are in the vault
Answers
Answer:
600 nickels
Step-by-step explanation:
$3,000 divided by 0.05 (value of 1 nickel) = 60,000 nickels
What is the value of X?
Answers
Answer:
The answer is 46'
Step-by-step explanation:
The first triangle is:85'+53'+Y=180' so y=42'
The second triangle with X is:92+42'+X=180' so X=46'
nmwmemdmenmrmrnrf
Adam and Paul an achieve the sales target of the company in 30 days, Paul and Charles In 40 days while Charles and Adam In 60 days. In how many days can
all three of them achieve the sales target together?
Answers
Answer:all three of them achieve the sales target together in 120 days.
Step-by-step explanation:
Given: Adam and Paul an achieve the sales target of the company in 30 days, Paul and Charles In 40 days while Charles and Adam In 60 days.
Then, the number of days taken by all of them to achieve the sales target together = [tex]\dfrac1{30}+\dfrac{1}{40}+\dfrac{1}{60}[/tex]
[tex]=\dfrac{1}{120}[/tex] [LCM(30,40,60)=120]
Thus, all three of them achieve the sales target together in 120 days.
Can y’all help me on question 28?!
Answers
Answer:
C. It the correct answer
In the expression below, the
3 is the
of x.
3x + 2
A. Coefficient
B. Constant
C. Operator
D. Variable
Answers
A) Coefficient is the correct answer.
Step-by-step explanation:
The 3 is a coefficient. The x is the variable.
HELP ME PLEASEEEEEEEEEEEEEEEEEEE
Answers
Set up an algebraic equation that could represent the following situation:
Nkateko sells bananas at the low but fixed price of R3/kg. In order to ensure that she makes a reasonable profit, she adds a certain fixed amount of money to any quantity of bananas purchased. A customer who bought 4 kg of bananas was observed paying R14.
Answers
Answer:
The profit for any purchased of bananas is R2.
Step-by-step explanation:
Cost of 1 kg banana = R 3
Banana purchased = 4 kg
So, the cost of 4 kg bananas = 4 x 3 = R 12
Amount paid = R 14
Profit = R 14 - R 12 = R 2
So, the profit on any purchased of bananas is R 2.
4. It was 68.7°F at midday, then it rose 9°F in the afternoon and dropped another 12.3°F by 7:00 p.m. What was the temperature at 7:00p.m.?
Answers
The temperature rose so you add the amount it rose to the starting temperature
68.7 + 9 = 77.7 degrees
It then dropped so mow you subtract t the amount it dropped:
77.7 - 12.3 = 65.4 degrees
The answer is 65.4 degrees
find the y-intercept for the parabola
defined by this same equation:
y = 2x2 – 8x + 5
Answers
Answer:
y=5
y int
x=0
y=2(0)^2-8(0)+5
y=5
note everything multiplied by 0 is 0
PLEASE HELP!!!! WHOEVER GETS IT RIGHT GETS BRAINLIEST !!!!
FIND THE VALUE OF Y=
Answers
Answer: 8 is the value for y.
since x=16 as answered in the previous question, then 10x-3+(3y-1)=180 being in a straight line.
Help again pleaseeeee
Answers
Hope it helps :)
PLS HELP ASAP !!! PLSSSSSSS
Answers
Answer:
Here is the answerStep-by-step explanation:
Does the answer help for you?
Find the area
76 sq meters
60 sq meters
30.5 sq meters
65 sq meters
Answers
Answer:
60 square meters
Step-by-step explanation:
Write an equation of a line that is parallel to 6x - 2y = -3 and passes through the point (1, 3).
Answers
Answer:
Step-by-step explanation:
hope this video link be helpfull to you
Which data set has an apparent negative, but not perfect, linear relationship between its two variables
Answers
please answer this , like ASAP
Answers
Answer:
let total be U and strawberry be S and.apple be A .
now
n[U]=200
n[S]=56% 0f 200=112
n[A]=44%of 200=88
n[A n S]=30%of 200=60
now
[tex] \bar {A U S}=?[/tex]
we have
n[U]=n[A] +n[B]-n[ A n B]+[tex] \bar{A U S}[/tex]
[tex] \bar{A U S}[/tex]=200-112-88+60=60
option C. 60 is a required answer.
Hope this help!!!
Have a nice day!!!
There is a mound of g pounds of gravel in a quarry. Throughout the day, 200 pounds of gravel are added to the mound. Two orders of 600 pounds are sold and the gravel is removed from the mound. At the end of the day, the mound has 1,400 pounds of gravel.
Write the equation that describes the situation. Then solve for g.
Answers
Answer:
g + 200 - 2*600 = 1400
g = 2400 pounds
Step-by-step explanation:
g + 200 - 2*600 = 1400
g + 200 - 1200 = 1400
g - 1000 = 1400
g = 2400
Determine algebraically whether the function is even, odd, or neither even nor odd.
f(x) = -3x^4 - 2x - 5
Neither
Even
Odd
Answers
Answer:
Neither
Step-by-step explanation:
Roderick has an Internet service that charges by the hour. This piecewise function shows the cost of the Internet service based on the number of hours that Roderick uses
the Internet.
when x 34
10
(10 + 2.50(x-4)
when x > 4
Last month, Roderick used the Internet for 7.5 hours. What was he charged?
Helppppp Plssssssss
Answers
Answer:
18.75 is the answer
Step-by-step explanation:
since the internet usage is more than 4 hrs, the second equation will be used. that is
cost = (10 + 2.50 (x - 4)) where x is the usage hours.
thus
[tex]cost = 10 + (2.5 \times (7.5 - 4)) \\ = 10 + (2.5 \times 3.5) \\ = 10 + 8.75 \\ = 18.75[/tex]
Find the volume of the parallelepiped with one vertex at the origin and adjacent vertices at (1, 4, 0), (-2, -5, 2), and (-2, 2, 1).
Answers
17 cubic units.
Step-by-step explanation:
The volume (V) of a parallelepiped with one vertex at the origin is given by the absolute value of the scalar vector product of the vectors at the adjacent vertices.
V = |(a x b) · c|
In this case,
a = (1,4,0) = i + 4k + 0j
b = (-2,-5,2) = -2i -5j + 2k
c = (-2,2,1) = -2i + 2j + k
First, let's calculate the cross product of vectors a and b. i.e a x b as follows:
(i) Arrange the vectors in a matrix form
a x b = | i j k |
| 1 4 0 |
| -2 -5 2 |
(ii) Calculate the determinant of the matrix
a x b = i(8 - 0) -j(2-0) + k(-5+8)
a x b = i(8) -j(2) + k(3)
a x b = 8i - 2j + 3k
Secondly, calculate the scalar product of the cross product found above and the vector c as follows;
(a x b) . c = (8i - 2j + 3k) · (-2i + 2j + k)
Multiply like terms
(a x b) . c = (8 * -2)(i.i) + (-2 * 2)(j.j) + (3 * 1)(k.k) [i.i = j.j = k.k = 1]
(a x b) . c = (-16) + (-4) + (3)
(a x b) . c = -16 - 4 + 3
(a x b) . c = -17
Thirdly, find the absolute value of the result found above. i.e
|(a x b) . c| = |-17|
|(a x b) . c| = 17
Therefore, the volume of the parallelepiped is 17 cubic units.
how do you find the rate of change for a function over a given interval
Answers
Step-by-step explanation:
Differentiate it. You will be given a value of x. Substitute into the differentiated equation use the formula for rate of change. You will find the answerFormula:
[tex]\frac{\alpha y}{\alpha x} =\frac{dy}{dx }[/tex]
please help! (listing BRAINLIST and giving points) :D
Answers
Answer:
x = 50 + 95 = 145
.........
Answer:
x = 145°
Step-by-step explanation:
Given,
Measure of the first angle = 50°
Measure of the second angle = 95°
We know,
Sum of 3 angles of a triangle is equals to 180°
∴ The third angle = 180° - (50+95)°
= 180° - 145°
= 35°
Again,
Straight angle = 180°
∴ x = 180° - 35°
= 145°
∴x = 145°
Andy is comparing how long two tablets can be used after being fully charged.
-
Tablet A Tablet B
(minutes) (minutes)
540
593
Mean
Median
580
589
NOR
21
13
MAD
6
2
Answers
Answer:
Part A: On average Tablet B's battery will last longer.
Part B: The MAD is lower in tablet B's battery life so Tablet B is more consistent.
Step-by-step explanation:
Help with number 4 I'm stuck on this algebra test with my kid and neither of us understand it
Answers
Answer:
a) x = 4
b) x = 8
c) y = -7
d) y = -10
Step-by-step explanation:
Solve by substitution on all
a)
3x + 2y = -5
3x +2 * -17/2 = -5
3x - 17 = -5
3x = -5+17
3x = 12
x = 12/3
x = 4
HELPP DONT SEND A FILE WHATS the surface area explain step by step too
Answers
Answer:6
Step-by-step explanation:
Which statement or inequalities describe the number line graph?
Answers
Answer:
Step-by-step explanation:
( - ∞ , - 3 ) ∪ [ - 1 , ∞ )
You get a $600 bonus from work and want to share with your two kids. How much money will each of the three of you get if you split it evenly?
Answers
Answer:
$200 each.
Step-by-step explanation:
You are sharing the $600 bonus with 2 of your kids, meaning that the money will be evenly divided between 3 people. Divide the total amount of money with the total amount of people:
$600/3 persons = $200/person
Each person obtains $200.
~
You measure 34 textbooks' weights, and find they have a mean weight of 69 ounces. Assume the population standard deviation is 8.2 ounces. Based on this, construct a 95% confidence interval for the true population mean textbook weight. Give your answers as decimals, to two places
Answers
Answer:
The 95% confidence interval for the true population mean textbook weight is between 66.24 and 71.76 ounces.
Step-by-step explanation:
We have that to find our [tex]\alpha[/tex] level, that is the subtraction of 1 by the confidence interval divided by 2. So:
[tex]\alpha = \frac{1 - 0.95}{2} = 0.025[/tex]
Now, we have to find z in the Z-table as such z has a p-value of [tex]1 - \alpha[/tex].
That is z with a pvalue of [tex]1 - 0.025 = 0.975[/tex], so Z = 1.96.
Now, find the margin of error M as such
[tex]M = z\frac{\sigma}{\sqrt{n}}[/tex]
In which [tex]\sigma[/tex] is the standard deviation of the population and n is the size of the sample.
[tex]M = 1.96\frac{8.2}{\sqrt{34}} = 2.76[/tex]
The lower end of the interval is the sample mean subtracted by M. So it is 69 - 2.76 = 66.24 ounces
The upper end of the interval is the sample mean added to M. So it is 69 + 2.76 = 71.76 ounces.
The 95% confidence interval for the true population mean textbook weight is between 66.24 and 71.76 ounces.
it says 10^-4
please help give brainliest
Answers
Answer:
jane is correct
Step-by-step explanation:
10⁻⁴ can be written as [tex]\frac{1}{10000}[/tex] and as 0.0001
