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

(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

Solution: