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
Rewrite 14/32 in simplest form.
Answers
Answer:
7/16
Step-by-step explanation:
Answer:
14/32 = 7/16
Step-by-step explanation:
You divide each number by two
What is the answer to this??
Answers
blue line: y is less than or equal to -x -10
Direction: Analyze and solve each problem.
1. Annie bought 3 apples for Php 51.00. How much would 5 apples cost?
2. In a table ternis match, Adonis scores 2 points for every 3 that Lexus makes. What is Adonis final score if Lexus score is 217?
pls help me.. i dont know what this is.. answer this if u know it pls..
Answers
Answer:
\(5 \ apples = 85.00\)
\(Adonis = 144.67\)
Step-by-step explanation:
Solving (a):
\(3\ apples = 51.00\)
Required
The cost of 5
Divide through by 3, to get the cost of 1
\(1\ apple = 17.00\)
Multiply through by 5, to get the cost of 5
\(5 * 1\ apple = 17.00*5\)
\(5 \ apples = 85.00\)
Solving (b):
\(Adonis : Lexus = 2 : 3\)
\(Lexus= 217\)
Required
Find Adonis' final score
Substitute 217 for Lexus
\(Adonis : 217 = 2 : 3\)
Express as fraction
\(\frac{Adonis}{217} = \frac{2}{3}\)
\(Adonis = \frac{2}{3} * 217\)
\(Adonis = \frac{2 * 217}{3}\)
\(Adonis = \frac{434}{3}\)
\(Adonis = 144.67\)
In a school, 1600 children have opted for digital learning while 400 students have decided to do face to face learning. What percent of the school population have decided to opt for face to face learning?
Answers
The percentage of the school population who have decided to opt for face-to-face learning is 20%.
What is the percentage?The percentage is the ratio of a value to another value.
Percentages are fractional values that show how much a value or number is contained in the whole.
Percentages are expressed over 100 with the percent sign (%).
The number of students opting for digital learning = 1,600
The number of students opting for face-to-face learning = 400
The total number of students in the school (population) = 2,000
The percentage of the school population opting for face-to-face learning = 20% (400/2,000 x 100)
Thus, expressing the percentage of students choosing in-class learning shows only 20% of the school population.
Learn more about percentages at https://brainly.com/question/24877689
#SPJ1
10 cm
15 cm
7 cm
6 cm
2 cm
Find the perimeter of an irregular shape
Answers
The perimeter of the irregular shape is 40 cm.
We know that a polygon is defined as a closed figure made up of three or more line segments connected end to end.
Given that the parameters as :
10 cm
15 cm
7 cm
6 cm
2 cm
Perimeter ; the sum of length of the sides used to made the given figure..
Let Perimeter = p
Perimeter P = 10 + 15 + 7 + 6 + 2
= 40 cm
The answer will be 40 cm.
Learn more about perimeter here:
https://brainly.com/question/10466285
#SPJ1
Graph the line with slope 1/3 and y-intercept −2.
Answers
The graph of the function y = 1/3x - 2 is added as an attachment
Sketching the graph of the functionFrom the question, we have the following parameters that can be used in our computation:
Slope = 1/3y-intercept = -2So, the equation is
y = 1/3x - 2
The above function is a linear function that has been transformed as follows
Vertically stretched by a factor of 1/3Shifted down by 2 unitsNext, we plot the graph using a graphing tool by taking note of the above transformations rules
The graph of the function is added as an attachment
Read more about functions at
brainly.com/question/2456547
#SPJ1
Are lines JN and KM parallel?
Answers
Answer:yes
Step-by-step explanation:
Answer:
yes
Step-by-step explanation:
if you remove the triangle, they will continuously go on both sides with one on the other.
GEOMETRY PLEASE HELP. Can you see triangles in this baseball player’s posture? Find how players improve using the properties of geometry to evaluate their positions and postures. Choose at least three examples and explain how the concepts you learned about in this Unit relate to the examples you find. For example, you might look for certain triangles formed in golf or baseball swings, or you could look for the triangles formed by players on a soccer field.
Answers
Therefore , the solution to the given problem of trigonometry comes out to be Additionally, the symmetry of these basketball courts, tennis courts, and soccer fields is mirror imaged.
What is trigonometry?Trigonometry is the discipline of mathematics that studies correlations between angles and sides of triangles. Trigonometry is present in all of geometry because every straight-sided form may be reduced to a set of triangles. Amazingly intricate connections exist between trigonometry and other areas of mathematics, particularly calculus, real or complex, infinite series, logarithms, and infinite series.
Here,
Geometry has a wide variety of shapes depending on the size. The 2-d shapes include a variety of polygonal forms and the following: circle, triangle, square, rectangle, kite, trapezium, parallelogram, and rhombus.
The fundamental shapes in three dimensions are cube, cuboid, sphere, cone, and cylinder.
Many sports use geometric forms to help delineate the precise areas of play.
View the soccer field below to see how it is composed of quadrilaterals, rectangles, 90-degree angles, and circles.
Additionally, the symmetry of these basketball courts, tennis courts, and soccer fields is mirror imaged.
Therefore , the solution to the given problem of trigonometry comes out to be Additionally, the symmetry of these basketball courts, tennis courts, and soccer fields is mirror imaged.
To know more about trigonometry , visit
brainly.com/question/12068045
#SPJ1
3. What type of angle will the clock show when it is 6:55 pm?
Answers
Hope you could understand that. Plzz let me know if you have any doubts.
Have a nice day :)
Which of the following have a sum of 0? (Pick 2) *
1:The football team gained 10 yards on the first play, gained 10 yards on the second play, and lost 10 yards on the third play. What was the overall change in yardage?
2: While playing the integer game, Sam pulled the following cards: 8, 4, 5, -6, -8, -3. What is the sum of Sam's hand?
3: -15 - 8 + 12 + 11
4: 6 + (-5) - 7 + (-4) + (-4)
Answers
Answer:
The answer is number 3.
Step-by-step explanation:
-15 - 8 = -23
12 + 11 = 23
When you subtract -23 from 23 you have a sum of 0
Therefore the answer is 0
Trucks in a delivery fleet travel a mean of 120 miles per day with a standard deviation of 18 miles per day. The mileage per day is distributed normally. Find the probability that a truck drives between 150 and 156 miles in a day. Round your answer to four decimal places.
Answers
The probability that a truck drives between 150 and 156 miles in a day is 0.0247. Using the standard normal distribution table, the required probability is calculated.
How to calculate the probability distribution?The formula for calculating the probability distribution for a random variable X, Z-score is calculated. I.e.,
Z = (X - μ)/σ
Where X - random variable; μ - mean; σ - standard deviation;
Then the probability is calculated by P(Z < x), using the values from the distribution table.
Calculation:The given data has the mean μ = 120 and the standard deviation σ = 18
Z- score for X =150:
Z = (150 - 120)/18
= 1.67
Z - score for X = 156:
Z = (156 - 120)/18
= 2
So, the probability distribution over these scores is
P(150 < X < 156) = P(1.67 < Z < 2)
⇒ P(Z < 2) - P(Z < 1.67)
From the standard distribution table,
P(Z < 2) = 0.97725 and P(Z < 1.67) = 0.95254
On substituting,
P(150 < X < 156) = 0.97725 - 0.95254 = 0.02471
Rounding off to four decimal places,
P(150 < X < 156) = 0.0247
Thus, the required probability is 0.0247.
Learn more about standard normal distribution here:
https://brainly.com/question/26822684
#SPJ1
You earned $24 mowing lawns, which is 3/4 of the amount your
friend made washing cars. Write and solve an equation to find the
amount of money c your friend made for washing cars.
Answers
Akili has two tests next week. The probability that he will pass the first test, science, is 3 4 . How he does on that test affects how he will do on his math test. If he passes science, then the probability that he will also pass the math test is 4 5 ; otherwise, the probability is only 1 3 that he will pass the math test. What is the probability he passes exactly one test
Answers
Answer:
0.2333 = 23.33% probability he passes exactly one test
Step-by-step explanation:
We have these following probabilities:
3/4 probability that he passes the first test.
If he passes the first test, 4/5 probability that he passes the math test.
If he does not pass the first test, 1/3 probability that he passes the math test.
What is the probability he passes exactly one test
Two scenarios:
Pass first(3/4 probability) and fails second(1/5 probability).
Fails first(1/4 probability) and passes second(1/3 probability). So
\(p = \frac{3}{4}*\frac{1}{5} + \frac{1}{4}*\frac{1}{3} = \frac{3}{20} + \frac{1}{12} = \frac{9 + 5}{60} = \frac{14}{60} = 0.2333\)
0.2333 = 23.33% probability he passes exactly one test
Higher Order Thinking Morgan read
a thermometer at 7:00 P.M. The
temperature was 16°C. This temperature
was 9°C less than the temperature at
2:00 P.M. The temperature at 2:00 P.M.
was 10°C higher than the temperature at
8:00 A.M. What was the temperature at
8:00 A.M.?
Answers
The temperature at 8:00 A.M. was 15°C.
Using the given information:
1. At 7:00 P.M., the temperature was 16°C.
2. This temperature was 9°C less than the temperature at 2:00 P.M.
We can use this information to find the temperature at 2:00 P.M.:
Temperature at 2:00 P.M. = 16°C (temperature at 7:00 P.M.) + 9°C
Temperature at 2:00 P.M. = 25°C
3. The temperature at 2:00 P.M. was 10°C higher than the temperature at 8:00 A.M.
Now, we can find the temperature at 8:00 A.M.:
Temperature at 8:00 A.M. = 25°C (temperature at 2:00 P.M.) - 10°C
Temperature at 8:00 A.M. = 15°C
To know more about temperature refer to
https://brainly.com/question/24746268
What is the average rate of change for the depth of the river, measured as feet per hour, between hour 9 and hour 18?.
Answers
0.3 feet/ hour is the average rate of change for the depth of the river, measured as feet per hour, between hour 9 and hour 18
Average rate of change for depth of the river = \(\frac{21 feet - 18 feet}{18 hours- 9 hours}\)
= \(\frac{21- 18}{18-9} feet/ hour\)
= \(\frac{3}{9}\)
=\(\frac{1}{3}\)
= 0.3 feet/ hour
an normal is a single number taken as representative of a list of figures, generally the sum of the figures divided by how numerous figures are in the list( the computation mean). For illustration, the normal of the figures 2, 3, 4, 7, and 9( summing to 25) is 5. Depending on the environment, an average might be another statistic similar as the standard, or mode.
To know more about Average, visit: brainly.com/question/27193544
#SPJ4
Complete Question
The depth of a river changes after a heavy rainstorm. Its depth, in feet, is modeled as a function of time, in hours. Consider this graph of the function. Write the average rate of change for the depth of the river, measured as feet per hour, between hour 9 and hour 18. Round your answer to the nearest tenth.
A random sample of 10 subjects have weights with a standard deviation of 11.6144 kg. What is the variance of their weights? Be sure to include the appropriate units with the result.
Answers
Answer:
Variance=134.8943 kg
Step-by-step explanation:
The relationship between standard deviation and variance is that standard deviation is the square root of the variance.
So given the value of standard deviation to be 11.6144kg, the variance will be the square of the number.
Standard deviation= √variance
Standard deviation ²=√variance²
Standard deviation ² = variance
11.6144²= variance
134.8943
Variance=134.8943 kg
Answer:
122.4409 kg
Step-by-step explanation:
A full can of paint contains 4/5 of a gallon. Brandon used 3/4 of a can of paint to paint a doghouse. He then used 2/3 of what remained in the can to paint a door. How much paint is left in the can,in gallons?
Answers
Answer:
1/60 gallon
Step-by-step explanation:
You want to know what is left of 4/5 gallon of paint if 3/4 gallon was used to paint a doghouse, and 2/3 of the remaining amount was used to paint a door.
Amount remainingTo find the amount remaining we subtract the amount used for the doghouse from the original amount:
4/5 -3/4 = (16 -15)/20 = 1/20 . . . . . gallon
2/3 of that was used, so 1/3 of it remains:
(1/3)(1/20 gallon) = 1/60 gallon
There is 1/60 of a gallon of paint left in the can.
__
Additional comment
In a standard size gallon paint can, that's about 0.11 inches of paint in the bottom.
<95141404393>
What is 34 x 45 - 14x (5235+-42) / 24x
Answers
Answer:
3(2040x-4039)/4x
Step-by-step explanation:
Solve by completing the square x^2+6x+13=0
Answers
Answer:
x = -3 + 2 i or x = -3 - 2 i
Step-by-step explanation:
Solve for x:
x^2 + 6 x + 13 = 0
Hint: | Solve the quadratic equation by completing the square.
Subtract 13 from both sides:
x^2 + 6 x = -13
Hint: | Take one half of the coefficient of x and square it, then add it to both sides.
Add 9 to both sides:
x^2 + 6 x + 9 = -4
Hint: | Factor the left hand side.
Write the left hand side as a square:
(x + 3)^2 = -4
Hint: | Eliminate the exponent on the left hand side.
Take the square root of both sides:
x + 3 = 2 i or x + 3 = -2 i
Hint: | Look at the first equation: Solve for x.
Subtract 3 from both sides:
x = -3 + 2 i or x + 3 = -2 i
Hint: | Look at the second equation: Solve for x.
Subtract 3 from both sides:
Answer: x = -3 + 2 i or x = -3 - 2 i
After running a 100 meter dash, Jane turns left 40 degrees and walks 60 meter. True or false: she is closer now to her starting position than when she crossed the finish line. What about if Jane turns left 90 degrees or 120 degrees?
Answers
False. When Jane turns left 40 degrees and walks 60 meters, she is farther away from her starting position than when she crossed the finish line.
If Jane turns left 90 degrees or 120 degrees, then she will also be farther away from her starting position than when she crossed the finish line. Turning left 90 degrees or 120 degrees will take her in a different direction, and thus she will be farther away from her starting position than when she crossed the finish line.
Therefore, the given statement is false.
Learn more about the bearings here:
brainly.com/question/27962362.
#SPJ1
Piper generated data by guessing on a test. Hear data was 252 incorrect 128 correct. Which of the following was piper most likely simulating. A: multi choice tests with 5 choices. B: multiple choice test with 4 answers. C: a multiple choice test with 3 answers or D a true or false test
Answers
Step-by-step explanation:
To determine which test Piper was most likely simulating, we can use the formula for the expected number of correct answers on a multiple-choice test:
Expected number of correct answers = (total number of questions) * (probability of getting a question correct)
For a multiple-choice test with 5 choices, the probability of getting a question correct by guessing is 1/5 = 0.2. Therefore, the expected number of correct answers for 380 questions would be:
Expected number of correct answers = 380 * 0.2 = 76
For a multiple-choice test with 4 choices, the probability of getting a question correct by guessing is 1/4 = 0.25. Therefore, the expected number of correct answers for 380 questions would be:
Expected number of correct answers = 380 * 0.25 = 95
For a multiple-choice test with 3 choices, the probability of getting a question correct by guessing is 1/3 = 0.3333. Therefore, the expected number of correct answers for 380 questions would be:
Expected number of correct answers = 380 * 0.3333 = 126.63
For a true or false test, the probability of getting a question correct by guessing is 1/2 = 0.5. Therefore, the expected number of correct answers for 380 questions would be:
Expected number of correct answers = 380 * 0.5 = 190
Comparing the expected number of correct answers for each test to Piper's actual number of correct answers (128), we can see that Piper's performance is closest to what would be expected on a multiple-choice test with 3 answers. Therefore, it is most likely that Piper was simulating a multiple-choice test with 3 answers.
Please guys help me
Answers
Answer:
\(C' = (2,8)\)
\(A' = (4,4)\)
\(T' = (10,10)\)
Step-by-step explanation:
Given
\(k =2\)
\(C =(1,4)\)
\(A = (2,2)\)
\(T =(5,5)\)
Solving (a): The new points
To do this, we simply multiply the old points by the scale factor.
i.e.
\(New = Old * k\)
So:
\(C' = (1,4) * 2 = (2,8)\)
\(A' = (2,2) * 2 = (4,4)\)
\(T' = (5,5) * 2 = (10,10)\)
Solving (b): The graph of the original image
See attachment
Nikhil and Mae work at the same company. Nikhil has been at the company 4 times as long as Mae. Nikhil's time at the company is 8 more than 2 times Mae's time. The following system of equations models the scenario: x = 4y x = 8 + 2y How many years has each person been employed by the company? Nikhil has been with the company for 16 years, while Mae has been there for 4 years. Nikhil has been with the company for 24 years, while Mae has been there for 6 years. Nikhil has been with the company for 20 years, while Mae has been there for 5 years. Nikhil has been with the company for 12 years, while Mae has been there for 3 years
Answers
The number of years of employment is A. Nikhil has been with the company for 16 years, while Mae has been there for 4 years.
How to find the years of employment ?The system of equations given is:
x = 4y
x = 8 + 2y
You can solve the system by setting the two expressions for x equal to each other:
4y = 8 + 2y
2y = 8
2y / 2 = 8 / 2
y = 4
Substitute y = 4 into the first equation to solve for x:
x = 4 x 4
= 16
So, Mae (y) has been at the company for 4 years and Nikhil (x) has been at the company for 16 years.
Find out more on system of equations at https://brainly.com/question/3978002
#SPJ1
x-intercept of 3 and y-intercept of 8
How do you write a lunar equation given this information and how do you write the equation in slope form
Answers
Answer:
y = -8/3x + 8
Step-by-step explanation:
Step 1: Identify which values we have and need to find in the slope-intercept form:
The general equation of the slope-intercept form of a line is given by:
y = mx + b, where
(x, y) is any point,m is the slope,and b is the y-intercept.Since we're told that the y-intercept is 8, this is our b value in the slope-intercept form.
Step 2: Find m, the slope of the line:
Since the x-intercept is 3, the entire coordinates of the x-intercept are (3, 0)Thus, we can find m, the slope of the line by plugging in (3, 0) for (x, y) and 8 for b:
0 = m(3) + 8
0 = 3m + 8
-8 = 3m
-8/3 = m
Thus, the slope is -8/3.
Therefore, the the equation of the line in slope-intercept form whose x-intercept is 3 and whose y-intercept is 8 is y = -8/3x + 8.
Optional Step 3: Check the validity of the answer:
We know that the entire coordinates of the x-intercept are (3, 0) and the entire coordinates of the y-intercept are (0, 8).Thus, we can check that we've found the correct equation in slope-intercept form by plugging in (3, 0) and (0, 8) for (x, y), -8/3 for m, and 8 for b and seeing if we get the same answer on both sides of the equation when simplifying:
Plugging in (3, 0) for (x, y) along with -8/3 for m and 8 for b:
0 = -8/3(3) + 8
0 = -24/3 + 8
0 = -8 = 8
0 = 0
Plugging in (0, 8) for (x, y) along with -8/3 for m and 8 for b;
8 = -8/3(0) + 8
8 = 0 + 8
8 = 8
Thus, the equation we've found is correct as it contains the points (3, 0) and (0, 8), which are the x and y intercepts.
Which translation moves point Z so that the whole image is only in quadrant 1 and 2
Captionless Image
Answers
Answer:
I can’t see the picture!
Step-by-step explanation:
2. Solve for X. SHOW YOUR WORK.
(7x - 25)°
(4x + 2)°
Answers
Answer:
the answer is 9,
Step-by-step explanation:
i looked it up and passed my test with a 100
GIVING BRAINLIST PLEASE HELP ME OUT!!
Answers
Answer:
P = 165/360 = 11/24 = about .46
= about 45.83%
1/6 of a pan and how many brownies does he need if he is going to give brownies to 5 friends
Answers
The computation shows that the number of pans needed will be 5/6.
How to compute the value?From the information given, it should be noted that it was stated that 1/6 of a pan will be needed for one person.
Therefore, the pans that will be needed for the 5 friends will be:
= 1/6 × 5..
= 5/6
Learn more about computations on:
brainly.com/question/4658834
#SPJ1
i need help with this one plz! (marking BRAINLIST) :)
Answers
Answer:
cosθ = 7/25
Step-by-step explanation:
To find hypotenuse, you use Pythagorean's Theorem.
a^2+b^2=c^2
7^2+24^2=c^2
625=c^2
25=c
This means cosθ = 7/25
PLSSSSSS HELP LIMITED TIME!!! Lyle is performing a probability experiment by tossing 2 quarters and recording the outcomes. What is the probability that the outcome of one toss of the coins is 1 head and 1 tail?
A: 23
B: 12
C: 14
D: 13
Answers
Answer:
it would be 1/2
Step-by-step explanation:
Answer:
Its C thank me later
Step-by-step explanation: