Question

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.

QUESTION 1.  Use technology (Excel, graphing calculator, etc.) to sort the 25 sample data values from low to high. Use Excel or similar software to put the data into a table with 5 columns and 5 rows. Label this “Table 1: Sorted Set of Sample Data.”

Answer 1

The Sorted Set of data in Excel:

For sorting data in Excel use the following steps:

1) Type data in Excel cell

2) select the data

3) click on Data option on the taskbar then click on sort option

4) select the smallest to largest option

then we get the required output:

Weight of border collie in pounds
29.3
33.2
33.3
33.5
33.9
34.1
34.9
34.9
35.4
35.6
35.8
36.0
36.2
36.5
36.9
37.2
37.3
37.4
37.6
37.7
37.8
38.6
39.0
40.8
43.4

Table:

Data divided in five rows and columns:

29.3	34.1	35.8	37.2	37.8
33.2	34.9	36.0	37.3	38.6
33.3	34.9	36.2	37.4	39.0
33.5	35.4	36.5	37.6	40.8
33.9	35.6	36.9	37.7	43.4

>>>>>>>>>>>>>>>>>>> Best Luck >>>>>>>>>>>>