Question

1. Given the following set of exam scores: 58, 53, 56, 68, 60, 62, 65, 62, 75, 75, 78, 70, 70, 75, 72, 79, 80, 85, 88, 83, 85, 87, 95, 97, 90 (I recommend Excel for all of this) a. Determine the five ranges and the frequency in each range b. Plot, in Excel, a bar graph of frequency vs range. Include a title and axis labels c. Using the same ranges determine the cumulative frequency d. Plot, in Excel, a bar graph of cumulative frequency vs range. Include a title and axis labels e. Determine the mean, median, and mode of the scores f. Determine the deviation for each score g. Determine the standard deviation for the data set h. Determine the probability of scoring in each range based on the data set

2. How long does it take to double a deposit of $1000 a. at a compound annual interest rate of 6% b. at a compound annual interest rate of 7% c. at a compound annual interest rate of 8% d. If instead of $1000 you deposit $5000, would the time to double your money be different in parts (a)-(c)? In other words, is the initial sum of money a factor in determining how long it takes to double your money?

Answer 1

a.

Range	Frequency
50-60	4
61-70	6
71-80	7
81-90	6
91-100	2

b. Plotting the above table into a bar chart, we have the follwing:

c.  

Range	Cumulative Frequency
50-60	4
61-70	10
71-80	17
81-90	23
91-100	25

d.

e. Using Excel formula, Mean = 74.72, Median = 75, Mode = 75.

f.

Score	Deviation
53	-21.72
56	-18.72
58	-16.72
60	-14.72
62	-12.72
62	-12.72
65	-9.72
68	-6.72
70	-4.72
70	-4.72
72	-2.72
75	0.28
75	0.28
75	0.28
78	3.28
79	4.28
80	5.28
83	8.28
85	10.28
85	10.28
87	12.28
88	13.28
90	15.28
95	20.28
97	22.28

g. Standard Deviation =

h. Probability = frequency / n

Range	Frequency	Probability
50-60	4	0.16
61-70	6	0.24
71-80	7	0.28
81-90	6	0.24
91-100	2	0.08