For the following sample, answer the following: Remember you can copy and "paste special" the table into the Excel sheet. Here is a sample of the cost of new cars. 34000 31000 37000 28000 27000 38000 39000 29000 40000 25000 26000 30000 Here is a sample of grades on a test. 63 66 84 30 85 89 83 34 79 96 87 71 What is the mean of the car costs? The standard deviation tells you how spread out the scores are. What is the sample standard deviation of car costs? The coefficient of variation tells you how spread out the scores are, relative to the average. The coefficient of variation is calculated by dividing the standard deviation by the mean. What is the sample coefficient of variation of car costs?
For the following sample, answer the following:
Remember you can copy and "paste special" the table into the Excel sheet.
Here is a sample of the cost of new cars.
34000 |
31000 |
37000 |
28000 |
27000 |
38000 |
39000 |
29000 |
40000 |
25000 |
26000 |
30000 |
Here is a sample of grades on a test.
63 |
66 |
84 |
30 |
85 |
89 |
83 |
34 |
79 |
96 |
87 |
71 |
What is the
The standard deviation tells you how spread out the scores are.
What is the sample standard deviation of car costs?
The coefficient of variation tells you how spread out the scores are, relative to the average.
The coefficient of variation is calculated by dividing the standard deviation by the mean.
What is the sample coefficient of variation of car costs?
Obtain the mean of the car costs.
The mean of the car costs is obtained below as follows:
Use EXCEL Procedure for finding the value of sample mean.
Follow the instruction to obtain the value of sample mean:
- Open EXCEL
- Go to Formula bar.
- In formula bar enter the function as“=AVERAGE”
- Enter the range as $A$1:$A$13.
- Click enter.
EXCEL output:
From the EXCEL output, the value of the sample mean is 32000.
The mean of the car costs is 32,000.
Step by step
Solved in 3 steps with 1 images