25 Nov 2022


Scatter Diagram: How to Create a Scatter Plot in Excel

Format: APA

Academic level: University

Paper type: Assignment

Words: 317

Pages: 2

Downloads: 0

Trends in statistical data are interpreted using scatter diagrams. A scatter diagram presents each data point in two coordinates. The first point of data representation is done in correlation to the x-axis while the second coordinate corresponds to the y axis. The intersection of the two coordinates represents the point of observation ( Mindrila & Balentyne 1 ). The independent variable is represented on the horizontal axis while the dependent variable is placed on the vertical axis. The horizontal and the vertical axes cross a point referred to as the point of origin. The coordinates at the point of origin are represented as (0,0). 


The data presented in the question is obtained from the weekly sales of the case study of American Toys Inc. The data presents the sales clerk hours against the number of sales. A scatter diagram of the data is represented on the attached excel file. 

It’s time to jumpstart your paper!

Delegate your assignment to our experts and they will do the rest.

Get custom essay

From the data presented, the work hours represent the independent variable and hence is placed on the horizontal axis ( Nguyen et al. 2 ). The number of sales is the dependent variable and is placed on the vertical axis. The horizontal axis is the x-axis, while the vertical axis is also referred to as the y-axis ( Smart & Szafir 3). The data presented in the excel scatter diagram indicates an uphill pattern as one moves from left to right hence a positive correlation between the work hours and the number of sales is deduced ( Stockemer et al. 4 ). It is accurate to conclude that an increase in x-values results in a significant increase in y-values. 


The positive correlation between the x-values and the y-values indicates that more work hours result in more sales. There is no linear correlation between the x-values and the y-values. It is vital to note that the relationships deduced from the scatter diagram do not necessarily indicate a cause-and-effect relationship. 


Mindrila, D., & Balentyne, P. (2017). Scatterplots and correlation.  Retrieved from

Nguyen, Q. V., Miller, N., Arness, D., Huang, W., Huang, M. L., & Simoff, S. (2020). Evaluation on interactive visualization data with scatterplots.  Visual Informatics 4 (4), 1-10. 

Smart, S., & Szafir, D. A. (2019, May). Measuring the separability of shape, size, and color in scatterplots. In  Proceedings of the 2019 CHI Conference on Human Factors in Computing Systems  (pp. 1-14). 

Stockemer, D., Stockemer, & Glaeser. (2019).  Quantitative Methods for the social sciences  (Vol. 50, p. 185). Springer International Publishing. 

Cite this page

Select style:


StudyBounty. (2023, September 17). Scatter Diagram: How to Create a Scatter Plot in Excel.


Related essays

We post free essay examples for college on a regular basis. Stay in the know!

17 Sep 2023

Calculating and Reporting Healthcare Statistics

10\. The denominator is usually calculated using the formula: No. of available beds x No. of days 50 bed x 1 day =50 11\. Percentage Occupancy is calculated as: = =86.0% 12\. Percentage Occupancy is calculated...

Words: 133

Pages: 1

Views: 150

17 Sep 2023

Survival Rate for COVID-19 Patients: A Comparative Analysis

Null: There is no difference in the survival rate of COVID-19 patients in tropical countries compared to temperate countries. Alternative: There is a difference in the survival rate of COVID-19 patients in tropical...

Words: 255

Pages: 1

Views: 250

17 Sep 2023

5 Types of Regression Models You Should Know

Theobald et al. (2019) explore the appropriateness of various types of regression models. Despite the importance of regression in testing hypotheses, the authors were concerned that linear regression is used without...

Words: 543

Pages: 2

Views: 175

17 Sep 2023

The Motion Picture Industry - A Comprehensive Overview

The motion picture industry is among some of the best performing industries in the country. Having over fifty major films produced each year with different performances, it is necessary to determine the success of a...

Words: 464

Pages: 2

Views: 86

17 Sep 2023

Spearman's Rank Correlation Coefficient (Spearman's Rho)

The Spearman’s rank coefficient, sometimes called Spearman’s rho is widely used in statistics. It is a nonparametric concept used to measure statistical dependence between two variables. It employs the use of a...

Words: 590

Pages: 2

Views: 309

17 Sep 2023

Transportation Policy and Planning: What You Need to Know

Monopoly describes a situation of exclusive control of the supply or trade of a commodity or service. Further, corruption describes the dishonest behavior as displayed among those in power while gross inefficiency...

Words: 836

Pages: 3

Views: 98


Running out of time?

Entrust your assignment to proficient writers and receive TOP-quality paper before the deadline is over.