provided with data representing the time it took husbands and wives to run a mile. All data are in minutes
Husband Wife
8.2 9.7
8.9 8.5
9.7 8.9
9.8 8
10 9
7.9 7.9
6.7 8
8.9 7.9
12.2 9.9
15 10.2
8.8 8.4
8.9 --
21 10.4
11.3 9.2
What is your question? Why is the data for the third to last wife missing?
How do I do an excel file? Also, the data is missing because that is the way it was given-In the SPSS19 one would use 999 to represent a missing variable, I guess!
To analyze the data, let's perform some calculations and observations using the provided information:
1. To determine the average time taken by husbands and wives, calculate the mean for each group separately. Add up the times and divide by the total number of observations:
For husbands:
Husbands' Mean = (8.2 + 8.9 + 9.7 + 9.8 + 10 + 7.9 + 6.7 + 8.9 + 12.2 + 15 + 8.8 + 8.9 + 21 + 11.3) / 13
For wives:
Wives' Mean = (9.7 + 8.5 + 8.9 + 8 + 9 + 7.9 + 8 + 7.9 + 9.9 + 10.2 + 8.4 + 9.2 + 10.4) / 13
2. To find the fastest and slowest times for husbands and wives, identify the minimum and maximum values among the data:
For husbands:
Fastest time = minimum value among husband's times
Slowest time = maximum value among husband's times
For wives:
Fastest time = minimum value among wife's times
Slowest time = maximum value among wife's times
3. To assess the variability in the data, calculate the range for each group:
For husbands:
Range = Slowest time - Fastest time
For wives:
Range = Slowest time - Fastest time
Calculating these values will provide a better understanding of the data and allow for comparison between husbands and wives.