SPREADSHEET, MULTISTEP To solve this problem, you will use

Chapter , Problem 81

(choose chapter or problem)

SPREADSHEET, MULTISTEP To solve this problem, you will use a spreadsheet to study the distribution of molecular speeds in a gas. Figure 17-22 should help you get started. (a) Enter the values for constants and as shown. Then in column A, enter values of speeds ranging from in increments of (This spreadsheet will be long.) In cell B7, enter the formula for the MaxwellBoltzmann fractional speed distribution. This formula contains parameters v, R, M and T. Substitute A7 for v, B$1 for R, B$2 for M and B$3 for T. Then use the FILL DOWN command to enter the formula in the cells below B7. Create a graph of versus using the data in columns A and B. (b) Explore how the graph changes as you increase and decrease the temperature, and describe the results. (c) Add a third column in which each cell contains the cumulative sum of all values, multiplied by the interval size (which equals 1), in the rows above and including the row in question. What is the physical interpretation of the numbers in this column? (d) For nitrogen gas at 300 K, what percentage of the molecules has speeds less than (e) For nitrogen gas at 300 K, what percentage of the molecules has speeds greater than 700 m>s