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://allaplusessays.com/order

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://allaplusessays.com/order

Video: https://allaplusessays.com/order

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://allaplusessays.com/order

Box plot video:

Video: https://allaplusessays.com/order

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://allaplusessays.com/order

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://allaplusessays.com/order

Video: https://allaplusessays.com/order

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)

PSY Article Critique...

PSY Article Critique Order Descriptionveryone concedes that there is a severe shortage of qualified teachers in the United States...

Question description In Discussion 1 you read “Resolving Ethical Business Challenges” in Chapter 2 of your text and examined Karl’s scen...

week 5 discussion 1...

Need a initial discussion...

APA format, 2 pages, 3 references 1 from walden university library Due Wednesday 3/27/19 at 7pm Applying Learning Theories t...

Accounting : Intermediate Accounting Chapter 1 (Fi...

Intermediate Accounting Chapter 1by annialin35 CHAPTER 1Financial Accounting and Accounting StandardsASSIGNMENT CLASSIFICATION TABLETopics 1. 2. 3. 4...

...

reflect on your own relationship with food by tel...

Use MLA formattingfix the spealing mistakethe ourument make it stronger even if u want to cheange but don't go far from the infor...

Running Head: CAPITAL MARKET EFFICIENCYCapital Market EfficiencyNameCourseTutorDate1CAPITAL MARKET EFFICIENCY2A capital market can be described as th...

Describe the changes that occur in a childs brain...

Write a 1,050- to 1,400-word paper that addresses the following in children from early childhood through middle child...

Ethical Conduct Of Research Infections Disease A G...

Ethical Conduct Of Research; Infections Disease: A Global Perspective...

Algebra : 201909042049121105 Pre Class Assignment...

MAC 1105 Pre-Class Assignment: Multiple Representations of FunctionsRead sections 2.1 Graphs of Functions and 2.2 Properties of Functions to prepare...

CPS 400 What Matters: Discernment 3 pages paper...

Readings:Martin Chapter 8: The Simple Life: The Surprising Freedom of Downward Mobility...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
\$65
Order a paper. Study better. Sleep tight. Calculate Price!
Calculate Price
Approx. price
\$65