Excel Problem Walmart Inc. has made historical sales data available for 45 stores located in different regions throughout the United States. Go to the student download page at http://www.pearsonhighered.com/romney and download the files labeled “WalmartSales.csv” and “WalmartFeatures.csv”. Using this data, a data analyst produced a viz to try to explain how temperature and fuel prices relate to average weekly sales. The visualization has the following elements: the black line represents weekly sales, the bars represent average weekly temperatures, the blue coloring on the bars shows median weekly fuel prices, and the red line is a regression trend line that corresponds to the equation shown on the chart.

REQUIRED For this chart, do the following:

a. Discuss how you would simplify the chart to show how temperature and fuel prices relate to average weekly sales.

b. Download the data and make a new visualization (or visualizations) that presents the information in a simplified form.