On Excel

Work should be done on paper converted to a pdf submission, and show all solutions in the pdf submission. You are free to use Excel and a calculator. If you use Excel for a calculation, please write down the function name, for example =CORRELO used. Do not include an image or pdf of your Excel workbook, it is assumed you are using Excel to expedite computations. I- Consider the following frequency distribution showing the tickets sold by age group to a Tenet screening Age # Of Tickets Sold 18-28 35 29-38 10 39-48 35 49-58 145 59+ 100 Find a) the mean age of movie goers, b) the median age, and c) the mode. (3 pts each) d) How many people under the age of 49 saw the screening? ( 3 pts ) e) Is our data (Age of Movie Goers) quantitative data or qualitative data? (1 pt ) 0 Is our data continuous or discrete? Explain briey (2 pts ) g) Is our data sample data or population data? Explain briey. (2pts ) II. a. Create a relative frequency distribution from the information in part I. ( 5 pts ) b. What percentage of viewers were 49 or older? [I]. Consider the following sample of critic scores for Nintendo's Breath of the HEM: {90, 100, 85, 90, 95, 95, 100, 100 } a. Find the average rating. ( 3 pts ) b. If each rating was decreased by 10, what would be the new average? 0. Find the variance. ( 3 pts) d. Find the standard deviation. ( 3 pts) e- Find the median score. ( 2 pts) f. Find Q1, Q2, Q3 g. Find the mode. ( 2 pts) h. Find :20: 50)3( 2pts) (next page)