Answered You can hire a professional tutor to get the answer.
I need help with this please . For this assignment, please review the chapter reading(s) and videos for this week. You will be using an Excel
I need help with this please .


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? (60 word minimum)
To see how to calculate the standard deviation by hand, please watch the video below...
Video: https://www.youtube.com/watch?v=qqOyy_NjflU
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 your Word document.
4. List the Mean and Standard Deviation from your descriptive data analysis in #3 above.
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: https://www.youtube.com/watch?v=b1ArHTb8iwM
Video: https://www.youtube.com/watch?v=YLK8zxojdh0
5. A) Develop a five-number summary for the 10 data items in #1. Then list the 5-number summary on Excel. B) 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: https://www.youtube.com/watch?v=Mhu5ANQc_74
Box plot video:
Video: https://www.youtube.com/watch?v=DNpvSg2X0xQ&feature=youtu.be
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: https://www.youtube.com/watch?v=p4tFovMryyU
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.INC( )
Note: from now on, you will use the =Percentile.INC ( ) formula in Excel when you need a percentile.
Please watch the below videos on Quartiles and Percentiles in Excel...
Video: https://www.youtube.com/watch?v=WtJclu-CvQ0
Video: https://www.youtube.com/watch?v=Snf6Wpn-L4c
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 from the initial data in problem #1. You can select the 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)
