Assignment info

1. Find a two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using =AVERAGE(A2:A36) and =STDEV(A2:A36).
2. 3. Assuming that this variable is normally distributed, what percentage of data would you predict would be less than 40 miles? This would be based on the calculated probability. · Find a free cell on the spreadsheet and use the formula =NORM.DIST(40,mean,stdev,TRUE). For the “mean” and “stdev” in the formula, you don’t want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable. · (Round your answer to 3 decimal places) · o Now, determine the actual percentage of data points in the dataset that fall within this range (less than 40 miles). To find the actual percentage, sort the DRIVE variable and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points. This is the actual percentage. · (Round your answer to 3 decimal places) · o How does your predicted probability from question 2 compare to the actual percentage calculated in question 3? |

Question 1

Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using =AVERAGE(A2:A36) and =STDEV(A2:A36).

(Round your answers to 5 decimal places)

The mean of the DRIVE variable is .

The standard deviation of the DRIVE variable is

Question 2

Assuming that this variable is normally distributed, what percentage of data would you predict would be less than 40 miles? This would be based on the calculated probability.

Find a free cell on the spreadsheet and use the formula =NORM.DIST(40,mean,stdev,TRUE). For the “mean” and “stdev” in the formula, you don’t want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable.

(Round your answer to 3 decimal places)

Answer: The proportion of values that I expect to be less than 40 is [x].

Question 3

Now, determine the actual percentage of data points in the dataset that fall within this range (less than 40 miles). To find the actual percentage, sort the DRIVE variable and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points. This is the actual proportion of values under 40 miles.

(Round your answer to 3 decimal places)

Answer: The actual proportion of values less than 40 miles is [x].

Question 4

How does your predicted probability from question 2 compare to the actual percentage calculated in question 3? In other words, if these values are different, why do you think they’re different, etc? Use complete sentences.

Drive (miles) | Birth Year | State | Shoe Size | Height (inches) | Sleep (hours) | Gender | Class Standing | Car Color | TV (hours) | Money (dollars) | Coin | |

4 | 1988 | NY | 9 | 69 | 7 | F | Sophomore | blue | 5 | 21.00 | 5 | |

6 | 1990 | OR | 13 | 75 | 10 | M | Junior | silver | 6 | 7.00 | 4 | |

6 | 1978 | MI | 10 | 66 | 6 | M | Freshman | black | 5 | 34.00 | 3 | |

20 | 1977 | IL | 5 | 62 | 7 | F | Junior | black | 3 | 10.00 | 2 | |

20 | 1985 | OR | 7 | 65 | 4 | F | Sophomore | green | 1 | 46.00 | 4 | |

25 | 1988 | CA | 8 | 69 | 6 | F | Senior | silver | 4 | 30.00 | 4 | |

25 | 1995 | GA | 9 | 63 | 7 | M | Junior | silver | 3 | 53.00 | 5 | |

28 | 1992 | NY | 7 | 67 | 4 | F | Freshman | black | 1 | 25.00 | 4 | |

29 | 1990 | TX | 11 | 70 | 7 | M | Freshman | silver | 2 | 28.00 | 3 | |

33 | 1985 | SC | 11 | 68 | 8 | M | Sophomore | blue | 1 | 9.00 | 4 | |

33 | 1990 | TX | 9 | 75 | 7 | M | Senior | silver | 5 | 54.00 | 7 | |

36 | 1982 | MI | 10 | 61 | 7 | M | Senior | blue | 6 | 5.00 | 2 | |

36 | 1996 | TX | 7 | 66 | 5 | M | Freshman | orange | 3 | 7.00 | 3 | |

36 | 1990 | IL | 12 | 61 | 7 | M | Junior | red | 4 | 14.00 | 3 | |

36 | 1988 | OR | 9 | 73 | 7 | M | Sophomore | blue | 5 | 23.00 | 5 | |

40 | 1987 | IL | 10 | 68 | 6 | M | Sophomore | silver | 5 | 16.00 | 5 | |

42 | 1962 | IL | 8 | 65 | 6 | F | Junior | red | 4 | 4.00 | 4 | |

54 | 1968 | FL | 9 | 70 | 8 | F | Freshman | green | 2 | 5.00 | 3 | |

54 | 1970 | NV | 11 | 65 | 4 | F | Freshman | silver | 5 | 54.00 | 7 | |

55 | 1997 | OH | 9 | 67 | 6 | F | Freshman | dark blue | 4 | 27.00 | 2 | |

63 | 1990 | PA | 10 | 66 | 8 | F | Sophomore | silver | 3 | 5.00 | 7 | |

63 | 1986 | MI | 5 | 69 | 7 | F | Sophomore | orange | 3 | 9.00 | 2 | |

71 | 1984 | MI | 11 | 64 | 6 | F | Freshman | silver | 2 | 1.00 | 2 | |

73 | 1968 | FL | 12 | 70 | 7 | F | Junior | green | 4 | 15.00 | 3 | |

73 | 1987 | SC | 11 | 68 | 7 | F | Junior | red | 2 | 18.00 | 5 | |

76 | 1985 | PA | 11 | 70 | 8 | F | Sophomore | blue | 3 | 5.00 | 4 | |

76 | 1992 | NY | 9 | 65 | 7 | F | Freshman | red | 6 | 7.00 | 2 | |

76 | 1990 | PA | 11 | 63 | 4 | M | Sophomore | silver | 5 | 13.00 | 5 | |

76 | 1991 | NY | 9 | 63 | 6 | M | Sophomore | silver | 4 | 38.00 | 2 | |

78 | 1995 | CA | 11 | 63 | 6 | M | Junior | blue | 2 | 47.00 | 2 | |

80 | 1989 | NV | 12 | 69 | 8 | M | Senior | white | 4 | 3.00 | 4 | |

80 | 1990 | SC | 10 | 63 | 8 | F | Senior | black | 2 | 7.00 | 7 | |

80 | 1999 | FL | 9 | 66 | 7 | F | Freshman | black | 5 | 22.00 | 2 | |

88 | 1998 | SC | 6 | 63 | 5 | F | Freshman | black | 3 | 43.00 | 6 | |

94 | 1983 | KY | 11 | 74 | 8 | M | Sophomore | red | 3 | 20.00 | 4 | |