Question

Data sets for the 2 questions 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.

1. Choose another confidence level similar to one found in the homework (do not use the
confidence level from the posted example). Based on the second confidence level, find the
critical value and calculate the margin of error. In a table, state the second confidence level,
the point estimate, the critical value, margin of error, and confidence interval. Put the proper
symbols in the left column and the value of the statistic or properly formatted confidence
interval in the right column. The statistics and confidence interval should be rounded properly.
Label this “Table 5: Confidence Interval 2.”

Answer 1

**If you found my answer helpful, kindly give a positive rating. Thank you.