Find the midpoint of the firm size range in column A. What is the correlation between each data labels and why is this correlation calculated and interpreted that away? What is the correlation between columns H, C, and D. What equation for the regession line for pairs of variables a significant relationship? Calculate 10-14 line and 100-149 regression lines. After finding those lines predict values within the predictive range of the data. Intrepret these values. Preform a hypothesis test for any correlation between the two variables in one of the regressions. Include both null and alternative draw.

Employer Firms, Employment and Annual Payroll Small Firm Size Classes, 2007 Employmentsize of Firm Mid point of Firm Number of Firms in Tota Emplo ymentin Employee (in Revenues per Firm Employee [in Category 2,101,982 41,42526 S 6 Employer Firms, Employment and Annual Payroll Small Firm Size Classes, 2007 Employmentsize of Firm Mid point of Firm Number of Firms in Tota Emplo ymentin Employee (in Revenues per Firm Employee [in Category 2,101,982 41,42526 S 6