Bi-lo Appliance Super-Store has outlets in several large metropolitan areas in New England. The general sales manager aired a commercial for a digital camera on selected local TV stations prior to a sale starting on Saturday and ending Sunday. She obtained the information for Saturday-Sunday digital camera sales at the various outlets and paired it with the number of times the advertisement was shown on the local TV stations. The purpose is to find whether there is any relationship between the number of times the advertisement was aired and digital camera sales. The pairings are: Click here for the Excel Data File a. What is the dependent variable? b. Draw a scatter diagram. 1. On the graph below, use the point tool to plot the point corresponding to the first Number of Airings and her Sales (No of Airings1). 2. Repeat the process for the remainder of the sample (No of Airings2, No of Airings3, ...). 3. To enter exact coordinates, double-click on the point and enter the exact coordinates of x and y. c. Determine the correlation coefficient. (Round your answer to 2 decimal places.) d. Interpret these statistical measures