# Spreadsheet Assignment | Online Assignment Help

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).

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.

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.

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

30% OFF
Turnitin Report
Formatting
Title Page
Citation
Place an Order