Statistics works
kach1234
MA201_HW5-11.docxHome Work #5
Note: ALL YOUR WORK SHOULD EVIDENCE USE OF Microsoft Excel
1. There are five rows of students seated in a class. Following table shows the number of students in each row and the average score for that row in a mid-term exam. What is the average score for the class?
|
ROW |
Number of students |
Row average score |
|
1 |
6 |
82.3 |
|
2 |
7 |
91.4 |
|
3 |
4 |
85 |
|
4 |
5 |
78.3 |
|
5 |
6 |
89.1 |
2. Following data represents the number of Sony TVs sold per day at Best Buy store in Chestnut Hill Mall over a random sample of five data. What is the variance of this sample?
9 2 7 7 5
3. Six randomly selected employees take following minutes to commute to work. There is an employee who takes 35 minutes. What is her z-score?
23 15 32 10 26 31
4. Six employees were randomly selected at Muzzy Ford to study if years of experience had an impact on sales volume. With the following data, what do you find as the covariance between experience and sales volume?
|
Experience of employee |
Number of cars sold |
|
1 |
10 |
|
2 |
9 |
|
3 |
9 |
|
5 |
8 |
|
8 |
16 |
|
11 |
14 |
5. For the above data, what is the sample correlation coefficient? Does experience impact sales volume positively?
6. Bruce sells timeshares at a resort in Orlando, Florida. The data below represents the number of units Bruce had sold per month over past eight months. What will be the z-score, when Bruce sold 4 units?
4 11 7 2 13 6 6 10
