Include Top

How Do I Create Dotplots in Excel Using SigmaXL?

Dotplots

  1. Click Sheet 1 Tab of Customer Data.xls (or press F4 to activate last worksheet). Click SigmaXL > Graphical Tools > Dotplots.
  2. Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.
  3. Select Overall Satisfaction, click Numeric Data Variable (Y) >>, select Customer Type, click Group Category (X1) >>:
  4. SigmaXL Dotplots

  1. Click OK. Multiple dotplots of Customer Satisfaction By Customer Type are produced:

  2. Dotplots in SigmaXL
  1. Since all data points are shown, dotplots are a useful alternative to Histograms, particularly when the group sample sizes are small (n < 30).
Click here to download a Free 30-Day Trial.

Define, Measure, Analyze, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,
Realize

Lean Six Sigma Software Excel Add-in

Web Demos

Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!

Contact Us

Ph: 1.888.SigmaXL (744.6295)

Support: Support@SigmaXL.com

Sales: Sales@SigmaXL.com

Information: Information@SigmaXL.com