**ALL PROBABILITIES FOR THIS ASSIGNMENT SHOULD BE CALCULATED WITH THE USE OF EXCEL** * ***FOR TESTING PURPOSES, YOU ARE RESPONSIBLE FOR ALSO KNOWING HOW TO MAKE THESE CALCULATIONS BY HAND** * 1. Fanshawe College is exploring removing all textbooks from their programs in favour of open sourced materials and in house faculty created content. The administration at Fanshawe would like took determine what percent of their student body would approve of such a decision. A college committee has been assigned with the task of determining the level student support with the goal of a 3% margin of error and 95% level of confidence. BLANK #1: Is this a question involving mean or proportion? ***ANSWER "MEAN" OR "PROPORTION"*** BLANK #2: What is the minimum sample size required? 2. Sherrie has spent the last 5 years working for an appliance repair company, and would like to use the skills that she's acquired to venture out and open her shop. As part of her small business grant proposal, Sherrie would like to estimate the average house call repair bill in her area and wants the estimate to be within $25 of the actual figure. Sherrie was able to find a series of old customer invoices in her work truck (invoice amounts listed below). How large a sample should Sherrie take if she wants to be 95% confident of the results? $344.95 $435.63 $58.83 $97.62 $60.44 $58.95 $55.47 $58.32 $87.57 $50.39 $63.68 $59.76 $166.27 $79.35 $75.77 $220.07 BLANK #1: Is this a question involving mean or proportion? ***ANSWER "MEAN" OR "PROPORTION"*** BLANK #2: What is the minimum sample size required