2 Ensure the Sales Data worksheet is active, then use the FREQUENCY function to calculate the frequency distribution of the square footage of homes located in column D. Place your results in the range H4:H11. Enter a function in cell J4 to calculate the standard deviation of the current home values (column E). Enter a function in cell J7 to calculate the variance of the current home values (column E). Enter a function in cell J10 to calculate the covariance between square footage (column C) and the current home values (column E). Enter a function in cell J13 to calculate the correlation between square footage (column C) and the current home values (column E). Apply Accounting Number format to cell J4. Ensure the Analysis ToolPak add-in is active. Insert a histogram based on the square footage located in column C. Move the chart so the upper-left comer is in cell G15. Resize the chart so if fills the range G15:J28. 2 Ensure the Sales Data worksheet is active, then use the FREQUENCY function to calculate the frequency distribution of the square footage of homes located in column D. Place your results in the range H4:H11. Enter a function in cell J4 to calculate the standard deviation of the current home values (column E). Enter a function in cell J7 to calculate the variance of the current home values (column E). Enter a function in cell J10 to calculate the covariance between square footage (column C) and the current home values (column E). Enter a function in cell J13 to calculate the correlation between square footage (column C) and the current home values (column E). Apply Accounting Number format to cell J4. Ensure the Analysis ToolPak add-in is active. Insert a histogram based on the square footage located in column C. Move the chart so the upper-left comer is in cell G15. Resize the chart so if fills the range G15:J28