Scatterplot

Convert the dataset into a table that recognizes the headers. Name the table "Orders". Use a soft green banding.

In a new sheet, named Correlation Test, use columns A and B to paste a copy of columns Avg. Ref. Price and Order Units.

Starting in cell C$2,$ add a scatter plot to see whether the average reference price in each order grows when the order contains more units.

Remember that the X axis represents the independent variable and that the order of the columns affects the design of the chart.

Add a linear trend line to the chart and make it orange.

Use informative titles for the chart and axes and make sure the right units with zero decimals are used for each variable.

Implement a professional approach in choosing font sizes, colors, and all visual aspects of the chart. Rename the worksheet as "Orders," as well.

Heatmap