Question

# Data sets for the question below Data Set G: Assume the population values are normally distributed....

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 s2 7.67 Mean s.d 36.25 2.77 1st quartile Q1 34.9 2nd quartile Q2 = median =M 36.2 3rd quartile Q3 37.6 quartile deviation = Q.D=(Q3 - Q1) /2 1.35 skewness 0.41 95% confidence interval for population mean (35.29, 37.22)