# Statistics w/ Excel Project (Undergraduate College)

*label*Statistics

*timer*Asked: Apr 20th, 2015

**Question description**

The assignment is for what is equivalent to an undergraduate college statistics course with a Microsoft Excel component.

The following document is everything that needs to be completed for the assignment:

The course atlas below is to give you an idea of what we have learned and what you should use when completing the project:

**Tentative Course Outline**

1. The Big Picture and Introduction to Excel (intended for the new user) - BH Ch 1 and Lecture Notes

2. Random Variables, Distributions and Expectations - Lecture Notes

3. (Parametric) Sample Statistics and the Law of Large Numbers - Lecture Notes

4. Non-parametric Sample Statistics - Lecture Notes

5. Box-plots and Histograms - Lecture Notes

6. The Normal Distribution and the Central Limit Theorem - Lecture Notes

7. Hypothesis Testing and ConÖdence Intervals - Lecture Notes

8. The F-test of Equal Variances - Lecture Notes

9. Two Sample t-tests - Lecture Notes

10. Scatterplots, Covariance and Correlation - Lecture Notes

11. The Simple Linear Regression Model - BH Ch 2 and Lecture Notes from HGL

12. Interval Estimation and Hypothesis Testing - BH Ch 3 and Lecture Notes from HGL

13. Prediction, Goodness-of-Öt and Modeling Issues - BH Ch 4 and Lecture Notes from HGL

14. Multiple Linear Regression - BH Ch 5 and Lecture Notes from HGL

15. Further Inference in the Multiple Regression Model - BH Ch 6 and Lecture Notes from HGL