Gillian Goodhue Test Excel Portion

# Gillian Goodhue Test Excel Portion - 64.3 114.8 66.4 149.3...

This preview shows pages 1–7. Sign up to view the full content.

Bin Frequency 58.9 3 60.9 6 62.9 8 64.9 13 66.9 6 68.9 4 More 0

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Introduction to Statistics Name Test 1 Excel portion Fall 2007 Complete the following items and email the exam to Dr. S Dr. V. Sapko at [email protected] by midnight on Friday. Include your name in the filename. Problem 1: Alex and Juana went on a 50-mile canoe trip with their class. On the first day they traveled On the second day they traveled 36% of the distance. What percent of the distance did they canoe the first day? How many miles did they canoe the secon (3pts each) On the first day, they traveled 24% of the total distance. On the second day, they traveled 18 miles Problem 2: The following data gives the heights of women in inches and the weights of those women i Part a: (12pts) Construct a histogram of the data on heights. Make sure you appropriate word and num Part b: (12pts) Construct a scatterplot of the data. Make sure you use appropriate word and number la Part c: (2pts each) Calculate the mean and median of the heights of women. Height Weight

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 64.3 114.8 66.4 149.3 62.3 107.8 62.3 160.1 59.6 127.1 63.6 123.1 59.8 111.7 63.3 156.3 67.9 218.8 61.4 110.2 66.7 188.3 64.8 105.4 63.1 136.1 66.7 182.4 66.8 238.4 64.7 108.8 65.1 119.0 61.9 161.9 64.3 174.1 63.4 181.2 60.7 124.3 63.4 255.9 62.6 106.7 60.6 149.9 63.5 163.1 58.6 94.3 60.2 159.7 67.6 162.8 63.4 130.0 64.1 179.9 62.7 147.8 61.3 112.9 56.0 58.0 60.0 90.0 110.0 130.0 150.0 170.0 190.0 210.0 230.0 250.0 Heigh Women's Weights (In Pounds) 58.2 195.6 63.2 124.2 60.5 135.0 65.0 141.4 61.8 123.9 68.0 135.5 67.0 130.4 57.0 100.7 Mean of women's heights= 63.2 inches Median of women's heights= 63.4 inches 58.9 60.9 Bin Frequency 62.9 58.9 3 64.9 60.9 6 66.9 62.9 8 68.9 64.9 13 66.9 6 68.9 4 More 58.9 2 4 6 8 10 12 14 Frequency Sapko d 12 miles. d day? in pounds. mber labels. labels. 62.0 64.0 66.0 68.0 70.0 hts and Weights of Women Column B Women's Heights (In Inches) 60.9 62.9 64.9 66.9 68.9 More Women's Heights Women's Heights (In Inches)...
View Full Document

{[ snackBarMessage ]}

### Page1 / 7

Gillian Goodhue Test Excel Portion - 64.3 114.8 66.4 149.3...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online