The data for  the Exercise 1.32  is stored on the CD at:
F:\PCDataSets\Excel\ CHAP01\TA01_006.XLS.   If you do not have the CD read note
To load it you should:

Click the "Open" icon     to pull up the the "Open" window.  Then   and then browse in the Open window
till you get a window like this:
   

Click on "TA01_006.XLS" to load the file.

Your Excel spreadsheet will fill up like:
 
 

To round the GPA scores:

Highlight the cell F2 then click on the "Function" icon       and in the "Paste Function" window choose 
"Math & Trig"  then "ROUND" and click OK to pull up the "Round" window.  Then fill up the options exactly like here:
 

Click OK then drag the lower right little square all along the column.  Your spreadsheet should look like:
 

A Stemplot will look like:
 

 Here are the stemplots of the rounded GPA for female and male students:
 

***********************************
Selection of the bin ranges for histograms.
***********************************
 

If you make a histogram of the GPA scores using the Excel default bins choices  you will get something like:
 

As you can see, Excel generates two pieces of information and place this output beginning at the location you specified above.
The first is a table of the data that is being charted.  The table contains two columns Bin and Frequency.  Bin refers to the upper
endpoints of the histogram bar that is to be drawn and Frequency is the number of observations that will be included in the
corresponding bar.  The way in which Excel choose the endpoints can be controlled and you can generate different histograms
from the same data.  It is important to emphasize that no one histogram that is produced from the data is considered the "correct"
one.  But a histogram with a good choice of the number of the Bins and of the endpoints will allow for a better understanding of the data.  Then,  let's organize the spreadsheet.
 

Keep only the GPA column, and delete the others.  Then put in column D the labels:

Then in the adjacent E cells type the corresponding formulas:

As for the "# of Bins" choose 10.
 

In the cell B3 type an integer smaller than the Minimum, in this case 0, then in the cell B4 write the following formula to generate the endpoints.

Then highlight B4 and drag the lower right small square till you get an endpoint greater than the Max imum.
You should obtain something like:

Now, delete the previous histogram chart and generate a new one, but this time use your own column with "Bin Range " values.
See the first part of Ex. 1.26 for instruction about the "Bin Range " option.
You should obtain something like:
 

The neat look of the new histogram can be produce using the "Format" option from the menu:

   Click  one of the bars in the histogram, then select "Format" and click on the "Selected Data Series".
Select the "Options" tab and then adjust to zero the "Gap width":
 

Question 1.  Generate similar histograms for the "GPA", "IQ" and "Self-concept" data.  For each of the histograms choose the number of bins to be equal to 8.

Print the three Excel spreadsheets.  Describe the shape, center and spread of the
distributions.

Question 2.  Generate separate histograms for the male and female subgroups for "GPA" and "Self-concept" data.  Once more choose the number of bins to be equal to 8.

 Print the four Excel spreadsheets.  Describe the shape, center and spread of the
distributions.