Data sets for the question below
Data Set G: Assume the population values are normally distributed.
Random variable: x = weight of border collie in pounds
sample size = 25
34.1
40.8
36.0
34.9
35.6
43.4
35.4
29.3
33.3
37.8
35.8
37.4
39.0
38.6
33.9
36.5
37.2
37.6
37.3
37.7
34.9
33.2
36.2
33.5
36.9
Use Excel (or similar software) to create the tables. Then copy the items and paste them into a Word document. The tables should be formatted vertically, have borders, and be given the labels and titles stated in the assignment. The proper symbols should be used. Do not submit this assignment as an Excel file. The completed assignment should be a Word (or .pdf) document.
2. Use technology to find the mean, median, standard deviation,
and variance of the sample
data organized in Table 1 (from step 2 above). Put these values,
plus the range and sample
size, into a table with the proper symbol in the left column and
the value of the statistic in the
right column. The median and range do not generally have symbols so
the terms “Median” and
“Range” can be used in the left column. The statistics should be
rounded properly (one more
decimal place than the data). Label this “Table 2: Important
Statistics.”
In the given problem X = weight of border collie in pounds
n = sample size= 25
All the required statistics based on the sample data given below
statistical function | value |
size (n) | 25 |
Max.value | 43.4 |
Min. value | 29.3 |
Range= Max-Min | 14.1 |
Mean | 36.25 |
Standard deviation s | 2.77 |
variance s^{2} | 7.67 |
Mean s.d | 36.252.77 |
1st quartile Q_{1} | 34.9 |
2nd quartile Q_{2} = median =M | 36.2 |
3rd quartile Q3 | 37.6 |
quartile deviation = Q.D=(Q_{3} - Q_{1}) /2 | 1.35 |
skewness | 0.41 |
95% confidence interval for population mean | (35.29, 37.22) |
Get Answers For Free
Most questions answered within 1 hours.