MATH309 - Statistics Week 2 - Homework Deadline Due by the end of Week 2 at 11:59pm, ET. Directions For this assignment, please review the chapter reading(s) and videos for this week. You will be using an Excel spreadsheet for the below assignment. You will use Excel to calculate the answers, and you will need to do all the calculations indicated. When you submit your assignment in Blackboard, please copy your work from the Excel file to a Word document, and submit only the Word document. The word document allows me to find your answers quickly and be sure to number your problems. Note - You are required to put all your work in the Word document and required to label every problem in the Word doc: 1. Use a sample of 10 data items listed below. The 10 data items will need to be listed in column format. The data is listed as (patient #, patient height in feet with decimal format): (1, 5.8), (2, 3.4), (3, 6.1), (4, 5.1), (5, 6.2), (6, 4.8), (7, 5.2), (8, 4.1), (9, 4.4), (10, 4.1). Note: You will use the same data throughout this exercise. Copy the column data from Excel to Word. 2. watch the video below - Question: What did you find challenging in the hand calculations after watching the video - you do not have to do the calculations - only describe the challenges? To see how to calculate the mean and standard deviation by hand, please watch the video below... Video: How to calculate Standard Deviation and Variance 3. Do a Descriptive Data Analysis on the patient height data of: (1, 5.8), (2, 3.4), (3, 6.1), (4, 5.1), (5, 6.2), (6, 4.8), (7, 5.2), (8, 4.1), (9, 4.4), (10, 4.1) using Excel (under Data, then click Data Analysis on the top right, then select the column of data of just the height, and select this as the data under Descriptive Data in Data Analysis) - copy the Descriptive Data results from Excel to Word 4. List the Mean and Standard Deviation from #3 Please watch the below videos on Descriptive Statistics using Excel Data Analysis (Note: if you do not see Data Analysis after you click on Data at the top of Excel, you will need to add the Data Analysis Tool pak in Excel going to File, Add ins, etc.) ...If you do not see Data Analysis at the top right screen after clicking on the Data button in Excel, please watch the below video on adding Data Analysis to Excel. (Note: the second video is on using Descriptive Statistics in Excel). Video: Installing Analysis TookPak on Excel 2013 Video: Excel Statistics: Using Data Analysis to Find Descriptive Statistics 5. Develop a five-number summary for the 10 data items in #1. Then list the 5-number summary on Excel. Then draw a box plot with the five-number summary and include the box plot in Excel or as a separate document. Use Excel to draw the box plot (see the video below on developing a box plot in Excel - you can also use any other video in YouTube on developing a box plot in Excel) Please watch the below video on the 5-number summary using Excel... Video: Excel 2010: Five Number Summary Using Formulas Box plot video: Video: Boxplots in Excel 2013 6. Show the z score for one of the patient #3 whose height is 6.1 feet. Write the answer in Word. Please watch the below video on z-scores... Video: Excel for Statistics 5Z scores 7. Find the 50th percentile related to the data. Remember to order your data in Excel then show your work in Excel and/or your Word document. Use the Excel formula of =Percentile.EXC( ) Please watch the below videos on Quartiles and Percentiles in Excel... Video: Excel 2010: Percentiles and Quartiles Using Formulas Video: Percentiles and Quartiles 8. Find the 75th percentile of your 10 data item data set. How many items are above the 75th percentile? What are those data items above the 75th percentile? 9. Calculate the z-scores of three separate data heights. 10. What applications are there in your field of study or interest for the concepts listed above for mean, standard deviations, 5 number summaries, and z scores - list three applications (i.e., this means discuss how you can apply and use what you have learned) by doing a Google search. List the applications in real life (i.e., how you can apply this in your own life or future profession) in your Word document (200-word minimum) Upload your Word file to Blackboard with the answers for 1 - 10 above