logo Hurry, Grab up to 30% discount on the entire course
Order Now logo
508 Times Downloaded

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Kevin BatesTechnical writing
(5/5)

673 Answers

Hire Me
expert
Sam BingamanAccounting
(5/5)

913 Answers

Hire Me
expert
Devanshu KamraMarketing
(5/5)

546 Answers

Hire Me
expert
Aaryan KhannaGeneral article writing
(5/5)

584 Answers

Hire Me
Tableau
(5/5)

Scatterplots are a very easy and powerful way to visualize the relationships between numeric variables

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Scatterplots

Scatterplots are a very easy and powerful way to visualize the relationships between numeric variables (Measures). For example, I wonder if there is a relationship between Discount and Profit (seems like a reasonable possibility).

1. Let’s take a look by selecting those two fields and clicking Scatterplot on the Show Me menu.

Figure LW8.1: Creating our first scatterplot

2. Go to Analysis, uncheck Aggregate Measures.

3. Swap if needed to get Discount on the horizontal axis – looks like Profit tends to decrease as a larger Discount is given (confirms intuition).

Remember that with Tableau, unlike many other tools, we don’t need to stop here. It is very easy to

keep adding data.

4. Drag Segment to Color. This makes it easy to see what segment certain outliers belong to.

Figure LW8.2: Creating our first scatterplot, with color channel for segment.

Let us say that we want to focus on just one segment (while leaving all the data displayed).

5. Select Corporate segment by highlighting it from the Legend.

Figure LW8.3: Creating our first scatterplot, highlighting the Corporate segment.

6. Go back to viewing all the data by clicking anywhere on the worksheet.

7. Go to the Analytics pane and drag out a trend line (choose linear).

Figure LW8.4: Creating our first scatterplot, adding a linear trend line.

If you have had a statistics course, you probably realize that this is a regression line.

This trend line does not look very impressive but take a look at the y-axis scale. We need to investigate more before dismissing this as a negligible relationship. Hover over the trend line.

Figure LW8.5: Creating our first scatterplot, viewing the p-value associated with a trend line.

The p-value is very small (less than 0.0001) so relationship between these variables is statistically significant. And we can see by the negative coefficient (-251.388…) that the relationship is negative.

However, the R-Squared (0.0461243) value is somewhat low, so our simple trend line has not explained very much of the relationship. A little mini-review of correlation.

The quantity r, measures the strength and the direction of a linear relationship between two variables (Bennett, Briggs, & Triola). The formula for computing this value is very scary so let us be glad that Tableau (and stats programs, too) compute this value for us.

The value of r ranges from -1 < r < +1. The + sign are used for positive linear correlations and the – sign negative linear correlations (Bennett et al., 2018):

• Positive correlation: If x and y have a strong positive linear correlation, r is close to +1. An r value of exactly +1 indicates a perfect positive fit. Positive values indicate a relationship between x and y variables such that as values for x increases, values for y also increase.

• Negative correlation: If x and y have a strong negative linear correlation, r is close to -1. An r value of exactly -1 indicates a perfect negative fit. Negative values indicate a relationship between x and y such that as values for x increase, values for y decrease.

• A correlation greater than 0.8 is generally described as strong, whereas a correlation less than

0.5 is generally described as weak. These values can vary based upon the “type” of data being examined. A study utilizing scientific data may require a stronger correlation than a study using social science data.

 

(5/5)
Attachments:

Expert's Answer

508 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme