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)

## Describe the effect that obesity (childhood and /...

Write a one to two page (1-2) page essay in which you:Describe the effect that obesity (childhood and / or adult) has h...

## need help with excel...

Create a pivot table of the data you created for attached file and add a pivot chart of something you find interesting in this data. Fil...

## Business : Milestone Two Msil...

Running head: FINAL PROJECT MILESTONE TWO1Qualitative Data and Research QuestionNameInstitutionCourseDateFINAL PROJECT MILESTONE TWO2Qualitative Data...

ASSIGNMENT...

## Distinguish between the Four elements of the marke...

Distinguish between the Four elements of the marketing mix and the Five uncontrollable forces that affect a marketing decision in an organ...

## Prepare and submit a paper on the role of the envi...

Prepare and submit a paper on the role of the environment on the impact of product strategy. Your assignment is to prepare and submit a paper on the r...

...

## religion questions...

1.  What was Jesus' favorite teaching device? How did Jesus use this form to communicate his message? ...

## Assignment 4 On-boarding...

Create an outline of an onboarding process. Summarize what you feel are the 2 most important elements in onboarding in the global environm...

...

## Stress Management...

Examine different theories or views on stress(BEEBE,POTTER & PERRY).Define your personal definition of stress related to those theorie(3 th...

## Maddox Specialty Company, a division of Lost World...

P9?9(Statement and Note Disclosure, LCM, and Purchase Commitment) Maddox Specialty Company, a division of Lost Worl...
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