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
A team of researchers want to measure the distance covered while driving compared to a car's driving speed. Which statement is correct?
a. The speed of the car is a confounding variable.
b. The speed of the car is an explanatory variable.
c. The speed of the car is a response variable.
d. The speed of the car is a dependent variable.
Answers
Answer:
b. The speed of the car is an explanatory variable
Step-by-step explanation:
In the scenario above, the variable which the researcher intends to measure is the a distance covered by a car using the speed information available. The measured variable is the dependent variable as it outcome depends on the variable with which it is being measured, this is called the independent or explanatory variable.
Therefore, car speed is the explanatory or independent variable
Distance is the dependent, response or measured variable.
HELP PLEASEEEEEEEEEEEEEEEEEEEEEEEEE
Answers
Answer:
The solution set to the absolute value is:
[tex]S = \{x \in \mathbb{R}| x \ge 0\}[/tex] or [tex]S = [0, +\infty)[/tex]
Negative real numbers are not included in the solution set, as for [tex]x < 0[/tex], [tex]|x| = - x[/tex].
Step-by-step explanation:
From Mathematics, we know that absolute values are defined by the following characteristics:
1) For [tex]x \ge 0[/tex], [tex]|x| = x[/tex]
2) For [tex]x < 0[/tex], [tex]|x| = - x[/tex]
Then, if [tex]|x| = x[/tex], then the solution set to the absolute value is:
[tex]S = \{x \in \mathbb{R}| x \ge 0\}[/tex] or [tex]S = [0, +\infty)[/tex]
Negative real numbers are not included in the solution set, as for [tex]x < 0[/tex], [tex]|x| = - x[/tex].
25 Points!!! Need to be Done Now Please. Priority
Use Newton's method to app a root of the equation 3x^7+2x^4+3=0
Let x1=1 be the initial approximation
Second approx. x2 is?
Third approx x3 is?
Answers
9514 1404 393
Answer:
x2 = .72413793x3 = .087249546Step-by-step explanation:
Modern graphing calculators have a derivative function available, so using a calculator to find the next value of x is pretty simple.
The Newton's Method iterator for finding the next approximation to the root (x') is ...
x' = x -f(x)/f'(x) . . . . . where f'(x) is the derivative of f(x).
The attachment shows the first 3 iterations (4 approximations). We observe that the starting point is pretty far from the root, and on the wrong side of some wiggles in the function, so convergence is pretty slow.
The desired approximations are shown above and in the table below.
__
Additional comment
To 12 significant figures, the only real root is −1.10305899649. When the calculator can interactively produce a next guess, you can type the next guess value into the iterator function even as it is showing you the next value. This lets you find the best-precision result as fast as you can type it.
For a calculator like a TI-84, the iterator function can make repeated use of "Ans" as an argument. It usually doesn't take more than 3 or 4 iterations to get a best-precision result, since the number of good decimal places is about doubled on each iteration. (Of course, you have to start with a better approximation than the one given in this problem.)
Pls help luv y’a thx
Answers
36 + 64 = 100, Right Triangle
2. 5^2 + 7^2 () 9^2
25 + 49 () 81
74 < 81, Not A Right Triangle
3. 8^2 + 15^2 () 17^2
64 + 225 = 289, Right Triangle
4. 9^2 + 12^2 () 15^2
81 + 144 = 225, Right Triangle
5. 7^2 + 24^2 () 25^2
49 + 576 = 625, Right Triangle
Hope this helps, luv y’a too, you’re welcome.
In the accompanying diagram, ABC is isosceles, BC is extended to D. AB = AC. and M
Answers
Answer:
m∠ACD = 130
Step-by-step explanation:
If ABC is an isosceles, AB = AC and m∠A = 80°, then m∠B and m∠C is equal to 50°.
This is because angles in a triangle adds up to 180°.
180° - 80° = 100°/2 = 50°
∴ m∠ACD = 130°, this is because the interior opposite angles in a triangle is supplementary to the opposite exterior angle:
50° + 80° = 130°
Or
Angles on a straight line adds up to 180°.
180° - 50° = 130°
help plssssssssssssssssssssssssssssss
Answers
Answer:
285 mi
Step-by-step explanation:
We can see that for every gallon, Josh drives 30 more miles. This means that he will drive 30*9.5 mi.
30*9.5 = 285
30*9.5= 285
Find the
volume of the
composite solid
Answers
Answer:
253.5 ft³
Step-by-step explanation:
Volume of a pyramid = [tex] \frac{1}{3} [/tex]× base area × height
Volume of a prism = base area × height
Volume of the pyramid
= [tex] \frac{1}{3} [/tex]× (6×6.5÷2) × 9
= [tex] \frac{1}{3} [/tex]× 19.5 × 9
= 58.5 ft³
Volume of the prism
= (6×6.5÷2) × 10
= 195 ft³
Volume of the solid
= 58.5 + 195
= 253.5 ft³
Answer:
A
Step-by-step explanation:
the base is 19.5 feet squared
(6 * 6.5 / 2)
multiplied by 10 gives you 195 feet cubed for the lower solid
19.5 * 9 / 3
gives you 58.5 feet cubed for the upper solid
just add both volumes together
one half plus one third
Answers
Answer:
0.83333333333
Step-by-step explanation:
One-half plus one-third equals 5/6 or 0.8333.
Given that:
Expression: 1/2 + 1/3
To add one-half (1/2) and one-third (1/3), to find a common denominator and then add the fractions together.
The least common denominator (LCD) of 2 and 3 is 6. To convert the fractions to have a common denominator of 6, multiply the numerator and denominator of 1/2 by 3, and the numerator and denominator of 1/3 by 2:
1/2 × 3/3 = 3/6
1/3 × 2/2 = 2/6
Now that the fractions have a common denominator of 6, add them:
3/6 + 2/6 = 5/6
3/6 + 2/6 = 0.8333
Therefore, one-half plus one-third equals 5/6 or 0.8333.
Learn more about Divisor here:
https://brainly.com/question/30925934
#SPJ6
a rope of length 18 m is used to form a sector of a circle of radius 3.5 m on a school field. What is the size of the angle of the sector?
Answers
Answer:
Perimeter of the sector = 2r + length of arc= 2(3.5)+11= 7+11=18 meters exactly the length of the rope.
Step-by-step explanation:
The perimeter of the sector is equivalent to the length of the rope which is 18 meters
Perimeter of the sector= 2 x radius + length of the arc
But length of arc= radius x central angle in radian
18= 2(3.5)+ 3.5(central angle in radians)
18=7+3.5 (central angle in radians)
18–7=3.5(central angle)
11=3.5(central angle)
central angle =11/3.5=3.14 radians or pi radians
Angle in degrees =pi radians x 360 degrees/2pi radians =pi radians x 180 degrees/pi radians = 180 degrees
Therefore the central angle = 180 degrees because pi radians is half of 2pi radians which is half of 360 degrees
Notes: This sector shape is a semicircle because the central angle is 180 degrees
Check: Length of Arc for semicircle =3.5(pi radians)=11 meters
Perimeter of the sector = 2r + length of arc= 2(3.5)+11= 7+11=18 meters exactly the length of the rope.
how can i solve the following
2(x + 3) = x - 4
Answers
Answer:
x=-10
Step-by-step explanation:
2(x+3)=x-4
2*x+2*3=x-4
2x+6=x-4
2x-x=-4-6
x=-10
Answer:
[tex]x = - 10[/tex]
Step-by-step explanation:
Let's solve:
[tex]2(x+3)=x−4[/tex]
Step 1: Simplify both sides of the equation.
[tex]2(x+3)=x−4 \\ (2)(x)+(2)(3)=x+−4(Distribute) \\ 2x+6=x+−4 \\ 2x+6=x−4[/tex]
Step 2: Subtract x from both sides.
[tex]2x+6−x=x−4−x \\ x+6=−4[/tex]
Step 3: Subtract 6 from both sides.
[tex]x+6−6=−4−6 \\ x=−10[/tex]
Paulette had two books One of the books weighed 7/8 pound and the other book weighed 2/3 pound If both books were put on sale how much will they weigh together
Answers
A bicycle has a listed price of 593.98 before tax. If the sales tax rate is 9.5%, find the total cost of the bicycle with sales tax included. Round your answer to the nearest cent, as necessary.
Answers
Answer:
the answer is in
Step-by-step explanation:
How does a pedometer help people reach their fitness goals?
A.
It measures calories burned throughout the day
B.
It usually doubles as an MP3 player and keeps people motivated.
C.
They help people reach their goals by counting the number of steps taken.
D.
They measure the number of lifts done during each exercise performed.
Answers
Answer:
C
Step-by-step explanation:
pedometers are devices that count the steps you take throughout the day. Seeing your daily step count can give you an idea of how active you are in a given day and give motivating feedback to help you achieve a daily step goal.
Answer:c i just took the test
Step-by-step explanation:
Help, please
no links
Answers
9514 1404 393
Answer:
4/10 and 10/25
Step-by-step explanation:
If each of the ratios reduces to the same lowest terms, then they are a proportion. All are in lowest terms except the first pair. Reducing those gives ...
4/10 = 10/25 = 2/5
4/10 and 10/25 form a proportion
__
All of the other pairs are pairs of different ratios, so do not form a proportion.
name an outcome that has a probability between 0.5 and 1
Answers
Answer:
a coin flip
Step-by-step explanation:
The probability of an event is a number describing the chance that the event will happen. An event that is certain to happen has a probability of 1. An event that cannot possibly happen has a probability of zero.
Find the surface area of
the prism.
Answers
Answer:
[tex]\text{D. }464\:\mathrm{ft^2}[/tex]
Step-by-step explanation:
The surface area of the prism consists of four rectangles and two trapezoids. The sum of the areas of these polygons will give the total surface area of the prism:
Rectangle 1 (top base): [tex]12\cdot 14=168[/tex]
Rectangle 2 (bottom base): [tex]6\cdot 14 = 84[/tex]
Trapezoids 1 and 2 (lateral): [tex]2\cdot 9 \cdot 4=72[/tex]
Rectangles 3 and 4 (lateral): [tex]2\cdot 14\cdot 5=140[/tex]
Thus the total surface area is equal to
[tex]168+84+72+140=\boxed{\text{D. }464\:\mathrm{ft^2}}[/tex]
Name two numbers that are 14 units from 2 on the number line
Answers
Answer:
12 and 12.5
Step-by-step explanation:
What is the answer to this
Answers
Answer:
x = 25
Step-by-step explanation:
3x-15 = 2x+10
x-15 = 10
x = 25
Answer:
x = 25 degree
Step-by-step explanation:
3x - 15 = 2x + 10 (their relation will be alternate interior angles if they [tex]l_{1}[/tex] and [tex]l_{2}[/tex] are parallel)
3x - 2x = 10 + 15
x = 25 degree
A cylinder of radius 12cm and height 9cm.
Answers
What do you want me to find?
Find the radius of the sphere with the given volume.
Answers
Answer:
see below
Step-by-step explanation: 6 5 17 43
Volume of a sphere = 121.5 π mm³ Find r
Vol Sphere = (4π r³) / 3 solve for r
Vol Sphere × 3 = (4π r³)
(Vol Sphere × 3) / 4π = r³
∛((Vol Sphere × 3) / 4π) = r
∛((121.5 π mm³× 3) / 4π) = r the pi terms cancel
∛((121.5 mm³× 3) / 4) = r
∛((364.5 mm³) / 4) = r
∛((91.125 mm³) ) = r
4.5 = r
Madison and Aidan roll two number cubes. Which of the following rules will make the game fair?
Madison wins if a total of 5 is rolled. Aidan wins if a total of 10 is rolled.
Madison wins if a total of 8 is rolled. Aidan wins if a total of 6 is rolled.
Madison wins if a total of 9 is rolled. Aidan wins if a total of 7 is rolled.
Madison wins if a total of 2 is rolled. Aidan wins if a total of 11 is rolled.
Answers
Answer:
If I understand this right I think it would be 8 and 6?
Step-by-step explanation:
Sorry if this is wrong I'm really bad at math, please tell me if this is right.
0,-2,-4,-6,-8,-10 nth term
Answers
Answer:
The nth term of this sequence is [tex]a_{n} = -2n + 2[/tex]
Step-by-step explanation:
In this sequence we keep adding -2 on to get the next term. This sequence is called an arithmetic sequence, a sequence that uses addition to keep increasing.
The formula for the nth term of an arithmetic sequence is
[tex]a_{n} = d[/tex] · [tex]n + a_{1} - d[/tex]
[tex]a_{1}[/tex] stands for the first term in the sequence, and [tex]d[/tex] stands for the difference between each number in the sequence.
[tex]a_{1} = 0[/tex] and [tex]d[/tex] = -2, so :
[tex]a_{n} = -2[/tex] · [tex]n + 0 - (-2)\\[/tex]
[tex]a_{n} = -2n + 2[/tex]
Therefore, to find the nth term in this sequence you would use the formula
[tex]a_{n} = -2n + 2[/tex]
which statement is true?
Answers
Answer:
The y-intercept of Function A is less than the y-intercept of Function B.
Step-by-step explanation:
Function A's y-intercept would be (0, -1) and Function B's y-intercept is (0, 4). Therefore, Function A's y-intercept is less than Function B's.
The probability that he or she is a female given that the person is married
Answers
Answer:
3 /4
Step-by-step explanation:
The probability that selected person is a female Given she is married :
This is a conditional probability in the form ; A given B
P(A|B) = P(AnB) / P(B)
Let, Female = F ; Married = M
P(F|M) = P(FnM) / P(M) = 150 / 200 = 3 / 4
The party planning committee has to determine the number of tables needed for an upcoming event. If a square table can fit 8 people and a round table can fit 6 people, the equation 150 = 8x + 6y represents the number of each type of table needed for 150 people.
The variable x represents the number of
Answers
Answer:
Square tables used
Step-by-step explanation:
x represents the number of square tables used since it is being multiplied times 8 which is the number of people a square table can fit
Answer:
answer in pictures
Step-by-step explanation:
What is the value of
[tex] \frac{ - 2(7 - 15)}{4} [/tex]
○-4
○-2
○2
○4
Answers
Answer:
4
Step-by-step explanation:
Based on your math expression:
7-15 = -8
-2*(-8) = 16
16 / 4 = 4
Answer:
4
Step-by-step explanation:
-2(7-15)
=-14+30
=16÷4
=4
What is the production matrix?
Answers
Answer:
[tex]\left[\begin{array}{ccc}3\\3.8\end{array}\right][/tex]
Step-by-step explanation:
Here we want to compute the product of two matrices, one 2x2, and other 2x1.
[tex]\left[\begin{array}{ccc}0.3&0.3\\0.35&0.4\end{array}\right]*\left[\begin{array}{ccc}4\\6\end{array}\right][/tex]
Remember that in the product, we multiply the rows of the first one by the columns of the second one, then the product is just:
[tex]\left[\begin{array}{ccc}0.3&0.3\\0.35&0.4\end{array}\right]*\left[\begin{array}{ccc}4\\6\end{array}\right] = \left[\begin{array}{ccc}0.3*4 + 0.3*6\\0.35*4 + 0.4*6\end{array}\right] = \left[\begin{array}{ccc}3\\3.8\end{array}\right][/tex]
Find the area of the figure.
1 in
1 in
5 in
3 in
3 in
PLEASE HELP ITS URGENT ITS DUE BY 8
Answers
Answer:
It is 4
Step-by-step explanation:
1 times 1 for square
3 times 3 then divide by 2 = 3
add together
4
Answer:
a = 5.5 in²
Step-by-step explanation:
square
a = lw
a = 1 * 1
a = 1
Triangle
a = (1/2)bh
a = (1/2) * 3 * 3
a = 4.5
combined figure
a = 1 + 4.5
a = 5.5 in²
What is the mean of 43,69,48,37,85,57,95,102
Answers
The mean of 43,69,48,37,85,57,95,102 is 67
Find the equation of a sphere if one of its diameters has endpoints: (-14. -3, -6) and (-4, 7, 4) Note that you must move everything to the left hand side of the equation and that we desire the coefficients of the quadratic terms to be 1.
Answers
Answer:
[tex]x^2+y^2+z^2-18x-4y+2z-21=0[/tex]
Step-by-step explanation:
From the question we are told that:
Diameters has endpoints: [tex](-14. -3, -6) & (-4, 7, 4)[/tex]
Generally the equation for Center of The sphere is mathematically given by
[tex]C=(\frac{-14+(-4)}{2},\frac{-3+(7)}{2},\frac{-6+(4)}{2})[/tex]
[tex]C=(9,2,-1)[/tex]
Generally the equation for Radius of the sphere is mathematically given by
[tex]R=\sqrt{(9-2)^2+(2-9)^2+(-1-2)^2}[/tex]
[tex]R=\sqrt{107}[/tex]
Therefore the Equation of the Sphere is
[tex](x-9)^2+(y-2)^2+(z+1)^2=107[/tex]
[tex](x^2-18x+81)+(y^2-4y+4+(z^2+2z+1))=107[/tex]
[tex]x^2+y^2+z^2-18x-4y+2z-21=0[/tex]