Do the problems using Microsoft Excel.

2.25 How do college students spend their day? The 2016 American Time Use Survey for college students found the following results:

Activity Percentage

Eating and Drinking 4%

Educational Activities 14%

Grooming 3%

Leisure and Sports 17%

Sleeping 37%

Traveling 6%

Working and Related Activities 10%

Other 9%

Source: Data extracted from American Time Use Survey: Charts by Topic: Students (bls.gov)(Links to an external site.), accessed February 3, 2017.

• Construct a bar chart, a pie or doughnut chart, and a Pareto chart.
• Which graphical method do you think is best for portraying these data?
• What conclusions can you reach concerning how college students spend their day?

2.38 The following is data about the cost of electricity during July of a recent year for a random sample of 50 one-bedroom apartments in a large city:

96 171 202 178 147 102 153 197 127 82

157 185 90 116 172 111 148 213 130 165

141 149 206 175 123 128 144 168 109 167

95 163 150 154 130 143 187 166 139 149

108 119 183 151 114 135 191 137 129 158

• Construct a histogram and a percentage polygon.
• Construct a cumulative percentage polygon.
• Around what amount does the monthly electricity cost seem to be concentrated?

2.48 The following is a set of data from a sample of n = 11 items:

X: 7 5 8 3 6 0 2 4 9 5 8

Y: 1 5 4 9 8 0 6 2 7 5 4

• Construct a scatter plot.
• Is there a relationship between X and Y? Explain.