1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Mumz [18]
2 years ago
9

Hello. I need help with creating a normal distribution for a pre-made dataset in excel? I mainly confused with the steps to comp

lete the process.
Mathematics
1 answer:
Inessa05 [86]2 years ago
8 0

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.

You might be interested in
The numbers to the items:3.99 6.00 4.50 now question. He principal at Gotham Elementary bought each teacher the three items show
sashaice [31]

Answer:

jk

Step-by-step explanation:

5 0
3 years ago
Amy drove to her Mother’s house, which is 204 miles away. If it took her 3 hours, what was her average speed mph?
lora16 [44]

Answer:

68

Step-by-step explanation:

204/3 = Avg MPH

5 0
3 years ago
Read 2 more answers
Which number has the prime factorization 5 · 72 · 32?
lubasha [3.4K]

Answer:

see below

Step-by-step explanation:

5*72*32 is not a prime factorization to begin with because neither 72, nor 32 are primes. A prime factorization for this product would be:

2*2*2*2*2*2*2*2*3*3*5

and the number with this factorization is 11520.

There is a small chance that what you meant to write was this: 5\cdot 7^2 \cdot 3^2 in which case the number for this prime factorization is 2205.

5 0
3 years ago
Read 2 more answers
An executive invests $26,000, some at 8% and some at 6% annual interest. If he receives an annual return of $1,860, how much is
S_A_V [24]
Let x = amount invested at 8%
 26000 - x = amount invested at 6%

0.08x + 0.06(26000 - x) = 1860

solving the equation you get x = 15000
and subtract that from 26000 you get 11000
8% investment = 15000
6% investment = 11000
5 0
3 years ago
Every day, Paula performs physical activity on her treadmill. For an hour, she runs 15,000 meters. Knowing that she spends an ho
natali 33 [55]

Answer: 105 kilometers

Step-by-step explanation:

1 kilometer=1,000 meters

15,000 (meters a day) x 7 (days a week) = 105,000 meters.

Convert the meters to kilometers:

105,000/1,000 = 105 kilometers

3 0
3 years ago
Other questions:
  • The length of each side of an equilateral triangle is 74mm, correct to the nearest millimeter. Calculate the smallest possible p
    14·1 answer
  • Using a commen denominator to order fractions, please help...
    10·1 answer
  • Help me pleaseeee I don’t understand this
    7·1 answer
  • Determine the intercepts of the graph described by the following linear equation<br> y=6x+13
    15·1 answer
  • Onetta biked 325 miles in 5 days. If she biked the same number of miles each day, how far did she bike each day help moi plz
    8·1 answer
  • 11. Which of the following points is on the
    9·1 answer
  • 1.
    10·2 answers
  • Which of the following proportionality statements is correct ?
    9·1 answer
  • A formula for finding SA, the surface area of a rectangular prism, is
    13·2 answers
  • Do you know this??<br> I’m confused
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!