Question

25. KAYAKING It takes 3 hours to paddle a kayak

12 miles downstream and 4 hours for the
return trip upstream. Find the rate of the
kayak in still water.
Let k = the rate of the kayak in still water and
c = the rate of the current. (Lesson 6-4)

R t d rt=d
Upstream. k+c 3 12 3(k + c) = 12

Downstream k-c 4 12 4(k - c) = 12

Answer 1

Explanation:

For part a:

Mean: Use the AVERAGE function to find the mean of the "Number" column.

Median: Use the MEDIAN function to find the median of the "Number" column.

Mode: There is no built-in function to find the mode in Excel, but you can use a combination of the IF, COUNTIF, and MAX functions to find the most frequently occurring value.

Maximum: Use the MAX function to find the maximum value in the "Number" column.

Minimum: Use the MIN function to find the minimum value in the "Number" column.

For part b:

Mean: Use the AVERAGE function to find the mean of the "Percent" column.

Median: Use the MEDIAN function to find the median of the "Percent" column.

Mode: There is no built-in function to find the mode in Excel, but you can use a combination of the IF, COUNTIF, and MAX functions to find the most frequently occurring value.

Maximum: Use the MAX function to find the maximum value in the "Percent" column.

Minimum: Use the MIN function to find the minimum value in the "Percent" column.

For part c:

The statistics on children whose parents do not have secure employment provide important insights into the state of the economy. In this case, the mean and median of the number of children in each state seem to be around 450,000. The mode cannot be determined since there are no repeated values in the "Number" column. The maximum number of children is 678,000 in Ohio, while the minimum number is 141,000 in Iowa.

Comparing the states, Indiana has a slightly higher mean and median percent of children whose parents do not have secure employment at 27%, compared to the other surrounding states which range from 20% to 31%. However, there is no clear state with the best or worst data as the range of the percent values is not too wide.

In terms of comparison, the number of children may provide a more comprehensive understanding of the extent of the problem, as it gives a clearer picture of the actual number of children affected. However, the percentage provides a more relative comparison between the states, allowing for easier comparison and a clearer understanding of the proportion of children affected in each state.