Math- Evaluating Statistics: Mean, Median, Mode, and Scatter Plot Analysis

evaluate a set of statistics.  An Excel spreadsheet is attached including 30 data sets representing the height and weight of 10 year old boys.  The first column is the height in inches and the second the weight in pounds.  Choose one data set that has not already been selected (include the number of the data set in your title to make this easier to do).  Calculate the mean, median and mode of the weights in the data set.  You can either do this by hand or see the video below to show you how to do this using the tools in Excel.  Then, explain what these numbers mean.  Are they the same?  Why are they different?  
Then, construct a scatter plot.  

From the insert menu select scatter or the chart that says scatter and then select the chart at the top left on the dropdown
Click on one of the points
Select Add Trendline (Note you may need to add Trendline and then click on the line to format Trendline) 
The default radio button is linear, keep it checked

What are your observations from the scatter plot?  Does it appear that there is a correlation between the height and weight of 10 yr old boys.  Note:  this data is made up, so do you think this is accurate?  Do you think given real data that there would be a greater amount of correlation or less?  
If you have a different version of excel then you may want to search to see how to form a trendline. These instructions work with Office 365 and Office 2010.

Attach your excel worksheet with your scatter plot
For the title of your post use your last name and the data set that you selected (Example:  Smith – Data Set #51).
Be sure to comment on at least 2 classmates.  You could discuss other times that this visualization would be useful?  Or what other visualizations could be useful in this scenario?  How do you choose?

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
You can contact our live agent via WhatsApp! Via + 1 9294730077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 20% with the discount code CODE