please read the attached instructions for the assignment and follow the instructions.  Please see the instructions for the Business memo format that you have to follow.  DUE IN 24 HOURS .  NOTE: 1. Th

please read the attached instructions for the assignment and follow the instructions. 

Please see the instructions for the Business memo format that you have to follow. 

DUE IN 24 HOURS . 

NOTE:

1. There is only one R-square for a regression.

2. It is descriptive statistic, not a test statistic.

3. The t-stat is a test statistics. Each X variable has a t-stat. (So does the constant) In LINEST, you will have to calculate the t-stats.

4. The X-variables (when there are more than one) must be side by side.

5. In LINEST, the coefficients are reported in the reverse order of the X variables.

6. In this assignment, you have more columns of data than you need. You also have more rows of data.

7. All of these things are deliberate. Statistics involves both some ability to think in the abstract AND some ability to be careful about details. And, writing the report also involves the ability to communicate quantitative information.