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
Which number is greater 65% or 0.56
coldgirl [10]
65% is bigger than 0.56 which would be 56%
8 0
2 years ago
Read 2 more answers
At the start of the day there was 129.75 in the till one hour later there is 145.40 how much did the shop take in a hour
777dan777 [17]
At the start of the day, there was £129.75. Later, they made more money, so the <span>£145.50. To find the amount of change, you just need to deduct the number 129.75 from 145.50.

145.50 - 129.75 = 15.75

The shop made </span><span>£15.75 in one hour.</span>
8 0
3 years ago
In a simple regression analysis (where y is a dependent and x an independent variable), if the y-intercept is positive, then it
Rom4ik [11]

Answer:

m=\frac{S_{xy}}{S_{xx}}  

Where:  

S_{xy}=\sum_{i=1}^n x_i y_i -\frac{(\sum_{i=1}^n x_i)(\sum_{i=1}^n y_i)}{n}  

S_{xx}=\sum_{i=1}^n x^2_i -\frac{(\sum_{i=1}^n x_i)^2}{n}  

\bar x= \frac{\sum x_i}{n}  

\bar y= \frac{\sum y_i}{n}  

And we can find the intercept using this:  

b=\bar y -m \bar x  

On this case the correct answer would be:

E.  none of the above

Since the intercept has no association between the increase/decrease of the dependent variable respect to the independent variable

Step-by-step explanation:

Assuming the following options:

A.  there is a positive correlation between X and Y

B.  there is a negative correlation between X and Y

C.  if X is increased, Y must also increase

D.  if Y is increased, X must also increase

E.  none of the above

If we want a model y = mx +b where m represent the lope and b the intercept

m=\frac{S_{xy}}{S_{xx}}  

Where:  

S_{xy}=\sum_{i=1}^n x_i y_i -\frac{(\sum_{i=1}^n x_i)(\sum_{i=1}^n y_i)}{n}  

S_{xx}=\sum_{i=1}^n x^2_i -\frac{(\sum_{i=1}^n x_i)^2}{n}  

\bar x= \frac{\sum x_i}{n}  

\bar y= \frac{\sum y_i}{n}  

And we can find the intercept using this:  

b=\bar y -m \bar x  

On this case the correct answer would be:

E.  none of the above

Since the intercept has no association between the increase/decrease of the dependent variable respect to the independent variable

3 0
2 years ago
A geometric seqerence 1.5, -3, 6, -12 .... How many regative terms in the sequencs greater than
Leno4ka [110]

The total negative terms are 4 which are greater than -6000 if the geometric sequence 1.5, -3, 6, -12 ... with a common ratio -3.

<h3>What is a sequence?</h3>

It is defined as the systematic way of representing the data that follows a certain rule of arithmetic.

We have:

A geometric sequence 1.5, -3, 6, -12 ....

The common ratio r = -3/1.5 = -2

1.5, -3.6, 6, -12, 36, -108, 324, -972, 2916, -8748

The total negative terms = 4

Thus, the total negative terms are 4 which are greater than -6000 if the geometric sequence 1.5, -3, 6, -12 ... with a common ratio -3.

Learn more about the sequence here:

brainly.com/question/21961097

#SPj1

4 0
2 years ago
Factor an expression:<br>(x²+x+1)²+3x(x²+x+1)-18x²​
Ivahew [28]

Answer:

x^4 + 5x^3 - 12x^2 + 5x + 1

3 0
2 years ago
Read 2 more answers
Other questions:
  • The scale of a map is 1cm : 70km. What is the actual distance between two towns that are 3cm apart on the map
    9·1 answer
  • I Need Help With My Work <br><br>x-9=-5
    12·1 answer
  • SOMEONE PLEASE HELP QUICK
    6·1 answer
  • Algebra 2 find the solution of the equation using a method of your choice
    14·1 answer
  • The members at a health club decreased in number by 15% from last year to this year. The following expression was used to find t
    6·2 answers
  • A car travels at a speed of 72 miles per hour. Write a direct variation equation for the distance, y, the car will travel in x h
    6·1 answer
  • Evaluate 5r-8.35s when r=12 and s=4
    12·1 answer
  • A circular "No U-Turn" road sign has a diameter of 20 inches.
    14·1 answer
  • 12 x 12 x 12 = 4 x # x 4 what number must replace the '#' symbol​
    14·1 answer
  • Let R(x)=3x3+2x2+x and S(x)=4x2+1. Find R(x)+S(x).
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!