EE/GG 275 First Lab Assignment

Review of Statistics

For this first lab assignment you do not have to write a lab report – only to hand in the printouts requested.

EXCEL ASSIGNMENT

Task 1.

1. Open up Excel and import into Column A and Column B the following data:

A                     B

Year	Population
1970	260
1971	271
1972	289
1973	302
1974	316
1975	331
1976	345
1977	360
1978	374
1979	389
1980	403
1981	418
1982	432
1983	447
1984	461
1985	474
1986	490
1987	505
1988	519
1989	534
1990	548
1991	563
1992	577
1993	592
1994	606
1995	621
1996	635
1997	650
1998	664
1999	679
2000	693

2. Calculate in Column C
1.  Annual growth of the population – that is how many people are being born every year.
2.  Average growth of the population between 1970 and 2000

3. Graph columns A and B using a scatter plot, and create a graph that looks as the graph below.

 

4. Estimate the standard deviation and variance of the annual growth of the population – using EXCEL.

5. Print out:

a. The excel spreadsheet, with the annual growth calculated and the estimation of the average growth, the standard deviation and the variance.

b. The graph.

Hand in both printouts to the lab instructor with your name on it and your ID number.

 

Task 2.

1.     Open Excel and import the following data.

 

Grades	Average Cups of Coffee per day
2.3	1
2.5	1.5
3.7	4.5
3.3	4
3	3.5
3	3.5
3	3.5
2.7	2
2.7	2
2.3	1
2	0.5
1.7	0
2.3	1
2.7	2
2.7	2
3	3.5
4	5
3.7	4.5
3.7	4.5
3.7	4.5
4	5
2	0.5
2	0.5
2	0.5
3.3	4
3	3.5
2.7	2
2.7	2
2.7	2
2.7	2

2. Estimate the standard deviation and the variance of the grades in the class as well as the standard deviation and the variance of cups of coffee consumed.

3. Go to “tools” on the menu bar and open “Analysis Tools”.  Perform a regression analysis on the data where “grades” are the dependent variable (Y), and cups of coffee are the independent variable (X).

4. Interpret the regression output – that is the R squared, the meaning of the coefficients, that is the intercept and the coefficient on the average coffee per day.

5. Write the regression equation – only including significant coefficients.

6. Hand in to your lab instructor the output with your regression results and the necessary interpretation, as well as your estimate of the standard deviation and the variance.

HAVE FUN!