How Do I Create Dotplots in Excel Using SigmaXL?
- Click Sheet 1 Tab of Customer Data.xlsx. Click SigmaXL > Graphical Tools > Dotplots.
- Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.
- Select Overall Satisfaction, click Numeric Data Variable (Y) >>, select Customer Type, click Group Category (X1) >>:
- Click OK. Multiple dotplots of Customer Satisfaction By Customer Type are produced:
- Since all data points are shown, dotplots are a useful alternative to Histograms, particularly when the group sample sizes are small (n < 30).
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
Phone: 1.888.SigmaXL (744.6295)
Support: Support@SigmaXL.com
Sales: Sales@SigmaXL.com
Information: Information@SigmaXL.com