MTH 143 300 - Computer Project 1 Due Date: Wednesday, June 14, 2017 This project will give you the opportunity to apply the analysis methods of descriptive statistics to sets of data. You will collect data, analyze data, and write a project report. Spelling, grammar, and the overall quality of your written work will be taken into account for your grade. Complete the following : 1. Add a text box to your Excel spreadsheet and in paragraph form describe your first topic. You may choose any topic you wish as long as it involves quantitative data ( numbers ) of some kind. Identify the relevant population relating to your topic. Next, obtain data in order to address your question of interest. Collect a sample related to your question of interest where the sample size ( n ) is 40 or more by conducting a survey. Remember, the data must be quantitative as the term is defined in the text, so for whatever survey question you ask, the answer must be a number. In paragraph form, describe how you obtained your data, including the phrasing of the question you asked and how you conducted your poll ( e.g. asked friends, family, coworkers, went to a mall, chat rooms, etc. ). You may not use age for your quantitative topic. 2. For your quantitative data a. Provide a list of your original data sorted in ascending order. This should be a list of at least 40 numbers. Pictures of data are not acceptable. b. Create a frequency distribution table. Show upper and lower class limits and include relative and cumulative frequencies. c. Create a histogram using the frequencies found in part (b). d. Create a Stem and Leaf display. Be sure to left justify the leaf column. e. Add a text box to your Excel spreadsheet and in paragraph form, describe what you have found and write any conclusions you could draw based on the tables and graphs you have created to describe the data. 3. Add a text box to your Excel spreadsheet and in paragraph form, describe your second topic. You may choose any topic you wish as long as it involves qualitative data ( categories ) of some kind. Also, identify the relevant population and possible samples needed to address some question of interest relating to your topic. Collect a sample related to your question of interest where the sample size ( n ) is 40 or more and there are at least 4 different categories with at least one response. Again, you must obtain your data by conducting a survey. In paragraph form, describe how you obtained your data, including the phrasing of the question you asked and how you conducted your poll ( e.g. asked friends, family, coworkers, went to a mall, chat rooms, etc. ). 4. For your qualitative data a. Create a frequency table for your categories. Include relative frequencies. b. Create a Pareto Diagram. c. Create a Pie Chart d. Add a text box to your Excel spreadsheet and in paragraph form, describe what you have found and write any conclusions you could draw based on the tables and graphs you have created to describe the data. You will submit a printed copy and an electronic copy of your report. Electronic submissions must be submitted through Black Board and must be a single Excel file. YOUR EXCEL FILE MUST BE FORMATTED FOR PRINTING. Sharing data or working in groups is NOT allowed. Late reports will be penalized 15 points initially, then an additional 10 points each day beyond the due date