11 Jul 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
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?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.