Question

USE EXCEL ONLY PLEASE

Using the data on the weight of a particular small animal find a simple random sample of size 10, and a systematic sample of size 10. If you use the Data Analysis Tool Pack, include screenshots of your settings in your submitted work. Find the mean and standard deviations of your sample

Weight |

16.5 |

12.2 |

12.0 |

10.6 |

9.8 |

9.3 |

12.4 |

14.2 |

13.1 |

10.9 |

12.8 |

16.1 |

13.5 |

14.1 |

12.5 |

10.7 |

13.1 |

15.3 |

12.7 |

12.1 |

15.9 |

14.7 |

15.3 |

16.6 |

13.1 |

16.3 |

13.0 |

15.8 |

12.8 |

13.2 |

15.4 |

15.4 |

15.5 |

12.6 |

15.0 |

12.1 |

13.1 |

12.4 |

12.2 |

15.7 |

13.0 |

11.3 |

15.1 |

12.0 |

10.8 |

13.4 |

14.4 |

15.1 |

15.4 |

14.4 |

13.9 |

14.8 |

12.4 |

17.6 |

17.5 |

12.2 |

13.9 |

13.3 |

12.8 |

16.1 |

Answer #1

Using the Data Analysis Tool Pack

(Excel)

Zoologists studied the characteristics of the burrow systems of
a subterranean rodent. A sample of 51 burrows had their depths,
in centimeters, recorded in the following table. 15.8, 15.9, 18.9,
18.4, 13.6, 15.6, 14.6, 12.2, 11.1, 12.9, 17.1, 16.3, 16.5, 16.3,
12.0, 14.4, 15.4, 13.1, 17.3, 12.2, 18.9, 16.1, 13.2, 14.9, 14.3,
12.6, 11.2, 16.7, 17.6, 8.1, 19.3, 17.5, 15.3, 15.6, 19.7, 14.3,
12.9, 12.8, 13.7, 16.3, 17.7, 13.8, 14.1, 16.6, 11.7, 15.9, 16.8,
9.2, 15.4, 18.2, 14.4.
Find and...

The cost of electricity (in $) was recorded for a random sample
of 50 cities in a country. These data are as follows:
9.0
9.0
9.5
9.6
10.2
10.8
10.9
11.1
11.4
11.6
11.9
12.3
12.7
12.8
12.9
13.0
13.0
13.5
13.7
13.9
14.1
14.3
14.4
14.7
14.8
14.8
14.9
14.9
15.0
15.1
15.3
15.4
15.7
16.3
16.5
16.6
16.7
16.8
17.1
17.2
17.5
17.8
18.3
18.5
18.7
19.1
19.7
20.2
20.6
21.3
A “less than” frequency distribution is constructed...

Great white sharks are big and hungry. Here are the lengths in
feet of 44 great whites.
18.9, 16.3, 13.3, 19.0,12.4 ,16.6, 15.8 ,16.1 18.4 17.6 14.2
22.6 16.4 16.3 16.8 16.8 15.5 12.5 9.4 13.4 18.1 17.7 18.4 13.2
14.8 14.0 13.3 15.8 15.8 12.3 13.8 19.6 14.8 15.1 15.1 18.9 17.6
14.6 16.3 13.2 11.9 12.2 13.4 16.7
Examine these data for shape, center, spread and outliers. The
normal quantile plot indicates the distribution is reasonably
Normal except...

A biologist was interested in determining whether sunflower
seedlings treated with an extract from Vinca minor roots
resulted in a different average height of sunflower seedlings than
the standard height of 15.7 cm at a 0.05 level of significance. The
biologist treated a random sample of n = 33 seedlings with
the extract and subsequently obtained the following heights:
11.5
11.8
15.7
16.1
14.1
10.5
15.2
17.0
12.8
12.4
17.5
13.5
16.5
13.5
14.4
16.7
10.9
13.0
15.1
17.1
13.3...

4. The CDC publishes charts on Body
Mass Index (BMI) percentiles for boys and girls of different ages.
Based on the chart for girls, the mean BMI for 6-year-old girls is
listed as 15.2 kg/m2. The data from which the CDC charts were
developed is old and there is concern that the mean BMI for 6-year
old girls has increased. The BMIs of a random sample of 30
6-year-old girls are given below.
24.5
16.3
15.7
20.6
15.3
14.5
14.7...

Are cigarettes bad for people? Cigarette smoking involves tar,
carbon monoxide, and nicotine (measured in milligrams). The first
two are definitely not good for a person's health, and the last
ingredient can cause addiction.
Brand
Tar
Nicotine
CO
Brand
Tar
Nicotine
CO
Alpine
Benson & Hedges
Bull Durham
Camel Lights
Carlton
Chesterfield
Golden Lights
Kent
Kool
L&M
Lark Lights
Marlboro
Merit
14.1
16.0
29.8
8.0
4.1
15.0
8.8
12.4
16.6
14.9
13.7
15.1
7.8
0.86
1.06
2.03
0.67
0.40
1.04...

7. Using Excel, find the mean and the standard deviation of the
AT&T speeds from the data set #32 Airport Data Speeds. Round
your answers to 3 decimal places. (Show your work!)
mean, x :
standard deviation:
AIRPORT
CODE
VERIZON
SPRINT
AT&T
T-MOBILE
ATL
77.8
0.4
33.9
27.3
AUS
28.5
0.5
29.0
5.1
BNA
1.9
2.3
4.6
9.5
BOS
6.2
1.0
11.7
9.6
BWI
43.0
3.4
12.7
3.2
CLE
15.1
0.5
7.6
24.7
CLT
7.9
1.1
9.1
4.4
CMH
25.7...

The CDC publishes charts on Body Mass Index (BMI) for boys and
girls of different ages. Based on the chart for girls, the mean BMI
for 6-year-old girls is listed as 15.8 kg/m2. The data from which
the CDC charts were developed is old and there is concern that the
mean BMI for 6 year olds girls has increased.
The BMI’s from a current random sample of 50 6-year-old girls is
attached in a list on the next page. Use...

A gardener plants 300 sunflower seeds (of a brand called
KwikGrow) and, after 2 weeks, measures the seedlings’ heights (in
mm). These height are: 38.6 39.1 50.4 49.2 46.2 0 43.1 49.6 16.1
17.9 11.6 50.2 36.5 50.6 40.3 36.3 14.3 40.8 12.1 43.7 47.2 49.9
37.9 49.1 53 47.7 13.8 38.3 49.2 50.6 49.6 52.3 19.8 12.8 46.9 35.3
38.7 39.3 12.4 51.9 36.9 20.8 51.7 44.3 49.1 10.7 14.9 48.2 14.8 38
41.4 39.4 11.9 13.8 0 35.1...

We want to compare the
soil water content (% water by volume) of two fields growing bell
peppers.
The claim is that the two fields have different soil water
content.
Use the data below to test the hypothesis that the fields have
different soil water content.
Field 1 is in list1 and Field 2 is in list2.
We do not know whether the water content values are normally
distributed or not, but their variances are equal.
Provide your answers below....

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 43 minutes ago

asked 43 minutes ago

asked 48 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago