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 thefive ranges and the frequency in each range b. Plot, in Excel, abar 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 atitle and axis labels e. Determine the mean, median, and mode ofthe scores f. Determine the deviation for each score g. Determinethe standard deviation for the data set h. Determine theprobability of scoring in each range based on the data set
2. How long does it take to double a deposit of $1000 a. at acompound annual interest rate of 6% b. at a compound annualinterest rate of 7% c. at a compound annual interest rate of 8% d.If instead of $1000 you deposit $5000, would the time to doubleyour money be different in parts (a)-(c)? In other words, is theinitial sum of money a factor in determining how long it takes todouble your money?
