Create scatterplot using Excel with the following variables:gender: 0 = male, 1 = female.height: in inches.weight: in pounds.First we will create a scatterplot to examine how weight is related to height, ignoring gender.To do that in Excel:Sort the data by gender:Hold down the Control key (Command key on MacOS) and click the A key to select all of the data in the worksheet.Select the Home tab, then the Editing group Sort & Filter -> Custom Sort.In the pop-up window, make sure that My list has headers box is checked and then choose gender from the pull-down menu next to Sort by. Click OK.Now select all of the data in columns B and C, select the Insert tab and in the Charts group choose Scatter.Choose the first scatterplot option (Scatter with only Markers).Now we have a scatterplot, but the data is all on the right of the plot. To fix this:Right-click on the x-axis, and choose Format Axis from the pop-up menu.Make sure that Axis Options is selected on the left, and then next to Minimum enter 50 in the textbox. Click the X button to close the menu. gender height73000000000000000000000000000000000000008RN288FF69707273696871716869676667726875687372727272746873687072706767717273687268weight195135145170172168155185175158185146135150160155230149240170198163230170151220145130160210145185237205147170181150gender00000000111height6872686770717067585663weight170181150150200175155167100100125 gender00011111000001110010111111111000111height7267656763546664726666717157666770736872657064646360696567676865626665weight15514512512010512012512516013317520517582125133175163133180107170110140110110125120180120140130122114115

Answered: Create scatterplot using Excel with the…

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

Related questions

Question

Create scatterplot using Excel with the following variables:

gender: 0 = male, 1 = female.

height: in inches.

weight: in pounds.

First we will create a scatterplot to examine how weight is related to height, ignoring gender.

To do that in Excel:

Sort the data by gender:
Hold down the Control key (Command key on MacOS) and click the A key to select all of the data in the worksheet.
Select the Home tab, then the Editing group Sort & Filter -> Custom Sort.
In the pop-up window, make sure that My list has headers box is checked and then choose gender from the pull-down menu next to Sort by. Click OK.
Now select all of the data in columns B and C, select the Insert tab and in the Charts group choose Scatter.
Choose the first scatterplot option (Scatter with only Markers).
Now we have a scatterplot, but the data is all on the right of the plot. To fix this:
Right-click on the x-axis, and choose Format Axis from the pop-up menu.
Make sure that Axis Options is selected on the left, and then next to Minimum enter 50 in the textbox. Click the X button to close the menu.