Question

how to construct a dot plot in excel

how to construct a dot plot in excel

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Please don't hesitate to give a "thumbs up" in case you're satisfied with the answer

You cannot directly plot the dot plot in Excel , as there is no way to do that.

But you do a work-around in excel to make a dot plot.

Lets say you have a frequency distribution just like below. Use Excel' REPT command to make a frequency distribution with the symbol you want. For example, below I have used "*" symbol to draw the following frequency distribution' box plot.

You can also check the formula of REPT() to know how to replicate the dot plot.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
how to calculate ground state for N and N+1 electrons quantum dot and plot grap between...
how to calculate ground state for N and N+1 electrons quantum dot and plot grap between number of electrons vs energy. if you can comsider electrons are parabolic simple harmonic oscillator quantum confirment.
A dot plot is best applied when _____________________. Select one: a. The mean, median, and mode...
A dot plot is best applied when _____________________. Select one: a. The mean, median, and mode are equal b. The general shape of a distribution is symmetric c. The relationship between two variables is summarized d. A single variable is summarized
The set of data from a sample of n=6: 7,4,9,7,3,12. A) Construct a box plot and...
The set of data from a sample of n=6: 7,4,9,7,3,12. A) Construct a box plot and describe it's shape ****I need help to understand what I need to put into excel in which cells to make this work. I'm stuck and not great with excel. Thanks!
how to use excell to Using excel, You will need to plot the log of the...
how to use excell to Using excel, You will need to plot the log of the copy number (x axis) against the CT values (Y-axis) and generate a line of best fit together with an R2 value (which measures the goodness of fit). copies per UL cq(Value) 10,000,000 28.87 1,000,000 32.01 100,000 35.27 10,000 38.87
Toss four pennies 30 times and record the number of heads in each toss. a. Construct...
Toss four pennies 30 times and record the number of heads in each toss. a. Construct a dot plot for the data. b. draw a bar graph for the data.
Compare the three data sets on the right. ​(i) 45678910 A dot plot has a horizontal...
Compare the three data sets on the right. ​(i) 45678910 A dot plot has a horizontal axis labeled from 4 to 10 in increments of 1. The graph consists of a series of plotted points from left to right. The coordinates of the plotted points are as follows, where the label is listed first and the number of dots is listed second: 5, 1; 6, 4; 7, 5; 8, 4; 9, 1. ​(ii) 45678910 A dot plot has a horizontal...
1) Construct the scatter plot for the following. From the plot does there appear to be...
1) Construct the scatter plot for the following. From the plot does there appear to be a linear correlation? x 2 -4 -2 -1 -2 -1 -4 6 -5 -2 y -1 -7 2 -7 4 -2 -5 4 -4 -5 2) Find the value of the linear correlation coefficient. 3) Perform a hypothesis test on the claim that there is a linear correlation. Does there appear to be a linear correlation? Why or why not?
A-. Consider the data set {1,2,4,5,7,8,9,9,10,1,12,11,14,16,17,20,22,23,25,27,35} Construct a Box Plot. Upload the document with the box...
A-. Consider the data set {1,2,4,5,7,8,9,9,10,1,12,11,14,16,17,20,22,23,25,27,35} Construct a Box Plot. Upload the document with the box plot. B-.GPAs at CCSU are normally distributed with a mean of 2.38 and a standard deviation of 0.45. Find the z-score for a GPA of 3.06. and discuss the significance of the z-score.
How to plot exponentially the P(0.8 < x < 1.0) with a mean of .88?? Please...
How to plot exponentially the P(0.8 < x < 1.0) with a mean of .88?? Please show the work of plotting a graph exponentially using excel? I am getting confused.
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (Each pair of variables has a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The caloric content and the sodium content​ (in milligrams) for 6 beef hot dogs are shown in the table below. (a) x=170 Calories (B )x=100 calories (C) x=140 Calories...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT