Data Analysis with Microsoft Excel: Updated for Office 2007

108 Excel By linking to the label cells, you ensure that any changes you make to text in the University column will be automatic ...

Chapter 3 Working with Charts 109 When you label every data point, there is often a problem with overcrowd- ing. Points that are ...

110 Excel EXCEL TIPS You can also select and format your data labels by clicking the Data Labels button located in the Labels gr ...

Chapter 3 Working with Charts 111 Excel inserts the unformatted bubble plot as an embedded chart on the Grad Percents worksheet ...

112 Excel As you did earlier in creating the scatter plot, you now have to format the appearance of the chart to make it easier ...

Chapter 3 Working with Charts 113 Figure 3-25 shows the current appearance of the bubble plot. Figure 3-25 The initial bubble pl ...

114 Excel 5 You still need to specify a border color for the different bubbles so that you can see where one bubble begins and t ...

Chapter 3 Working with Charts 115 The area of each bubble in the plot is proportional to the percentage of in- coming freshman-a ...

116 Excel 4 Click the Close button and then deselect the chart. The fi nal appear- ance of the bubble chart is shown in Figure 3 ...

Chapter 3 Working with Charts 117 Let’s evaluate what we’ve created. In interpreting bubble plots, the stat- istician looks for ...

118 Excel categories with different symbols. For example we can divide the universi- ties into two groups: one in which the perc ...

Chapter 3 Working with Charts 119 The plot labels disappear (you won’t be using them in the plot you’ll cre- ate next). Now, bre ...

120 Excel STATPLUS TIPS Once you break a scatter plot into categories, you cannot go back to the original scatter plot (without ...

Chapter 3 Working with Charts 121 these results needs to have several data series. You can create such a scatter plot by simply ...

122 Excel 5 As you did for the other scatter plots, change the title of the x axis to Calculated SAT Values and the title of the ...

Chapter 3 Working with Charts 123 STATPLUS TIPS You can quickly create your own scatter plots using StatPlus. To create a scatte ...

124 Excel c. Break the scatter plot points into two categories on the basis of gen- der. Does the plot suggest that male salarie ...

Chapter 3 Working with Charts 125 Label the axes appropriately. Save the chart into a chart sheet named Protein Chart. c. Label ...

126 Excel i. There appears to be a player whose reported salary is lower than expected for his combination of batting average an ...

Chapter 3 Working with Charts 127 c. Label the points that are highest in MPG as measured by the height above the average MPG fo ...