MS 150 Statistics fall 2005 Test One • Name:
LRC kwh |
15400 |
25500 |
26400 |
27100 |
31500 |
24400 |
34600 |
28100 |
29100 |
26700 |
47900 |
31300 |
II. Basic statistics and histogram
Use the Learning Resource Center (LRC) kilowatt hour (kwh) data for this section. The data is the monthly power consumption for the LRC for twelve months between June 2004 to July 2005.
- __________ Find the sample size n for the power data.
- __________ Find the minimum power.
- __________ Find the maximum power.
- __________ Find the range of the power.
- __________ Find the median power.
- __________ Find the mode for the power.
- __________ Find the sample mean power.
- __________ Find the sample standard deviation for the power.
- __________ Find the sample coefficient of variation CV.
- __________ If this data is to be divided into five bins, what is the width of a single bin?
- Determine the frequency and calculate the relative frequency using five bins (classes, intervals). Record your results in the table provided.
Bins | Frequency | Relative Frequency |
| | |
| | |
| | |
| | |
| | |
Sums: | | |
- Sketch a frequency histogram of the data, labeling your horizontal axis and vertical axis as appropriate. Use the back of this sheet if necessary.
The following data is the net power consumption for the LRC in spring 2003, spring 2004, and spring 2005. Use this data to find the linear regression (trend line) for this data.
Spring term (x) | Net kwh (y) |
03 | 97200 |
04 | 118000 |
05 | 118500 |
- ______________ Calculate the slope of the linear regression (trend line) for the data.
- ______________ Calculate the y-intercept of the linear regression (trend line) for the data.
- ______________ Is the correlation positive or negative?
- ______________ Use the slope and intercept to calculate the projected power usage in spring 06. Go ahead and make this projection even though '06 is beyond the data provided.
- ______________ Use the slope and intercept to calculate the projected year in which power usage is 144,000 kwh. Go ahead and make this projection even though 144000 is beyond the data provided.
Table of statistical functions used by Excel
Basic Statistics |
Statistic or Parameter | Symbol | Equations | Excel |
Sample size | n | | =COUNT(data) |
Minimum | | | =MIN(data) |
Maximum | | | =MAX(data) |
Median | | | =MEDIAN(data) |
Mode | | | =MODE(data) |
Sample mean | x
| Σx/n | =AVERAGE(data) |
Sample standard deviation | sx | | =STDEV(data) |
Sample Coefficient of Variation | CV |
sx/x |
=STDEV(data)/AVERAGE(data) |
Linear Regression Statistics |
Statistic or Parameter | Symbol | Equations | Excel |
Slope | b | | =SLOPE(y data, x data) |
Intercept | a | | =INTERCEPT(y data, x data) |
Correlation | r | | =CORREL(y data, x data) |
Coefficient of Determination | r2 | |
=(CORREL(y data, x data))^2 |
Statistics •
Lee Ling •
COMFSM